Re: Extents, Index, Optimization Q's

Len wrote:
>
> I have a VB application that opens and accesses an Oracle DB.
> The routine iterates through records at glacial speeds.
>
> I indexed the 22 tables that are opened read and closed, that helped
> marginally.
> All tables have unique indexes, some one mentioned Primary indexing is
> more efficient, is that true?
>
> After only experiencing marginal improvements I tried reducing the
> extents on the tables, marginal improvement but nothing colossal.
>
> Does anyone have recommendations to improve the speed of my
> application by tweaking the way data is stored in the Oracle 8 DB?
>
> Thanking you in a advance,
> Len

Try

alter session set sql_trace = true;
select * from v$session_event;
(run app)
select * from v$session_event;

and check the deltas. You need to see what the problem is, before you can hope to solve it

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."