Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » 100%cpu usage
100%cpu usage [message #77129] Tue, 14 September 2004 22:59 Go to next message
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 Go to previous message
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
Previous Topic: Menu by defect of oracle developer 10g
Next Topic: WebForms + Oracle 9i Database
Goto Forum:
  


Current Time: Fri Feb 23 16:31:45 CST 2024