v$sysstat names


For definiitions check : https://sites.google.com/site/oraclemonitor/oracle-statistics-defined-11-2

Collected with:

10g was on LINIX, and 11.2 on windows

 create table statnames as select i.version, m.name
from  V$statname m,
      (select version from v$instance where rownum < 2 ) i
;

insert into  statnames  (
select i.version, m.name
from  V$statname@LINUX m,
      (select version from v$instance@LINUX where rownum < 2 ) i
)
;


with statv as (
   select a.version v1, b.version v2,b.name
   from
         ( select version,name
          from statnames
          where version='11.2.0.1.0' ) b,
         ( select version,name
          from statnames
          where version='10.2.0.4.0') a
   where a.name=b.name(+)
   union
   select a.version, b.version,b.name
   from
         ( select version,name
          from statnames
          where version='11.2.0.1.0' ) b,
         ( select version,name
          from statnames
          where version='10.2.0.4.0') a
   where a.name(+)=b.name
)
select * from statv order by name;
SQL> /

V1                V2                NAME
----------------- ----------------- ----------------------------------------------------------------
                  11.2.0.1.0        Batched IO (bound) vector count
                  11.2.0.1.0        Batched IO (full) vector count
                  11.2.0.1.0        Batched IO (space) vector count
                  11.2.0.1.0        Batched IO block miss count
                  11.2.0.1.0        Batched IO buffer defrag count
                  11.2.0.1.0        Batched IO double miss count
                  11.2.0.1.0        Batched IO same unit count
                  11.2.0.1.0        Batched IO single block count
                  11.2.0.1.0        Batched IO slow jump count
                  11.2.0.1.0        Batched IO vector block count
                  11.2.0.1.0        Batched IO vector read count
                  11.2.0.1.0        Batched IO zero block count
                  11.2.0.1.0        Block Cleanout Optim referenced
                  11.2.0.1.0        CC Analyze CUs Decompressed
                  11.2.0.1.0        CC Analyzer Calls
                  11.2.0.1.0        CC Archive CUs Compressed
                  11.2.0.1.0        CC Archive CUs Decompressed
                  11.2.0.1.0        CC CU Row Pieces Compressed
                  11.2.0.1.0        CC CUs Compressed
                  11.2.0.1.0        CC CUs Decompressed
                  11.2.0.1.0        CC Check CUs Decompressed
                  11.2.0.1.0        CC Columns Decompressed
                  11.2.0.1.0        CC Compressed Length Compressed
                  11.2.0.1.0        CC Compressed Length Decompressed
                  11.2.0.1.0        CC DML CUs Decompressed
                  11.2.0.1.0        CC Decompressed Length Compressed
                  11.2.0.1.0        CC Decompressed Length Decompressed
                  11.2.0.1.0        CC Dump CUs Decompressed
                  11.2.0.1.0        CC Pieces Buffered for Decompression
                  11.2.0.1.0        CC Query High CUs Compressed
                  11.2.0.1.0        CC Query High CUs Decompressed
                  11.2.0.1.0        CC Query Low CUs Compressed
                  11.2.0.1.0        CC Query Low CUs Decompressed
                  11.2.0.1.0        CC Rowid CUs Decompressed
                  11.2.0.1.0        CC Rows Compressed
                  11.2.0.1.0        CC Rows Not Compressed
                  11.2.0.1.0        CC Scan CUs Decompressed
                  11.2.0.1.0        CC Total Columns for Decompression
                  11.2.0.1.0        CC Total Pieces for Decompression
                  11.2.0.1.0        CC Total Rows for Decompression
                  11.2.0.1.0        CC Turbo Scan CUs Decompressed
10.2.0.4.0        11.2.0.1.0        CCursor + sql area evicted
10.2.0.4.0        11.2.0.1.0        CPU used by this session
10.2.0.4.0        11.2.0.1.0        CPU used when call started
10.2.0.4.0        11.2.0.1.0        CR blocks created
10.2.0.4.0        11.2.0.1.0        Cached Commit SCN referenced
                  11.2.0.1.0        Clusterwide global transactions
                  11.2.0.1.0        Clusterwide global transactions spanning RAC nodes
10.2.0.4.0        11.2.0.1.0        Commit SCN cached
10.2.0.4.0        11.2.0.1.0        DB time
10.2.0.4.0        11.2.0.1.0        DBWR checkpoint buffers written
10.2.0.4.0        11.2.0.1.0        DBWR checkpoints
10.2.0.4.0        11.2.0.1.0        DBWR fusion writes
10.2.0.4.0        11.2.0.1.0        DBWR lru scans
10.2.0.4.0        11.2.0.1.0        DBWR object drop buffers written
10.2.0.4.0        11.2.0.1.0        DBWR parallel query checkpoint buffers written
10.2.0.4.0        11.2.0.1.0        DBWR revisited being-written buffer
10.2.0.4.0        11.2.0.1.0        DBWR tablespace checkpoint buffers written
10.2.0.4.0        11.2.0.1.0        DBWR thread checkpoint buffers written
10.2.0.4.0        11.2.0.1.0        DBWR transaction table writes
10.2.0.4.0        11.2.0.1.0        DBWR undo block writes
10.2.0.4.0        11.2.0.1.0        DDL statements parallelized
10.2.0.4.0        11.2.0.1.0        DFO trees parallelized
10.2.0.4.0        11.2.0.1.0        DML statements parallelized
                  11.2.0.1.0        DX/BB enqueue lock background get time
                  11.2.0.1.0        DX/BB enqueue lock background gets
                  11.2.0.1.0        DX/BB enqueue lock foreground requests
                  11.2.0.1.0        DX/BB enqueue lock foreground wait time
                  11.2.0.1.0        Effective IO time
                  11.2.0.1.0        Forwarded 2PC commands across RAC nodes
                  11.2.0.1.0        GTX processes spawned by autotune
                  11.2.0.1.0        GTX processes stopped by autotune
                  11.2.0.1.0        HSC Compressed Segment Block Changes
                  11.2.0.1.0        HSC Heap Segment Block Changes
                  11.2.0.1.0        HSC IDL Compressed Blocks
                  11.2.0.1.0        HSC OLTP Compressed Blocks
                  11.2.0.1.0        HSC OLTP Compression skipped rows
                  11.2.0.1.0        HSC OLTP Drop Column
                  11.2.0.1.0        HSC OLTP Non Compressible Blocks
                  11.2.0.1.0        HSC OLTP Space Saving
                  11.2.0.1.0        HSC OLTP compression block checked
                  11.2.0.1.0        HSC OLTP inline compression
                  11.2.0.1.0        HSC OLTP negative compression
                  11.2.0.1.0        HSC OLTP positive compression
                  11.2.0.1.0        HSC OLTP recursive compression
                  11.2.0.1.0        Heap Segment Array Inserts
                  11.2.0.1.0        Heap Segment Array Updates
10.2.0.4.0        11.2.0.1.0        IMU CR rollbacks
10.2.0.4.0        11.2.0.1.0        IMU Flushes
10.2.0.4.0        11.2.0.1.0        IMU Redo allocation size
10.2.0.4.0        11.2.0.1.0        IMU bind flushes
10.2.0.4.0        11.2.0.1.0        IMU commits
10.2.0.4.0        11.2.0.1.0        IMU contention
10.2.0.4.0        11.2.0.1.0        IMU ktichg flush
10.2.0.4.0        11.2.0.1.0        IMU mbu flush
10.2.0.4.0        11.2.0.1.0        IMU pool not allocated
10.2.0.4.0        11.2.0.1.0        IMU recursive-transaction flush
10.2.0.4.0        11.2.0.1.0        IMU undo allocation size
10.2.0.4.0        11.2.0.1.0        IMU undo retention flush
10.2.0.4.0        11.2.0.1.0        IMU- failed to get a private strand
10.2.0.4.0        11.2.0.1.0        IPC CPU used by this session
                  11.2.0.1.0        LOB table id lookup cache misses
10.2.0.4.0        11.2.0.1.0        Misses for writing mapping
                  11.2.0.1.0        No. of Decrypt ops
                  11.2.0.1.0        No. of Encrypt ops
                  11.2.0.1.0        No. of Namespaces Created
                  11.2.0.1.0        No. of Principal Cache Misses
                  11.2.0.1.0        No. of Principal Invalidations
                  11.2.0.1.0        No. of Roles Enabled or Disabled
                  11.2.0.1.0        No. of User Callbacks Executed
                  11.2.0.1.0        No. of XS Sessions Attached
                  11.2.0.1.0        No. of XS Sessions Created
                  11.2.0.1.0        Number of read IOs issued
                  11.2.0.1.0        OS CPU Qt wait time
10.2.0.4.0        11.2.0.1.0        OTC commit optimization attempts
10.2.0.4.0        11.2.0.1.0        OTC commit optimization failure - setup
10.2.0.4.0        11.2.0.1.0        OTC commit optimization hits
10.2.0.4.0        11.2.0.1.0        PX local messages recv'd
10.2.0.4.0        11.2.0.1.0        PX local messages sent
10.2.0.4.0        11.2.0.1.0        PX remote messages recv'd
10.2.0.4.0        11.2.0.1.0        PX remote messages sent
10.2.0.4.0        11.2.0.1.0        Parallel operations downgraded 1 to 25 pct
10.2.0.4.0        11.2.0.1.0        Parallel operations downgraded 25 to 50 pct
10.2.0.4.0        11.2.0.1.0        Parallel operations downgraded 50 to 75 pct
10.2.0.4.0        11.2.0.1.0        Parallel operations downgraded 75 to 99 pct
10.2.0.4.0        11.2.0.1.0        Parallel operations downgraded to serial
10.2.0.4.0        11.2.0.1.0        Parallel operations not downgraded
10.2.0.4.0        11.2.0.1.0        RowCR - resume
10.2.0.4.0        11.2.0.1.0        RowCR - row contention
10.2.0.4.0        11.2.0.1.0        RowCR attempts
10.2.0.4.0        11.2.0.1.0        RowCR hits
10.2.0.4.0        11.2.0.1.0        SMON posted for dropping temp segment
10.2.0.4.0        11.2.0.1.0        SMON posted for instance recovery
10.2.0.4.0        11.2.0.1.0        SMON posted for txn recovery for other instances
10.2.0.4.0        11.2.0.1.0        SMON posted for undo segment recovery
10.2.0.4.0        11.2.0.1.0        SMON posted for undo segment shrink
10.2.0.4.0        11.2.0.1.0        SQL*Net roundtrips to/from client
10.2.0.4.0        11.2.0.1.0        SQL*Net roundtrips to/from dblink
                  11.2.0.1.0        TBS Extension: bytes extended
                  11.2.0.1.0        TBS Extension: files extended
                  11.2.0.1.0        TBS Extension: tasks created
                  11.2.0.1.0        TBS Extension: tasks executed
10.2.0.4.0        11.2.0.1.0        Workload Capture: dbtime
10.2.0.4.0        11.2.0.1.0        Workload Capture: errors
10.2.0.4.0        11.2.0.1.0        Workload Capture: size (in bytes) of recording
10.2.0.4.0        11.2.0.1.0        Workload Capture: unreplayable user calls
10.2.0.4.0        11.2.0.1.0        Workload Capture: unsupported user calls
10.2.0.4.0        11.2.0.1.0        Workload Capture: user calls
10.2.0.4.0        11.2.0.1.0        Workload Capture: user calls flushed
10.2.0.4.0        11.2.0.1.0        Workload Capture: user logins
10.2.0.4.0        11.2.0.1.0        Workload Capture: user txns
                  11.2.0.1.0        Workload Replay: dbtime
                  11.2.0.1.0        Workload Replay: deadlocks resolved
                  11.2.0.1.0        Workload Replay: network time
                  11.2.0.1.0        Workload Replay: think time
                  11.2.0.1.0        Workload Replay: time gain
                  11.2.0.1.0        Workload Replay: time loss
                  11.2.0.1.0        Workload Replay: user calls
10.2.0.4.0        11.2.0.1.0        active txn count during cleanout
10.2.0.4.0        11.2.0.1.0        application wait time
10.2.0.4.0        11.2.0.1.0        auto extends on undo tablespace
10.2.0.4.0        11.2.0.1.0        background checkpoints completed
10.2.0.4.0        11.2.0.1.0        background checkpoints started
10.2.0.4.0        11.2.0.1.0        background timeouts
10.2.0.4.0        11.2.0.1.0        branch node splits
10.2.0.4.0        11.2.0.1.0        buffer is not pinned count
10.2.0.4.0        11.2.0.1.0        buffer is pinned count
10.2.0.4.0        11.2.0.1.0        bytes received via SQL*Net from client
10.2.0.4.0        11.2.0.1.0        bytes received via SQL*Net from dblink
10.2.0.4.0        11.2.0.1.0        bytes sent via SQL*Net to client
10.2.0.4.0        11.2.0.1.0        bytes sent via SQL*Net to dblink
                  11.2.0.1.0        bytes via SQL*Net vector from client
                  11.2.0.1.0        bytes via SQL*Net vector from dblink
                  11.2.0.1.0        bytes via SQL*Net vector to client
                  11.2.0.1.0        bytes via SQL*Net vector to dblink
10.2.0.4.0        11.2.0.1.0        calls to get snapshot scn: kcmgss
10.2.0.4.0        11.2.0.1.0        calls to kcmgas
10.2.0.4.0        11.2.0.1.0        calls to kcmgcs
10.2.0.4.0        11.2.0.1.0        calls to kcmgrs
                  11.2.0.1.0        cell CUs processed for compressed
                  11.2.0.1.0        cell CUs processed for uncompressed
                  11.2.0.1.0        cell CUs sent compressed
                  11.2.0.1.0        cell CUs sent head piece
                  11.2.0.1.0        cell CUs sent uncompressed
                  11.2.0.1.0        cell IO uncompressed bytes
                  11.2.0.1.0        cell blocks helped by commit cache
                  11.2.0.1.0        cell blocks helped by minscn optimization
                  11.2.0.1.0        cell blocks processed by cache layer
                  11.2.0.1.0        cell blocks processed by data layer
                  11.2.0.1.0        cell blocks processed by index layer
                  11.2.0.1.0        cell blocks processed by txn layer
                  11.2.0.1.0        cell blocks skipped due to chained rows
                  11.2.0.1.0        cell commit cache queries
                  11.2.0.1.0        cell flash cache read hits
                  11.2.0.1.0        cell index scans
                  11.2.0.1.0        cell num smart IO sessions in rdbms block IO due to big payload
                  11.2.0.1.0        cell num smart IO sessions in rdbms block IO due to user
                  11.2.0.1.0        cell num smart IO sessions using passthru mode due to cellsrv
                  11.2.0.1.0        cell num smart IO sessions using passthru mode due to timezone
                  11.2.0.1.0        cell num smart IO sessions using passthru mode due to user
                  11.2.0.1.0        cell num smart file creation sessions using rdbms block IO mode
                  11.2.0.1.0        cell physical IO bytes eligible for predicate offload
                  11.2.0.1.0        cell physical IO bytes saved by storage index
                  11.2.0.1.0        cell physical IO bytes saved during optimized RMAN file restore
                  11.2.0.1.0        cell physical IO bytes saved during optimized file creation
                  11.2.0.1.0        cell physical IO interconnect bytes
                  11.2.0.1.0        cell physical IO interconnect bytes returned by smart scan
                  11.2.0.1.0        cell scans
                  11.2.0.1.0        cell session smart scan efficiency
                  11.2.0.1.0        cell simulated physical IO bytes eligible for predicate offload
                  11.2.0.1.0        cell simulated physical IO bytes returned by predicate offload
                  11.2.0.1.0        cell simulated session smart scan efficiency
                  11.2.0.1.0        cell smart IO session cache hard misses
                  11.2.0.1.0        cell smart IO session cache hits
                  11.2.0.1.0        cell smart IO session cache hwm
                  11.2.0.1.0        cell smart IO session cache lookups
                  11.2.0.1.0        cell smart IO session cache soft misses
                  11.2.0.1.0        cell transactions found in commit cache
10.2.0.4.0        11.2.0.1.0        change write time
10.2.0.4.0        11.2.0.1.0        cleanout - number of ktugct calls
10.2.0.4.0        11.2.0.1.0        cleanouts and rollbacks - consistent read gets
10.2.0.4.0        11.2.0.1.0        cleanouts only - consistent read gets
10.2.0.4.0        11.2.0.1.0        cluster key scan block gets
10.2.0.4.0        11.2.0.1.0        cluster key scans
10.2.0.4.0        11.2.0.1.0        cluster wait time
10.2.0.4.0        11.2.0.1.0        cold recycle reads
10.2.0.4.0        11.2.0.1.0        commit batch performed
10.2.0.4.0        11.2.0.1.0        commit batch requested
10.2.0.4.0        11.2.0.1.0        commit batch/immediate performed
10.2.0.4.0        11.2.0.1.0        commit batch/immediate requested
10.2.0.4.0        11.2.0.1.0        commit cleanout failures: block lost
10.2.0.4.0        11.2.0.1.0        commit cleanout failures: buffer being written
10.2.0.4.0        11.2.0.1.0        commit cleanout failures: callback failure
10.2.0.4.0        11.2.0.1.0        commit cleanout failures: cannot pin
10.2.0.4.0        11.2.0.1.0        commit cleanout failures: hot backup in progress
10.2.0.4.0        11.2.0.1.0        commit cleanout failures: write disabled
10.2.0.4.0        11.2.0.1.0        commit cleanouts
10.2.0.4.0        11.2.0.1.0        commit cleanouts successfully completed
10.2.0.4.0        11.2.0.1.0        commit immediate performed
10.2.0.4.0        11.2.0.1.0        commit immediate requested
10.2.0.4.0        11.2.0.1.0        commit nowait performed
10.2.0.4.0        11.2.0.1.0        commit nowait requested
10.2.0.4.0        11.2.0.1.0        commit txn count during cleanout
10.2.0.4.0        11.2.0.1.0        commit wait performed
10.2.0.4.0        11.2.0.1.0        commit wait requested
10.2.0.4.0        11.2.0.1.0        commit wait/nowait performed
10.2.0.4.0        11.2.0.1.0        commit wait/nowait requested
10.2.0.4.0        11.2.0.1.0        concurrency wait time
10.2.0.4.0        11.2.0.1.0        consistent changes
10.2.0.4.0        11.2.0.1.0        consistent gets
10.2.0.4.0        11.2.0.1.0        consistent gets - examination
10.2.0.4.0        11.2.0.1.0        consistent gets direct
10.2.0.4.0        11.2.0.1.0        consistent gets from cache
                  11.2.0.1.0        consistent gets from cache (fastpath)
10.2.0.4.0        11.2.0.1.0        current blocks converted for CR
10.2.0.4.0        11.2.0.1.0        cursor authentications
10.2.0.4.0        11.2.0.1.0        data blocks consistent reads - undo records applied
10.2.0.4.0        11.2.0.1.0        db block changes
10.2.0.4.0        11.2.0.1.0        db block gets
10.2.0.4.0        11.2.0.1.0        db block gets direct
10.2.0.4.0        11.2.0.1.0        db block gets from cache
                  11.2.0.1.0        db block gets from cache (fastpath)
                  11.2.0.1.0        db corrupt blocks detected
                  11.2.0.1.0        db corrupt blocks recovered
10.2.0.4.0        11.2.0.1.0        deferred (CURRENT) block cleanout applications
10.2.0.4.0        11.2.0.1.0        deferred CUR cleanouts (index blocks)
10.2.0.4.0        11.2.0.1.0        dirty buffers inspected
10.2.0.4.0        11.2.0.1.0        doubling up with imu segment
10.2.0.4.0        11.2.0.1.0        drop segment calls in space pressure
10.2.0.4.0        11.2.0.1.0        enqueue conversions
10.2.0.4.0        11.2.0.1.0        enqueue deadlocks
10.2.0.4.0        11.2.0.1.0        enqueue releases
10.2.0.4.0        11.2.0.1.0        enqueue requests
10.2.0.4.0        11.2.0.1.0        enqueue timeouts
10.2.0.4.0        11.2.0.1.0        enqueue waits
10.2.0.4.0        11.2.0.1.0        exchange deadlocks
10.2.0.4.0        11.2.0.1.0        execute count
10.2.0.4.0        11.2.0.1.0        failed probes on index block reclamation
                  11.2.0.1.0        file io service time
                  11.2.0.1.0        file io wait time
                  11.2.0.1.0        flash cache eviction: aged out
                  11.2.0.1.0        flash cache eviction: buffer pinned
                  11.2.0.1.0        flash cache eviction: invalidated
                  11.2.0.1.0        flash cache insert skip: DBWR overloaded
                  11.2.0.1.0        flash cache insert skip: corrupt
                  11.2.0.1.0        flash cache insert skip: exists
                  11.2.0.1.0        flash cache insert skip: modification
                  11.2.0.1.0        flash cache insert skip: not current
                  11.2.0.1.0        flash cache insert skip: not useful
                  11.2.0.1.0        flash cache inserts
                  11.2.0.1.0        flashback log write bytes
10.2.0.4.0        11.2.0.1.0        flashback log writes
10.2.0.4.0        11.2.0.1.0        frame signature mismatch
10.2.0.4.0        11.2.0.1.0        free buffer inspected
10.2.0.4.0        11.2.0.1.0        free buffer requested
10.2.0.4.0        11.2.0.1.0        gc CPU used by this session
                  11.2.0.1.0        gc blocks compressed
10.2.0.4.0        11.2.0.1.0        gc blocks corrupt
10.2.0.4.0        11.2.0.1.0        gc blocks lost
10.2.0.4.0        11.2.0.1.0        gc claim blocks lost
10.2.0.4.0        11.2.0.1.0        gc cr block build time
10.2.0.4.0        11.2.0.1.0        gc cr block flush time
                  11.2.0.1.0        gc cr block read wait time
10.2.0.4.0        11.2.0.1.0        gc cr block receive time
10.2.0.4.0        11.2.0.1.0        gc cr block send time
10.2.0.4.0        11.2.0.1.0        gc cr blocks received
10.2.0.4.0        11.2.0.1.0        gc cr blocks served
10.2.0.4.0        11.2.0.1.0        gc current block flush time
10.2.0.4.0        11.2.0.1.0        gc current block pin time
10.2.0.4.0        11.2.0.1.0        gc current block receive time
10.2.0.4.0        11.2.0.1.0        gc current block send time
10.2.0.4.0        11.2.0.1.0        gc current blocks received
10.2.0.4.0        11.2.0.1.0        gc current blocks served
                  11.2.0.1.0        gc kbytes saved
                  11.2.0.1.0        gc kbytes sent
10.2.0.4.0        11.2.0.1.0        gc local grants
                  11.2.0.1.0        gc reader bypass grants
10.2.0.4.0        11.2.0.1.0        gc remote grants
10.2.0.4.0        11.2.0.1.0        gcs messages sent
10.2.0.4.0        11.2.0.1.0        ges messages sent
10.2.0.4.0        11.2.0.1.0        global enqueue CPU used by this session
10.2.0.4.0        11.2.0.1.0        global enqueue get time
10.2.0.4.0        11.2.0.1.0        global enqueue gets async
10.2.0.4.0        11.2.0.1.0        global enqueue gets sync
10.2.0.4.0        11.2.0.1.0        global enqueue releases
10.2.0.4.0        11.2.0.1.0        global undo segment hints helped
10.2.0.4.0        11.2.0.1.0        global undo segment hints were stale
10.2.0.4.0        11.2.0.1.0        heap block compress
10.2.0.4.0        11.2.0.1.0        hot buffers moved to head of LRU
10.2.0.4.0        11.2.0.1.0        immediate (CR) block cleanout applications
10.2.0.4.0        11.2.0.1.0        immediate (CURRENT) block cleanout applications
10.2.0.4.0        11.2.0.1.0        immediate CR cleanouts (index blocks)
10.2.0.4.0        11.2.0.1.0        index crx upgrade (found)
10.2.0.4.0        11.2.0.1.0        index crx upgrade (positioned)
10.2.0.4.0        11.2.0.1.0        index crx upgrade (prefetch)
10.2.0.4.0        11.2.0.1.0        index fast full scans (direct read)
10.2.0.4.0        11.2.0.1.0        index fast full scans (full)
10.2.0.4.0        11.2.0.1.0        index fast full scans (rowid ranges)
10.2.0.4.0        11.2.0.1.0        index fetch by key
                  11.2.0.1.0        index reclamation/extension switch
10.2.0.4.0        11.2.0.1.0        index scans kdiixs1
10.2.0.4.0        11.2.0.1.0        java call heap collected bytes
10.2.0.4.0        11.2.0.1.0        java call heap collected count
10.2.0.4.0        11.2.0.1.0        java call heap gc count
10.2.0.4.0        11.2.0.1.0        java call heap live object count
10.2.0.4.0        11.2.0.1.0        java call heap live object count max
10.2.0.4.0        11.2.0.1.0        java call heap live size
10.2.0.4.0        11.2.0.1.0        java call heap live size max
10.2.0.4.0        11.2.0.1.0        java call heap object count
10.2.0.4.0        11.2.0.1.0        java call heap object count max
10.2.0.4.0        11.2.0.1.0        java call heap total size
10.2.0.4.0        11.2.0.1.0        java call heap total size max
10.2.0.4.0        11.2.0.1.0        java call heap used size
10.2.0.4.0        11.2.0.1.0        java call heap used size max
10.2.0.4.0        11.2.0.1.0        java session heap collected bytes
10.2.0.4.0        11.2.0.1.0        java session heap collected count
10.2.0.4.0        11.2.0.1.0        java session heap gc count
10.2.0.4.0        11.2.0.1.0        java session heap live object count
10.2.0.4.0        11.2.0.1.0        java session heap live object count max
10.2.0.4.0        11.2.0.1.0        java session heap live size
10.2.0.4.0        11.2.0.1.0        java session heap live size max
10.2.0.4.0        11.2.0.1.0        java session heap object count
10.2.0.4.0        11.2.0.1.0        java session heap object count max
10.2.0.4.0        11.2.0.1.0        java session heap used size
10.2.0.4.0        11.2.0.1.0        java session heap used size max
10.2.0.4.0        11.2.0.1.0        leaf node 90-10 splits
10.2.0.4.0        11.2.0.1.0        leaf node splits
10.2.0.4.0        11.2.0.1.0        lob reads
10.2.0.4.0        11.2.0.1.0        lob writes
10.2.0.4.0        11.2.0.1.0        lob writes unaligned
10.2.0.4.0        11.2.0.1.0        local undo segment hints helped
10.2.0.4.0        11.2.0.1.0        local undo segment hints were stale
10.2.0.4.0        11.2.0.1.0        logons cumulative
10.2.0.4.0        11.2.0.1.0        logons current
                  11.2.0.1.0        max cf enq hold time
10.2.0.4.0        11.2.0.1.0        messages received
10.2.0.4.0        11.2.0.1.0        messages sent
                  11.2.0.1.0        min active SCN optimization applied on CR
10.2.0.4.0        11.2.0.1.0        native hash arithmetic execute
10.2.0.4.0        11.2.0.1.0        native hash arithmetic fail
10.2.0.4.0        11.2.0.1.0        no buffer to keep pinned count
10.2.0.4.0        11.2.0.1.0        no work - consistent read gets
                  11.2.0.1.0        non-idle wait count
                  11.2.0.1.0        non-idle wait time
10.2.0.4.0        11.2.0.1.0        number of map misses
10.2.0.4.0        11.2.0.1.0        number of map operations
10.2.0.4.0        11.2.0.1.0        opened cursors cumulative
10.2.0.4.0        11.2.0.1.0        opened cursors current
                  11.2.0.1.0        parse count (describe)
10.2.0.4.0        11.2.0.1.0        parse count (failures)
10.2.0.4.0        11.2.0.1.0        parse count (hard)
10.2.0.4.0        11.2.0.1.0        parse count (total)
10.2.0.4.0        11.2.0.1.0        parse time cpu
10.2.0.4.0        11.2.0.1.0        parse time elapsed
10.2.0.4.0        11.2.0.1.0        physical read IO requests
10.2.0.4.0        11.2.0.1.0        physical read bytes
                  11.2.0.1.0        physical read flash cache hits
                  11.2.0.1.0        physical read requests optimized
10.2.0.4.0        11.2.0.1.0        physical read total IO requests
10.2.0.4.0        11.2.0.1.0        physical read total bytes
10.2.0.4.0        11.2.0.1.0        physical read total multi block requests
10.2.0.4.0        11.2.0.1.0        physical reads
10.2.0.4.0        11.2.0.1.0        physical reads cache
10.2.0.4.0        11.2.0.1.0        physical reads cache prefetch
10.2.0.4.0        11.2.0.1.0        physical reads direct
10.2.0.4.0        11.2.0.1.0        physical reads direct (lob)
10.2.0.4.0        11.2.0.1.0        physical reads direct temporary tablespace
10.2.0.4.0        11.2.0.1.0        physical reads for flashback new
10.2.0.4.0        11.2.0.1.0        physical reads prefetch warmup
10.2.0.4.0        11.2.0.1.0        physical reads retry corrupt
10.2.0.4.0        11.2.0.1.0        physical write IO requests
10.2.0.4.0        11.2.0.1.0        physical write bytes
10.2.0.4.0        11.2.0.1.0        physical write total IO requests
10.2.0.4.0        11.2.0.1.0        physical write total bytes
10.2.0.4.0        11.2.0.1.0        physical write total multi block requests
10.2.0.4.0        11.2.0.1.0        physical writes
10.2.0.4.0        11.2.0.1.0        physical writes direct
10.2.0.4.0        11.2.0.1.0        physical writes direct (lob)
10.2.0.4.0        11.2.0.1.0        physical writes direct temporary tablespace
10.2.0.4.0        11.2.0.1.0        physical writes from cache
10.2.0.4.0        11.2.0.1.0        physical writes non checkpoint
10.2.0.4.0        11.2.0.1.0        pinned buffers inspected
                  11.2.0.1.0        pinned cursors current
10.2.0.4.0        11.2.0.1.0        prefetch clients - 16k
10.2.0.4.0        11.2.0.1.0        prefetch clients - 2k
10.2.0.4.0        11.2.0.1.0        prefetch clients - 32k
10.2.0.4.0        11.2.0.1.0        prefetch clients - 4k
10.2.0.4.0        11.2.0.1.0        prefetch clients - 8k
10.2.0.4.0        11.2.0.1.0        prefetch clients - default
10.2.0.4.0        11.2.0.1.0        prefetch clients - keep
10.2.0.4.0        11.2.0.1.0        prefetch clients - recycle
10.2.0.4.0        11.2.0.1.0        prefetch warmup blocks aged out before use
10.2.0.4.0        11.2.0.1.0        prefetch warmup blocks flushed out before use
10.2.0.4.0        11.2.0.1.0        prefetched blocks aged out before use
10.2.0.4.0        11.2.0.1.0        process last non-idle time
10.2.0.4.0        11.2.0.1.0        queries parallelized
10.2.0.4.0        11.2.0.1.0        queue flush
10.2.0.4.0        11.2.0.1.0        queue ocp pages
10.2.0.4.0        11.2.0.1.0        queue position update
10.2.0.4.0        11.2.0.1.0        queue qno pages
10.2.0.4.0        11.2.0.1.0        queue single row
10.2.0.4.0        11.2.0.1.0        queue splits
10.2.0.4.0        11.2.0.1.0        queue update without cp update
10.2.0.4.0        11.2.0.1.0        recovery array read time
10.2.0.4.0        11.2.0.1.0        recovery array reads
                  11.2.0.1.0        recovery block gets from cache
10.2.0.4.0        11.2.0.1.0        recovery blocks read
                  11.2.0.1.0        recovery blocks read for lost write detection
                  11.2.0.1.0        recovery blocks skipped lost write checks
10.2.0.4.0        11.2.0.1.0        recursive aborts on index block reclamation
10.2.0.4.0        11.2.0.1.0        recursive calls
10.2.0.4.0        11.2.0.1.0        recursive cpu usage
                  11.2.0.1.0        recursive system API invocations
                  11.2.0.1.0        redo blocks checksummed by FG (exclusive)
                  11.2.0.1.0        redo blocks checksummed by LGWR
10.2.0.4.0        11.2.0.1.0        redo blocks read for recovery
10.2.0.4.0        11.2.0.1.0        redo blocks written
10.2.0.4.0        11.2.0.1.0        redo buffer allocation retries
10.2.0.4.0        11.2.0.1.0        redo entries
                  11.2.0.1.0        redo entries for lost write detection
                  11.2.0.1.0        redo k-bytes read (memory)
                  11.2.0.1.0        redo k-bytes read (memory) by LNS
                  11.2.0.1.0        redo k-bytes read for recovery
                  11.2.0.1.0        redo k-bytes read for terminal recovery
                  11.2.0.1.0        redo k-bytes read total
                  11.2.0.1.0        redo k-bytes read total by LNS
10.2.0.4.0        11.2.0.1.0        redo log space requests
10.2.0.4.0        11.2.0.1.0        redo log space wait time
10.2.0.4.0        11.2.0.1.0        redo ordering marks
10.2.0.4.0        11.2.0.1.0        redo size
                  11.2.0.1.0        redo size for direct writes
                  11.2.0.1.0        redo size for lost write detection
10.2.0.4.0        11.2.0.1.0        redo subscn max counts
10.2.0.4.0        11.2.0.1.0        redo synch time
10.2.0.4.0        11.2.0.1.0        redo synch writes
10.2.0.4.0        11.2.0.1.0        redo wastage
                  11.2.0.1.0        redo write broadcast ack count
                  11.2.0.1.0        redo write broadcast ack time
10.2.0.4.0        11.2.0.1.0        redo write time
10.2.0.4.0        11.2.0.1.0        redo writes
                  11.2.0.1.0        remote Oradebug requests
10.2.0.4.0        11.2.0.1.0        rollback changes - undo records applied
10.2.0.4.0        11.2.0.1.0        rollbacks only - consistent read gets
                  11.2.0.1.0        root node splits
10.2.0.4.0        11.2.0.1.0        rows fetched via callback
                  11.2.0.1.0        scheduler wait time
                  11.2.0.1.0        securefile add dedupd lob to set
                  11.2.0.1.0        securefile allocation bytes
                  11.2.0.1.0        securefile allocation chunks
                  11.2.0.1.0        securefile bytes cleartext
                  11.2.0.1.0        securefile bytes deduplicated
                  11.2.0.1.0        securefile bytes encrypted
                  11.2.0.1.0        securefile bytes non-transformed
                  11.2.0.1.0        securefile compressed bytes
                  11.2.0.1.0        securefile create dedup set
                  11.2.0.1.0        securefile dedup callback oper final
                  11.2.0.1.0        securefile dedup fits inline
                  11.2.0.1.0        securefile dedup flush too low
                  11.2.0.1.0        securefile dedup hash collision
                  11.2.0.1.0        securefile dedup prefix hash match
                  11.2.0.1.0        securefile destroy dedup set
                  11.2.0.1.0        securefile direct read bytes
                  11.2.0.1.0        securefile direct read ops
                  11.2.0.1.0        securefile direct write bytes
                  11.2.0.1.0        securefile direct write ops
                  11.2.0.1.0        securefile inode ioreap time
                  11.2.0.1.0        securefile inode read time
                  11.2.0.1.0        securefile inode write time
                  11.2.0.1.0        securefile number of flushes
                  11.2.0.1.0        securefile number of non-transformed flushes
                  11.2.0.1.0        securefile reject deduplication
                  11.2.0.1.0        securefile rmv from dedup set
                  11.2.0.1.0        securefile uncompressed bytes
                  11.2.0.1.0        segemnt dispenser load empty
                  11.2.0.1.0        segment cfs allocations
                  11.2.0.1.0        segment chunks allocation from disepnser
                  11.2.0.1.0        segment dispenser allocations
                  11.2.0.1.0        segment dispenser load tasks
                  11.2.0.1.0        segment prealloc bytes
                  11.2.0.1.0        segment prealloc ops
                  11.2.0.1.0        segment prealloc tasks
                  11.2.0.1.0        segment prealloc time (ms)
                  11.2.0.1.0        segment prealloc ufs2cfs bytes
                  11.2.0.1.0        segment total chunk allocation
10.2.0.4.0        11.2.0.1.0        serializable aborts
10.2.0.4.0        11.2.0.1.0        session connect time
10.2.0.4.0        11.2.0.1.0        session cursor cache count
10.2.0.4.0        11.2.0.1.0        session cursor cache hits
10.2.0.4.0        11.2.0.1.0        session logical reads
10.2.0.4.0        11.2.0.1.0        session pga memory
10.2.0.4.0        11.2.0.1.0        session pga memory max
10.2.0.4.0        11.2.0.1.0        session stored procedure space
10.2.0.4.0        11.2.0.1.0        session uga memory
10.2.0.4.0        11.2.0.1.0        session uga memory max
10.2.0.4.0        11.2.0.1.0        shared hash latch upgrades - no wait
10.2.0.4.0        11.2.0.1.0        shared hash latch upgrades - wait
                  11.2.0.1.0        shared io pool buffer get failure
                  11.2.0.1.0        shared io pool buffer get success
10.2.0.4.0        11.2.0.1.0        sorts (disk)
10.2.0.4.0        11.2.0.1.0        sorts (memory)
10.2.0.4.0        11.2.0.1.0        sorts (rows)
10.2.0.4.0        11.2.0.1.0        space was found by tune down
10.2.0.4.0        11.2.0.1.0        space was not found by tune down
                  11.2.0.1.0        spare statistic 1
                  11.2.0.1.0        spare statistic 2
                  11.2.0.1.0        spare statistic 3
                  11.2.0.1.0        spare statistic 4
10.2.0.4.0        11.2.0.1.0        sql area evicted
10.2.0.4.0        11.2.0.1.0        sql area purged
10.2.0.4.0        11.2.0.1.0        steps of tune down ret. in space pressure
10.2.0.4.0        11.2.0.1.0        summed dirty queue length
10.2.0.4.0        11.2.0.1.0        switch current to new buffer
10.2.0.4.0        11.2.0.1.0        table fetch by rowid
10.2.0.4.0        11.2.0.1.0        table fetch continued row
10.2.0.4.0        11.2.0.1.0        table scan blocks gotten
10.2.0.4.0        11.2.0.1.0        table scan rows gotten
10.2.0.4.0        11.2.0.1.0        table scans (cache partitions)
10.2.0.4.0        11.2.0.1.0        table scans (direct read)
10.2.0.4.0        11.2.0.1.0        table scans (long tables)
10.2.0.4.0        11.2.0.1.0        table scans (rowid ranges)
10.2.0.4.0        11.2.0.1.0        table scans (short tables)
                  11.2.0.1.0        temp space allocated (bytes)
                  11.2.0.1.0        total cf enq hold time
                  11.2.0.1.0        total number of cf enq holders
10.2.0.4.0        11.2.0.1.0        total number of slots
10.2.0.4.0        11.2.0.1.0        total number of times SMON posted
10.2.0.4.0        11.2.0.1.0        total number of undo segments dropped
10.2.0.4.0        11.2.0.1.0        transaction lock background get time
10.2.0.4.0        11.2.0.1.0        transaction lock background gets
10.2.0.4.0        11.2.0.1.0        transaction lock foreground requests
10.2.0.4.0        11.2.0.1.0        transaction lock foreground wait time
10.2.0.4.0        11.2.0.1.0        transaction rollbacks
10.2.0.4.0        11.2.0.1.0        transaction tables consistent read rollbacks
10.2.0.4.0        11.2.0.1.0        transaction tables consistent reads - undo records applied
10.2.0.4.0        11.2.0.1.0        tune down retentions in space pressure
10.2.0.4.0        11.2.0.1.0        undo change vector size
10.2.0.4.0        11.2.0.1.0        undo segment header was pinned
10.2.0.4.0        11.2.0.1.0        user I/O wait time
10.2.0.4.0        11.2.0.1.0        user calls
10.2.0.4.0        11.2.0.1.0        user commits
10.2.0.4.0        11.2.0.1.0        user rollbacks
10.2.0.4.0        11.2.0.1.0        workarea executions - multipass
10.2.0.4.0        11.2.0.1.0        workarea executions - onepass
10.2.0.4.0        11.2.0.1.0        workarea executions - optimal
10.2.0.4.0        11.2.0.1.0        workarea memory allocated
10.2.0.4.0        11.2.0.1.0        write clones created for recovery
10.2.0.4.0        11.2.0.1.0        write clones created in background
10.2.0.4.0        11.2.0.1.0        write clones created in foreground
10.2.0.4.0

589 rows selected.

SQL> spool off

Comments