Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: want clarification from Oracle gurus regarding I/O
Yes I could enable the trace , but my point is what oracle do to process the UPDATE statement and how many time oracle have to go to the disk to read and write data blocks. I will appreciate If someone can explain me in brief this process .
thanks in advance.
suresh
In article <959197199.11125.0.pluto.d4ee154e_at_news.demon.nl>,
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
>
> <suresh_joshi_at_my-deja.com> schreef in berichtnieuws
> 8gh7go$o1m$1_at_nnrp1.deja.com...
> > Hi, I want to know that how many i/o oracle will do to update 5
rows as
> > result of the Update ... where ... ; statement.
> > assume that the row has 10 column , the row being update is part of
> > two indexes and oracle is using cost based optimzer and the blevel
of
> > the index is three and the db_block_size is 4k.
> >
> > I appreciate if someone give me exactly what oracle do process the
> > UPDATE request and how many i/o will happens because of that
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
> Just enable trace in your session (alter session set sql_trace = true)
> perform the update, disconnect, and you will know.
> Issues like this are explained in the Oracle Concepts Manual, and the
> purpose of this group is not to rewrite the concepts manual.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu May 25 2000 - 00:00:00 CDT