+ Reply to Thread
Results 1 to 6 of 6
  1. 04-11-2003 03:00 PM #1
    wwalice
    wwalice is offline Junior Member
    Join Date
    Jul 2000
    Posts
    68

    database performance

    Hi,

    Now I am going to get a report on the database performance. I know bstat/estat, or statspack. But these tools just take the snapshots at the beginning and the end. What I want to get is the I/O performance, real track of the I/O performance, not just the statistics from the beginning to the end.
    Any info will be appreciated!!

    Thanks.
    Reply With Quote Reply With Quote
  2. 04-11-2003 03:39 PM #2
    slimdave
    slimdave is offline Foreign Script Kiddie
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    have you looked as o/s level tools? vmstat and sar on unix, or windows tools?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE
    Reply With Quote Reply With Quote
  3. 04-12-2003 05:08 AM #3
    hacketta1
    hacketta1 is offline Senior Member
    Join Date
    Feb 2003
    Location
    Leeds, UK
    Posts
    367
    It's not cheap, but "Oracle High Performance Tuning with STATSPACK" by Donald K Burleson contains scripts to extend STATSPACK to include OS stats via the vmstat and iostaty commands. Obviously, this won't be much good if you're not on UNIX/Linux.
    Reply With Quote Reply With Quote
  4. 04-12-2003 12:34 PM #4
    stmontgo's Avatar
    stmontgo
    stmontgo is offline Senior Advisor
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    look at Oracle 92 diagnostics pack, u can collect OS stats from there
    I'm stmontgo and I approve of this message
    Reply With Quote Reply With Quote
  5. 04-14-2003 05:19 PM #5
    tamilselvan
    tamilselvan is offline Moderator
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    You can query V$FILESTAT to know about datafiles I/O perf.
    This view has great in-depth statistics with respect to the datafiles I/O.
    Reply With Quote Reply With Quote
  6. 04-15-2003 06:21 AM #6
    dasari98's Avatar
    dasari98
    dasari98 is offline Member
    Join Date
    Apr 2002
    Location
    Bangalore
    Posts
    47
    Oracle enterprise manager has tools for this
    Cheers
    Murali
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

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

Forum Rules

 Click Here to Expand Forum to Full Width