Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002
    Posts
    7

    Unanswered: easy way to check memory

    Is there an easy way to check how much memory has been given to oracle?

  2. #2
    Join Date
    Apr 2001
    Location
    Netherlands
    Posts
    191
    Select * from v$sga

    that gives the SGA-size

    You could also on Unix type:
    ipcs -mobs

    That will show the memory segment size, look for the user 'oracle'
    Ruud Schilders
    -----------------
    Oracle DBA
    e-mail : ruud@schilders.it
    URL : www.schilders.it
    Twitter : www.twitter.com/ruudschilders

Posting Permissions

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