Oh geez... okay, you have GOT to read the manuals!!!!!!!!!!!!!
check out the SQL reference guide, specifically the "Create Database"
statement
<getting on soapbox>
This is why I so hate the damned GUI tools. If a DBA doesn't know how
to perform the same functions without the tools, what happens to them
when the tools are not there??
</getting off soapbox>
- Gavin D'mello <gavin_d_at_tis.co.in> wrote:
> Is it possible to create a database without using dbassist ?
>
> Gavin
>
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Saturday, December 15, 2001 5:25 PM
>
>
> > This is not outdated -- the Oracle queries against the data
> dictionary
> > tables are tuned for RULE and so analyzing the SYS tables wreaks
> havoc
> > in the database.
> >
> >
> > --- Amar Kumar Padhi <TS2017_at_emirates.com> wrote:
> > > My information on this may be a bit outdated. I had read it
> somewhere
> > > that
> > > statistics are not to be generated for SYS tables. Oracle will
> handle
> > > the
> > > dictionary information access, irrespective of the optimizer mode
> > > being
> > > used. The setting of the optimizer_mode should affect the
> application
> > > queries being generated for other schemas. So if you are using
> CBO,
> > > setting
> > > the Optimizer_mode to first_rows looks more applicable than doing
> an
> > > alter
> > > session every time. I am not able to comment on the poor
> performance
> > > when
> > > accessing the dict.
> > >
> > > rgds
> > > amar
> > >
> > > -----Original Message-----
> > > Sent: Friday, December 14, 2001 11:00 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > FYI,
> > >
> > > I just logged a call with Oracle re. Designer 6.0 vs.
> > > all_cons_columns.
> > >
> > > A developer noticed that whenever he queries that data dictionary
> > > table as
> > > part of generating database from server models, the process slows
> > > down to a
> > > crawl.
> > >
> > > If the target doesn't have any constraints, no problem.
> > >
> > > I am starting to wonder if it isn't because FIRST_ROWS was
> specified
> > > on this
> > > database, most of the developers are developing forms (6i) so I
> set
> > > the
> > > init.ora parameter accordingly.
> > >
> > > The Oracle documentation however implies that the CBO only
> switches
> > > to rule
> > > when there are no stats if optimizer_mode had been set to CHOOSE,
> if
> > > it's
> > > either ALL_ROWS or FIRST_ROWS it tries to use the CBO against the
> > > data
> > > dictionary anyway. How the CBO can run when there are no stats
> > > probably
> > > means it defaults to full table scans (?).
> > >
> > > OPTIMIZER_MODE = { all_rows | first_rows | rule | choose }
> > >
> > > The OPTIMIZER_MODE parameter specifies the approach and mode of
> the
> > > optimizer for your session.
> > >
> > >
> > > See Also: Oracle8i Concepts <../../server.817/a76965/toc.htm>
> and
> > > Oracle8i
> > > Performance Guide and Reference <../../server.817/a76992/toc.htm>
>
> > > for
> > > information on how to choose a goal for the cost-based approach
> based
> > > on the
> > > characteristics of your application
> > >
> > >
> > >
> > > * all_rows specifies the cost-based approach and optimizes for
> best
> > > throughput.
> > > * first_rows specifies the cost-based approach and optimizes for
> best
> > > response time.
> > > * rule specifies the rule-based approach. (The rule-based
> optimizer
> > > does not use function-based indexes.)
> > > * choose causes the optimizer to choose an optimization approach
> > > based
> > > on the presence of statistics in the data dictionary.
> > >
> > > Is this correct? If so, then I suppose I should set the init.ora
> > > parameter
> > > back to optimizer_mode=choose, and tell each developer to put an
> > > alter
> > > session statement on their clients to alter their sessions
> > > automatically to
> > > first_rows. The developer using designer will then be able to
> run it
> > > in a
> > > timely manner.
> > >
> > > Please tell me if my suspicion is correct.
> > >
> > > If correct, it begs the question: why are first_rows and
> all_rows
> > > available
> > > for the init.ora file???
> > >
> > > Regards,
> > > Patrice Boivin
> > > Systems Analyst (Oracle Certified DBA)
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Boivin, Patrice J
> > > INET: BoivinP_at_mar.dfo-mpo.gc.ca
> > >
> > > 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).
> > >
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Check out Yahoo! Shopping and Yahoo! Auctions for all of
> > your unique holiday gifts! Buy at http://shopping.yahoo.com
> > or bid at http://auctions.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Rachel Carmichael
> > INET: wisernet100_at_yahoo.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: Gavin D'mello
> INET: gavin_d_at_tis.co.in
>
> 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).
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at
http://shopping.yahoo.com
or bid at
http://auctions.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.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).
Received on Sat Dec 15 2001 - 11:54:15 CST