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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Should we stop analyzing?

Re: Should we stop analyzing?

From: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Mon, 12 Jan 2004 04:14:26 -0800
Message-ID: <F001.005DC6EE.20040112041426@fatcity.com>


And all the +RULE queries you listed, where data dictionary queries anyway (which is designed for RBO).

Tanel.

> [TG]: I can't even spell "10g", so I'll take your word for it...
>
> The OraApps 11i assertion did not sound right, so to verify I queried both
> the V$SQLAREA view as well as the STATSPACK repository (i.e.
STATS$SQLTEXT)
> on a rather busy OraApps 11.5.8 system running Financials, ERP,
HR/Payroll,
> Order Entry, and Inventory. The STATSPACK repository is only holding 14
> days worth of data; I keep it purged pretty tight to keep it below 1Gb in
> size...

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

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: 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 Mon Jan 12 2004 - 06:14:26 CST

Original text of this message

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