To check PGA:
select * from v$sgainfo; select * from v$sgastat;
However it is unlikely that only checking/changing SGA/PGA settings you will solve your performance issue. As already said you need to use more advanced tools like AWR/Staspack or SQL/trace/TKPROF.
select * from v$pgastat;
938946 wrote:Dear xyz, if it were possible to answer these questions in a forum message, no-one would need to hire database administrators. A good starting point would be to complete your introductory training (the OCP curriculum) and only when you a are comfortable with that, move on to tuning.
can you please tell me,how can i tune SGA which includes
1)tuning of buffer cache,
2)tunning of shared pool,
3)tuning of library cache,
4)tuning of dictionary cache,
5)tunning the redo log buffer and
6) tuning the sort area.
what should be the minimum and maximum values of each? when to increase the size?
thanks and regards,