# 6.1 Session browser **URL:** \ **Category:** SQL Navigator\ **Created:** [February 9, 2009, 4:32am UTC](https://forums.toadworld.com/t/6-1-session-browser/3663 "2009-02-09T04:32:44Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Andres](https://avatars.discourse-cdn.com/v4/letter/a/a4c791/32.png) [@Andres](https://forums.toadworld.com/u/Andres)\ **Post date:** [February 9, 2009, 4:32am UTC](https://forums.toadworld.com/t/6-1-session-browser/3663/1 "2009-02-09T04:32:44Z")
1. would it be possible to add three more columns from v$session - module, action, client\_info? These columns may contain very useful information… 2. when watching a sessions ‘current SQL’, it very often doesn’t contain a sql statement, but a plsql program, so that the explain plan fails and the output window gets soon filled with “Error in SQL: ORA-00905: missing keyword”. Maybe there is a flag somewhere whether the “current SQL” is plsql or sql, and not try to explain plsql… ---
**Author:** ![RadarAutomation](https://avatars.discourse-cdn.com/v4/letter/r/f0a364/32.png) [@RadarAutomation](https://forums.toadworld.com/u/RadarAutomation)\ **Post date:** [February 9, 2009, 6:59am UTC](https://forums.toadworld.com/t/6-1-session-browser/3663/2 "2009-02-09T06:59:01Z")
Hello, Regarding request 1) : I’d also like to have “last\_call\_et” - to be able to quickly identify stale/timed-out sessions. ---
**Author:** ![Fsilva](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/fsilva/32/39_2.png) [@Fsilva](https://forums.toadworld.com/u/Fsilva)\ **Post date:** [February 9, 2009, 12:44pm UTC](https://forums.toadworld.com/t/6-1-session-browser/3663/3 "2009-02-09T12:44:39Z")
I also agree with the request 1) ---
**Author:** ![jchan](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/jchan/32/34_2.png) [@jchan](https://forums.toadworld.com/u/jchan)\ **Post date:** [February 9, 2009, 8:53pm UTC](https://forums.toadworld.com/t/6-1-session-browser/3663/4 "2009-02-09T20:53:54Z")
Hi all, 1. In Session Browser, when you selected a session in the grid, in Session tab you should be able to see all the columns (module, action, client\_info and last\_call\_et), is that what you’re looking for? 2)Could you please provide more information and the steps for this problem? We use the following SQL statement to get current SQL. SELECT SQL\_TEXT FROM V$SQLTEXT\_WITH\_NEWLINES WHERE HASH\_VALUE = TO\_NUMBER(‘SQL\_HASH\_VALUE’) ORDER BY PIECE Also try to use SQL Monitor to capture the SQL when you get “Error inSQL: ORA-00905: missing keyword” and send back the captured SQLs. Regards, Jeff ---
**Author:** ![RadarAutomation](https://avatars.discourse-cdn.com/v4/letter/r/f0a364/32.png) [@RadarAutomation](https://forums.toadworld.com/u/RadarAutomation)\ **Post date:** [February 10, 2009, 4:08am UTC](https://forums.toadworld.com/t/6-1-session-browser/3663/5 "2009-02-10T04:08:29Z")
Hi, jchan, 1. Indeed, but we'd like to be able to view more columns in the top half of the session grid (above the tabs "Session", "Process", "IO",...) 2. I've attached a screenschot of a session with PL/SQL code, which triggers the ORA-00905 error in the explain plan pane. ![B45_01.png](https://global.discourse-cdn.com/quest/original/2X/a/afe7feb9986510b95fa48dd72dfcaaf627519a47.png) ---
**Author:** ![Andres](https://avatars.discourse-cdn.com/v4/letter/a/a4c791/32.png) [@Andres](https://forums.toadworld.com/u/Andres)\ **Post date:** [February 10, 2009, 4:27am UTC](https://forums.toadworld.com/t/6-1-session-browser/3663/6 "2009-02-10T04:27:38Z")
Hi, 1. yes, the info is there in the session tab, but i'd like to see it already in the report (so that it can be toggled with right-click -\> visible columns, like others) 2. see the picture - the active SQL/PLSQL of the selected session goes to position 1, the explain plan of the statement goes to position 2, error, when plan can't be shown, goes to position 3 (lack of rights for example). Also, the errors get logged to position 4. as you can see, it's a plsql call, so no explain plan possible. I can live with the error message in position 3, but can the error flood to position 4 be turned off (for at least ORA-00905)? And what i tried to ask was, not to perform explain plan at all when "current sql" is plsql. Not only to hide the error, but not to even try to generate one for plsql. Thanks, Andres ![sqlnav_61_sessbr.jpeg](https://global.discourse-cdn.com/quest/original/2X/1/1cf1930a990aa1729d2b8c3aa04ce94292fbdde4.jpeg) ---
**Author:** ![jchan](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/jchan/32/34_2.png) [@jchan](https://forums.toadworld.com/u/jchan)\ **Post date:** [February 10, 2009, 7:58pm UTC](https://forums.toadworld.com/t/6-1-session-browser/3663/7 "2009-02-10T19:58:25Z")
Hi Radar and Andres, Thank you very much for your feedback, I will add these two enhancement request in our future release. Except module, action, client\_info and last\_call\_et, what other column you think is useful? I will add them together in one ER.