Hi,
Unrelated question : If the system tablespace is so big would it not hurt performance for queries to all_tables, v$session, dba_segments etc. In such a case : can tables like source$ be moved out of system tablespace and would it make sense. Thank You
Vladimir Begun <[EMAIL PROTECTED]> wrote:
Vladimir Begun <[EMAIL PROTECTED]> wrote:
Tell me about it. :)
Regards,
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
Tanel Poder wrote:
> Hi!
>
> The views are small part. There are over 150000 objects in whole database,
> of which over 22000 are packages. System TS is about 4GB. (source$ table is
> 1.2GB, total of IDL_ tables is also about 1.2G).
>
> Tanel.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vladimir Begun
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-! Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
