Help - Three Memory Questions

From: <kal121_at_yahoo.com>
Date: Wed, 05 May 1999 19:45:18 GMT
Message-ID: <7gq74e$4e7$1@nnrp1.deja.com>

First, is there a data dictionary view that allows you to see how much sort_area_size is being used by a given user? I've observed that sort_area_size isn't actually eaten up until a user starts doing sorts. It would be interesting to see the sort_area_size usage in real-time.

Second,
how much memory does Oracle8 Server program for Windows NT use? This is NOT including the SGA. I cannot seem to find an answer anywhere.

Third,
how much memory does each user session use? There's the pga and sort_area_size, but what else? How big is the pga - in general (my guess in around 500K?)

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed May 05 1999 - 14:45:18 CDT