A stored procedure is taking more than 150 mins when working with UNIX setup while its taking only 12 to 15 sec. with same data volume with Oracle installed on Windows setup. (with Oracle 9.2)
2006-08-13 23:01:39 · 3 answers · asked by Anonymous in Computers & Internet ➔ Programming & Design
Some things that can kill performance in an oracle database are inadequate buffer cache , sort area, or missing indexes. I would suspect cache size, myself.
2006-08-14 18:09:08 · answer #1 · answered by oohhbother 7 · 0⤊ 0⤋
A quick and dirty check would be to trace the executions on both installs and compare the TKPROF output to validate which queries are performing poorly and compare the explain plans of each statement. This will show you which statements may be executing differently and if it is a sql issue.
2006-08-16 18:00:38 · answer #2 · answered by Wake Cobra 4 · 0⤊ 0⤋
eagertoknow Don't be to eager help is @hand. Here is your link
http://www.google.co.uk/search?hl=en&q=finetune+oracle+database+settings&meta=
2006-08-13 23:14:53 · answer #3 · answered by Joe_Young 6 · 0⤊ 0⤋