Steps for SGA:
Option 1: By using SQLPlus,
Execute SQL Command: show sga (sample show ~4GB for SGA)
Option 2: TCODE: DBACOCKPIT
Tcode: DBACOCKPIT -> Performance -> Statistical information -> SGA Monitor -> SGA tab
Steps for PGA:
Tcode: DBACOCKPIT -> Performance -> Statistical information -> PGA Monitor -> PGA Status tab (Parameter: Total PGA allocated)
No comments:
Post a Comment