Please refer to dba_object_size view.
- Kirti
> -----Original Message-----
> From: Subhash Chandra Mudiraj N. [SMTP:nsub_at_sonata-software.com]
> Sent: Friday, October 20, 2000 2:59 AM
> To: ORACLE-L (E-mail)
> Cc: Lazy DBA (E-mail)
> Subject: Size of a package
>
> Hi DBA's
>
> Is there any way to find out the amount of space that a package will
> occupy
> in the shared buffer cache when it is loaded into SGA. This I want to know
> for pinning it in the shared area.
>
>
> thanks in advance
> subhash
>
> > ----------
> > From: Pramod Gudula[SMTP:Pramod.Gudula_at_colesmyer.com.au]
> > Sent: Thursday, October 19, 2000 10:11 PM
> > To: 'rmalladi_at_inteliant.com'; ORACLE-L (E-mail)
> > Cc: Lazy DBA (E-mail)
> > Subject: RE: Temp Tablespace - What is this 68.2502?
> >
> >
> > Hi Rama,
> >
> > If you are doing lot big sorting then Oracle server creates these below
> > temporary objects to sort records for given SQL. These sort objects get
> > created if your sort_area_size is not big enough to hold all the sort
> > records. But SMON should wake up periodically and clean these objects or
> > this should gets deleted after next restart database.
> >
> > Hope this helps.
> >
> >
> >
> >
> >
> > -----Original Message-----
> > From: Rama Malladi [mailto:rmalladi_at_inteliant.com]
> > Sent: Friday, October 20, 2000 1:29 PM
> > To: ORACLE-L (E-mail)
> > Cc: Lazy DBA (E-mail)
> > Subject: Temp Tablespace - What is this 68.2502?
> >
> > Hi,
> > My Temp Tablespace is taking up 2GB. It should not be that
> > high.. When I
> > issued the following Query, I got the following result... Do
> > you know what
> > this 68.2502 is? Where does it come from? I have no clue!
> >
> > select SEGMENT_NAME, TABLESPACE_NAME, SEGMENT_TYPE, BYTES
> > from dba_extents
> > where TABLESPACE_NAME='TEMP';
> >
> > SEGMENT_NAME TABLE SEGMENT_TYPE BYTES
> > ------------------------------ ----- ------------------
> > -------
> > ---
> > 68.2502 TEMP TEMPORARY
> > 5120000
> > 68.2502 TEMP TEMPORARY
> > 5120000
> > 68.2502 TEMP TEMPORARY
> > 5120000
> > 68.2502 TEMP TEMPORARY
> > 5120000
> > 68.2502 TEMP TEMPORARY
> > 5120000
> > 68.2502 TEMP TEMPORARY
> > 5120000
> > 68.2502 TEMP TEMPORARY
> > 5120000
> > 68.2502 TEMP TEMPORARY
> > 5120000
> > 68.2502 TEMP TEMPORARY
> > 5120000
> > 68.2502 TEMP TEMPORARY
> > 5120000
> > .....
> >
> > The list goes on like this
> > select SEGMENT_NAME, TABLESPACE_NAME, BYTES from
> > dba_segments where
> > TABLESPACE_NAME='TEMP';
> >
> > SEGMENT_NAME TABLESPACE_NAME BYTES
> > 68.2502 TEMP
> > 2073600000
> >
> > TIA
> > Rama
> >
> >
> > --------
> > Think you know someone who can answer the above question?
> > Forward it to them!
> > to unsubscribe, send a blank email to
> > oracledba-unsubscribe_at_LAZYDBA.com
> > to subscribe send a blank email to
> > oracledba-subscribe_at_LAZYDBA.com
> >
> > --------
> > Think you know someone who can answer the above question? Forward it to
> > them!
> > to unsubscribe, send a blank email to oracledba-unsubscribe_at_LAZYDBA.com
> > to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com
> >
>
> --------
> Think you know someone who can answer the above question? Forward it to
> them!
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_LAZYDBA.com
Received on Fri Oct 20 2000 - 08:41:59 CDT
