V $ SGASTAT和V$ SGA是指什么?它们有关吗?
摘要:
视图V$SGA和V$SGASTAT的内容表明什么?有可能涉及这两个表的值吗?
应用范围:
信息:
视图V$SGA和V$SGASTAT的内容表明什么?它们有关系吗?
-----------------------------------------------------------------------------------------
仅在Oracle 7.x上
V$SGASTAT视图详细的显示系统全局区,视图V$SGA显示总的系统全局区。
例如:
svrmgrl> desc V$SGA;
Name Null? Type
------------------------------- -------- ----
NAME VARCHAR2(20)
VALUE NUMBER
svrmgrl> desc V$SGASTAT;
Name Null? Type
------------------------------- -------- ----
NAME VARCHAR2(26)
BYTES NUMBER
svrmgrl> select * from v$sga;
NAME VALUE
-------------------- ----------
Fixed Size 39816
Variable Size 16780848
Database Buffers 40960000
Redo Buffers 8192
AND
svrmgrl> select * from v$sgastat
NAME BYTES
-------------------------- ----------
free memory 6087756
miscellaneous 90396
fixed_sga 39816
db_block_buffers 40960000
log_buffer 8192
LCCMD SGA Table 13988
PLS non-lib hp 2096
kxfp buffer su 515576
node map 16384
table definiti 120
latch nowait fails or sle 10320
db_block_multiple_hashcha 540324
fixed allocation callback 512
kxfp subheap 29816
db_block_hash_buckets 3634584
SEQ S.O. 44500
enqueue_resources 66600
transaction_branches 70272
PL/SQL DIANA 260300
ktlbk state objects 131052
gc_* 73564
transactions 187776
enqueue_hash 11100
enqueue_locks 296036
dictionary cache 350336
event statistics 566040
distributed_transactions- 40632
character set memory 21456
messages 26368
library cache 673752
DML locks 10800
sql area 1877780
processes 278400
sessions 710220
db_files 13216
PL/SQL MPCODE 128776
为了得到两个表之间的关系,运行以下查询:
svrmgrl> select sum(bytes) from v$sgastat;
SUM(BYTES)
----------
57788856
svrmgrl> select sum(value) from v$sga;
SUM(VALUE)
----------
57788856
两个SELECT语句具有相同的值。
或者:
svrmgrl> select sum(bytes) from v$sgastat
where name != 'db_block_buffers' and name != 'fixed_sga' and
name != 'log_buffer';
would result in:
SUM(BYTES)
----------
16780848
The value of VARIABLE SIZE of the SGA