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


Latest page update: made by spviewer , Jan 10 2008, 5:34 PM EST (about this update About This Update spviewer Edited by spviewer

5 words added

view changes

- complete history)
More Info: links to this page

Anonymous  (Get credit for your thread)


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?    
Show Last Reply

Related Content

  (what's this?Related ContentThanks to keyword tags, links to related pages and threads are added to the bottom of your pages. Up to 15 links are shown, determined by matching tags and by how recently the content was updated; keeping the most current at the top. Share your feedback on Wetpaint Central.)
Top Contributors