Oracle Common fool question 1000 Q (ix)

oracle| problem
Oracle Common fool question 1000 Q (ix)



Author: ccbzzp



9I-managed v$ view.

401. V$pq_tqstat

Contains statistics on parallel execution operations. Helps to measure imbalances in a query.

402. v$process

Contains information about the currently active process.

403. V$proxy_archivedlog

Contains descriptive information about archived log backup files with a new feature called a proxy replica.

404. V$proxy_datafile

Contains descriptive information about data files and control file backups with a new feature called a proxy replica.

405. V$pwfile_users

Lists the users who are granted SYSDBA and sysoper privileges.

406. v$px_process

Contains information for a session that is running a parallel operation.

407. V$px_process_sysstat

Contains information for a session that is running a parallel operation.

408. v$px_session

Contains information for a session that is running a parallel operation.

409. V$px_sesstat

Contains information for a session that is running a parallel operation.

410. V$queue

Contains information for multithreaded message queues.

411. v$queueing_mth

Displays all available query resource allocation methods.

412. V$recover_file

Displays the status of the file that requires media recovery.

413. V$recovery_file_status

Contains one row of information for each data file for each recovery command.

414. V$recovery_log

Lists information about archived logs that require media recovery to complete. This information is from V$log_history.

415. v$recovery_process

Can be used to track database recovery operations so that they do not terminate execution.

Also used to estimate the time required to complete this operation in the process.

416. V$recovery_status

Contains the statistics for the current recovery process.

417. v$reqdist

Lists the statistics for the histogram of the number of requests for the MTS scheduler.

418. V$reserved_words

Gives a list of keywords used by the Pl/sql compiler.

419. V$resource

Contains resource names and address information.

420. V$resource_limit

Displays information about the use of global resources for system resources.

421. V$rollname

Lists information for all online rollback segments.

422. V$rollstat

Contains the statistics for the rollback segment.

423. V$rowcache

Displays the statistics for the active data dictionary.

424. V$rowcache_parent

Displays information about all the parent objects in the data dictionary.

425. V$rowcache_subordinate

Displays information about dependent objects in the data dictionary.

426. V$rsrc_consumer_group

Displays the data associated with the current active resource consumer user group.

427. v$rsrc_consumer_group_cpu_mth

Displays the allocation method for all available resources for the resource Consumer user group.

428. V$rsrc_plan

Displays the name of all currently active resource scenarios.

429. v$rsrc_plan_cpu_mth

Displays all available CPU resource allocation methods for the resource scheme.

430. V$sess_io

Lists I/O statistics for each user session.

431. v$session

Lists the current session information for each session.

432. V$session_connect_info

Displays information about the network connection for the current session.

433. V$session_cursor_cache

Displays information about the cursor usage of the current session.

434. v$session_event

Lists information that a session is waiting for an event.

435. V$session_longops

Displays the status of a long-running operation.

436. V$session_object_cache

Displays the statistics for the object cache for the current user dialog on the local server.

437. v$session_wait

Lists the resources or events for the active session you are waiting for.

438. V$sesstat

Lists the number of user session statistics.

439. V$sga

Contains the president metering of the system global zone.

440. V$sgastat

Contains details about the system global area.

441. v$shared_pool_reserved

Lists 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 for debugging a shared server process.

444. V$sort_segment

Contains information about each of the sorted segments in a given instance.

445. V$spparameter

Lists the contents of the SPFile.

446. V$sql

Lists the statistics for the SQL shared area.

447. V$sql_bind_data

If the data is available on the server, it will have a different connection variable for each of the cursors that query this view's session.



Displays the actual connection data sent by the client.

448. V$sql_bind_metadata

Displays the connection metadata provided by the client for each of the different connection variables in each cursor owned by the session that queries this view.

449. V$sql_cursor

Displays the debug information for each cursor associated with the session in which this view is queried.

450. V$sql_plan

Contains execution plan information that mounts to each child cursor in the library cache.

451. V$sql_shared_cursor

Why a particular child cursor does not have a shared interpretation of the existing subquery.

452. V$sql_shared_memeory

Information about cursors for shared memory snapshots.

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 information about the Mithushi of the workspace currently allocated by the system.

456. V$sqlarea

Statistics that share SQL.

457. V$sqltext

Contains the SQL statement text that belongs to a shared SQL cursor in the SGA.

458. V$sqltext_with_newlines

You cannot use spaces instead of new line tabs, as with v$sqltext features.

459. V$statname

Displays the names of the codes for the statistics in the V$sesstat and V$systat tables.

460. V$subcache

Displays information about the dependent cache currently mounted in the library cache.

461. V$sysstat

Lists the system statistics.

462. V$system_cursor_cache

System-wide 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 value of the parameters and parameters that are currently affected in the Oracle instance.

466. V$tablespace

Control information about the tablespace in the 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 for each cell in all temporary tablespace spaces.

469. V$temp_extent_pool

Displays the state of the temporary space cache used by a given instance.

470. v$temp_ping

Displays the number of blocks that each data file probes.

471. V$temp_space_header

Displays the aggregation information for each file in each temporary tablespace, covering how much space is currently used in each space header and how many self



by Space.

472. V$tempfile

Displays information about the temporary file.

473. V$temporary_lobs

Displays a temporary lob.

474. V$tempstat

Contains statistical information for 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 the legal time zone names.

478. v$transaction

Lists the active transactions in the system.

479. V$transaction_enqueue

Displays the locks owned by the transaction state object.

V$type_size.

Lists the size of different database components to use to estimate the size of the data block.

481. V$undostat

Displays a historical statistic to show how the system works.

482. v$version

Lists the version numbers of the core library components in the Oracle server.

483. V$vpd_policy

Lists all the security policies associated with cursors currently in the library cache.

484. V$waitstat

Lists block competition statistics.



Cond...