Home » SQL & PL/SQL » SQL & PL/SQL » How identity gets maintained?
How identity gets maintained? [message #270269] Wed, 26 September 2007 06:24 Go to next message
gurumurthy4
Messages: 17
Registered: August 2007
Junior Member
Can anyone give any idea regarding this.....

Consider that there are ten applications using the same instance and the same table at the same time...... Each application also fires the query (resulting in the same execution plan and sql_id in v$sql)...

eg:

select count(*) from table1 where column1=:1;
let the value be 1
select count(*) from table1 where column1=:1;
let the value be 2

will refer to same entry in the v$sql...

I want to know how Oracle manages to identify each of this query and responds accordingly... I suppose that there should be something else that uniquely identifies each of these queires...

Re: How identity gets maintained? [message #270270 is a reply to message #270269] Wed, 26 September 2007 06:28 Go to previous messageGo to next message
gurumurthy4
Messages: 17
Registered: August 2007
Junior Member
Oracle may do it internally.... But I am trying to say How can we see that from the tables?
Re: How identity gets maintained? [message #270289 is a reply to message #270269] Wed, 26 September 2007 07:06 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is the same statement, there is only ONE occurrence of it in SGA.
You can see bind variables in the V$SQL_BIND% views.

Regards
Michel
Previous Topic: Count distinct values in column for >2 tables
Next Topic: No more data to read from socket
Goto Forum:
  


Current Time: Fri Dec 09 13:53:33 CST 2016

Total time taken to generate the page: 0.08563 seconds