Oracle Common Fool question 1000 question (viii)

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.



Cond...