Oracle Common Questions 1000 Questions Complete Works (4)

xiaoxiao2021-03-06  143

301. V $ buffer_pool

Displays information about the instance buffer pool.

302. V $ buffer_pool_statistics

Displays information about the instance buffer pool.

303. V $ cache

Contains head information of each block in the SGA of the current instance.

304. V $ cache_lock

Contains head information of each block in the SGA of the current instance. And V $ cache is very similar,

Except for the special envoy the platform lock manager identifier.

305. V $ Cache_TRANSFER

In addition to only those blocks that are probed at least once, and the V $ cache function is the same.

306. V $ CIRCUIT

Contains information about the virtual circuit, is the user through the scheduler and server to all connections.

307. V $ Class_Ping

Displays the number of probed blocks in each block class.

308. V $ CompaTibility

Display the feature used by the database instance, prevent the database from going back to the early versions.

309. V $ compatseg

Displays the permanent feature used by the database instance, prevent the database from going back to the early versions.

310. V $ context

List the setting properties of the current dialog.

311. V $ ControlFile

List the name of the control file.

312. V $ controlfile_record_section

Displays information about the control file recording section.

313. V $ COPY_CORRUPTION

Display information of corruption in the control file.

314. V $ CR_BLOCK_SERVER

Displays statistics on the background process of the block server background in the cache.

315. V $ database

Contains information about the database in the control file.

316. V $ DataFile

Contains information about database files in the control file.

317. V $ datafile_copy

Contains information about the copy of the database file file in the control file.

318. V $ dataFile_Header

Displays data file information on the header of the data file.

319. V $ db_cache_advice

Estimate the amount of physical read according to the size of the cache.

320. V $ db_Object_cache

Caches the database object in the library cache.

321. V $ db_pipes

Displays the currently depicted pipes in the instance.

322. V $ dbfile

List all data files that make up the database.

323. V $ dblink

Query all database connections that sessions open.

324. V $ deleted_Object

The archive log is deleted in the display control file.

325. V $ dispatcher

Provide information about the schedule process.

326. V $ dispatcher_rate

Provide high quality providing rate statistics for the scheduling process.

327. V $ dlm_all_locks

List the information of all current locks.

328. V $ dlm_convert_local

The time consumed by the local lock conversion operation.

329. V $ dlm_convert_remote

The time consumed by the remote lock conversion operation.

330. V $ dlm_latch

It is Outdated, see V $ Latch

331. V $ DLM_LOCKS

These are locking messages that are blocked or block other objects known to the lock manager.

332. V $ dlm_misc

Display a variety of DLM statistics.

333. V $ DLM_RESS

Displays information about all resources known to the current lock manager.

334. V $ enabledprive

Display the granted privilege.

335. V $ enqueue_lock

Displays all locks owned by the queuing object.

336. V $ Event_Name

Contains information waiting for the event.

337. V $ execution

Displays information in parallel execution.

338. V $ false_ping

It is possible to get a buffer that the exploration failed.

339. V $ fast_start_servers

Perform information of all the subordinate operations recovered in parallel operations.

340. V $ fast_start_transactions

Transaction progress information in recovery.

341. V $ file_cache_transfer

Displays the number of blocks detected in each data file.

342. V $ file_ping

Display the number of blocks that each data file is proud. 343. V $ filestat

Contains files about read / write statistics.

344. V $ fixed_table

Display all dynamic performance tables and views and export tables in the database.

345. V $ fixed_view_definition

Displays the definition of all fixed views.

346. V $ GC_ELEMENTS_WITH_COLLISIONS

You can find a lock that protects more cache.

347. V $ GES_BLOCKING_ENQUEUE

These are locking messages that are blocked or block other objects known to the lock manager.

348. V $ GES_CONVERT_LOCAL

Local lock conversion operation

349. V $ GES_CONVERT_REMOTE

The time consumed by the remote lock conversion operation.

350. V $ GES_ENQUEUE

Displays all the locks you know by the current lock administrator.

351. V $ GES_LATCH

See also v $ latch

352. V $ GES_RESOURCE

Displays information about all resources known to the current lock manager.

353. V $ GES_STATISTICS

Display a variety of DLM statistics.

354. V $ global_blocked_locks

Display global block lock.

355. V $ global_transaction

Displays information about currently activated global transactions.

356. V $ HS_AGENT

Identify the collection of HS agents currently running on a given host.

357. V $ HS_SESSION

The Oracle server opens the HS session set.

358. V $ indexed_fixed_column

Displays the column in the dynamic performance table of the index (X $ table).

359. V $ INSTANCE

Displays the status of the current instance.

360. V $ INSTANCE_RECOVERY

Used to monitor the limit mechanism to perform the user to specify the number of times the recovery.

361. V $ latch

The statistic is collected for non-parental simple locks.

362. V $ latch_children

About the statistics of the subcontractic lock.

363. V $ latch_misses

Trying to get a statistic of a simple lock failure.

364. V $ latch_parent

Contains a statistic about the simple lock of the double pro.

365. V $ latchholder

The current simple lock holder's information.

366. V $ latchname

Contains information about the unlocking unlocking name of the simple lock in V $ latch.

367. V $ librarycache

Statistics on cache performance and activity.

368. V $ license

Information for license restrictions.

369. V $ loadCSTAT

Contains SQL * Loader statistics compiled during a direct load execution process.

370. V $ LOCK

The currently held by Oracle.

371. V $ LOCK_AACTIVITY

Displays the DLM lock operation activity of the current instance.

372. V $ LOCK_ELEMENT

Each PCM lock that is cached is an entry in V $ LOCK_ELEMENTS.

373. V $ locked_Object

List all locks obtained by each transaction.

374. V $ loc_with_collisions

You can query the lock of the multi-buffer.

375. V $ log

Control the information of the log file in the file.

376. V $ log_history

Control the historical information of the log file in the file.

377. V $ logfile

The information that contains redo log files.

378. V $ loghist

Control the log history information of the log file in the file.

379. V $ logmnr_contents

Log History.

380. V $ logmnr_dictionary

Log History.

381. V $ logmnr_logs

Log information.

382. V $ logmnr_parameters

Log information.

383. V $ MTS

Contains information of the server that adjusts multi-threaded servers.

384. V $ mystat

The statistic of the current session.

385. V $ NLS_PARAMETERS

Current NLS parameter information.

386. V $ NLS_VALID_VALUES

List all the valid values ​​for all NLS parameters.

387. V $ Object_Dependency

Can determine which object is determined by the package, process or cursor currently loaded in the shared pool. 388. V $ Object_USAGE

To monitor the use of the index.

389. V $ Obsolete_Parameter

List the old parameters.

390. V $ OFFINE_RANGE

Display offline information of the data file in the control file.

391. V $ OPEN_CURSOR

List the cursors of each session currently open and parsed.

392. V $ Option

List the status of Oracle service installation.

393. V $ parallel_degree_limit_mth

Show all effective ways to limit resource allocation.

394. V $ Parameter

List the information about initialization parameters.

395. V $ Parameter2

List the parameters and parameter values ​​that currently affect the session.

396. V $ pgastat

List Oracle Memory Use Statistics.

397. V $ ping

Like V $ Cache.

398. V $ PQ_SESSTAT

List the statistics for parallel query sessions.

399. V $ PQ_SLAVE

An instance of each active parallel execution server statistic.

400. V $ PQ_SYSSTAT

List the statistics of the system of parallel queries.

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

New Post(0)