Oracle - how to estimate the size of SGA????

GeekInterview.com > Interview Questions > Oracle

Go To First | Previous Question | Next Question

Oracle | Question 37 of 81

how to estimate the size of SGA????

Total Answers and Comments: 3

Last Update: March 05, 2007 Asked by: hasanvtu

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

November 28, 2006 02:49:37

srinivas

RE: how to estimate the size of SGA????

connect sys and execute this command

select * from v$sga;

Is this answer useful? Yes | No

December 01, 2006 00:56:06

rajatm2

Member Since: July 2006 Contribution: 2

RE: how to estimate the size of SGA????

connect sqlplus using sys or system or any user .

and type show sga

regards

Rajat

Is this answer useful? Yes | No

March 05, 2007 19:58:32

mani

RE: how to estimate the size of SGA????

connect as sysdba and type
select * from v$sgainfo;

Is this answer useful? Yes | No

User Name		Remember Me?
Password

Question Bank