UNYOUG

I don't know how many of you have traced sql.. It can be helpful to try to find out why an error is occuring or just verifying parameters (like DEFAULT_SDU_SIZE). The way to accomplish this is to 1) create a new subdirectory in /tmp 2) Copy the files from $ORACLE_HOME/network/admin to /tmp/{mydir} 3...

Are you interested in a direct hire at Paychex? Do you dream about RAC and ASM ?  Did you watch the OEM big announcement ??  Do you have a "Linux or Die" bumber sticker.. Paychex is a great place to work leading the technology forefront in Rochester. Now for the nitty gritty. Required: -  ...

I've been on exadata groups conversing with Others.. I found a hardware specialist in Norway who told me he priced the Sun hardware and found that a 1/2 rack is really only $300,000 US for parts. No one is really arguing the Value of the Exadata.. The Speed numbers are so fast, the question is aroun...

New tact.. start with the v1 and build it with current technology.. According the specs (start with a 42u rack...  list price for a full RAC 8 Database servers   ==  $ 93,000 14 Storage servers   ==  $173,152 4 24 port switches   ==  $ 30,000 1 48 port eth. switch =  $  1,500 TOTAL hardware       ==...

I am working on building my own Exadata from commidity items on the HP website.. It appears that since Oracle bought SUN, their prices have been dissapearing. So far I have 2 c7000 enclosures, These are 10u so I need 2 of them.. Each enclosure includes fans, 3 phase power, and 1 infiniband switches ...

I've been putting a lot of thought into the exadata lately, and doing a LOT more research. 1st.  you have to to take a look at your database (the AWR report is good for this)...  are you I/O bound ?  Is your top wait event Disk ?  Then the Exadata will probably give you a big bang.  The more CPU you...

This is a webcast you can join in http://www.oracle.com/webapps/events/EventsDetail.jsp?p_eventId=110025&src=6773871&src=6773871&Act=42&msgid=8574739&eid=4755026243&lid=3 Why should you care ?? Well Enterprise Manger 11g is changing the front end to web 2.0  This release prom...

I've been testing with 11gr2, and trying to compare plans with 10.2.0.4 utilizing "OPTIMIZER_FEATURES_ENABLED".. This parameter "should" cause the optimizer to give you same plan on an 11gr2 database that it used in 10gr2.. The idea, is you can run a replay on 11g and 10g optimiz...

I'm going to be following this up with more information on exadata.  I'm going to go back to presentations at openworld, and see what I can find that is public information. To start with Kevin Closson is a GREAT resource, as I said at the meeting.. He is a top storage engineer, and prolific blogger....

Well, I've posted a second time because I have been busy following up on this feature.  I've posted to different groups, and the most interesting responses I've gotten have been from Jonathon Lewis.. He also has been posting on Direct path reads.. He told me he has seen 2 similar cases where paralle...

Have you heard of linkedin ?? Well if you are an Oracle professional, it is worth checking out.  If you are familiar with Facebook, and you are thinking it is the same, well yes and no.. Linkedin is to professional relationships, what Facebook is to personal relationships..  I have a lot of contacts...

Wow.. Did you know there is a team at oracle called "the Real-World Performance group" ?? Well either did I.. This group does exactly what you would expect.. They look at real world customers, and find ways to help things scale.. I came acrosss it while I was "chatting" with a me...

The question I like to ask "experts" is what do you think of system statistics and do you trust them ? Here is a great article from Randolph Geist.. He is my favorite Optimizer expert out of Germany.. This is his presentation from OUG UK. http://www.sqltools-plusplus.org:7676/media/System%...

Well as you read the title, you are probably going huh ??  Until you upgrade to 11g, you probably just think direct reads are for reading temp only.. Well it all changes with 11g.  Full table scans of large tables turn from "db scattered read" to "direct path read"..   What does ...

I just ran across this great pocket guide for ASM

http://www.dbaexpert.com/ASM.Pocket.pdf

and here is for CRS
http://dbaexpert.com/RAC.Pocket.pdf