Search found 88 matches
- Tue Jun 08, 2010 9:56 am
- Forum: DBA Topics
- Topic: Location of sqlnet trace files in 11g
- Replies: 0
- Views: 10131
Location of sqlnet trace files in 11g
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...
- Mon Apr 26, 2010 1:53 pm
- Forum: Job Postings
- Topic: Paychex still looking
- Replies: 0
- Views: 4240
Paychex still looking
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: - ...
- Fri Apr 23, 2010 11:38 pm
- Forum: DBA Topics
- Topic: Exadata
- Replies: 6
- Views: 20657
Sun exadata v2
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...
- Fri Apr 16, 2010 3:29 pm
- Forum: DBA Topics
- Topic: Exadata
- Replies: 6
- Views: 20657
HP exadata
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 ==...
- Mon Apr 12, 2010 8:55 pm
- Forum: DBA Topics
- Topic: Exadata
- Replies: 6
- Views: 20657
Build your own Hardware solution (minus Special sauce).
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 ...
- Tue Apr 06, 2010 10:48 pm
- Forum: DBA Topics
- Topic: Exadata
- Replies: 6
- Views: 20657
First impressions
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...
- Mon Apr 05, 2010 10:52 am
- Forum: Other Tech Events
- Topic: Enterprise Manager 11g launch
- Replies: 0
- Views: 8647
Enterprise Manager 11g launch
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...
- Sun Mar 28, 2010 9:00 am
- Forum: DBA Topics
- Topic: SQLT - A sql tuners best friend.
- Replies: 0
- Views: 19434
SQLT - A sql tuners best friend.
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...
- Sun Mar 21, 2010 6:35 pm
- Forum: DBA Topics
- Topic: Exadata
- Replies: 6
- Views: 20657
Exadata
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....
- Sun Mar 21, 2010 6:30 pm
- Forum: DBA Topics
- Topic: Adaptive Direct path reads
- Replies: 1
- Views: 11233
More information
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...
- Sat Mar 06, 2010 4:44 pm
- Forum: DBA Topics
- Topic: Linkedin
- Replies: 0
- Views: 9404
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...
- Wed Feb 17, 2010 11:28 pm
- Forum: DBA Topics
- Topic: Performance testing with Oracle
- Replies: 0
- Views: 9578
Performance testing with Oracle
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...
- Thu Feb 04, 2010 5:11 pm
- Forum: DBA Topics
- Topic: System Statistics
- Replies: 0
- Views: 9323
System Statistics
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%...
- Tue Feb 02, 2010 10:08 pm
- Forum: DBA Topics
- Topic: Adaptive Direct path reads
- Replies: 1
- Views: 11233
Adaptive Direct path reads
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 ...
- Tue Jan 26, 2010 1:48 pm
- Forum: DBA Topics
- Topic: Pocket guide for ASM and CRS
- Replies: 0
- Views: 10290
Pocket guide for ASM and CRS
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
http://www.dbaexpert.com/ASM.Pocket.pdf
and here is for CRS
http://dbaexpert.com/RAC.Pocket.pdf