how to check Sga_max_size

sql>show parameter Sga_max_size;

To check all the parameters

sql>select * from v$parameter;

Thanks
Naveen

Comments

Post a Comment

Popular posts from this blog

.net framework 4 has not been installed because hresult 0xc80003f3

.Net framework 4 has not been installed because HRESULT 0xc80003f3 Microsoft .Net Installation fails Installation failed with error code: (0xC80003F3) unable to install microsoft .net framework 4 win7 I just found a solution that worked and I will make it a little easier for those who need it. Now remove the  Microsoft  .Net Framework 1.0 and  .Net Framework 4.0 from control panel as well as using the .Net Frame Work clean up tool Restart the system. Create a batch file with the following and run it from a command prompt. *******Start File Below******** regsvr32 MSXML3.dll /s  net stop wuauserv  cd /d %windir%\SoftwareDistribution  rd /s /q DataStore  net start wuauserv regsvr32 softpub.dll regsvr32 mssip32.dll ******End File Above******* Go to services and stop the Windows Update service  Go to the Windows directory (default is c:\Windows) and rename the "SoftwareDistribution" folder to "SoftwareDistribution...
Read more