SGA INFO

SQL> desc v$sgainfo
Name Null? Type
—————————————– ——– —————————-
NAME VARCHAR2(32)
BYTES NUMBER
RESIZEABLE VARCHAR2(3)

SQL>select * from v$sgainfo;

NAME BYTES RESIZEABLE
——————————– ———- —
Fixed SGA Size 2073128 No
Redo Buffers 31477760 No
Buffer Cache Size 1962934272 Yes
Shared Pool Size 788529152 Yes
Large Pool Size 33554432 Yes
Java Pool Size 16777216 Yes
Streams Pool Size 50331648 Yes
Granule Size 16777216 No
Maximum SGA Size 3456106496 No
Startup overhead in Shared Pool 117440512 No
Free SGA Memory Available 570425344

11 rows selected.

Advertisements

One Response

  1. very good content on your site. can you send me your e-mail to get support. i am hang with an issue.

    thanks

    Farhan

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: