Oracle Database Administrator

Saturday, February 22, 2020

Monitoring Memory Resize Operation Query


Select * from v$memory_target_advice order by memory_size ;

Select  component,oper_type,parameter,final_size,target_size from v$memory_resize_ops;
Posted by Oracle Database Administartor at 2/22/2020 09:43:00 AM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Oracle SGA & Memory Advisior

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

Oracle Database Administartor
View my complete profile

Blog Archive

  • ►  2026 (3)
    • ►  March (3)
  • ►  2025 (2)
    • ►  September (1)
    • ►  July (1)
  • ►  2022 (2)
    • ►  December (1)
    • ►  October (1)
  • ▼  2020 (12)
    • ►  December (2)
    • ▼  February (10)
      • Generating Explain Plan & Gather Statistics
      • Open Cursor Queries
      • Temp Related Queries
      • Undo Related Queries
      • Analyzing Operaing System Performance
      • AWR
      • PGA Queries
      • Monitoring Memory Resize Operation Query
      • Performance Queries
      • DataGuard Queries
Simple theme. Powered by Blogger.