Announcement

Collapse

http://progeeking.com

See more
See less

Display IO by file

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Display IO by file

    Code:
    select 
    substr(a.file#,1,2) "#", 
    substr(a.name,1,30) "Name", 
    a.status, 
    a.bytes, 
    b.phyrds, 
    b.phywrts 
    from v$datafile a, v$filestat b 
    where a.file# = b.file#;
    
Working...
X