Home » SQL & PL/SQL » SQL & PL/SQL » query
query [message #254260] Thu, 26 July 2007 05:46 Go to next message
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.

Re: query [message #254267 is a reply to message #254260] Thu, 26 July 2007 06:11 Go to previous message
Michel Cadot
Messages: 65154
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
A statement is consistent with the time it begins.

Previous Topic: How to display output of pl/sql table?
Next Topic: Need help for locks related issue
Goto Forum:

Current Time: Wed Aug 23 07:05:00 CDT 2017

Total time taken to generate the page: 0.05142 seconds