| End user problem [message #140886] |
Thu, 06 October 2005 00:51  |
oradba16
Messages: 54
Registered: September 2005
|
Member |
|
|
plz ans the following ques.........
1).A end-user complains of the system running slow?what would be your reaction?what are the primary steps should be taken to solve the issue?
2).Where to view the SQL query?How to find which query is using "extensive CPU"...CPU hog?
|
|
|
|
|
|
| Re: End user problem [message #140909 is a reply to message #140887] |
Thu, 06 October 2005 02:58  |
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
|
Senior Member |
|
|
1)a) Ask the user to define slow, find out what query / queries he/she is running. Then assess yourself if it is truely slow.
b) Are you manageing resources? Is this user in a resource group that is allocated a small amount of resources?
2) view the sqltext from v$sql or v$sqltext or v$sqlarea for the sql itself and see v$session_longops for sql that takes more that 6 seconds (cpu time) for that session.
Along with lots and lots of other things.
As girish says, it's time for you to start reading the documentation, check out tahiti.oracle.com to get the documentation.
Jim
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
