-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathorav.1.html
316 lines (296 loc) · 17.3 KB
/
orav.1.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
<!doctype html><html lang="en">
<head><meta charset="UTF-8">
<link rel="STYLESHEET" href="main.css" type="text/css">
<title>Oracle v$ Views | SS64.com</title>
<meta name="Description" CONTENT="Oracle V$ Data Dictionary">
<meta name="Keywords" CONTENT="oracle,v$,Command line,sql,script">
</head><body>
<div id="tnav"><ul>
<li class="tbtn"><a href="index.html">( SS64 )</a></li>
<li class="tbtn"><a href="ora.1.html">Oracle</a></li>
<li class="tbtn"><a href="ora/syntax.html">Syntax</a></li>
<li><div id="search"><form action="https://www.google.com/search" method="get">
<button tabindex="-1" type="submit" id="q-img"></button>
<input type="text" name="q" id="q" size="27" maxlength="255" onblur="if(this.value=='')this.value='Search…';" onclick="if(this.value=='Search…')this.value='';" value="Search…">
<input type="hidden" name="sitesearch" value="ss64.com"></form></div></li>
</ul></div>
<h1>Oracle Dynamic Performance V$ Views</h1>
<p>See also a dump of the <a href="orad/index.html">Oracle Data Dictionary</a></p>
<pre>
<a href="orav/V$ACCESS.html">V$ACCESS</a>
<a href="orav/V$ACTIVE_INSTANCES.html">V$ACTIVE_INSTANCES</a>
<a href="orav/V$ACTIVE_SESS_POOL_MTH.html">V$ACTIVE_SESS_POOL_MTH</a>
<a href="orav/V$AQ.html">V$AQ</a>
<a href="orav/V$AQ1.html">V$AQ1</a>
<a href="orav/V$ARCHIVE.html">V$ARCHIVE</a>
<a href="orav/V$ARCHIVED_LOG.html">V$ARCHIVED_LOG</a>
<a href="orav/V$ARCHIVE_DEST.html">V$ARCHIVE_DEST</a>
<a href="orav/V$ARCHIVE_DEST_STATUS.html">V$ARCHIVE_DEST_STATUS</a>
<a href="orav/V$ARCHIVE_GAP.html">V$ARCHIVE_GAP</a>
<a href="orav/V$ARCHIVE_PROCESSES.html">V$ARCHIVE_PROCESSES</a>
<a href="orav/V$AW_CALC.html">V$AW_CALC</a>
<a href="orav/V$AW_OLAP.html">V$AW_OLAP</a>
<a href="orav/V$AW_SESSION_INFO.html">V$AW_SESSION_INFO</a>
<a href="orav/V$BACKUP.html">V$BACKUP</a>
<a href="orav/V$BACKUP_ASYNC_IO.html">V$BACKUP_ASYNC_IO</a>
<a href="orav/V$BACKUP_CORRUPTION.html">V$BACKUP_CORRUPTION</a>
<a href="orav/V$BACKUP_DATAFILE.html">V$BACKUP_DATAFILE</a>
<a href="orav/V$BACKUP_DEVICE.html">V$BACKUP_DEVICE</a>
<a href="orav/V$BACKUP_PIECE.html">V$BACKUP_PIECE</a>
<a href="orav/V$BACKUP_REDOLOG.html">V$BACKUP_REDOLOG</a>
<a href="orav/V$BACKUP_SET.html">V$BACKUP_SET</a>
<a href="orav/V$BACKUP_SPFILE.html">V$BACKUP_SPFILE</a>
<a href="orav/V$BACKUP_SYNC_IO.html">V$BACKUP_SYNC_IO</a>
<a href="orav/V$BGPROCESS.html">V$BGPROCESS</a>
<a href="orav/V$BH.html">V$BH</a>
<a href="orav/V$BSP.html">V$BSP</a>
<a href="orav/V$BUFFER_POOL.html">V$BUFFER_POOL</a>
<a href="orav/V$BUFFER_POOL_STATISTICS.html">V$BUFFER_POOL_STATISTICS</a>
<a href="orav/V$CIRCUIT.html">V$CIRCUIT</a>
<a href="orav/V$CLASS_CACHE_TRANSFER.html">V$CLASS_CACHE_TRANSFER</a>
<a href="orav/V$CLASS_PING.html">V$CLASS_PING</a>
<a href="orav/V$COMPATIBILITY.html">V$COMPATIBILITY</a>
<a href="orav/V$COMPATSEG.html">V$COMPATSEG</a>
<a href="orav/V$CONTEXT.html">V$CONTEXT</a>
<a href="orav/V$CONTROLFILE.html">V$CONTROLFILE</a>
<a href="orav/V$CONTROLFILE_RECORD_SECTION.html">V$CONTROLFILE_RECORD_SECTION</a>
<a href="orav/V$COPY_CORRUPTION.html">V$COPY_CORRUPTION</a>
<a href="orav/V$CR_BLOCK_SERVER.html">V$CR_BLOCK_SERVER</a>
<a href="orav/V$DATABASE.html">V$DATABASE</a>
<a href="orav/V$DATABASE_BLOCK_CORRUPTION.html">V$DATABASE_BLOCK_CORRUPTION</a>
<a href="orav/V$DATABASE_INCARNATION.html">V$DATABASE_INCARNATION</a>
<a href="orav/V$DATAFILE.html">V$DATAFILE</a>
<a href="orav/V$DATAFILE_COPY.html">V$DATAFILE_COPY</a>
<a href="orav/V$DATAFILE_HEADER.html">V$DATAFILE_HEADER</a>
<a href="orav/V$DATAGUARD_STATUS.html">V$DATAGUARD_STATUS</a>
<a href="orav/V$DBFILE.html">V$DBFILE</a>
<a href="orav/V$DBLINK.html">V$DBLINK</a>
<a href="orav/V$DB_CACHE_ADVICE.html">V$DB_CACHE_ADVICE</a>
<a href="orav/V$DB_OBJECT_CACHE.html">V$DB_OBJECT_CACHE</a>
<a href="orav/V$DB_PIPES.html">V$DB_PIPES</a>
<a href="orav/V$DELETED_OBJECT.html">V$DELETED_OBJECT</a>
<a href="orav/V$DISPATCHER.html">V$DISPATCHER</a>
<a href="orav/V$DISPATCHER_RATE.html">V$DISPATCHER_RATE</a>
<a href="orav/V$DLM_ALL_LOCKS.html">V$DLM_ALL_LOCKS</a>
<a href="orav/V$DLM_CONVERT_LOCAL.html">V$DLM_CONVERT_LOCAL</a>
<a href="orav/V$DLM_CONVERT_REMOTE.html">V$DLM_CONVERT_REMOTE</a>
<a href="orav/V$DLM_LATCH.html">V$DLM_LATCH</a>
<a href="orav/V$DLM_LOCKS.html">V$DLM_LOCKS</a>
<a href="orav/V$DLM_MISC.html">V$DLM_MISC</a>
<a href="orav/V$DLM_RESS.html">V$DLM_RESS</a>
<a href="orav/V$DLM_TRAFFIC_CONTROLLER.html">V$DLM_TRAFFIC_CONTROLLER</a>
<a href="orav/V$ENABLEDPRIVS.html">V$ENABLEDPRIVS</a>
<a href="orav/V$ENQUEUE_LOCK.html">V$ENQUEUE_LOCK</a>
<a href="orav/V$ENQUEUE_STAT.html">V$ENQUEUE_STAT</a>
<a href="orav/V$EVENT_NAME.html">V$EVENT_NAME</a>
<a href="orav/V$EXECUTION.html">V$EXECUTION</a>
<a href="orav/V$FAST_START_SERVERS.html">V$FAST_START_SERVERS</a>
<a href="orav/V$FAST_START_TRANSACTIONS.html">V$FAST_START_TRANSACTIONS</a>
<a href="orav/V$FILESTAT.html">V$FILESTAT</a>
<a href="orav/V$FILESTATXS.html">V$FILESTATXS</a>
<a href="orav/V$FILE_CACHE_TRANSFER.html">V$FILE_CACHE_TRANSFER</a>
<a href="orav/V$FILE_PING.html">V$FILE_PING</a>
<a href="orav/V$FIXED_TABLE.html">V$FIXED_TABLE</a>
<a href="orav/V$FIXED_VIEW_DEFINITION.html">V$FIXED_VIEW_DEFINITION</a>
<a href="orav/V$GCSHVMASTER_INFO.html">V$GCSHVMASTER_INFO</a>
<a href="orav/V$GCSPFMASTER_INFO.html">V$GCSPFMASTER_INFO</a>
<a href="orav/V$GC_ELEMENT.html">V$GC_ELEMENT</a>
<a href="orav/V$GC_ELEMENTS_W_COLLISIONS.html">V$GC_ELEMENTS_W_COLLISIONS</a>
<a href="orav/V$GES_BLOCKING_ENQUEUE.html">V$GES_BLOCKING_ENQUEUE</a>
<a href="orav/V$GES_ENQUEUE.html">V$GES_ENQUEUE</a>
<a href="orav/V$GLOBALCONTEXT.html">V$GLOBALCONTEXT</a>
<a href="orav/V$GLOBAL_BLOCKED_LOCKS.html">V$GLOBAL_BLOCKED_LOCKS</a>
<a href="orav/V$GLOBAL_TRANSACTION.html">V$GLOBAL_TRANSACTION</a>
<a href="orav/V$HS_AGENT.html">V$HS_AGENT</a>
<a href="orav/V$HS_PARAMETER.html">V$HS_PARAMETER</a>
<a href="orav/V$HS_SESSION.html">V$HS_SESSION</a>
<a href="orav/V$HVMASTER_INFO.html">V$HVMASTER_INFO</a>
<a href="orav/V$INDEXED_FIXED_COLUMN.html">V$INDEXED_FIXED_COLUMN</a>
<a href="orav/V$INSTANCE.html">V$INSTANCE</a>
<a href="orav/V$INSTANCE_RECOVERY.html">V$INSTANCE_RECOVERY</a>
<a href="orav/V$KCCDI.html">V$KCCDI</a>
<a href="orav/V$KCCFE.html">V$KCCFE</a>
<a href="orav/V$LATCH.html">V$LATCH</a>
<a href="orav/V$LATCHHOLDER.html">V$LATCHHOLDER</a>
<a href="orav/V$LATCHNAME.html">V$LATCHNAME</a>
<a href="orav/V$LATCH_CHILDREN.html">V$LATCH_CHILDREN</a>
<a href="orav/V$LATCH_MISSES.html">V$LATCH_MISSES</a>
<a href="orav/V$LATCH_PARENT.html">V$LATCH_PARENT</a>
<a href="orav/V$LIBRARYCACHE.html">V$LIBRARYCACHE</a>
<a href="orav/V$LIBRARY_CACHE_MEMORY.html">V$LIBRARY_CACHE_MEMORY</a>
<a href="orav/V$LICENSE.html">V$LICENSE</a>
<a href="orav/V$LOADISTAT.html">V$LOADISTAT</a>
<a href="orav/V$LOADPSTAT.html">V$LOADPSTAT</a>
<a href="orav/V$LOCK.html">V$LOCK</a>
<a href="orav/V$_LOCK.html">V$_LOCK</a>
<a href="orav/V$LOCKED_OBJECT.html">V$LOCKED_OBJECT</a>
<a href="orav/V$LOCKS_WITH_COLLISIONS.html">V$LOCKS_WITH_COLLISIONS</a>
<a href="orav/V$LOCK_ACTIVITY.html">V$LOCK_ACTIVITY</a>
<a href="orav/V$LOCK_ELEMENT.html">V$LOCK_ELEMENT</a>
<a href="orav/V$LOG.html">V$LOG</a>
<a href="orav/V$LOGFILE.html">V$LOGFILE</a>
<a href="orav/V$LOGHIST.html">V$LOGHIST</a>
<a href="orav/V$LOGMNR_CALLBACK.html">V$LOGMNR_CALLBACK</a>
<a href="orav/V$LOGMNR_CONTENTS.html">V$LOGMNR_CONTENTS</a>
<a href="orav/V$LOGMNR_DICTIONARY.html">V$LOGMNR_DICTIONARY</a>
<a href="orav/V$LOGMNR_LOGFILE.html">V$LOGMNR_LOGFILE</a>
<a href="orav/V$LOGMNR_LOGS.html">V$LOGMNR_LOGS</a>
<a href="orav/V$LOGMNR_PARAMETERS.html">V$LOGMNR_PARAMETERS</a>
<a href="orav/V$LOGMNR_PROCESS.html">V$LOGMNR_PROCESS</a>
<a href="orav/V$LOGMNR_REGION.html">V$LOGMNR_REGION</a>
<a href="orav/V$LOGMNR_SESSION.html">V$LOGMNR_SESSION</a>
<a href="orav/V$LOGMNR_STATS.html">V$LOGMNR_STATS</a>
<a href="orav/V$LOGMNR_TRANSACTION.html">V$LOGMNR_TRANSACTION</a>
<a href="orav/V$LOGSTDBY.html">V$LOGSTDBY</a>
<a href="orav/V$LOGSTDBY_STATS.html">V$LOGSTDBY_STATS</a>
<a href="orav/V$LOG_HISTORY.html">V$LOG_HISTORY</a>
<a href="orav/V$MANAGED_STANDBY.html">V$MANAGED_STANDBY</a>
<a href="orav/V$MAP_COMP_LIST.html">V$MAP_COMP_LIST</a>
<a href="orav/V$MAP_ELEMENT.html">V$MAP_ELEMENT</a>
<a href="orav/V$MAP_EXT_ELEMENT.html">V$MAP_EXT_ELEMENT</a>
<a href="orav/V$MAP_FILE.html">V$MAP_FILE</a>
<a href="orav/V$MAP_FILE_EXTENT.html">V$MAP_FILE_EXTENT</a>
<a href="orav/V$MAP_FILE_IO_STACK.html">V$MAP_FILE_IO_STACK</a>
<a href="orav/V$MAP_LIBRARY.html">V$MAP_LIBRARY</a>
<a href="orav/V$MAP_SUBELEMENT.html">V$MAP_SUBELEMENT</a>
<a href="orav/V$MAX_ACTIVE_SESS_TARGET_MTH.html">V$MAX_ACTIVE_SESS_TARGET_MTH</a>
<a href="orav/V$MLS_PARAMETERS.html">V$MLS_PARAMETERS</a>
<a href="orav/V$MTS.html">V$MTS</a>
<a href="orav/V$MTTR_TARGET_ADVICE.html">V$MTTR_TARGET_ADVICE</a>
<a href="orav/V$MVREFRESH.html">V$MVREFRESH</a>
<a href="orav/V$MYSTAT.html">V$MYSTAT</a>
<a href="orav/V$NLS_PARAMETERS.html">V$NLS_PARAMETERS</a>
<a href="orav/V$NLS_VALID_VALUES.html">V$NLS_VALID_VALUES</a>
<a href="orav/V$OBJECT_DEPENDENCY.html">V$OBJECT_DEPENDENCY</a>
<a href="orav/V$OBJECT_USAGE.html">V$OBJECT_USAGE</a>
<a href="orav/V$OBSOLETE_PARAMETER.html">V$OBSOLETE_PARAMETER</a>
<a href="orav/V$OFFLINE_RANGE.html">V$OFFLINE_RANGE</a>
<a href="orav/V$OLAP_ALTER_SESSION.html">V$OLAP_ALTER_SESSION</a>
<a href="orav/V$OPEN_CURSOR.html">V$OPEN_CURSOR</a>
<a href="orav/V$OPTION.html">V$OPTION</a>
<a href="orav/V$PARALLEL_DEGREE_LIMIT_MTH.html">V$PARALLEL_DEGREE_LIMIT_MTH</a>
<a href="orav/V$PARAMETER.html">V$PARAMETER</a>
<a href="orav/V$PARAMETER2.html">V$PARAMETER2</a>
<a href="orav/V$PGASTAT.html">V$PGASTAT</a>
<a href="orav/V$PGA_TARGET_ADVICE.html">V$PGA_TARGET_ADVICE</a>
<a href="orav/V$PGA_TARGET_ADVICE_HISTOGRAM.html">V$PGA_TARGET_ADVICE_HISTOGRAM</a>
<a href="orav/V$PQ_SESSTAT.html">V$PQ_SESSTAT</a>
<a href="orav/V$PQ_SLAVE.html">V$PQ_SLAVE</a>
<a href="orav/V$PQ_SYSSTAT.html">V$PQ_SYSSTAT</a>
<a href="orav/V$PQ_TQSTAT.html">V$PQ_TQSTAT</a>
<a href="orav/V$PROCESS.html">V$PROCESS</a>
<a href="orav/V$PROXY_ARCHIVEDLOG.html">V$PROXY_ARCHIVEDLOG</a>
<a href="orav/V$PROXY_DATAFILE.html">V$PROXY_DATAFILE</a>
<a href="orav/V$PWFILE_USERS.html">V$PWFILE_USERS</a>
<a href="orav/V$PX_PROCESS.html">V$PX_PROCESS</a>
<a href="orav/V$PX_PROCESS_SYSSTAT.html">V$PX_PROCESS_SYSSTAT</a>
<a href="orav/V$PX_SESSION.html">V$PX_SESSION</a>
<a href="orav/V$PX_SESSTAT.html">V$PX_SESSTAT</a>
<a href="orav/V$QUEUE.html">V$QUEUE</a>
<a href="orav/V$QUEUEING_MTH.html">V$QUEUEING_MTH</a>
<a href="orav/V$RECOVERY_FILE_STATUS.html">V$RECOVERY_FILE_STATUS</a>
<a href="orav/V$RECOVERY_LOG.html">V$RECOVERY_LOG</a>
<a href="orav/V$RECOVERY_PROGRESS.html">V$RECOVERY_PROGRESS</a>
<a href="orav/V$RECOVERY_STATUS.html">V$RECOVERY_STATUS</a>
<a href="orav/V$RECOVER_FILE.html">V$RECOVER_FILE</a>
<a href="orav/V$REPLPROP.html">V$REPLPROP</a>
<a href="orav/V$REPLQUEUE.html">V$REPLQUEUE</a>
<a href="orav/V$REQDIST.html">V$REQDIST</a>
<a href="orav/V$RESERVED_WORDS.html">V$RESERVED_WORDS</a>
<a href="orav/V$RESOURCE.html">V$RESOURCE</a>
<a href="orav/V$RESOURCE_LIMIT.html">V$RESOURCE_LIMIT</a>
<a href="orav/V$RESUMABLE.html">V$RESUMABLE</a>
<a href="orav/V$RMAN_CONFIGURATION.html">V$RMAN_CONFIGURATION</a>
<a href="orav/V$ROLLNAME.html">V$ROLLNAME</a>
<a href="orav/V$ROLLSTAT.html">V$ROLLSTAT</a>
<a href="orav/V$ROWCACHE.html">V$ROWCACHE</a>
<a href="orav/V$ROWCACHE_PARENT.html">V$ROWCACHE_PARENT</a>
<a href="orav/V$ROWCACHE_SUBORDINATE.html">V$ROWCACHE_SUBORDINATE</a>
<a href="orav/V$RSRC_CONSUMER_GROUP.html">V$RSRC_CONSUMER_GROUP</a>
<a href="orav/V$RSRC_CONSUMER_GROUP_CPU_MTH.html">V$RSRC_CONSUMER_GROUP_CPU_MTH</a>
<a href="orav/V$RSRC_PLAN.html">V$RSRC_PLAN</a>
<a href="orav/V$RSRC_PLAN_CPU_MTH.html">V$RSRC_PLAN_CPU_MTH</a>
<a href="orav/V$SEGMENT_STATISTICS.html">V$SEGMENT_STATISTICS</a>
<a href="orav/V$SEGSTAT.html">V$SEGSTAT</a>
<a href="orav/V$SEGSTAT_NAME.html">V$SEGSTAT_NAME</a>
<a href="orav/V$SESSION.html">V$SESSION</a>
<a href="orav/V$SESSION_CONNECT_INFO.html">V$SESSION_CONNECT_INFO</a>
<a href="orav/V$SESSION_CURSOR_CACHE.html">V$SESSION_CURSOR_CACHE</a>
<a href="orav/V$SESSION_EVENT.html">V$SESSION_EVENT</a>
<a href="orav/V$SESSION_LONGOPS.html">V$SESSION_LONGOPS</a>
<a href="orav/V$SESSION_OBJECT_CACHE.html">V$SESSION_OBJECT_CACHE</a>
<a href="orav/V$SESSION_WAIT.html">V$SESSION_WAIT</a>
<a href="orav/V$SESSTAT.html">V$SESSTAT</a>
<a href="orav/V$SESS_IO.html">V$SESS_IO</a>
<a href="orav/V$SGA.html">V$SGA</a>
<a href="orav/V$SGASTAT.html">V$SGASTAT</a>
<a href="orav/V$SGA_CURRENT_RESIZE_OPS.html">V$SGA_CURRENT_RESIZE_OPS</a>
<a href="orav/V$SGA_DYNAMIC_COMPONENTS.html">V$SGA_DYNAMIC_COMPONENTS</a>
<a href="orav/V$SGA_DYNAMIC_FREE_MEMORY.html">V$SGA_DYNAMIC_FREE_MEMORY</a>
<a href="orav/V$SGA_RESIZE_OPS.html">V$SGA_RESIZE_OPS</a>
<a href="orav/V$SHARED_POOL_ADVICE.html">V$SHARED_POOL_ADVICE</a>
<a href="orav/V$SHARED_POOL_RESERVED.html">V$SHARED_POOL_RESERVED</a>
<a href="orav/V$SHARED_SERVER.html">V$SHARED_SERVER</a>
<a href="orav/V$SHARED_SERVER_MONITOR.html">V$SHARED_SERVER_MONITOR</a>
<a href="orav/V$SORT_SEGMENT.html">V$SORT_SEGMENT</a>
<a href="orav/V$SORT_USAGE.html">V$SORT_USAGE</a>
<a href="orav/V$SPPARAMETER.html">V$SPPARAMETER</a>
<a href="orav/V$SQL.html">V$SQL</a>
<a href="orav/V$SQLAREA.html">V$SQLAREA</a>
<a href="orav/V$SQLTEXT.html">V$SQLTEXT</a>
<a href="orav/V$SQLTEXT_WITH_NEWLINES.html">V$SQLTEXT_WITH_NEWLINES</a>
<a href="orav/V$SQLXS.html">V$SQLXS</a>
<a href="orav/V$SQL_BIND_DATA.html">V$SQL_BIND_DATA</a>
<a href="orav/V$SQL_BIND_METADATA.html">V$SQL_BIND_METADATA</a>
<a href="orav/V$SQL_CURSOR.html">V$SQL_CURSOR</a>
<a href="orav/V$SQL_PLAN.html">V$SQL_PLAN</a>
<a href="orav/V$SQL_PLAN_STATISTICS.html">V$SQL_PLAN_STATISTICS</a>
<a href="orav/V$SQL_PLAN_STATISTICS_ALL.html">V$SQL_PLAN_STATISTICS_ALL</a>
<a href="orav/V$SQL_REDIRECTION.html">V$SQL_REDIRECTION</a>
<a href="orav/V$SQL_SHARED_CURSOR.html">V$SQL_SHARED_CURSOR</a>
<a href="orav/V$SQL_SHARED_MEMORY.html">V$SQL_SHARED_MEMORY</a>
<a href="orav/V$SQL_WORKAREA.html">V$SQL_WORKAREA</a>
<a href="orav/V$SQL_WORKAREA_ACTIVE.html">V$SQL_WORKAREA_ACTIVE</a>
<a href="orav/V$SQL_WORKAREA_HISTOGRAM.html">V$SQL_WORKAREA_HISTOGRAM</a>
<a href="orav/V$STANDBY_LOG.html">V$STANDBY_LOG</a>
<a href="orav/V$STATISTICS_LEVEL.html">V$STATISTICS_LEVEL</a>
<a href="orav/V$STATNAME.html">V$STATNAME</a>
<a href="orav/V$STREAMS_APPLY_COORDINATOR.html">V$STREAMS_APPLY_COORDINATOR</a>
<a href="orav/V$STREAMS_APPLY_READER.html">V$STREAMS_APPLY_READER</a>
<a href="orav/V$STREAMS_APPLY_SERVER.html">V$STREAMS_APPLY_SERVER</a>
<a href="orav/V$STREAMS_CAPTURE.html">V$STREAMS_CAPTURE</a>
<a href="orav/V$SUBCACHE.html">V$SUBCACHE</a>
<a href="orav/V$SYSSTAT.html">V$SYSSTAT</a>
<a href="orav/V$SYSTEM_CURSOR_CACHE.html">V$SYSTEM_CURSOR_CACHE</a>
<a href="orav/V$SYSTEM_EVENT.html">V$SYSTEM_EVENT</a>
<a href="orav/V$SYSTEM_PARAMETER.html">V$SYSTEM_PARAMETER</a>
<a href="orav/V$SYSTEM_PARAMETER2.html">V$SYSTEM_PARAMETER2</a>
<a href="orav/V$TABLESPACE.html">V$TABLESPACE</a>
<a href="orav/V$TEMPFILE.html">V$TEMPFILE</a>
<a href="orav/V$TEMPORARY_LOBS.html">V$TEMPORARY_LOBS</a>
<a href="orav/V$TEMPSTAT.html">V$TEMPSTAT</a>
<a href="orav/V$TEMPSTATXS.html">V$TEMPSTATXS</a>
<a href="orav/V$TEMP_CACHE_TRANSFER.html">V$TEMP_CACHE_TRANSFER</a>
<a href="orav/V$TEMP_EXTENT_MAP.html">V$TEMP_EXTENT_MAP</a>
<a href="orav/V$TEMP_EXTENT_POOL.html">V$TEMP_EXTENT_POOL</a>
<a href="orav/V$TEMP_PING.html">V$TEMP_PING</a>
<a href="orav/V$TEMP_SPACE_HEADER.html">V$TEMP_SPACE_HEADER</a>
<a href="orav/V$THREAD.html">V$THREAD</a>
<a href="orav/V$TIMER.html">V$TIMER</a>
<a href="orav/V$TIMEZONE_NAMES.html">V$TIMEZONE_NAMES</a>
<a href="orav/V$TRANSACTION.html">V$TRANSACTION</a>
<a href="orav/V$TRANSACTION_ENQUEUE.html">V$TRANSACTION_ENQUEUE</a>
<a href="orav/V$TYPE_SIZE.html">V$TYPE_SIZE</a>
<a href="orav/V$UNDOSTAT.html">V$UNDOSTAT</a>
<a href="orav/V$VERSION.html">V$VERSION</a>
<a href="orav/V$VPD_POLICY.html">V$VPD_POLICY</a>
<a href="orav/V$WAITSTAT.html">V$WAITSTAT</a> </pre>
<p>These views are owned by SYS. The V$ views are actually public synonyms for corresponding SYS.V<b>_</b>$ views.</p>
<p>To list all the V$ views on your system look in <a href="orav/V$FIXED_VIEW_DEFINITION.html" class="code">V$FIXED_VIEW_DEFINITION</a>, or <span class="code">Select name from <a href="orav/V$FIXED_TABLE.html">V$FIXED_TABLE</a> where name like 'V$%';</span></p>
<p>To use
these views, ensure that timed_statistics is set in the <a href="ora/syntax-initora.html">init.ora</a> file (TIMED_STATISTICS=TRUE). This has minimal effect on performance.</p>
<p>GV$ views are dynamic performance views in a parallel
server environment. There is a GV$ view for almost every V$ view.
These have an additional column INST_ID (instance number)<br>
This document was originally based on Oracle 9i.</p></body>
</html>