select * from v$sysstat

STATISTIC# | NAME | CLASS | VALUE
0 | logons cumulative | 1 | 27
1 | logons current | 1 | 14
2 | opened cursors cumulative | 1 | 7581
3 | opened cursors current | 1 | 44
4 | user commits | 1 | 143
5 | user rollbacks | 1 | 57
6 | user calls | 1 | 12833
7 | recursive calls | 1 | 220104
8 | recursive cpu usage | 1 | 280
9 | session logical reads | 1 | 78291
10 | session stored procedure space | 1 | 0
11 | CPU used when call started | 128 | 827
12 | CPU used by this session | 1 | 827
13 | session connect time | 1 | 19749591837
14 | process last non-idle time | 128 | 19749591837
15 | session uga memory | 1 | 2013960
16 | session uga memory max | 1 | 8298296
17 | messages sent | 128 | 1420
18 | messages received | 128 | 1421
19 | background timeouts | 128 | 5208
20 | session pga memory | 1 | 11556244
21 | session pga memory max | 1 | 18436440
22 | enqueue timeouts | 4 | 0
23 | enqueue waits | 4 | 0
24 | enqueue deadlocks | 4 | 0
25 | enqueue requests | 4 | 6616
26 | enqueue conversions | 4 | 37
27 | enqueue releases | 4 | 6605
28 | global lock sync gets | 32 | 0
29 | global lock async gets | 32 | 0
30 | global lock get time | 32 | 0
31 | global lock sync converts | 32 | 0
32 | global lock async converts | 32 | 0
33 | global lock convert time | 32 | 0
34 | global lock releases | 32 | 0
35 | total file opens | 8 | 0
36 | opens requiring cache replacement | 8 | 0
37 | opens of replaced files | 8 | 0
38 | gcs messages sent | 32 | 0
39 | ges messages sent | 32 | 0
40 | db block gets | 8 | 7178
41 | consistent gets | 8 | 71113
42 | physical reads | 8 | 2448
43 | db block changes | 8 | 8886
44 | consistent changes | 8 | 307
45 | recovery blocks read | 8 | 39
46 | physical writes | 8 | 174
47 | physical writes non checkpoint | 8 | 154
48 | summed dirty queue length | 8 | 38
49 | DBWR checkpoint buffers written | 8 | 161
50 | DBWR transaction table writes | 8 | 31
51 | DBWR undo block writes | 8 | 39
52 | DBWR revisited being-written buffer | 8 | 0
53 | DBWR make free requests | 8 | 0
54 | DBWR free buffers found | 8 | 0
55 | DBWR lru scans | 8 | 0
56 | DBWR summed scan depth | 8 | 0
57 | DBWR buffers scanned | 8 | 0
58 | DBWR checkpoints | 8 | 1
59 | DBWR cross instance writes | 40 | 0
60 | DBWR fusion writes | 40 | 0
61 | remote instance undo block writes | 40 | 0
62 | remote instance undo header writes | 40 | 0
63 | prefetch clients - keep | 8 | 0
64 | prefetch clients - recycle | 8 | 0
65 | prefetch clients - default | 8 | 0
66 | prefetch clients - 2k | 8 | 0
67 | prefetch clients - 4k | 8 | 0
68 | prefetch clients - 8k | 8 | 0
69 | prefetch clients - 16k | 8 | 0
70 | prefetch clients - 32k | 8 | 0
71 | change write time | 8 | 11
72 | redo synch writes | 8 | 146
73 | redo synch time | 8 | 162
74 | exchange deadlocks | 8 | 0
75 | free buffer requested | 8 | 3242
76 | dirty buffers inspected | 8 | 0
77 | pinned buffers inspected | 8 | 0
78 | hot buffers moved to head of LRU | 8 | 0
79 | free buffer inspected | 8 | 0
80 | commit cleanout failures: write disabled | 8 | 0
81 | commit cleanout failures: block lost | 8 | 0
82 | commit cleanout failures: cannot pin | 8 | 0
83 | commit cleanout failures: hot backup in progress | 8 | 0
84 | commit cleanout failures: buffer being written | 8 | 0
85 | commit cleanout failures: callback failure | 8 | 0
86 | commit cleanouts | 8 | 2108
87 | commit cleanouts successfully completed | 8 | 2108
88 | recovery array reads | 8 | 0
89 | recovery array read time | 8 | 0
90 | CR blocks created | 8 | 157
91 | current blocks converted for CR | 8 | 0
92 | switch current to new buffer | 8 | 648
93 | write clones created in foreground | 8 | 0
94 | write clones created in background | 8 | 0
95 | prefetched blocks | 8 | 929
96 | prefetched blocks aged out before use | 8 | 0
97 | physical reads direct | 8 | 28
98 | physical writes direct | 8 | 12
99 | physical reads direct (lob) | 8 | 0
100 | physical writes direct (lob) | 8 | 0
101 | cold recycle reads | 8 | 0
102 | consistent gets - examination | 8 | 29632
103 | shared hash latch upgrades - no wait | 8 | 9519
104 | shared hash latch upgrades - wait | 8 | 0
105 | calls to kcmgcs | 128 | 15
106 | calls to kcmgrs | 128 | 0
107 | calls to kcmgas | 128 | 2322
108 | next scns gotten without going to GES | 32 | 0
109 | Unnecesary process cleanup for SCN batching | 32 | 0
110 | calls to get snapshot scn: kcmgss | 32 | 31942
111 | kcmgss waited for batching | 32 | 0
112 | kcmgss read scn without going to GES | 32 | 0
113 | kcmccs called get current scn | 32 | 0
114 | redo entries | 2 | 4563
115 | redo size | 2 | 1011880
116 | redo buffer allocation retries | 2 | 0
117 | redo wastage | 2 | 257704
118 | redo writer latching time | 2 | 0
119 | redo writes | 2 | 1405
120 | redo blocks written | 2 | 2561
121 | redo write time | 2 | 155
122 | redo log space requests | 2 | 0
123 | redo log space wait time | 2 | 0
124 | redo log switch interrupts | 2 | 0
125 | redo ordering marks | 2 | 0
126 | global cache gets | 40 | 0
127 | global cache get time | 40 | 0
128 | global cache converts | 40 | 0
129 | global cache convert time | 40 | 0
130 | global cache cr blocks received | 40 | 0
131 | global cache cr block receive time | 40 | 0
132 | global cache current blocks received | 40 | 0
133 | global cache current block receive time | 40 | 0
134 | global cache cr blocks served | 40 | 0
135 | global cache cr block build time | 40 | 0
136 | global cache cr block flush time | 40 | 0
137 | global cache cr block send time | 40 | 0
138 | global cache current blocks served | 40 | 0
139 | global cache current block pin time | 40 | 0
140 | global cache current block flush time | 40 | 0
141 | global cache current block send time | 40 | 0
142 | global cache freelist waits | 40 | 0
143 | global cache defers | 40 | 0
144 | global cache convert timeouts | 40 | 0
145 | global cache blocks lost | 40 | 0
146 | global cache claim blocks lost | 40 | 0
147 | global cache blocks corrupt | 40 | 0
148 | global cache prepare failures | 40 | 0
149 | global cache skip prepare failures | 40 | 0
150 | total number of slots | 8 | 0
151 | instance recovery database freeze count | 32 | 0
152 | background checkpoints started | 8 | 0
153 | background checkpoints completed | 8 | 0
154 | number of map operations | 8 | 0
155 | number of map misses | 8 | 0
156 | serializable aborts | 1 | 0
157 | transaction lock foreground requests | 128 | 0
158 | transaction lock foreground wait time | 128 | 0
159 | transaction lock background gets | 128 | 0
160 | transaction lock background get time | 128 | 0
161 | transaction tables consistent reads - undo records applied | 128 | 0
162 | transaction tables consistent read rollbacks | 128 | 0
163 | data blocks consistent reads - undo records applied | 128 | 307
164 | no work - consistent read gets | 128 | 23029
165 | cleanouts only - consistent read gets | 128 | 5
166 | rollbacks only - consistent read gets | 128 | 297
167 | cleanouts and rollbacks - consistent read gets | 128 | 5
168 | RowCR attempts | 128 | 0
169 | RowCR hits | 128 | 0
170 | RowCR - row contention | 128 | 0
171 | rollback changes - undo records applied | 128 | 0
172 | transaction rollbacks | 128 | 0
173 | immediate (CURRENT) block cleanout applications | 128 | 27
174 | immediate (CR) block cleanout applications | 128 | 10
175 | deferred (CURRENT) block cleanout applications | 128 | 1095
176 | commit txn count during cleanout | 128 | 6
177 | active txn count during cleanout | 128 | 7
178 | cleanout - number of ktugct calls | 128 | 11
179 | immediate CR cleanouts (index blocks) | 128 | 0
180 | deferred CUR cleanouts (index blocks) | 128 | 0
181 | Commit SCN cached | 128 | 0
182 | Cached Commit SCN referenced | 128 | 0
183 | number of auto extends on undo tablespace | 128 | 0
184 | number of drop segment calls under space pressure | 128 | 0
185 | total number of undo segments dropped | 128 | 0
186 | table scans (short tables) | 64 | 3685
187 | table scans (long tables) | 64 | 0
188 | table scans (rowid ranges) | 64 | 0
189 | table scans (cache partitions) | 64 | 0
190 | table scans (direct read) | 64 | 0
191 | table scan rows gotten | 64 | 29208
192 | table scan blocks gotten | 64 | 5936
193 | table fetch by rowid | 64 | 17932
194 | table fetch continued row | 64 | 0
195 | cluster key scans | 64 | 6081
196 | cluster key scan block gets | 64 | 8712
197 | rows fetched via callback | 64 | 5236
198 | leaf node splits | 128 | 0
199 | leaf node 90-10 splits | 128 | 0
200 | branch node splits | 128 | 0
201 | native hash arithmetic execute | 64 | 0
202 | native hash arithmetic fail | 64 | 0
203 | index fast full scans (full) | 64 | 0
204 | index fast full scans (rowid ranges) | 64 | 0
205 | index fast full scans (direct read) | 64 | 0
206 | index fetch by key | 128 | 14083
207 | index scans kdiixs1 | 128 | 12870
208 | session cursor cache hits | 64 | 5367
209 | session cursor cache count | 64 | 52
210 | cursor authentications | 128 | 227
211 | queries parallelized | 32 | 0
212 | DML statements parallelized | 32 | 0
213 | DDL statements parallelized | 32 | 0
214 | DFO trees parallelized | 32 | 0
215 | Parallel operations not downgraded | 32 | 0
216 | Parallel operations downgraded to serial | 32 | 0
217 | Parallel operations downgraded 75 to 99 pct | 32 | 0
218 | Parallel operations downgraded 50 to 75 pct | 32 | 0
219 | Parallel operations downgraded 25 to 50 pct | 32 | 0
220 | Parallel operations downgraded 1 to 25 pct | 32 | 0
221 | PX local messages sent | 32 | 0
222 | PX local messages recv'd | 32 | 0
223 | PX remote messages sent | 32 | 0
224 | PX remote messages recv'd | 32 | 0
225 | buffer is pinned count | 72 | 20624
226 | buffer is not pinned count | 72 | 37661
227 | no buffer to keep pinned count | 72 | 1
228 | table lookup prefetch client count | 8 | 0
229 | workarea memory allocated | 64 | 0
230 | workarea executions - optimal | 64 | 6002
231 | workarea executions - onepass | 64 | 0
232 | workarea executions - multipass | 64 | 0
233 | parse time cpu | 64 | 550
234 | parse time elapsed | 64 | 5455
235 | parse count (total) | 64 | 8050
236 | parse count (hard) | 64 | 370
237 | parse count (failures) | 64 | 0
238 | execute count | 64 | 19546
239 | bytes sent via SQL*Net to client | 1 | 1176411
240 | bytes received via SQL*Net from client | 1 | 2658604
241 | SQL*Net roundtrips to/from client | 1 | 13265
242 | bytes sent via SQL*Net to dblink | 1 | 0
243 | bytes received via SQL*Net from dblink | 1 | 0
244 | SQL*Net roundtrips to/from dblink | 1 | 0
245 | sorts (memory) | 64 | 5531
246 | sorts (disk) | 64 | 0
247 | sorts (rows) | 64 | 22304
248 | OTC commit optimization attempts | 128 | 0
249 | OTC commit optimization hits | 128 | 0
250 | OTC commit optimization failure - setup | 128 | 0