Using iSQL*Plus, I like to run 'select * from dba_objects' as my 'TPC for dummies' test in the lab. Hehehe.
In isolation (LAN/DB), the query completes in just over 45 seconds, weighing in at a 250MB RAM IE session on W2K client. Agreed its not probably the type of thing to do in production, nor at work on the DB or LAN. Regards, Mike Thomas --- "Jamadagni, Rajendra" <[EMAIL PROTECTED]> wrote: > select * > from dba_objects > where object_id in (select obj# from sys.obj$ sample > (5)) > / > > ps: this is not a serious answer ... don't try this > on your production system. > Raj > -------------------------------------------------------------------------------- > Rajendra dot Jamadagni at nospamespn dot com > All Views expressed in this email are strictly > personal. > QOTD: Any clod can have facts, having an opinion is > an art ! > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Jamadagni, Rajendra > INET: [EMAIL PROTECTED] > __________________________________ Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Thomas INET: [EMAIL PROTECTED] 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: [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).