Re: Insert problem ( sqlarea)

From: Ajay Singh Rathore <ajaysr_at_hclinsys.com>
Date: Sun, 24 Jun 2001 23:06:19 -0700
Message-ID: <F001.00335C90.20010624224520@fatcity.com>

Hi Anita,
 In my schema all tables have less than 100 columns.

Thanks,
Ajay Singh Rathore
HCL Infosystems Ltd

---

visit us at www.hclinsystems.com
----- Original Message -----
To: <ORACLE-L_at_fatcity.com>; <ajaysr_at_hclinsys.com> Sent: Saturday, June 23, 2001 8:16 PM

> Ajay,
>
> Do you have tables with more than 255 columns? Oracle
> handles tables with more than 255 columns using
> intra-block chaining. There was a bug where the
> "table fetch continued row" was incorrectly
> incremented when accessing those tables.
>
> HTH,
>
> -- Anita
>
> --- Ajay Singh Rathore <ajaysr_at_hclinsys.com> wrote:
> > Hi,
> > While using insert command on one of my table, In
> > V$SQLAREA I found below data for that table. Can
> > anybody help me why I am gettting this?
> >
> >
> > select
> > SQL_TEXT,ROWS_PROCESSED,DISK_READS,BUFFER_GETS
> > from v$sqlarea ;
> >
> > SQL_TEXT
> > ROWS_PROCESSED DISK_READS BUFFER_GETS
> > insert into event_bal_impacts_t ( percen
> > 16 27 403
> > t, product_obj_DB, product_obj_ID0, prod
> > uct_obj_TYPE, product_obj_REV, rate_obj_
> > DB, rate_obj_ID0, rate_obj_TYPE, rate_ob
> > j_REV, account_obj_DB, account_obj_ID0,
> > account_obj_TYPE, account_obj_REV, impac
> >
> > select * from v$sysstat where name like 'table%' ;
> >
> > STATISTIC# NAME
> > CLASS VALUE
> > ---------- ----------------------------------------
> > ---------- ----------
> > 143 table scans (short tables)
> > 64 379
> > 144 table scans (long tables)
> > 64 42
> > 145 table scans (rowid ranges)
> > 64 0
> > 146 table scans (cache partitions)
> > 64 0
> > 147 table scans (direct read)
> > 64 0
> > 148 table scan rows gotten
> > 64 3632937
> > 149 table scan blocks gotten
> > 64 36491
> > 150 table fetch by rowid
> > 64 463108
> > 151 table fetch continued row
> > 64 28
> >
> > 151 table fetch continued row SHOW VALUE 28 BUT
> > there is no-chaining in table(s).
> >
> > Thanks,
> > Ajay
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail
> http://personal.mail.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ajay Singh Rathore
  INET: ajaysr_at_hclinsys.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Mon Jun 25 2001 - 01:06:19 CDT