Discussion Locked

Oracle tuning: Start by looking at the big picture

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

6 replies

by marcus ferreira

Mr. Burleson

Although I agree with you on each topic mentioned (server, instance, object and SQL) I must point out that the Oracle documentation and the OCP Performance test strongly suggest a reversed other, i.e., more benefits are achieved with less intrusion when SQL tuning is made first and object, instance and server after.

What?s your opinion and experiende about it?

by shanghai sam

I agree that the steps may be at least partially reversed. You can throw all the processor power, faster drives and memory you want at the problem but if the queries are sloppy (recursive, etc.) you'll never speed it up much. We had this problem on Oracle 7, after fixing some poorly-written queries it ran a lot faster.

by dba_guru

Hi Marcus,

You make a good point, but it is my experience that SQL tuning will not always have the desired results if the init.ora parameters are not right. Also, improper setting in UNIX and bad table parameters will also effect SQL eecution time. Hence, I like to take care of these things before I tune the SQL

Don Burleson . . .

by emmett

The VERITAS Database Edition for Oracle will be very beneficial as measured by the performance enhancement of Quick I/O. The major components of the VERITAS Database Editions for Oracle is:
1. VXFS-VERITAS File System. A journaled file system thatenables your Oracle Database to read only the changed blocks. Literally takes FSCK's down from hours to minutes or seconds

2. VXVM- VERITAS Volume Manager. Hot relocates of volumes. eliminates the 7 partition dick requirements. Enhanced managability.

3. Quick I/O.-this will give you the performance of raw data and the managability of a file system. Bypasses the buffer and write directly to disk

This discussion is closed to new replies.