RE: Indexing SYS tables

From: Inka Bezdziecka <IBezdziecka_at_cupe.ca>
Date: Tue, 01 Oct 2002 10:25:10 -0800
Message-ID: <F001.004DD9D0.20021001102510@fatcity.com>

Oracle Corporation has a peculiar habit of providing scripts and solutions which it does not support officially. One of them is moving sys.aud$ out of SYSTEM tablespace. See note 1019377.6 on MetaLink.

inka

-----Original Message-----

Sent: Tuesday, October 01, 2002 1:18 PM
To: Multiple recipients of list ORACLE-L

Rich,

I think you're crazy adding indexes SYS tables. I would *never* add anything to sys objects. What are you going to do the first time something goes wrong and you call Oracle support and you "mention" you added an index and they say - hey, you're on your own! Not to mention that when you perform an upgrade, that this index may either get lost or be in the way.

No, a totally bad idea.

If anything, I would copy the audit records to a local table in your schema, and then index that baby anyway I'd like. That way, the system objects are the way that Oracle inteneded them to be.

Just my 2 cents.

Tom Mercadante
Oracle Certified Professional

-----Original Message-----

Sent: Tuesday, October 01, 2002 11:28 AM To: Multiple recipients of list ORACLE-L

Hey,

Anyone have any advice on indexing SYS tables? Specifically, I've been experimenting with putting a reverse index on the TIMESTAMP# column of AUD$, since almost all of my queries against the AUD$ views end with "ORDER BY TIMESTAMP DESC". In 8.1.7.4.0 test DBs on HP/UX, the index -- created under a non-SYS DBA schema -- works great. I'm looking for pitfalls, but can't come up with any of my own...

TIA!
Rich

--

Rich Jesse                           System/Database Administrator
Rich.Jesse_at_qtiworld.com              Quad/Tech International, Sussex, WI USA

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.com

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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mercadante, Thomas F
  INET: NDATFM_at_labor.state.ny.us

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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Inka Bezdziecka
  INET: IBezdziecka_at_cupe.ca

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 Tue Oct 01 2002 - 13:25:10 CDT