Edit D:\app\Administrator\product\11.2.0\dbhome_1\dbs\perf11.ora
COMMENT *********************************************************************** COMMENT COMMENT Performance Object file COMMENT COMMENT DESCRIPTION COMMENT This file contains all the performance objects to be displayed COMMENT by the Performance Monitor on Windows NT COMMENT COMMENT *********************************************************************** COMMENT 10/11/95 psciarra release COMMENT 07/03/95 rsubbaro creation COMMENT *********************************************************************** PERF_OBJECT_FILE = perf11.ora OBJ_START = DATAFILES OBJ_INDEX_OFFSET = 0 OBJ_DETAIL_LEVEL = PERF_DETAIL_NOVICE OBJ_SQL = select name, phyrds, phywrts from v$datafile df, v$filestat fs where df.file# = fs.file# OBJ_INSTANCES = 1 OBJ_INST_DATA_TYPE = STRING_TYPE OBJ_INST_DATA_LEN = 30 OBJ_INST_PARENT_INDEX_OFFSET = 0 OBJ_CTR_NUMBER = 2 OBJ_COUNTER_START = phyrds/sec OBJ_COUNTER_INDEX_OFFSET = 2 OBJ_COUNTER_SCALE = 0 OBJ_COUNTER_LEVEL = PERF_DETAIL_NOVICE OBJ_COUNTER_TYPE = PERF_COUNTER_COUNTER OBJ_COUNTER_SIZE = 4 OBJ_COUNTER_DATA_OFFSET = 4 OBJ_COUNTER_SQL = OBJ_COUNTER_EXT_ORACLE_DATA_TYPE = INTEGER_TYPE OBJ_COUNTER_EXT_ORACLE_DATA_LEN = 4 OBJ_COUNTER_END = phyrds/sec OBJ_COUNTER_START = phywrts/sec OBJ_COUNTER_INDEX_OFFSET = 4 OBJ_COUNTER_SCALE = 0 OBJ_COUNTER_LEVEL = PERF_DETAIL_NOVICE OBJ_COUNTER_TYPE = PERF_COUNTER_COUNTER OBJ_COUNTER_SIZE = 4 OBJ_COUNTER_DATA_OFFSET = 4 OBJ_COUNTER_SQL = OBJ_COUNTER_EXT_ORACLE_DATA_TYPE = INTEGER_TYPE OBJ_COUNTER_EXT_ORACLE_DATA_LEN = 4 OBJ_COUNTER_END = phywrts/sec OBJ_END = DATAFILES COMMENT *********************************************************************** OBJ_START = SORTS OBJ_INDEX_OFFSET = 10 OBJ_DETAIL_LEVEL = PERF_DETAIL_NOVICE OBJ_SQL = OBJ_INSTANCES = 0 OBJ_INST_DATA_TYPE = OBJ_INST_DATA_LEN = 0 OBJ_INST_PARENT_INDEX_OFFSET = 0 OBJ_CTR_NUMBER = 2 OBJ_COUNTER_START = sorts in memory/sec OBJ_COUNTER_INDEX_OFFSET = 12 OBJ_COUNTER_SCALE = 0 OBJ_COUNTER_LEVEL = PERF_DETAIL_NOVICE OBJ_COUNTER_TYPE = PERF_COUNTER_COUNTER OBJ_COUNTER_SIZE = 4 OBJ_COUNTER_DATA_OFFSET = 4 OBJ_COUNTER_SQL = select value from v$sysstat where NAME = 'sorts (memory)' OBJ_COUNTER_EXT_ORACLE_DATA_TYPE = INTEGER_TYPE OBJ_COUNTER_EXT_ORACLE_DATA_LEN = 4 OBJ_COUNTER_END = sorts in memory/sec OBJ_COUNTER_START = sorts on disk/sec OBJ_COUNTER_INDEX_OFFSET = 14 OBJ_COUNTER_SCALE = 0 OBJ_COUNTER_LEVEL = PERF_DETAIL_NOVICE OBJ_COUNTER_TYPE = PERF_COUNTER_COUNTER OBJ_COUNTER_SIZE = 4 OBJ_COUNTER_DATA_OFFSET = 4 OBJ_COUNTER_SQL = select value from v$sysstat where NAME = 'sorts (disk)' OBJ_COUNTER_EXT_ORACLE_DATA_TYPE = INTEGER_TYPE OBJ_COUNTER_EXT_ORACLE_DATA_LEN = 4 OBJ_COUNTER_END = sorts on disk/sec OBJ_END = SORTS COMMENT *********************************************************************** OBJ_START = SPACE OBJ_INDEX_OFFSET = 20 OBJ_DETAIL_LEVEL = PERF_DETAIL_NOVICE OBJ_SQL = OBJ_INSTANCES = 0 OBJ_INST_DATA_TYPE = OBJ_INST_DATA_LEN = 0 OBJ_INST_PARENT_INDEX_OFFSET = 0 OBJ_CTR_NUMBER = 1 OBJ_COUNTER_START = recursive calls/sec OBJ_COUNTER_INDEX_OFFSET = 22 OBJ_COUNTER_SCALE = 0 OBJ_COUNTER_LEVEL = PERF_DETAIL_NOVICE OBJ_COUNTER_TYPE = PERF_COUNTER_COUNTER OBJ_COUNTER_SIZE = 4 OBJ_COUNTER_DATA_OFFSET = 4 OBJ_COUNTER_SQL = select value from v$sysstat where NAME = 'recursive calls' OBJ_COUNTER_EXT_ORACLE_DATA_TYPE = INTEGER_TYPE OBJ_COUNTER_EXT_ORACLE_DATA_LEN = 4 OBJ_COUNTER_END = recursive calls/sec OBJ_END = SPACE COMMENT *********************************************************************** OBJ_START = LIBRARY OBJ_INDEX_OFFSET = 30 OBJ_DETAIL_LEVEL = PERF_DETAIL_NOVICE OBJ_SQL = OBJ_INSTANCES = 0 OBJ_INST_DATA_TYPE = OBJ_INST_DATA_LEN = 0 OBJ_INST_PARENT_INDEX_OFFSET = 0 OBJ_CTR_NUMBER = 2 OBJ_COUNTER_START = reloads/pins ratio OBJ_COUNTER_INDEX_OFFSET = 32 OBJ_COUNTER_SCALE = 0 OBJ_COUNTER_LEVEL = PERF_DETAIL_NOVICE OBJ_COUNTER_TYPE = PERF_RAW_FRACTION OBJ_COUNTER_SIZE = 4 OBJ_COUNTER_DATA_OFFSET = 4 OBJ_COUNTER_SQL = select sum(reloads) from v$librarycache OBJ_COUNTER_EXT_ORACLE_DATA_TYPE = INTEGER_TYPE OBJ_COUNTER_EXT_ORACLE_DATA_LEN = 4 OBJ_COUNTER_END = reloads/pins ratio OBJ_COUNTER_START = reload/pins base OBJ_COUNTER_INDEX_OFFSET = 34 OBJ_COUNTER_SCALE = 0 OBJ_COUNTER_LEVEL = PERF_DETAIL_NOVICE OBJ_COUNTER_TYPE = PERF_RAW_BASE OBJ_COUNTER_SIZE = 4 OBJ_COUNTER_DATA_OFFSET = 4 OBJ_COUNTER_SQL = select sum(pins) from v$librarycache OBJ_COUNTER_EXT_ORACLE_DATA_TYPE = INTEGER_TYPE OBJ_COUNTER_EXT_ORACLE_DATA_LEN = 4 OBJ_COUNTER_END = reload/pins base OBJ_END = LIBRARY COMMENT *********************************************************************** OBJ_START = DICTIONARY OBJ_INDEX_OFFSET = 40 OBJ_DETAIL_LEVEL = PERF_DETAIL_NOVICE OBJ_SQL = OBJ_INSTANCES = 0 OBJ_INST_DATA_TYPE = OBJ_INST_DATA_LEN = 0 OBJ_INST_PARENT_INDEX_OFFSET = 0 OBJ_CTR_NUMBER = 2 OBJ_COUNTER_START = getmisses/gets ratio OBJ_COUNTER_INDEX_OFFSET = 42 OBJ_COUNTER_SCALE = 0 OBJ_COUNTER_LEVEL = PERF_DETAIL_NOVICE OBJ_COUNTER_TYPE = PERF_RAW_FRACTION OBJ_COUNTER_SIZE = 4 OBJ_COUNTER_DATA_OFFSET = 4 OBJ_COUNTER_SQL = select sum(getmisses) from v$rowcache OBJ_COUNTER_EXT_ORACLE_DATA_TYPE = INTEGER_TYPE OBJ_COUNTER_EXT_ORACLE_DATA_LEN = 4 OBJ_COUNTER_END = getmisses/gets ratio OBJ_COUNTER_START = getmisses/gets base OBJ_COUNTER_INDEX_OFFSET = 44 OBJ_COUNTER_SCALE = 0 OBJ_COUNTER_LEVEL = PERF_DETAIL_NOVICE OBJ_COUNTER_TYPE = PERF_RAW_BASE OBJ_COUNTER_SIZE = 4 OBJ_COUNTER_DATA_OFFSET = 4 OBJ_COUNTER_SQL = select sum(gets) from v$rowcache OBJ_COUNTER_EXT_ORACLE_DATA_TYPE = INTEGER_TYPE OBJ_COUNTER_EXT_ORACLE_DATA_LEN = 4 OBJ_COUNTER_END = getmisses/gets base OBJ_END = DICTIONARY COMMENT *********************************************************************** OBJ_START = FREELIST OBJ_INDEX_OFFSET = 50 OBJ_DETAIL_LEVEL = PERF_DETAIL_NOVICE OBJ_SQL = OBJ_INSTANCES = 0 OBJ_INST_DATA_TYPE = OBJ_INST_DATA_LEN = 0 OBJ_INST_PARENT_INDEX_OFFSET = 0 OBJ_CTR_NUMBER = 2 OBJ_COUNTER_START = waits/request ratio OBJ_COUNTER_INDEX_OFFSET = 52 OBJ_COUNTER_SCALE = 0 OBJ_COUNTER_LEVEL = PERF_DETAIL_NOVICE OBJ_COUNTER_TYPE = PERF_RAW_FRACTION OBJ_COUNTER_SIZE = 4 OBJ_COUNTER_DATA_OFFSET = 4 OBJ_COUNTER_SQL = select count from v$waitstat where class = 'free list' OBJ_COUNTER_EXT_ORACLE_DATA_TYPE = INTEGER_TYPE OBJ_COUNTER_EXT_ORACLE_DATA_LEN = 4 OBJ_COUNTER_END =waits/request ratio OBJ_COUNTER_START = waits/request base OBJ_COUNTER_INDEX_OFFSET = 54 OBJ_COUNTER_SCALE = 0 OBJ_COUNTER_LEVEL = PERF_DETAIL_NOVICE OBJ_COUNTER_TYPE = PERF_RAW_BASE OBJ_COUNTER_SIZE = 4 OBJ_COUNTER_DATA_OFFSET = 4 OBJ_COUNTER_SQL = select sum(value) from v$sysstat where name in ('db block gets','consistent gets') OBJ_COUNTER_EXT_ORACLE_DATA_TYPE = INTEGER_TYPE OBJ_COUNTER_EXT_ORACLE_DATA_LEN = 4 OBJ_COUNTER_END = waits/request base OBJ_END = FREELIST COMMENT *********************************************************************** OBJ_START = DBWR1 OBJ_INDEX_OFFSET = 60 OBJ_DETAIL_LEVEL = PERF_DETAIL_NOVICE OBJ_SQL = OBJ_INSTANCES = 0 OBJ_INST_DATA_TYPE = OBJ_INST_DATA_LEN = 0 OBJ_INST_PARENT_INDEX_OFFSET = 0 OBJ_CTR_NUMBER = 2 OBJ_COUNTER_START = buffers_scanned/sec OBJ_COUNTER_INDEX_OFFSET = 62 OBJ_COUNTER_SCALE = 0 OBJ_COUNTER_LEVEL = PERF_DETAIL_NOVICE OBJ_COUNTER_TYPE = PERF_COUNTER_COUNTER OBJ_COUNTER_SIZE = 4 OBJ_COUNTER_DATA_OFFSET = 4 OBJ_COUNTER_SQL = select value from v$sysstat where NAME = 'DBWR buffers scanned' OBJ_COUNTER_EXT_ORACLE_DATA_TYPE = INTEGER_TYPE OBJ_COUNTER_EXT_ORACLE_DATA_LEN = 4 OBJ_COUNTER_END = buffers_scanned/sec OBJ_COUNTER_START = lru scans/sec OBJ_COUNTER_INDEX_OFFSET = 64 OBJ_COUNTER_SCALE = 0 OBJ_COUNTER_LEVEL = PERF_DETAIL_NOVICE OBJ_COUNTER_TYPE = PERF_COUNTER_COUNTER OBJ_COUNTER_SIZE = 4 OBJ_COUNTER_DATA_OFFSET = 4 OBJ_COUNTER_SQL = select value from v$sysstat where NAME = 'DBWR lru scans' OBJ_COUNTER_EXT_ORACLE_DATA_TYPE = INTEGER_TYPE OBJ_COUNTER_EXT_ORACLE_DATA_LEN = 4 OBJ_COUNTER_END = lru scans/sec OBJ_END = DBWR1 COMMENT *********************************************************************** OBJ_START = DBWR2 OBJ_INDEX_OFFSET = 70 OBJ_DETAIL_LEVEL = PERF_DETAIL_NOVICE OBJ_SQL = OBJ_INSTANCES = 0 OBJ_INST_DATA_TYPE = OBJ_INST_DATA_LEN = 0 OBJ_INST_PARENT_INDEX_OFFSET = 0 OBJ_CTR_NUMBER = 2 OBJ_COUNTER_START = timeouts/sec OBJ_COUNTER_INDEX_OFFSET = 72 OBJ_COUNTER_SCALE = 0 OBJ_COUNTER_LEVEL = PERF_DETAIL_NOVICE OBJ_COUNTER_TYPE = PERF_COUNTER_COUNTER OBJ_COUNTER_SIZE = 4 OBJ_COUNTER_DATA_OFFSET = 4 OBJ_COUNTER_SQL = select value from v$sysstat where NAME = 'DBWR timeouts' OBJ_COUNTER_EXT_ORACLE_DATA_TYPE = INTEGER_TYPE OBJ_COUNTER_EXT_ORACLE_DATA_LEN = 4 OBJ_COUNTER_END = timeouts/sec OBJ_COUNTER_START = checkpoints/sec OBJ_COUNTER_INDEX_OFFSET = 74 OBJ_COUNTER_SCALE = 0 OBJ_COUNTER_LEVEL = PERF_DETAIL_NOVICE OBJ_COUNTER_TYPE = PERF_COUNTER_COUNTER OBJ_COUNTER_SIZE = 4 OBJ_COUNTER_DATA_OFFSET = 4 OBJ_COUNTER_SQL = select value from v$sysstat where NAME = 'DBWR checkpoints' OBJ_COUNTER_EXT_ORACLE_DATA_TYPE = INTEGER_TYPE OBJ_COUNTER_EXT_ORACLE_DATA_LEN = 4 OBJ_COUNTER_END = checkpoints/sec OBJ_END = DBWR2 COMMENT *********************************************************************** OBJ_START = BUFFER OBJ_INDEX_OFFSET = 80 OBJ_DETAIL_LEVEL = PERF_DETAIL_NOVICE OBJ_SQL = OBJ_INSTANCES = 0 OBJ_INST_DATA_TYPE = OBJ_INST_DATA_LEN = 0 OBJ_INST_PARENT_INDEX_OFFSET = 0 OBJ_CTR_NUMBER = 2 OBJ_COUNTER_START = phyreads/gets ratio OBJ_COUNTER_INDEX_OFFSET = 82 OBJ_COUNTER_SCALE = 0 OBJ_COUNTER_LEVEL = PERF_DETAIL_NOVICE OBJ_COUNTER_TYPE = PERF_RAW_FRACTION OBJ_COUNTER_SIZE = 4 OBJ_COUNTER_DATA_OFFSET = 4 OBJ_COUNTER_SQL = select value from v$sysstat where name = 'physical reads' OBJ_COUNTER_EXT_ORACLE_DATA_TYPE = INTEGER_TYPE OBJ_COUNTER_EXT_ORACLE_DATA_LEN = 4 OBJ_COUNTER_END = phyreads/gets ratio OBJ_COUNTER_START = phyreads/gets base OBJ_COUNTER_INDEX_OFFSET = 84 OBJ_COUNTER_SCALE = 0 OBJ_COUNTER_LEVEL = PERF_DETAIL_NOVICE OBJ_COUNTER_TYPE = PERF_RAW_BASE OBJ_COUNTER_SIZE = 4 OBJ_COUNTER_DATA_OFFSET = 4 OBJ_COUNTER_SQL = select sum(value) from v$sysstat where name in ('db block gets','consistent gets') OBJ_COUNTER_EXT_ORACLE_DATA_TYPE = INTEGER_TYPE OBJ_COUNTER_EXT_ORACLE_DATA_LEN = 4 OBJ_COUNTER_END = phyreads/gets base OBJ_END = BUFFER COMMENT *********************************************************************** OBJ_START = REDO1 OBJ_INDEX_OFFSET = 90 OBJ_DETAIL_LEVEL = PERF_DETAIL_NOVICE OBJ_SQL = OBJ_INSTANCES = 0 OBJ_INST_DATA_TYPE = OBJ_INST_DATA_LEN = 0 OBJ_INST_PARENT_INDEX_OFFSET = 0 OBJ_CTR_NUMBER = 1 OBJ_COUNTER_START = redologs OBJ_COUNTER_INDEX_OFFSET = 92 OBJ_COUNTER_SCALE = 0 OBJ_COUNTER_LEVEL = PERF_DETAIL_NOVICE OBJ_COUNTER_TYPE = PERF_COUNTER_RAWCOUNT OBJ_COUNTER_SIZE = 4 OBJ_COUNTER_DATA_OFFSET = 4 OBJ_COUNTER_SQL = select value from v$sysstat where name = 'redo log space requests' OBJ_COUNTER_EXT_ORACLE_DATA_TYPE = INTEGER_TYPE OBJ_COUNTER_EXT_ORACLE_DATA_LEN = 4 OBJ_COUNTER_END = redologs OBJ_END = REDO1
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de