| How identity gets maintained? [message #270269] |
Wed, 26 September 2007 06:24  |
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...
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
