did oracle keep all sql that have been executed? if so, in which table/view?
The man called Zorro
RTM ( About Shared Pool )
funky... "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail." "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
you can have look at v$sql and v$sqlarea views. -Raja
Originally posted by zainalj did oracle keep all sql that have been executed? if so, in which table/view? No, of course it does not.
Jurij Modic ASCII a stupid question, get a stupid ANSI 24 hours in a day .... 24 beer in a case .... coincidence?
Forum Rules