Results 1 to 3 of 3

Thread: Mts

  1. #1
    Join Date
    Nov 2003
    Location
    kualalumpur
    Posts
    89

    Question Unanswered: Mts

    Hello Oracle DBAs,
    Our Database(oracle 8i on HP-UX11.0) has become very slow.
    As the first step of investigation I ran top and ps commands shows that oracle related process are consuming most of CPU usage.
    As the first step of action I checked the server processes and noticed that its not on MTS(by querying v$circuit--no rows selected).when I queried v$session to c how many users r accessing db concurrently.ranges from 120-130.Now..
    1)Is it really advantageous with respect to performance if I change it to MTS.
    2)How do I make it to run on MTS (shared server process) from dedicated...
    3)How do I measure the -ve effect of rowchaining/rowmigration on database server performance.
    Please help me in resolving this..
    Thanks in advance..
    sridhar

  2. #2
    Join Date
    Jan 2004
    Posts
    370
    Your system has started running very slowly.
    You don't have MTS configured, and you think it might help.

    Maybe, if you were memory bound...
    But you say Oracle processes consume most of the CPU.
    Unless the machine is CPU bound, then so what?

    Is the whole machine running slowly, or just the database?
    Or just certain jobs running against the database?
    Or just certain queries running against the database?

    What exactly has become very slow?

    Have you gathered statistics on the database?
    Do you have base line statistics to compare them against?

    Oracle statistics will tell you more about where the time is being spent than top or ps ever will.

  3. #3
    Join Date
    Nov 2003
    Location
    kualalumpur
    Posts
    89

    Details..

    Thankyou for your reply..
    what I was trying to say is due to certain oracle process the whole system become slow,and this I concluded by looking at report given by top command.
    The following is the output of of top command...

    System: mohrelx1 Wed Jun 30 11:04:52 2004
    Load averages: 2.87, 1.83, 0.95
    173 processes: 152 sleeping, 21 running
    Cpu states:
    CPU LOAD USER NICE SYS IDLE BLOCK SWAIT INTR SSYS
    0 2.55 93.4% 0.0% 6.6% 0.0% 0.0% 0.0% 0.0% 0.0%
    1 2.43 97.0% 0.0% 3.0% 0.0% 0.0% 0.0% 0.0% 0.0%
    2 3.21 96.8% 0.0% 3.2% 0.0% 0.0% 0.0% 0.0% 0.0%
    3 3.28 96.6% 0.0% 3.4% 0.0% 0.0% 0.0% 0.0% 0.0%
    --- ---- ----- ----- ----- ----- ----- ----- ----- -----
    avg 2.87 96.0% 0.0% 4.0% 0.0% 0.0% 0.0% 0.0% 0.0%

    Memory: 320220K (182300K) real, 887508K (578764K) virtual, 46896K free Page# 1/6

    CPU TTY PID USERNAME PRI NI SIZE RES STATE TIME %WCPU %CPU COMMAND
    2 ? 28699 oracle 241 20 33636K 4904K run 2:48 81.89 81.74 oracleelx
    3 ? 29035 oracle 241 20 33636K 4944K run 1:51 70.42 70.29 oracleelx
    0 ? 29234 oracle 239 20 33636K 4916K run 1:24 67.44 67.32 oracleelx
    1 ? 29269 oracle 241 20 33636K 4924K run 1:11 48.83 48.74 oracleelx
    3 ? 27104 oracle 241 20 33636K 4892K run 6:20 45.92 45.84 oracleelx
    1 ? 28508 oracle 241 20 33636K 4836K run 3:17 45.85 45.77 oracleelx
    0 ? 29924 oracle 212 20 33636K 1692K run 0:01 13.48 3.49 oracleelx
    1 ? 34 root 152 20 0K 0K run 157:44 1.25 1.25 vxfsd
    1 ? 1671 root 152 20 3088K 2472K run 154:53 1.10 1.10 ns-admin
    2 ? 29698 oracle 154 20 40948K 12176K sleep 0:00 1.18 1.08 oracleelx


    and I install statspack and took few snapshots..but as Iam learning few things now...I shall be greatful if u pass some clues by looking at following snapshot..
    Please refer to the attachments..
    Thanks in advance..
    sincerely
    sridhar
    Attached Files Attached Files
    Last edited by sridharreddy_d; 07-01-04 at 05:11.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •