Oracle Guru's?

[Liability]

We got any Oracle gurus here? Got a question for ya!

[NickFitz]

You may also need an apostrophe guru

[d000hg]

Maybe you could tell us what the question is...

[SallyAnne]

You may also need an apostrophe guru

[lilelvis2000]

I like to pretend to be one....but spend most of my time googling the answer.

[lightng]

Why not ask Tom?

[Liability]

Basically - have a solution [help desk] that is really slow. The issue isnt network, client machine, or client software but actually getting the data back and refreshing. Ive done the troubleshooting and the server resources are peaking at various times but that isnt the only issue


Now the Oracle DBA says that Unix will show 90% RAM utilisation as it reserves the allocated memory. He is viewing this in the Oracle Management Software. He says alot of other systems are like this and its just the OS reserving it but he cant see how much is actually being used within the 90% of XXGB RAM. The Management software always shows 90%+ memory reservation/utilisation regardless of time [and out of hours the system isnt used]

Went over to Unix guys and asks for paging stats - and they seem to be a little lost

[TCL]

Went over to Unix guys and asks for paging stats - and they seem to be a little lost

Then they should be walked out the door. This is bread+butter stuff for a Unix admin:


vmstat 3 (ignore the first line)
top (not standard utility in most Unixes (Unices? Uniii?))
sar


Seriously, find another/better Unix admin.

[lilelvis2000]

You probably need to run the AWR reports. These are normally snapshot reports which take a snapshot each hour. They can also be run on demand.

These show to SQL, top activity, memory, IO waits etc.. quite handy see what's going on...or not.

Tell your DBA the time range you need the report and he should be able to generate the report and send it on to you.

[b0redom]

top (not standard utility in most Unixes (Unices? Uniii?))

prstat