Result from v$sysstat
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Result from v$sysstat

  1. #1
    Join Date
    Oct 2002
    Location
    Breda, The Netherlands
    Posts
    317

    Question Result from v$sysstat

    Hello

    Please consider the following statement:

    PROMPT
    PROMPT Redo Log Buffer should be as close to 0 as possible
    PROMPT
    COLUMN value FORMAT 9999.9999
    COLUMN name FORMAT a50

    select
    substr(name,1,30) as name,
    value
    from
    v$sysstat
    where name ='redo log space requests';
    /


    The result of the statement when run on my production db (oracle 8.1.7):

    "Redo Log Buffer should be as close to 0 as possible"

    NAME | VALUE
    ------------------------| ----------
    redo log space requests | 4121.0000


    This DB is up for months now, and I don't know if this is a bad number.

    The statement came from the oraYAPS (Yet Another Performance Script), from http://www.integer.org. It's a project about building a versatile performce script.

    All the results of the statements inside that script looked fine, but I don't trust the result of this particular section.

    Can someone tell me how 'bad' this number is and what I should do?

    Thanks in advance!!
    Erik

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    you dont look statstics like that, you must take values between a time interval, i.e delta values

  3. #3
    Join Date
    Dec 2000
    Location
    Brazil / São Paulo
    Posts
    97
    Not found relation between the URL and the requested information.
    How much to the value of it REDO LOG, probably you has a very small value for the amount of transactions effected in this data base.

    Statistics of my data bases

    DBNAME VALUE
    ------ ----------
    Test 381
    pd00 297
    pd01 37810
    pd02 74
    Márcio de Souza Almeida
    DBA Oracle / SQLServer / PostgreSQL
    Rua Cupa, 139 Apto 85 A
    Penha - São Paulo - SP
    03640-000 - Brasil
    http://www.directory.com.br

  4. #4
    Join Date
    Oct 2002
    Location
    Breda, The Netherlands
    Posts
    317
    Link to the script: http://www.integer.org/files/oracle-...nce-tuning.sql

    Maybe it is wrong to use these kind of scripts, but I'm just entering the realm of Performance Tuning and I thought it could help me...

    Thanks sofar!

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    not useful scripts at all, if I was you I wouldnt even look at them

  6. #6
    Join Date
    Oct 2002
    Location
    Breda, The Netherlands
    Posts
    317
    I'll stay with STATSPACK, UTLBSTAT and UTLESTAT then...

    Thanks.

Posting Permissions

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



Click Here to Expand Forum to Full Width