S. Studeny
Member²
Hi.
As DBA, I usually assist to our developers with multisession PL/SQL developer. Sometimes we found usefull to change or customize window title to include some of these :
gv$session.INST_ID,
gv$session.SID,
gv$session.SERIAL#,
gv$process.SOSID
gv$process.SPID / STID (for those who uses multiprocess/multithread Oracle feature)
gv$process.TRACEFILE
Developer then can pass preliminary info from windows title to DBA directly
Thanks.
Best Regards,
Stanislav
As DBA, I usually assist to our developers with multisession PL/SQL developer. Sometimes we found usefull to change or customize window title to include some of these :
gv$session.INST_ID,
gv$session.SID,
gv$session.SERIAL#,
gv$process.SOSID
gv$process.SPID / STID (for those who uses multiprocess/multithread Oracle feature)
gv$process.TRACEFILE
Developer then can pass preliminary info from windows title to DBA directly

Thanks.
Best Regards,
Stanislav