Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002
    Posts
    9

    Red face Unanswered: How to get performance data of Oracle by using PROC API?

    I want to get performance data from Oracle Server in my PROC program, but I don't know what the API is.

    Anyone knows?

    Thanks a lot!

  2. #2
    Join Date
    May 2002
    Location
    Phoenix, AZ
    Posts
    24

    Re: How to get performance data of Oracle by using PROC API?

    You simply reference the dynamic performance views. You can get most of what you want from v$ views. This should be a good starting point. Check out this list:

    select table_name from dict
    where table_name like 'V$%';

    There are many other views to choose from if these do not meet your needs.

    Here are a few queries that are of interest to me:

    select name, value from v$sysstat
    where name in ('redo log space requests',
    'redo buffer allocation retries', 'DBWR checkpoints');

    col name format a18
    col mgr format 9.9999
    col imigr format 9.9999
    select
    name, misses, gets, misses/(gets+1) mgr,
    immediate_misses imisses, immediate_gets igets,
    immediate_misses/(immediate_gets+1) imigr
    from v$latch
    where
    misses/(gets+1) > 0.001
    or immediate_misses/(immediate_gets+1) > 0.001
    order by name;

    col usn format 999
    col status format a12
    select usn, status, gets, waits, aveactive, extends, shrinks
    from v$rollstat;

    select class, count, sysdate from v$waitstat where class like 'undo%';

    select name, value from v$sysstat
    where name in ('redo log space requests',
    'redo buffer allocation retries', 'DBWR checkpoints');

Posting Permissions

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