large pool usage
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: large pool usage

  1. #1
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322

    large pool usage

    1. I want to monitor the usage of large pool during backup and recovery processes and for I/O server processes. Which view can I use for monitoring the same?

    2. This is an excerpt from Oracle doc.
    "Configuring the large pool prevents RMAN from competing with other subsystems for the same memory. Recovery Manager (RMAN) uses the large pool for backup and restore when you set the DBWR_IO_SLAVES or BACKUP_TAPE_IO_SLAVES parameters to simulate asynchronous I/O. If neither of these parameters is enabled, then Oracle allocates backup buffers from local process memory rather than shared memory. Hence, the large pool is not used."

    My question is: Which is the local process memory being referred here? Is it PGA?
    lucky

  2. #2
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322
    any update on this?
    lucky

  3. #3
    Join Date
    Mar 2001
    Location
    India
    Posts
    57
    Check usage of large pool from v$sgastat dynamic view. Free space and allocated (used) space you can monitor large pool from same view.
    Thanks and Regards,
    Gitesh Trivedi
    Dbametrix Solutions
    Database DBA support

  4. #4
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    No, you can't.

    Check V$SGA_CURRENT_RESIZE_OPS for current SGA resize operations happening provided you have ASMM setup.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  5. #5
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322
    Thanks! It's of help.

    Would you be able to throw some light on the 2nd issue raised at the start of thread?
    lucky

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width