Oracle basics-6

400. V $ pq_sysstat
Lists the statistics of the parallel query system.
401. V $ pq_tqstat
Contains statistics on parallel execution operations to help determine imbalance in a query.
402. V $ Process
Contains information about the active process.
403. V $ proxy_archivedlog
Contains the description of the archive log backup file, which carries a new feature called a proxy copy.
404. V $ proxy_datafile
Contains the description of data files and control file backups, which contain a copy called proxy
New features.
405. V $ pwfile_users
List users granted sysdba and sysoper privileges.
406. V $ px_process
Contains information about sessions that are running parallel operations.
407. V $ px_process_sysstat
Contains information about sessions that are running parallel operations.
408. V $ px_session
Contains information about sessions that are running parallel operations.
409. V $ px_sesstat
Contains information about sessions that are running parallel operations.
410. V $ queue
Contains information about multi-thread message queues.
411. V $ queueing_mth
Shows all available query resource allocation methods.
412. V $ recover_file
Displays the status of the file to be restored.
413. V $ recovery_file_status
Contains a line of information for each data file of each recovery command.
414. V $ recovery_log
Lists the information of the archived logs to be restored. This information is from V $ log_history.
415. V $ recovery_process
It can be used to track database recovery operations so that 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 statistics of the current recovery process.
417. V $ reqdist
List the statistics of the number of requests of the MTS scheduler.
418. V $ reserved_words
A list of keywords used by the PL/SQL Compiler.
419. V $ Resource
Contains the Resource Name and address information.
420. V $ resource_limit
Displays global resource usage information for system resources.
421. V $ rollname
Lists information about all online rollback segments.
422. V $ rollstat
The statistic that contains the rollback segment.
423. V $ rowcache
Displays the statistics of the activity data dictionary.
424. V $ rowcache_parent
Displays information about all parent objects in the data dictionary.
425. V $ rowcache_subordinate
Displays the information of the dependent objects in the data dictionary.
426. V $ rsrc_consumer_group
Displays the data associated with the consumer group of the current active resource.
427. V $ rsrc_consumer_group_cpu_mth
Shows all available resource allocation methods for the resource consumer group.
428. V $ rsrc_plan
Displays the names of all currently active resource plans.
429. V $ rsrc_plan_cpu_mth
Shows all available CPU resource allocation methods for resource schemes.
430. V $ sess_io
Lists the I/O statistics for each user session.
431. V $ session
Lists the session information of each session.
432. V $ session_connect_info
Displays the network connection information of the current session.
433. V $ session_cursor_cache
Displays the cursor usage of the current session.
434. V $ session_event
Lists information about a session waiting for an event.
435. V $ session_longops
Displays the status of a long running operation.
436. V $ session_object_cache
Displays the high-speed cache statistics of the object for the current user conversation on the local server.
437. V $ session_wait
Lists the resources or events of a pending active session.
438. V $ sesstat
Lists user session statistics.
439. V $ SGA
Include the president's measurement in the global area of the system.
440. V $ sgastat
Contains detailed information about the global zone of the system.
441. V $ shared_pool_reserved
List the statistics that can help you adjust the reserved 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 Shared Server Processes.
444. V $ sort_segment
Contains information about each sorting segment of a given instance.
445. V $ spparameter
List the spfile content.
446. V $ SQL
List the statistics of the SQL sharing zone.
447. V $ SQL _bind_data
If the data is available on the server, it does not
The actual connection data sent by the client is displayed.
448. V $ SQL _bind_metadata
The client provides
.
449. V $ SQL _cursor
Displays the debug information of each cursor related to the session query for this view.
450. V $ SQL _plan
Contains the execution plan information of each sub-game Subject loaded into the library cache.
451. V $ SQL _shared_cursor
Why does a specific subcursor not share with an existing subquery.
452. V $ SQL _shared_memeory
Information about the cursor of the shared memory snapshot.
453. V $ SQL _redirection
The SQL statement that identifies the reset direction.
454. V $ SQL _workarea
Displays the workspace information used by the SQL cursor.
455. V $ SQL _workarea_active
Contains the Inter-region information of the workspace currently allocated by the system.
456. V $ sqlarea
Share the SQL statistics.
457. V $ sqltext
Contains the SQL statement text in SGA that shares the SQL cursor.
458. V $ sqltext_with_newlines
Do not use spaces to replace the New Line tab, which is the same as the function of V $ sqltext.
459. V $ statname
The name of the decoder statistics for the statistics in the V $ sesstat and V $ statistics at tables is displayed.
460. V $ subcache
Displays the information of the slave cache currently loaded in the library cache.
461. V $ sysstat
Lists system statistics.
462. V $ system_cursor_cache
System range information.
463. V $ system_event
Contains all the information waiting for an event.
464. V $ system_parameter
Contains system parameter information.
465. V $ system_parameter2
The currently affected parameters and parameter values in the Oracle instance.
466. V $ tablespace
Information about the tablespace in the control file.
467. V $ temp_cache_transfer
Displays the number of probe blocks in each data file.
468. V $ temp_extent_map
Displays the status information of each unit in all temporary tablespaces.
469. V $ temp_extent_pool
Displays the cache status of the temporary space used by a given instance.
470. V $ temp_ping
Displays the number of data exploring blocks for each data file.
471. V $ temp_space_header
Displays the aggregation information of each file in each temporary tablespace, involving the number of currently used spaces in each space header.
And the number of free spaces.
472. V $ tempfile
Displays information about temporary files.
473. V $ temporary_lobs
Display temporary lob.
474. V $ tempstat
Contains the statistics of file read/write.
475. V $ thread
Contains the thread information in the control file.
476. V $ Timer
Lists the elapsed time in 1% seconds.
477. V $ timezone_names
Lists valid time zone names.
478. V $ transaction
List active transactions in the system.
479. V $ transaction_enqueue
Displays the locks owned by the transaction status object.
480. V $ type_size
Lists the sizes of different database components to estimate the size of data blocks.
481. V $ undostat
Displays historical statistics to show how the system works.
482. V $ version
Lists the version numbers of the core library components on the Oracle server.
483. V $ vpd_policy
Lists All security policies related to the current cursor in the database cache.
484. V $ waitstat
List block competition statistics
9i data dictionary DBA View
485. dba_2pc_neighbors
Contains the inbound or outbound connection information for pending transactions.
486. dba_all_tables
Displays the descriptions of all tables in the database.
487. dba_application_roles
All roles with function-defined verification policies.
488. dba_associations
Displays user-defined statistics.
489. dba_audit_exists
Lists audit trails generated by audit not exists and audit exists.
490. dba_audit_object
Audit Trail records of all objects in the system.
491. dba_audit_session
Lists All audit trails for connect and disconnect.
492. dba_audit_statement
Lists audit trail information about Grant, revoke, audit, noaudit, and alter system statements.
493. dba_audit_trail
Lists All audit trail entries.
494. dba_blockers
Lists All sessions that are waiting for a lock held by a session, but not themselves waiting for a lock.
495. dba_base_table_mviews
Describes all materialized views in the database.
496. dba_catalog
Lists All Database labels, views, synonyms, and sequences.
497. dba_clu_columns
Lists the ing from a column to a clustering column.
498. dba_cluster_hash_expressions
Lists All clustering hash functions.
499. dba_clusters
Contains the description of all aggregates in the database.
500. dba_col_comments
Annotations for columns of all tables and views.
501. dba_col_privs
Lists all the privileges granted to columns in the database.
502. dba_coll_types
Displays all named set types in the database.
503. dba_cons_columns
Information of accessible columns contained in the constraint definition.
504. dba_constraints
All table constraints.
505. dba_context
Information of all context namespaces.
506. dba_data_files
Database file information.
507. dba_db_links
All database links in the database.
508. dba_ddl_locks
All DDL locks held by the database.
509. dba_dependencies
Lists dependencies between objects.
510. dba_dim_attributes
Represents the relationship between dimension-level and feature-dependent columns.
511. dba_dim_join_key
Represents the connection between two dimensions.
512 dba_dim_level_key
Represents a dimension column.
513. dba_dim_levels
Represents a dimension.
514. dba_dimensions
Represents a dimension object.
515. dba_directories
Provides information about all objects in the database.
516. dba_dml_locks
Lists All DML locks in the database and pending requests to a DML lock.
517. dba_errors
The current error that lists all stored objects in the database.
518. dba_exp_files
Contains information about the exported file.
519. dba_exp_objects
Lists the objects exported in incremental mode.
520. dba_exp_version
Contains the version number of the last exported session.
521. dba_extents
Lists information about all segments in a database.
522. dba_external_tables
Describes all external tables in the database.
523. dba_free_space
Lists free partitions in all tablespaces.
524. dba_free_space_coalesced
Contains the statistical data of the merged space in the tablespace.
525. dba_histograms
Synonym for dba_tab_histograms.
526. dba_ind_columns
Description of the columns that are indexed in all tables and clusters.
527. dba_ind_expressions
Expressions that are included in all tables and function indexes in the cluster.
528. dba_ind_partitions
For each index partition, describe the partition information at the partition level, the storage parameters of the partition and the various types determined by analyze
Partition statistics.