401. V $ PQ_TQSTAT
Contains a statistic on parallel implementation operations. Help measuring unbalanced issues in a query.
402. V $ processs
Contains information about the current activity process.
403. V $ proxy_archivedlog
Contains an archive log backup. Description information of files, these backup files have a new feature called Proxy copy
404. V $ proxy_datafile
Contains data files and new features. Description information of the file backup, these backup files have a copy of the Proxy copy
405. V $ PWFILE_USERS
A user who is granted SYSDBA and SYSOPER privileges is listed.
406. V $ PX_PROCESS
Contains information about sessions that are running in parallel.
407. V $ PX_PROCESS_SYSSTAT
Contains information about sessions that are running in parallel.
408. V $ PX_SESSION
Contains information about sessions that are running in parallel.
409. V $ PX_SESSTAT
Contains information about sessions that are running in parallel.
410. V $ queue
Contains information about multi-threaded message queues.
411. V $ queueing_mth
Display all available query resource allocation methods.
412. V $ Recover_File
Display file status required to recover media recovery.
413. V $ Recovery_File_Status
Contains a line of information for each data file for each recovery command.
414. V $ Recovery_log
List the information that requires an archive log that needs to be recovered. This information comes from V $ log_history
415. V $ Recovery_Process
Can be used to track database recovery operations so they will not be terminated.
It is also used to estimate the time required to complete this operation in the process.
416. V $ Recovery_Status
Contains the statistic of the current recovery process.
417. V $ reqdist
List the statistics of histograms of the MTS scheduler request number.
418. V $ reserved_words
Give a list of keywords used by the PL / SQL compiler.
419. V $ resource
Contains resource name and address information.
420. V $ resource_limit
Display information for global resource usage of system resources.
421. V $ ROLLNAME
List all online returns.
422. V $ ROLLSTAT
Contains the statistics of the rollback segment.
423. V $ ROWCACHE
Display the statistics of the active data dictionary.
424. V $ ROWCACHE_PARENT
Displays information about all dual-pro objects in the data dictionary.
425. V $ ROWCACHE_SUBORDINATE
Displays information about the dependent object in the data dictionary.
426. V $ rRC_CONSUMER_GROUP
Displays the data associated with the current active resource consumer user group.
427. V $ rRC_CONSUMER_GROUP_CPU_MTH
Displays all the allocation methods of all available resources for the resource consumer user group.
428. V $ RSRC_PLAN
Displays the name of all current active resource scenarios.
429. V $ rRC_PLAN_CPU_MTH
Display all available CPU resource allocation methods for the resource scheme.
430. V $ sess_io
List I / O statistics for each user session.
431. V $ session
List the session information of each session.
432. V $ session_connect_info
Displays information about the network connection of the current session.
433. V $ session_cursor_cache
Displays information about cursor usage of the current session.
434. V $ session_event
List the information that sessions waiting for an event.
435. V $ session_longops
Display a state of a long run operation.
436. V $ session_Object_cache
Displays the statistics of the object cache of the current user-talk on the local server.
437. V $ session_wait
List the resources or events of the active activities.
438. V $ sessstat
List the user session statistics.
439. V $ SGA
The presidential measurement of the system's global zone is included.
440. V $ SGASTAT
Contains details of the system's global zone.
441. V $ shared_pool_reserved lists the statistics that can help you adjust the pool and space in the shared pool.
442. V $ Shared_Server
Contains information about the shared server process.
443. V $ shared_server_monitor
Contains information about debugging the shared server process.
444. V $ sort_segment
Contains information of each sort segment in a given instance.
445. V $ spparameter
List the contents of the spfile.
446. V $ SQL
List the statistics of the SQL shared area.
447. V $ SQL_BIND_DATA
If the data is available in the server, it will different connection variables, display the client sent to each of the cursors in each cacker that queries this view.
448. V $ SQL_BIND_METADATA
The connection metadata supplied to the session of this view is queried. Each different connection variable in each cursor, display the client
449. V $ SQL_CURSOR
Display the debug information of each cursor associated with the session of this view.
450. V $ SQL_PLAN
Contains execution plan information that is loaded into the library cache.
451. V $ SQL_SHARED_CURSOR
Why is a specific sub-game not interpretation of sharing with a child query existing.
452. V $ SQL_SHARED_MEMEORY
Information about the cursor of the shared memory snapshot.
453. V $ SQL_REDIRECTION
Identify the SQL statement of the reset direction.
454. V $ SQL_WORKAREA
Displays workspace information used by SQL cursors.
455. V $ SQL_WORKAREA_ACTIVE
Contains the 昫 昫 information of the workspace that is currently allocated by the system.
456. V $ SQLAREA
Share SQL statistics.
457. V $ SQLText
The SQL statement text containing the SGA belongs to the shared SQL cursor.
458. V $ SQLTEXT_WITH_NEWLINES
You can't use space instead of the new row system, and the V $ SQLText functionality is the same.
459. V $ STATNAME
Display the decoding statistical name of the statistic in the V $ SESSSTAT and V $ SYSTAT table.
460. V $ SUBCACHE
Displays information about the dependent cache currently loaded in the library cache.
461. V $ sysstat
List system statistics.
462. V $ system_cursor_cache
System range information.
463. V $ SYSTEM_EVENT
Contains all information waiting for an event.
464. V $ SYSTEM_PARAMETER
Contains system parameter information.
465. V $ SYSTEM_PARAMETER2
The currently affected parameters and parameters of the Oracle instance.
466. V $ TABLESPACE
Control information of tablespace in the file.
467. V $ TEMP_CACHE_TRANSFER
Displays the number of checked blocks in each data file.
468. V $ TEMP_EXTENT_MAP
Shows the status information of each unit of all temporary tablespaces.
469. V $ TEMP_EXTENT_POOL
The status of the temporary spatial cache used by a given instance is displayed.
470. V $ TEMP_PING
Displays the number of blocks of each data file search.
471. V $ TEMP_SPACE_HEADER
Displaying each temporary table space and how much free space. The aggregation information of each file in the space involves how much it is in each space first
472. V $ TEMPFILE
Show information about temporary files.
473. V $ TEMPORY_LOBS
Show temporary LOB.
474. V $ TEMPSTAT
Contains statistics for file read / write.
475. V $ thread
Contains thread information in the control file.
476. V $ TIMER
List the passage time at 1% seconds.
477. V $ TIMEZONE_NAMES
List the legal time zone name.
478. V $ Transaction
List the active transactions in your system.
479. V $ transaction_enqueue
Show the lock owned by the transaction status object.
480. V $ TY_SIZE
List the size of different database components to estimate the size of the data block. 481. V $ undostat
Display a historical statistics to display how the system works.
482. V $ VERSION
List the version number of the core library component in the Oracle server.
483. V $ VPD_POLICY
List all security policies associated with the cursors currently in the library cache.
484. V $ WaitStat
List block competitive statistics
9i management data dictionary DBA view
485. DBA_2PC_Neighbors
Contains connection information of the introduction or flowing of the pending transaction.
486. DBA_ALL_TABLES
Displays a description of all tables in the database.
487. DBA_Application_Roles
All validation policies with functions defined.
488. DBA_ASSOCIATIONS
Display user-defined statistics.
489. DBA_AUDIT_EXISTS
List the audit trails generated by Audit NOTSTS and Auditexists.
490. DBA_AUDIT_OBJECT
Audit tracking record of all objects in the system.
491. DBA_AUDIT_SESSION
List all audit tracking information about Connect and Disconnect.
492. DBA_AUDIT_STATEMENT
List the audit tracing information about Grant, Revoke, Audit, NoAudit, Altersystem statement.
493. DBA_AUDIT_TRAIL
List all audit trace entries.
494. DBA_BLOCKERS
List all sessions that are waiting for a session holding lock, but not they are waiting for a lock.
495. DBA_BASE_TABLE_MVIEWS
Describe all materialized views in the database.
496. DBA_CATALOG
List all databases, views, synonyms, and sequences.
497. DBA_CLU_COLUMNS
List the mapping of the table to the aggregation column.
498. DBA_Cluster_hash_expressions
List all aggregated hash Hash functions.
499. DBA_ClUsters
Contains a description of all aggregations in the database.
500. DBA_COL_COMMENTS
Note from the columns of all tables and views.