| 100%cpu usage [message #77129] |
Tue, 14 September 2004 22:59  |
mohd shabbir
Messages: 3
Registered: September 2004
|
Junior Member |
|
|
hello,
I am DBA working in KSA.We have oracle 9i Application server on
Windows 2000.my processor is 2.4 gh and RAM being 1GB.
The number of users being 50 to 55.The servers cpu usage is showing 100% most of the time which is resulting in the Application running very slow.i my alert log file i got a message
KTSDUMP:End of in-memory trace dump.
Can you please suggest the solution and help me oUT.
Thanking you.
shabbir.
|
|
|
|
| Re: 100%cpu usage [message #77132 is a reply to message #77129] |
Wed, 15 September 2004 22:02  |
easywebtech
Messages: 20
Registered: August 2004
|
Junior Member |
|
|
run below when server 100% and get the running SQL.
After thet you need to finetune the SQL.(may be need to indexed)
SELECT USERNAME,SID,SERIAL#,TERMINAL,LOGON_TIME,STATUS,
(SELECT distinct SQL_TEXT FROM SYS.V_$SQL_SHARED_MEMORY
where HASH_VALUE=SQL_HASH_VALUE)SQL FROM V$SESSION
WHERE STATUS='ACTIVE'
and USERNAME IS NOT NULL
webmaster
www.easywebtech.com
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
