Database Tuning (MOSC)

MOSC Banner

approach for and good tips for mentioned scenario

edited Jan 21, 2014 5:32AM in Database Tuning (MOSC) 2 commentsAnswered
Please give the steps for above.Can you all please share views for below scenario and share you approach.

1.Let say unix team compalined at OS level oracle is using more cpu.

In server 9 databases are running.

How I need to approach on this scenario.


-->how should I catch that particular pid and from there spid,sid and sql etc..


-->should I focus only on foreground session eliminating background level.

Please give the steps for above.


2.Let say unix team ompalined at OS level oracle is using more memory.

-->how should I catch that particular pid and from there spid,sid and sql etc..

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center