oracle业务字典表关联,有那位高手介绍一下，常用的数据字典表字段的具体含义？及表之间的关联关系...

最新推荐文章于 2023-11-14 10:40:25 发布

weixin_39761481

最新推荐文章于 2023-11-14 10:40:25 发布

阅读量176

点赞数

文章标签： oracle业务字典表关联

最初由 wysfenghuo007 发布

[B]有那位高手介绍一下，常用的数据字典表字段的具体含义？及表之间的关联关系

譬如：v$latch,v$session_wait,v$process等等。谢谢 [/B]

as belows

V$LATCH shows aggregate latch statistics for both parent and child latches, grouped by latch name. Individual parent and child latch statistics are broken down in the views V$LATCH_PARENT and V$LATCH_CHILDREN.

Column Datatype Description

ADDR

RAW(4 | 8)

Address of the latch object

LATCH#

NUMBER

Latch number

LEVEL#

NUMBER

Latch level

NAME

VARCHAR2(64)

Latch name

GETS

NUMBER

Number of times the latch was requested in willing-to-wait mode

MISSES

NUMBER

Number of times the latch was requested in willing-to-wait mode and the requestor had to wait

SLEEPS

NUMBER

Number of times a willing-to-wait latch request resulted in a session sleeping while waiting for the latch

IMMEDIATE_GETS

NUMBER

Number of times a latch was requested in no-wait mode

IMMEDIATE_MISSES

NUMBER

Number of times a no-wait latch request did not succeed (that is, missed)

WAITERS_WOKEN

NUMBER

For some latches, the session releasing the latch posts a session waiting for the latch. This counts the number of times a waiting session was awakened.

WAITS_HOLDING_LATCH

NUMBER

Number of waits for the latch while the waiter was holding a different latch

SPIN_GETS

NUMBER

Willing-to-wait latch requests which missed the first try but succeeded while spinning

SLEEP[1 | 2 | 3]

NUMBER

Waits that slept 1 time through 3 times, respectively

SLEEP4

NUMBER

Waits that slept 4 or more times

SLEEP[5 | 6 | 7 | 8 | 9 | 10 | 11]

NUMBER

These columns are present for compatibility with previous releases of Oracle. No data is accumulated for these columns.

WAIT_TIME

NUMBER

Elapsed time spent waiting for the latch (in microseconds)

V$SESSION_WAIT

This view lists the resources or events for which active sessions are waiting.

The following are tuning considerations:

P1RAW, P2RAW, and P3RAW display the same values as the P1, P2, and P3 columns, except that the numbers are displayed in hexadecimal.

The WAIT_TIME column contains a value of -2 on platforms that do not support a fast timing mechanism. If you are running on one of these platforms and you want this column to reflect true wait times, you must set the TIMED_STATISTICS parameter to TRUE. Remember that doing this has a small negative effect on system performance.

In previous releases the WAIT_TIME column contained an arbitrarily large value instead of a negative value to indicate the platform did not have a fast timing mechanism.

The STATE column interprets the value of WAIT_TIME and describes the state of the current or most recent wait.