I am an Oracle Database Specialist in Singapore.
get an rss feed of this blog at http://hemantoracledba.blogspot.com/feeds/posts/default?alt=rss
follow me on twitter : @HemantKChitale
Hello,couple of days ago there was a thread on OTN about "Database recover". http://forums.oracle.com/forums/thread.jspa?threadID=893989&tstart=25OP said that it is a production system and having NO BACKUPS & database is in NO ARCHIVE mode. what to say on this?Regards!
Hello Hemant,I am not sure if this is the place where i can post my queryIf this isn't, please send me the link or help me knowing itI am using Oracle 9i R2 on HP-UXMy 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 thisThanks in advanceSaket
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
Post a Comment