Insert problem ( sqlarea)

From: Ajay Singh Rathore <ajaysr_at_hclinsys.com>
Date: Sat, 23 Jun 2001 00:34:27 -0700
Message-ID: <F001.0033501C.20010623003533@fatcity.com>

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_GETSfrom v$sqlarea ;
 

<FONT face=Arial

size=2>SQL_TEXT                                    


             ROWS_PROCESSED 

DISK_READS BUFFER_GETS
insert into event_bal_impacts_t (

percen             
16             


            

27            

     403t, product_obj_DB, product_obj_ID0,
product_obj_TYPE, product_obj_REV, rate_obj_DB, rate_obj_ID0, rate_obj_TYPE, rate_obj_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 Received on Sat Jun 23 2001 - 02:34:27 CDT