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

Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL help for a beginner

Re: PL/SQL help for a beginner

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Fri, 20 Sep 2002 07:36:35 +0200
Message-ID: <amec6h$37i$2@ctb-nnrp2.saix.net>


steve wrote:

> I need to "hammer" on the database, causing tremendous amounts of I/O.
> I have one program that I submit about 30 processes of to a batch queue,
> and it does 50K inserts to the table (per process), but the machine is
> still loafing.

Try using full table scans (not using any indexes). This can be done via a hint in your SQL SELECT statement, e.g.
SELECT /*+ FULL(tablename) */ * FROM tablename

Use cartesian joins, e.g.
SELECT * FROM table1, table2, table3

Combine these with a CREATE TABLE AS SELECT.

In fact, being a newbie you have all the qualifications you need or hammering Oracle. :-)

--
Billy
Received on Fri Sep 20 2002 - 00:36:35 CDT

Original text of this message

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