Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: db file sequential read [WAS:wait event puzzler]

Re: db file sequential read [WAS:wait event puzzler]

From: Jacques Kilchoer <>
Date: Thu, 12 Jun 2003 13:31:57 -0700
Message-ID: <>

> -----Original Message-----
> From: Senthil Kumar D [mailto:[EMAIL PROTECTED]
> I do agree with you. But some times we may need go beyond the scopes.
> For testing purpose we can do these kind of R&D's.
> Nothing wrong in this.
> -----Original Message-----
> Modifying data dictionary tables is definitely not a good idea and I
> am sure Oracle will not support this.

Actually you can save a lot of time by eliminating the middle-man and going straight to the data dictionary.

For example, you build a b-tree index but then decide later on that actually you meant to create a bitmap index?
update sys.ind$ set property = property + 16 where obj# = &index_object_id ;

That one procedure that keeps on giving you compilation errors? just
delete from sys.error$ where obj# = &procedure_object_id ; update sys.obj$ set status = 1 where obj# = &procedure_object_id ; All compilation errors easily fixed!

And moving a large table to a different tablespace can be SOOO time-consuming. Just
update$ set ts# = &new_tablespace_number ;

(Disclaimer: This suggestion is made for educational purposes only. Any resemblance to real persons, living or dead, is purely coincidental. Void where prohibited. Some assembly required. List each check separately by bank number. Batteries not included. Contents may settle during shipment. Use only as directed. No other warranty expressed or implied. Do not use while operating a motor vehicle or heavy equipment. Postage will be paid by addressee. Subject to CAB approval.

This is not an offer to sell securities. Apply only to affected area. May be too intense for some viewers. Do not stamp. Use other side for additional listings. For recreational use only. Do not disturb. All models over 18 years of age. If condition persists, consult your physician. No user-serviceable parts inside. Freshest if eaten before date on carton. Subject to change without notice. Times approximate. Simulated picture. No postage necessary if mailed in the United States. Breaking seal constitutes acceptance of agreement.

For off-road use only. As seen on TV. One size fits all. Many suitcases look alike. Contains a substantial amount of non-tobacco ingredients. Colors may, in time, fade. We have sent the forms which seem to be right for you. Slippery when wet. For office use only. Not affiliated with the American Red Cross. Drop in any mailbox. Edited for television. Keep cool; process promptly. Post office will not deliver without postage. List was current at time of printing.

Return to sender, no forwarding order on file, unable to forward. Not responsible for direct, indirect, incidental or consequential damages resulting from any defect, error or failure to perform. At participating locations only. Not the Beatles. Penalty for private use. See label for sequence. Substantial penalty for early withdrawal. Do not write below this line. Falling rocks. Lost ticket pays maximum rate. Your cancelled check is your receipt. Add toner.

Place stamp here. Avoid contact with skin. Sanitized for your protection. Be sure each item is properly endorsed. Sign here without admitting guilt. Slightly higher west of the Mississippi. Employees and their families are not eligible. Beware of dog. Contestants have been briefed on some questions before the show. Limited time offer, call now to insure prompt delivery. You must be present to win. No passes accepted for this engagement.

No purchase necessary. Processed at location stamped in code at top of carton. Shading within a garment may occur. Use only in well-ventilated area. Keep away from fire or flame. Replace with same type. Approved for veterans. Booths for two or more. Check here if tax deductible. Some equipment shown is optional. Price does not include taxes. No Canadian coins. Not recommended for children. Prerecorded for this time zone. Reproduction strictly prohibited.

No solicitors. No alcohol, dogs or horses. No anchovies unless otherwise specified. Restaurant package, not for resale. List at least two alternate dates. First pull up, then pull down. Call toll free before digging. Driver does not carry cash. Some of the trademarks mentioned in this product appear for identification purposes only. Record additional transactions on back of previous stub. This supersedes all previous notices.)

Please see the official ORACLE-L FAQ:
Author: Jacques Kilchoer

Fat City Network Services    -- 858-538-5051
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).
Received on Thu Jun 12 2003 - 15:31:57 CDT

Original text of this message