Oracle
Oracle Common Fool question 1000 question (viii)
Author: ccbzzp
There are a lot of simple questions that you might encounter with Oracle, especially for beginners, today I simply put it all together and send it to everyone, hoping to help!
9I-managed v$ view.
281. v$access
Displays the objects in the currently locked database and the session in which they are being accessed.
282. V$active_instances
Establishes a mapping from the instance name to the instance number for all instances that appear in the currently installed database.
283. v$active_sess_pool_mth
All active session pool resource allocation methods.
284. V$aq
The statistics for the queues in the current database.
285. v$archive
The information in the Redo log file required for archiving.
286. V$archive_dest
All archived log destination files for the current instance and their current values, patterns, status.
287. v$archive_processes
Provides information about different arch process states for an instance.
V$archive_log.
Control archived log information in the file.
289. V$backup
The backup status of all online data files.
290. V$backup_async_io
Displays information about the backup set from the control file.
291. V$backup_corruption
Displays information about the corruption in the data file backup from the control file.
292. V$backup_datafile
Displays information about the backup data file and the backup control file from the control file.
293. V$backup_device
Displays information about supporting backup devices.
294. v$backup_piece
Displays information about the backup block from the control file.
295. V$backup_redolog
Displays information about the archived logs in the backup set from the control file.
296. V$backup_set
Displays information about the backup set from the control file.
297. V$backup_sync_io
Displays information about the backup set from the control file.
298. v$bgprocess
Describes the background process.
299. V$BH
is the 9I real-time application cluster view. Gives the state and the number of probes for each buffer in the system global zone.
v$bsp.
Displays statistics that are used on a block server background process in the cache.
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 for each block in the SGA of the current instance.
304. V$cache_lock
Contains the header information for each block in the SGA of the current instance. Very similar to V$cache,
In addition to the Special Envoy platform lock manager identity symbol is different.
305. V$cache_transfer
In addition to the information that only shows those blocks that have been probed at least once, the V$cache function is the same.
306. V$circuit
Contains information about the virtual circuit, which is all the connections that the user has to the database through the scheduler and the server.
307. v$class_ping
Displays the number of probed blocks in each block class.
308. v$compatibility
Displays the features used by the database instance to prevent the database from returning to an earlier version.
309. V$compatseg
Displays the persistent features used by database instances to prevent the database from being returned to an earlier version.
310. V$context
Lists the settings properties for the current dialog.
311. V$controlfile
Lists the name of the control file.
312. v$controlfile_record_section
Displays information about the control file Records section.
313. V$copy_corruption
Displays information about corrupted data files in the control file.
V$cr_block_server.
Displays statistics that are used on a block server background process in the cache.
315. V$database
Contains information about the database in the control file.
316. V$datafile
Contains information about the database files in the control file.
317. V$datafile_copy
Contains information about a copy of the database file in the control file.
318. V$datafile_header
Displays data file information for the header of the data file.
319. V$db_cache_advice
Estimates the number of physical reads based on the size of the cache.
V$db_object_cache.
The database object that is cached in the library cache.
321. V$db_pipes
Displays the pipe currently depicted by the shared pool in the instance.
322. V$dbfile
Lists all the data files that make up the database.
323. V$dblink
All database connections opened by the query session.
324. V$deleted_object
Displays the deleted archive log in the control file.
325. V$dispatcher
Provides information about the scheduling process.
326. V$dispatcher_rate
Provide high quality delivery rate statistics for the scheduling process.
327. V$dlm_all_locks
Lists information for 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.
V$dlm_latch.
It is outdated, see V$latch
331. V$dlm_locks
These are lock information known to the lock manager that is blocked or blocked by other objects.
332. V$dlm_misc
Displays a variety of DLM statistics.
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 queued object.
336. V$event_name
Contains information about the wait event.
337. V$execution
Displays information in parallel execution.
338. v$false_ping
You may get a buffer to probe for failure.
339. V$fast_start_servers
Information for all dependent operations that perform a parallel operation transaction recovery.
V$fast_start_transactions.
The transaction progress information in the recovery.
341. V$file_cache_transfer
Displays the number of blocks probed in each data file.
342. v$file_ping
Displays the number of blocks per data file being probed.
343. V$filestat
Contains file information about read/write statistics.
344. v$fixed_table
Displays all dynamic performance tables and views and exported tables in the database.
345. v$fixed_view_definition
Shows the definition of all fixed views.
346. V$gc_elements_with_collisions
You can find a lock that protects multiple caches.
347. V$ges_blocking_enqueue
These are lock information known to the lock manager that is blocked or blocked by other objects.
348. v$ges_convert_local
The time consumed by the local lock conversion operation.
349. V$ges_convert_remote
The time consumed by the remote lock conversion operation.
V$ges_enqueue.
Displays all locks known to the current lock administrator.
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
Displays a variety of DLM statistics.
354. V$global_blocked_locks
Displays the global block lock.
355. v$global_transaction
Displays information for the currently active global transaction.
356. V$hs_agent
Identifies the collection of HS agents that are currently running on a given host.
357. v$hs_session
The set of HS sessions opened by the Oracle server.
358. V$indexed_fixed_column
Displays the columns in the Dynamic Performance table indexed (x$ table).
359. V$instance
Displays the status of the current instance.
360. V$instance_recovery
A restriction mechanism used to monitor the execution of user-specified recovery read times.
361. V$latch
Lists statistics for non-parental simple locks.
362. V$latch_children
Statistics about the child simple lock.
363. v$latch_misses
An attempt was made to obtain a simple lock failure statistic.
364. v$latch_parent
Contains statistics about simple parental locks.
365. V$latchholder
Information for the current simple lock holder.
366. V$latchname
Contains information about the decoding simple lock name of a simple lock displayed in V$latch.
367. V$librarycache
Statistics about cache performance and activity.
368. V$license
Information about the license limit.
369. V$loadcstat
Contains the Sql*loader statistics compiled during a direct load execution.
370. V$lock
The lock held by the current Oracle.
371. v$lock_activity
Displays the DLM lock operation activity for the current instance.
372. v$lock_element
Each PCM lock used in the cache has an entry in the v$lock_elements.
373. V$locked_object
Lists all locks acquired by each transaction.
374. V$lock_with_collisions
You can query for a lock that protects multiple buffers.
375. V$log
Control information about the log file in the file.
376. V$log_history
Controls the history of log files in a file.
377. V$logfile
Contains information about the redo log file.
378. V$loghist
Control log history information for log files in the file.
379. v$logmnr_contents
Log history information.
380. v$logmnr_dictionary
Log history information.
381. V$logmnr_logs
Log information.
382. V$logmnr_parameters
Log information.
383. V$mts
Contains information about servers that regulate multithreading.
384. V$mystat
The statistics for the current session.
385. V$nls_parameters
Current NLS parameter information.
386. v$nls_valid_values
Lists the valid values for all NLS parameters.
387. v$object_dependency
The ability to determine which object is dependent on a package, procedure, or cursor that is currently mounted in a shared pool.
388. V$object_usage
To monitor the use of indexes.
389. V$obsolete_parameter
Lists the stale parameters.
390. V$offine_range
Displays offline information about the data files in the control file.
391. V$open_cursor
Lists the currently open and parsed cursors for each session.
392. v$option
Lists the status of the Oracle service installation.
393. v$parallel_degree_limit_mth
Shows how all valid parallelism limits the allocation of resources.
394. V$parameter
Lists information about initialization parameters.
395. V$parameter2
Lists the parameters and parameter values that currently affect the session.
396. V$pgastat
Lists Oracle memory usage statistics.
397. v$ping
The same as V$cache.
398. V$pq_sesstat
Lists statistics for parallel query sessions.
399. V$pq_slave
The statistics of the server are executed in parallel for each activity on an instance.
V$pq_sysstat
Lists the statistics for the system for parallel queries.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.