how is sql id set
This is a discussion on how is sql id set within the Oracle Miscellaneous forums, part of the Oracle Database category; --> 10.2.0.2 EE How is the sql id of any given sql statement set? I've found that several of our ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
05-16-2008, 02:41 PM
| ||||
| ||||
 Re: how is sql id set On May 14, 2:50*pm, Ben <balve...@gmail.com> wrote: > 10.2.0.2 EE > > How is the sql id of any given sql statement set? I've found that > several of our most frequent sql statements have the same sqlid even > after the instance is shut down and started back. It's a hash, and you could have the same SQL_ID for a given statement no matter when that hash is generated. David Fitzjarrell      |
 |
« ORA-04091 Question
|
it happened, lost database and recovery catalog. starting distasterrecovery research »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 08:27 AM.
