Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Memory taken by s session

Memory taken by s session

From: Hussain Ahmed Qadri <hussain_at_skm.org.pk>
Date: Sat, 22 Mar 2003 13:15:16 +0500
Message-Id: <24738.322764@fatcity.com>


This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C2F04B.2BBDFD00
Content-Type: text/plain;

        charset="iso-8859-1"

Hi all,

Can anyone tell me what is the memory any session takes when it logs on to the database? That's is, when a person opens a SQL plus window, how much memory is allocated to that session (just opening it and then the session is idle). And when he performs certain query, which returns over a few thousand records or more, what is the effect on the memory usage of that session. Any guidelines perhaps?

Regards,

DBA
SKMCH&RC ------_=_NextPart_001_01C2F04B.2BBDFD00
Content-Type: text/html;

        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>Memory taken by s session</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2>Hi all,</FONT>
</P>

<P><FONT SIZE=3D2>Can anyone tell me what is the memory any session =
takes when it logs on to the database? That's is, when a person opens a = SQL plus window, how much memory is allocated to that session (just = opening it and then the session is idle). And when he performs certain = query, which returns over a few thousand records or more, what is the = effect on the memory usage of that session. Any guidelines = perhaps?</FONT></P>

<P><FONT SIZE=3D2>Regards,</FONT>
</P>

<P><FONT SIZE=3D2>DBA</FONT>
<BR><FONT SIZE=3D2>SKMCH&amp;RC</FONT>
</P>

</BODY>
Received on Sat Mar 22 2003 - 02:15:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US