RE: table reorganizations

From: Michael Thomas <mhthomas_at_yahoo.com>
Date: Wed, 07 Jan 2004 17:29:25 -0800
Message-ID: <F001.005DC06F.20040107172925@fatcity.com>

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" <Rajendra.Jamadagni_at_espn.com> 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: Rajendra.Jamadagni_at_espn.com
  >
  

  ---

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

Received on Wed Jan 07 2004 - 19:29:25 CST