>
> Dear Ari Kaplan,
>
> I am a Cadet Systems Engineer in a Japanese company in Japan. I have
> just visited your interesting web page. I would like to know how to check
> the used memory resource in an Oracle Developer/2000 application.
Greetings from the USA. I haven't been to Japan since 1994 and miss it.
To find the memory usage, if you are on UNIX you can do "top" and
look at SIZE (which is the total) and RES (which is what resides in memory).
In the SQL / Oracle side, you can find out the memory with a few statements:
SELECT * FROM V$SGA;
will show the fixed size and variable size of memory, along with the database
buffers and redo buffers. You may also do:
SELECT * FROM V$SGASTAT;
to give you the size of over 30 portions of memory.
-Ari Kaplan
Independent Oracle DBA Consultant
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 125+ Oracle tips, visit my Web Page: <->
<-> <->
<-> www.arikaplan.com <->
<-> <->
<-> email: akaplan@interaccess.com <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
Back to Ari Kaplan's Home Page