301. V $ buffer_pool
Displays information about the instance buffer pool.
302. V $ buffer_pool_statistics
Displays information about the instance buffer pool.
303. V $ cache
Contains head information of each block in the SGA of the current instance.
304. V $ cache_lock
Contains head information of each block in the SGA of the current instance. And V $ cache is very similar,
Except for the special envoy the platform lock manager identifier.
305. V $ Cache_TRANSFER
In addition to only those blocks that are probed at least once, and the V $ cache function is the same.
306. V $ CIRCUIT
Contains information about the virtual circuit, is the user through the scheduler and server to all connections.
307. V $ Class_Ping
Displays the number of probed blocks in each block class.
308. V $ CompaTibility
Display the feature used by the database instance, prevent the database from going back to the early versions.
309. V $ compatseg
Displays the permanent feature used by the database instance, prevent the database from going back to the early versions.
310. V $ context
List the setting properties of the current dialog.
311. V $ ControlFile
List the name of the control file.
312. V $ controlfile_record_section
Displays information about the control file recording section.
313. V $ COPY_CORRUPTION
Display information of corruption in the control file.
314. V $ CR_BLOCK_SERVER
Displays statistics on the background process of the block server background in the cache.
315. V $ database
Contains information about the database in the control file.
316. V $ DataFile
Contains information about database files in the control file.
317. V $ datafile_copy
Contains information about the copy of the database file file in the control file.
318. V $ dataFile_Header
Displays data file information on the header of the data file.
319. V $ db_cache_advice
Estimate the amount of physical read according to the size of the cache.
320. V $ db_Object_cache
Caches the database object in the library cache.
321. V $ db_pipes
Displays the currently depicted pipes in the instance.
322. V $ dbfile
List all data files that make up the database.
323. V $ dblink
Query all database connections that sessions open.
324. V $ deleted_Object
The archive log is deleted in the display control file.
325. V $ dispatcher
Provide information about the schedule process.
326. V $ dispatcher_rate
Provide high quality providing rate statistics for the scheduling process.
327. V $ dlm_all_locks
List the information of all current locks.
328. V $ dlm_convert_local
The time consumed by the local lock conversion operation.
329. V $ dlm_convert_remote
The time consumed by the remote lock conversion operation.
330. V $ dlm_latch
It is Outdated, see V $ Latch
331. V $ DLM_LOCKS
These are locking messages that are blocked or block other objects known to the lock manager.
332. V $ dlm_misc
Display a variety of DLM statistics.
333. V $ DLM_RESS
Displays information about all resources known to the current lock manager.
334. V $ enabledprive
Display the granted privilege.
335. V $ enqueue_lock
Displays all locks owned by the queuing object.
336. V $ Event_Name
Contains information waiting for the event.
337. V $ execution
Displays information in parallel execution.
338. V $ false_ping
It is possible to get a buffer that the exploration failed.
339. V $ fast_start_servers
Perform information of all the subordinate operations recovered in parallel operations.
340. V $ fast_start_transactions
Transaction progress information in recovery.
341. V $ file_cache_transfer
Displays the number of blocks detected in each data file.
342. V $ file_ping
Display the number of blocks that each data file is proud. 343. V $ filestat
Contains files about read / write statistics.
344. V $ fixed_table
Display all dynamic performance tables and views and export tables in the database.
345. V $ fixed_view_definition
Displays the definition of all fixed views.
346. V $ GC_ELEMENTS_WITH_COLLISIONS
You can find a lock that protects more cache.
347. V $ GES_BLOCKING_ENQUEUE
These are locking messages that are blocked or block other objects known to the lock manager.
348. V $ GES_CONVERT_LOCAL
Local lock conversion operation
349. V $ GES_CONVERT_REMOTE
The time consumed by the remote lock conversion operation.
350. V $ GES_ENQUEUE
Displays all the locks you know by the current lock administrator.
351. V $ GES_LATCH
See also v $ latch
352. V $ GES_RESOURCE
Displays information about all resources known to the current lock manager.
353. V $ GES_STATISTICS
Display a variety of DLM statistics.
354. V $ global_blocked_locks
Display global block lock.
355. V $ global_transaction
Displays information about currently activated global transactions.
356. V $ HS_AGENT
Identify the collection of HS agents currently running on a given host.
357. V $ HS_SESSION
The Oracle server opens the HS session set.
358. V $ indexed_fixed_column
Displays the column in the dynamic performance table of the index (X $ table).
359. V $ INSTANCE
Displays the status of the current instance.
360. V $ INSTANCE_RECOVERY
Used to monitor the limit mechanism to perform the user to specify the number of times the recovery.
361. V $ latch
The statistic is collected for non-parental simple locks.
362. V $ latch_children
About the statistics of the subcontractic lock.
363. V $ latch_misses
Trying to get a statistic of a simple lock failure.
364. V $ latch_parent
Contains a statistic about the simple lock of the double pro.
365. V $ latchholder
The current simple lock holder's information.
366. V $ latchname
Contains information about the unlocking unlocking name of the simple lock in V $ latch.
367. V $ librarycache
Statistics on cache performance and activity.
368. V $ license
Information for license restrictions.
369. V $ loadCSTAT
Contains SQL * Loader statistics compiled during a direct load execution process.
370. V $ LOCK
The currently held by Oracle.
371. V $ LOCK_AACTIVITY
Displays the DLM lock operation activity of the current instance.
372. V $ LOCK_ELEMENT
Each PCM lock that is cached is an entry in V $ LOCK_ELEMENTS.
373. V $ locked_Object
List all locks obtained by each transaction.
374. V $ loc_with_collisions
You can query the lock of the multi-buffer.
375. V $ log
Control the information of the log file in the file.
376. V $ log_history
Control the historical information of the log file in the file.
377. V $ logfile
The information that contains redo log files.
378. V $ loghist
Control the log history information of the log file in the file.
379. V $ logmnr_contents
Log History.
380. V $ logmnr_dictionary
Log History.
381. V $ logmnr_logs
Log information.
382. V $ logmnr_parameters
Log information.
383. V $ MTS
Contains information of the server that adjusts multi-threaded servers.
384. V $ mystat
The statistic of the current session.
385. V $ NLS_PARAMETERS
Current NLS parameter information.
386. V $ NLS_VALID_VALUES
List all the valid values for all NLS parameters.
387. V $ Object_Dependency
Can determine which object is determined by the package, process or cursor currently loaded in the shared pool. 388. V $ Object_USAGE
To monitor the use of the index.
389. V $ Obsolete_Parameter
List the old parameters.
390. V $ OFFINE_RANGE
Display offline information of the data file in the control file.
391. V $ OPEN_CURSOR
List the cursors of each session currently open and parsed.
392. V $ Option
List the status of Oracle service installation.
393. V $ parallel_degree_limit_mth
Show all effective ways to limit resource allocation.
394. V $ Parameter
List the information about initialization parameters.
395. V $ Parameter2
List the parameters and parameter values that currently affect the session.
396. V $ pgastat
List Oracle Memory Use Statistics.
397. V $ ping
Like V $ Cache.
398. V $ PQ_SESSTAT
List the statistics for parallel query sessions.
399. V $ PQ_SLAVE
An instance of each active parallel execution server statistic.
400. V $ PQ_SYSSTAT
List the statistics of the system of parallel queries.