Re: Oracle8 panic! - lousy performance/high load

In a sudden spasm of awareness,
Tom Karlsson - Remove NOSPAM doodled thusly:

>init file settings:
>

Forget that. Do a select of the relevant columns from v$parameter (loggd in as SYS or SYSTEM) and play them here.

>
>there's over a hundred of the oracleorcl processes showing in a top:
>

Yeah, but what are they doing?
And how many processes are there in total connected to ORACLE? Are they batch processes or on-line connections?

Try to get some information from V$SQLAREA. There, you can see for each SQL being executed and/or cached, the statistics of logical and physical disk reads, rows changed, number of executions, etc. Usually, this sort of thing means a statement without any optimisation being hit heaps of times by everybody.

>
>Anyway help, hints, tips, what so ever is appreciated.
>

for starters, more info.

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Wed Nov 14 2001 - 05:08:54 CST