Oracle FAQ 1000 (9th)

V$ view managed by 9i.

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 carry a new feature called a proxy copy.

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

Display 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

Lists the 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

Statistics containing rollback segments.

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

Display 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

Lists the statistics that 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 debugging information about the shared server process.

444. V $ sort_segment

Contains information about each sorting segment of a given instance.

445. V $ spparameter

List spfile content.

446. V $ SQL

Lists statistics of the SQL sharing zone.

447. V $ SQL _bind_data

If the data is available on the server, it will query each different connection variable in each cursor of the session that queries this view,

Displays the actual connection data sent by the client.

448. V $ SQL _bind_metadata

Display the connection metadata provided by the client for each connection variable in each cursor of the session that queries this view.

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

Identifies the redirected SQL statement.

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 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 translation 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 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 blocks under exploration for each data file.

471. V $ temp_space_header

Displays the aggregation information of each file in each temporary tablespace, involving the amount of space currently used in each space header and the amount of self-contained

By space.

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

Lists the 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 the security policies related to the current cursor in the database cache.

484. V $ waitstat

List the block competition statistics.