6 replies
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
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.
Trending IT Employment posts
Sort by Trending