Oracle common problem 1000 question complete set (5)

xiaoxiao2021-03-06  148

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.

转载请注明原文地址:https://www.9cbs.com/read-127671.html

New Post(0)