بسم الله الرحمن الرحيم
السلام عليكم سؤال:معرفت كل requetes
كامل اليوم في database
من , متى , كيف ....
شكرا

تم تعديل 15 أكتوبر 200817 سنة بواسطة zarzis

هل تقصد Queries ?
ارجو توضيح السؤال وشكرا

هل تقصد Queries ?
ارجو توضيح السؤال وشكرا

I try to create a "select" I would find all transactions (select, insert ,.....)
"SQL" executed in one session in particular!!
I tried with objects "v $ sqlarea, v $ session ,.........", but I can not.


And to this list and "Tunner" transactions in a session of a user.
In fact, it's just the link between a session and its operations that I can not do.

I can see a list of sessions (in v $ sessions and $ process v)
select sid SID, spid ORA_PID, process PGM_PID, s.USERNAME username,
substr (to_char (LOGON_TIME, 'DD / MM / YYYY HH24: MI: SS'), 1.22) connection_date
from v $ session s, v $ process where paddr p = addr order by connection_date
/

I can see a list of operations (in $ v v sqlarea or $ sqltext)
SQL_TEXT select from v $ sqlarea
/

there may be a table intermediary that would allow me to make this link?
or another technique?

وشكرا

حاول تجرب الكويري دى وقوللى على النتيجه

SELECT ٍT.SQL_TEXT FROM V$SQLTEXT T, V$SESSION S WHERE S.SID = 100 AND S.SQL_ADDRESS=T.ADDRESS ORDER BY T.PIECE

اتمنى اكون افدتك

حاول تجرب الكويري دى وقوللى على النتيجه

SELECT ٍT.SQL_TEXT FROM V$SQLTEXT T, V$SESSION S WHERE S.SID = 100 AND S.SQL_ADDRESS=T.ADDRESS ORDER BY T.PIECE

اتمنى اكون افدتك

No,it'not good
why you have put sid=100

هى دى اللى مزعلاك اوى اننا عملتها 100 ...ياسيدى خلليها انت Bind variable ...او بلاش خالص ..ممكن تحذف خالص اوبشن ال SID وتحط بداله USERNAME واكتب فيه zarzis و نفذها وشوف كميه الكود اللى عايز يتراجع اد ايه ؟ ..وعموما انا حبيت اساعدك

شكرا للمساعد ايها اخ..
هذا هو بيت القصيد !!!
لا ني اريد كامل يوزرنيم username ،لكامل اليوم ...

with this request I have all the lines that connect users with the same user oracle
and you can test
مع الشكر

ها هو الجواب

In v$session you have a link to the currently executed statement (SQL_ID), and the previously executed statements (PREV_SQL_ID) and you can link that to v$sql.

But you cannot have more because
- one session executes a lot of statements
- one statement is executed by a lot of sessions

So if you want the history, you need to activate tracing (sql_trace)

شكرا