OraFAQ Forum: Performance Tuning » Book for tuning (I'm not a DBA, though)

Home » RDBMS Server » Performance Tuning » Book for tuning (I'm not a DBA, though)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Book for tuning (I'm not a DBA, though) [message #143840]

Sun, 23 October 2005 05:36

vgs2005
Messages: 123
Registered: April 2005

Senior Member

hi,
I've seen lots of performance tuning books for DBAs. However, I am not a DBA but a PL/SQL developer. I just need to know how to fine tune a SQL, make some indexes, know the best approaches in writing an SQL with 10 joins and 10 subqueries.. and the like. I would like to be a DBA, but I need more exposure. Can you please suggest an Oracle Performance Tuning book for a 'not-so-expert' PL/SQL developer and a 'new/beginner' DBA?...
thanks a lot!

Report message to a moderator

Re: Book for tuning (I'm not a DBA, though) [message #143846 is a reply to message #143840]

Sun, 23 October 2005 06:14

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

oracle 10g performance tuning manual

Report message to a moderator

Re: Book for tuning (I'm not a DBA, though) [message #143847 is a reply to message #143846]

Sun, 23 October 2005 06:32

ziggy
Messages: 27
Registered: July 2005
Location: Moscow, Russia

Junior Member

It depends on which books you already read.

It seems to me that better start to read Oracle manuals from Concepts. May be even much better to start from Tom Kyte "Expert One-on-One Oracle" if you don't yet.

Then try Steve Adams "Oracle8i Internal Services for Waits, Latches, Locks, and Memory" by example.

Regards,
Ziggy.

Report message to a moderator

Re: Book for tuning (I'm not a DBA, though) [message #144468 is a reply to message #143840]

Wed, 26 October 2005 10:45

SQLTraceViewer
Messages: 5
Registered: October 2005

Junior Member

I would agree with Ziggy.

As a developer, your primary tuning job task is SQL tuning. Tom Kyte's book are the best. Several others:

http://www.amazon.com/gp/product/1590595300/002-4177322-1984819?v=glance&n=283155&n=507846&s=books&v=glance
-- The revised version of Expert One-on-One Oracle

http://www.amazon.com/gp/product/0072230657/002-4177322-1984819?v=glance&n=283155
-- Another must read

Cheers.
SQLTraceViewer, OCP&SCJD
http://sqltraceviewer.jarlib.com/

[Updated on: Wed, 26 October 2005 10:48]

Report message to a moderator

Previous Topic:	sequences shared pool
Next Topic:	Need An Alternate - Synonyms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 17 21:35:29 CDT 2024