OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » query

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

query [message #254260]

Thu, 26 July 2007 05:46

spsbombay
Messages: 29
Registered: June 2007

Junior Member

Good afternoon,

1 query. i m using oracle 9i.
lets i have a table emp which has 1 million of data. And i m doing

select count(*) from emp;

lets this query takes 60 seconds to fetch the result.
Now from another window i am inserting a record in this table which takes 10 seconds. means insertion will be finished before count query.

Can i see the effect of insertion in my count query.

Regards,
Prashant

Report message to a moderator