Auditing

[HideOut]

السلام عليكم

عندي طلب صغير وهو هل هناك طريقة الى اضافة الكمبيوتر نيم اللي صدر منه الترانزكشن الى الهوستريكال سيستم سواء من خلال sql or forms

my qustion is is there any way to add computer name that issued the transaction to the auditing table even from SQL or from Form bulder

thank you

[KhalidOCP]

there is a table called V$SESSION, it stores information about the current opened sessions , one of the columns is TERMINAL which store the computer name of the opened sessions, find a way to know the session ID (SID) and SERIAL# of ur session to know the TERMINAL name.

[HideOut]

thank you so much khalid but can you tell me if V$SESSION have the current SESSION or it is archiving for the session

from what i see i think it is currunt session but to be sure

[HideOut]

ONE MORE THING i had found this collumn SQL_ADDR at table V$SESSION can any one told me what this cullomn means coz i chick for my MAC address it is differ from what i got form this collumn can any one help me plz