Hemant's Oracle DBA Blog: Ever wonder "what if this database contains my data ?"

02 May, 2009

My forums posting 'Ever wonder "what if this database contains my data ?"' has also been been repeated by APC on his oraclecommunity.net blog.

I do hope that there are more responses and a better discussion on this.
.
.
.

Anonymous said...: Hello,
couple of days ago there was a thread on OTN about "Database recover
".
http://forums.oracle.com/forums/thread.jspa?threadID=893989&tstart=25

OP said that it is a production system and having NO BACKUPS & database is in NO ARCHIVE mode. what to say on this?

Regards!; 04 May, 2009
Saket Gokhale said...: Hello Hemant,

I am not sure if this is the place where i can post my query
If this isn't, please send me the link or help me knowing it

I am using Oracle 9i R2 on HP-UX

My query is :
If users are complaining about peformance and I am seeing that CPU usage is well within limits, how can I check which session is doing high I/O and thus impacting the System? How can I check it OS level on HP-UX?

Please help me understand this

Thanks in advance
Saket; 20 July, 2010
Hemant K Chitale said...: Saket,

Use V$SESSION and V$ACTIVE_SESSION_HISTORY.

Join V$SESSION to V$PROCESS on V$SESSION.PADDR=V$PROCESS.ADDR and get the SPID from v$PROCESS which is the OS server process id.

Hemant K Chitale; 20 July, 2010

Hemant's Oracle DBA Blog