Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> v$filestat and file efficiency

v$filestat and file efficiency

From: Jeffrey Hunter <jhunter_at_fore.com>
Date: Mon, 24 Aug 1998 11:19:08 -0400
Message-ID: <35E1846B.1423672E@fore.com>


Greetings all,

Can anyone tell me the difference between the columns: phywrts and phyblkwrt from the v$filestat view? I have a query that shows file efficiency and I am trying to gain an understanding of what this efficiency value represents and how it can be improved. Here is the query that produces the efficiency report:

SELECT

        f.tablespace_name         ts

, f.file_name fn
, v.phyrds rds
, v.phyblkrd blk_rds
, v.phywrts wrts
, v.phyblkwrt blk_wrts
, v.phyrds + v.phywrts rw
, v.phyblkrd + v.phyblkwrt blk_rw
, DECODE(v.phyblkrd, 0, null,
ROUND(100*(v.phyrds + v.phywrts)/ (v.phyblkrd + v.phyblkwrt), 2 )) eff FROM dba_data_files f
, v$filestat v
WHERE f.file_id = v.file# ORDER BY ts

Any help with understanding file efficiency would be greatly appreciated!

regards,
jeff

+----------------------------------------------------------+
| Jeffrey M. Hunter              |  WORK: jhunter_at_fore.com |
| Oracle Database Administrator  |  HOME: jhunter_at_isrv.com |
| FORE Systems                   |  www.isrv.com/~jhunter  |
| 3000 FORE Drive                |  OFFICE: (724) 742-7435 |
| Warrendale, PA 15086           |  FAX   : (724) 789-9601 |
+----------------------------------------------------------+



Received on Mon Aug 24 1998 - 10:19:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US