Oracle faq one thousand [301 to 400]

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 the header information of each block in the SGA of the current instance.
304. V $ CACHE_LOCK
Contains the header information of each block in the SGA of the current instance. It is very similar to V $ CACHE,
Except for the identity symbols of the Special Envoy platform lock manager.
305. V $ CACHE_TRANSFER
The function is the same as that of V $ CACHE except that the information of the blocks that have been probe at least once is displayed.
306. V $ CIRCUIT
Contains information about virtual circuits. It refers to all connections from the user to the database through the scheduler and server.
307. V $ CLASS_PING
Displays the number of probe blocks in each block class.
308. V $ COMPATIBILITY
Displaying the features used by the database instance can prevent the database from returning to earlier versions.
309. V $ COMPATSEG
Display the permanent features used by the database instance to prevent the database from returning to earlier versions.
310. V $ CONTEXT
Lists the setting attributes of the current dialog.
311. V $ CONTROLFILE
Lists the names of control files.
312. V $ CONTROLFILE_RECORD_SECTION
Displays information about the control file record.
313. V $ copy_partition uption
Displays corrupted data files in the control file.
314. V $ CR_BLOCK_SERVER
Displays the statistical information used in the background process of the cache block server.
315. V $ DATABASE
Contains the database information in the control file.
316. V $ DATAFILE
Contains information about the database files in the control file.
317. V $ DATAFILE_COPY
Contains the database file copy information in the control file.
318. V $ DATAFILE_HEADER
Displays the data file information in the data file header.
319. V $ DB_CACHE_ADVICE
The number of physical reads is estimated based on the cache size.
320. V $ DB_OBJECT_CACHE
Database objects cached in the database cache.
321. V $ DB_PIPES
Displays the pipeline currently depicted by the shared pool in the instance.
322. V $ DBFILE
Lists All data files that make up a database.
323. V $ DBLINK
Query all database connections opened by a session.
324. V $ DELETED_OBJECT
Displays the deleted archived logs in the control file.
325. V $ DISPATCHER
Provides information about the scheduling process.
326. V $ DISPATCHER_RATE
Provides high-quality rate statistics for scheduling processes.
327. V $ DLM_ALL_LOCKS
Lists information about 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 the lock information known by the lock manager to be blocked or blocked by other objects.
332. V $ DLM_MISC
Multiple DLM statistics are displayed.
333. V $ DLM_RESS
Displays information about all resources known to the current lock manager.
334. V $ ENABLEDPRIVE
Displays the granted privileges.
335. V $ ENQUEUE_LOCK
Displays all locks owned by the queue object.
336. V $ EVENT_NAME
Contains information about the waiting event.
337. V $ EXECUTION
Displays information in parallel execution.
338. V $ FALSE_PING
The buffer zone that failed the probe may be obtained.
339. V $ FAST_START_SERVERS
Information about all slave operations that execute parallel operation transaction recovery.
340. V $ FAST_START_TRANSACTIONS
Transaction progress information in recovery.
341. V $ FILE_CACHE_TRANSFER
Displays the number of blocks explored in each data file.
342. V $ FILE_PING
Displays the number of blocks under exploration for each data file.
343. V $ FILESTAT
Contains the read/write statistics of the file.
344. V $ FIXED_TABLE
Displays all dynamic performance tables and views in the database and export tables.
345. V $ FIXED_VIEW_DEFINITION
Displays the definitions of all fixed views.
346. V $ GC_ELEMENTS_WITH_COLLISIONS
You can find the lock to protect multiple caches.
347. V $ GES_BLOCKING_ENQUEUE
These are the lock information known by the lock manager to be blocked or blocked by other objects.
348. V $ GES_CONVERT_LOCAL
Local lock Conversion

349. V $ GES_CONVERT_REMOTE
The time consumed by the remote lock conversion operation.
350. V $ GES_ENQUEUE
Displays all the locks that the current lock administrator knows.
351. V $ GES_LATCH
See V $ LATCH
352. V $ GES_RESOURCE
Displays information about all resources known to the current lock manager.
353. V $ GES_STATISTICS
Multiple DLM statistics are displayed.
354. V $ GLOBAL_BLOCKED_LOCKS
Displays the global block lock.
355. V $ GLOBAL_TRANSACTION
Displays information about the currently activated global transaction.
356. V $ HS_AGENT
Identifies the set of HS proxies currently running on a given host.
357. V $ HS_SESSION
The HS session set opened by the ORACLE server.
358. V $ INDEXED_FIXED_COLUMN
Displays the columns (X $ table) in the index-created dynamic performance table ).
359. V $ INSTANCE
Displays the status of the current instance.
360. V $ INSTANCE_RECOVERY
It is used to monitor and execute the user-specified limit on the number of restored reads.
361. V $ LATCH
List statistics for non-parent simple locks.
362. V $ LATCH_CHILDREN
The statistic of the sub-simple lock.
363. V $ LATCH_MISSES
Attempts to obtain a statistical statement for simple lock failures.
364. V $ LATCH_PARENT
Contains the statistics about the easy-to-use locks of both parents.
365. V $ LATCHHOLDER
Information of the owner of the current simple lock.
366. V $ LATCHNAME
Contains information about the names of simple locks displayed in V $ LATCH.
367. V $ LIBRARYCACHE
Statistics on high-speed cache performance and activity.
368. V $ LICENSE
License restriction information.
369. V $ LOADCSTAT
Contains the SQL * LOADER statistics compiled during direct loading and execution.
370. V $ LOCK
The current ORACLE lock.
371. V $ LOCK_ACTIVITY
Displays the DLM lock activity of the current instance.
372. V $ LOCK_ELEMENT
Each cached PCM lock has an entry in V $ LOCK_ELEMENTS.
373. V $ LOCKED_OBJECT
Lists all the locks obtained by each firm.
374. V $ LOCK_WITH_COLLISIONS
You can query the locks that protect multiple buffers.
375. V $ LOG
The information of log files in the control file.
376. V $ LOG_HISTORY
History of log files in control files.
377. V $ LOGFILE
Contains information about the redo log file.
378. V $ LOGHIST
The log history information of the log file in the control 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 about the server that adjusts multiple threads.
384. V $ MYSTAT
The statistics of the current session.
385. V $ NLS_PARAMETERS
The current NLS parameter information.
386. V $ NLS_VALID_VALUES
Lists the valid values of all NLS parameters.
387. V $ OBJECT_DEPENDENCY
You can determine which object to depend on by the package, process, or cursor currently loaded in the shared pool.
388. V $ OBJECT_USAGE
To monitor the use of indexes.
389. V $ OBSOLETE_PARAMETER
Lists obsolete parameters.
390. V $ OFFINE_RANGE
Displays the offline information of data files in the control file.
391. V $ OPEN_CURSOR
Lists the opened and parsed cursors of each session.
392. V $ OPTION
List the status of ORACLE service installation.
393. V $ PARALLEL_DEGREE_LIMIT_MTH
Display all valid methods for limiting Resource Allocation in concurrency.
394. V $ PARAMETER
Lists information about initialization parameters.
395. V $ PARAMETER2
Lists the parameters and parameter values that affect the current session.
396. V $ PGASTAT
Lists ORACLE memory usage statistics.
397. V $ PING
Same as V $ CACHE.
398. V $ PQ_SESSTAT
Lists the statistics of parallel queries.
399. V $ PQ_SLAVE
The statistics of the server that executes each activity in parallel on an instance.
400. V $ PQ_SYSSTAT
Lists the statistics of the parallel query system.