FYI: dbassist

        Hi, fellow DBA,

        Not to start holy war, but this may be a good lesson to learn, how GUIs may make DBA's life easier. Recently, I decided to use dbassist to create new database - configure everything, save scripts and run. Upon a time a noticed - SYSTEM is unusually large and growing fast.

        Investigation revealed the root of the problem - SYSTEM had minimal extent size set to 640K, this mean, any expanding system object took at least 640k for the nest extent, even if NEXT is set to 10k - 630 K wasted !

        After I revised database creation scripts, and found the following lines in the <SID>run1.sh (generated by dbassist)

<SCRIPT>
@/u01/app/oracle/product/8.1.6/rdbms/admin/catalog.sql; REM ********** ALTER SYSTEM TABLESPACE ********* ALTER TABLESPACE SYSTEM
DEFAULT STORAGE ( INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 50);
ALTER TABLESPACE SYSTEM
 MINIMUM EXTENT 640K;
</SCRIPT>

        The last line silently did space management optimization for me! In GUI this value (640K) is NEXT allocation for autoextend option, and mast look like

 AUTOEXTEND ON NEXT 1280K,  MINIMUM EXTENT never referenced in GUI.

        I dont argue, in some cases fragmented free space may be an issue, (still have serious doubts about it), but otherwise i've got SYSTEM 500M+ for really small DB.         

        Did I miss sometihing from Installation Guide?

	Vadim Gorbounov, 
	Oracle DBA

-----Original Message-----
From: Helmut Daiminger [mailto:hdaiminger_at_vivonet.com] Sent: Wednesday, January 24, 2001 4:15 PM To: Multiple recipients of list ORACLE-L Subject: RE: Rational Rose reverse engineering

Hi!

We had the same problem, but I have got it working fine now, so there is hope.

We did two things that solved it:

1. make sure that the owner of the schema you are trying to RE has full privileges
2. upgrade to Rose 2001, check Rational website; there seemed to be major problems with 2000.

We are running Rose on Win2k.

hth,
Helmut

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Ajay
> Khandelwal
> Sent: Wednesday, January 24, 2001 10:51 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Rational Rose reverse engineering
>
>
> Hi All,
> Did any of you tried Reverse engineering(data model) feature
> of Rational
> Rose successfuly ? I am facing a problem here , it gets
> hanged while trying
> to reverse engineer database.
> Database is oracle 8.1.6 and
> Rose is Rose 2000e.
> Is it a bug or ..
>
> TIA
> -Ajay
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ajay Khandelwal
> INET: ajay_at_tems.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Helmut Daiminger
  INET: hdaiminger_at_vivonet.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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