Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How can find the schema name

654192May 5 2009 — edited May 5 2009
Hi,

I just want to know,

based on the sql statements in v$sql, want to know the schema from which the queries are being executed.

and one more thing,

one sql procedure/function got failed from the application , I want to know from which schema it got failed and the time when it got failed?

RR
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 2 2009
Added on May 5 2009
5 comments
643 views