Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2003
    Posts
    32

    Unanswered: how can i determine the performance

    Now our database have 20GB data and the performance is extremely slow
    So i would like to is the io of disk storage slow or there is bottleneck on oracle

    the disk storage used NAS with Oracle 9i on IBM AIX dual CPU 2GB ram

  2. #2
    Join Date
    Jan 2004
    Location
    India
    Posts
    191
    Hi,

    Go for oracle statspack. It give good picture about oracle performance.

    Thanks,
    Pagnint
    (No need to search web before posting new question)

  3. #3
    Join Date
    Dec 2003
    Posts
    32
    but how can i refer to this .. And which part should i study

  4. #4
    Join Date
    Nov 2002
    Posts
    833
    install the statspack package

    SQL> @ORACLE_HOME/rdbms/admin/spcreate

    if you run into problems simply run spdrop.sql as peruser

    then set timed_statistics = true
    collect snapshots at the highest level which is 10

    analyze the wait events esp. for I/Os

    for me I once figured out that even in a SAN/NAS Storage spindles count

  5. #5
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482
    Quote Originally Posted by alfredfong
    Now our database have 20GB data and the performance is extremely slow
    So i would like to is the io of disk storage slow or there is bottleneck on oracle

    the disk storage used NAS with Oracle 9i on IBM AIX dual CPU 2GB ram
    You can use the OEM Tuning Pack -> Expert. All you have to do is to install the agent on your db server and collect some statistics. The Expert will give you a tuning recommendations.

    The more precise way is to use STASTPACK as suggested.


    HTH,

    clio_usa - OCP 8/8i/9i DBA

Posting Permissions

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