Already a member?
Sign in
Welcome! Wikis are websites that everyone can build together. It's easy!
Performance Tuning
Oracle Performance Tuning
Performance tuning is the one area in which the Oracle DBA probably spends most of his or her time. If you’re a DBA helping developers to tune their SQL, you can improve performance by suggesting more efficient queries or table- and index-organization schemes. If you’re a production DBA, you’ll be dealing with user perceptions of a slow database, batch jobs taking longer and longer to complete, and so on. Performance tuning focuses primarily on writing efficient SQL, allocating appropriate computing resources, and analyzing wait events and contention in the system. Some Links for your kind reference.
1. Oracle® Database Performance Tuning Guide 10g Release 2 (10.2) :- http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/toc.htm
2. Oracle® Database 2 Day + Performance Tuning Guide 10g Release 2 (10.2) http://download.oracle.com/docs/cd/B19306_01/server.102/b28051/toc.htm
3. Jonathan Lewis tips
http://www.jlcomp.demon.co.uk/ind_mon.html
4. STATSPACK Tuning Tips
http://www.spviewer.com/tuning.html
Performance tuning is the one area in which the Oracle DBA probably spends most of his or her time. If you’re a DBA helping developers to tune their SQL, you can improve performance by suggesting more efficient queries or table- and index-organization schemes. If you’re a production DBA, you’ll be dealing with user perceptions of a slow database, batch jobs taking longer and longer to complete, and so on. Performance tuning focuses primarily on writing efficient SQL, allocating appropriate computing resources, and analyzing wait events and contention in the system. Some Links for your kind reference.
1. Oracle® Database Performance Tuning Guide 10g Release 2 (10.2) :- http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/toc.htm
2. Oracle® Database 2 Day + Performance Tuning Guide 10g Release 2 (10.2) http://download.oracle.com/docs/cd/B19306_01/server.102/b28051/toc.htm
3. Jonathan Lewis tips
http://www.jlcomp.demon.co.uk/ind_mon.html
4. STATSPACK Tuning Tips
http://www.spviewer.com/tuning.html
Latest page update: made by spviewer
, Jan 10 2008, 5:34 PM EST
(about this update
About This Update
Edited by spviewer
5 words added
view changes
- complete history)
Edited by spviewer
5 words added
view changes
- complete history)
Keyword tags:
Oracle Performance Tuning
Oracle Tuning
Performance Tuning
PT
Tuning
More Info: links to this page
| Started By | Thread Subject | Replies | Last Post | |
|---|---|---|---|---|
| redferrariteam | Multiple temp files | 5 | Jan 2 2008, 12:00 PM EST by HayrolR | |
|
Thread started: Dec 27 2007, 5:58 AM EST
Watch
Hi Experts,
We have a four disk solaris production server without RAID configuration. Many SQL queries of the application would perform huge sort operations. In order to use the available I/O bandwidth optimally we created 3 temp files on different disks for our TEMP tablespace. While monitoring the I/O performance we realized that only one tempfile is used extensively though the data being sorted is too huge compared to the extent size. In case of data files(multiple datafiles per TS) Oracle would allocate extents in a round ronbin fashion. Would like to know why the same seems to be not happening in our case. Any pointers?
1
out of
11 found this valuable.
Do you?
Keyword tags:
Oracle Performance Tuning
Oracle Tuning
Performance Tuning
PT
Tuning
|
||||
