1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68
|
ConnectÚ Ó :
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
SQL> select name,value from v$sga ;
NAME VALUE
-------------------- ----------
Fixed Size 2179336
Variable Size 452988664
Database Buffers 264241152
Redo Buffers 11304960
SQL> desc v$sga ;
Nom NULL ? Type
----------------------------------------- -------- ----------------------------
NAME VARCHAR2(20)
VALUE NUMBER
SQL> select name,round(bytes/(1024*1024),1) size_mb,resizeable from v$sgainfo ;
NAME SIZE_MB RES
-------------------------------- ---------- ---
Fixed SGA Size 2,1 No
Redo Buffers 10,8 No
Buffer Cache Size 252 Yes
Shared Pool Size 412 Yes
Large Pool Size 4 Yes
Java Pool Size 12 Yes
Streams Pool Size 4 Yes
Shared IO Pool Size 0 Yes
Granule Size 4 No
Maximum SGA Size 696,9 No
Startup overhead in Shared Pool 136 No
NAME SIZE_MB RES
-------------------------------- ---------- ---
Free SGA Memory Available 0
12 ligne(s) sÚlectionnÚe(s).
SQL> select component,current_size/(1024*1024) current_mb from v$memory_dynamic_components ;
COMPONENT CURRENT_MB
---------------------------------------------------------------- ----------
shared pool 412
large pool 4
java pool 12
streams pool 4
SGA Target 700
DEFAULT buffer cache 252
KEEP buffer cache 0
RECYCLE buffer cache 0
DEFAULT 2K buffer cache 0
DEFAULT 4K buffer cache 0
DEFAULT 8K buffer cache 0
COMPONENT CURRENT_MB
---------------------------------------------------------------- ----------
DEFAULT 16K buffer cache 0
DEFAULT 32K buffer cache 0
Shared IO Pool 0
PGA Target 200
ASM Buffer Cache 0
16 ligne(s) sÚlectionnÚe(s).
SQL> |
Partager