Toad World® Forums

Session Browser not working


#1

Hi

Session Browser works in 6.1.1 and I think in some of the previous Builds.
but not in the last build (1498)
gives: ORA-0094 (Table or view not found)

using SQL Monitor I found out that it uses GV$SESSION and not the V$SESSION and it’s not a RAC machine

Regards
Filipe

Message was edited by: Fsilva


#2

Hi Filipe,

Can you what version of Oracle DB you are using?

Thanks
Jeff


#3

Hi

I got that error with Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi (not a RAC node)
in the output console only appears
ORA-00942: tabela ou vista não existe
(it works with 6.1.1)

I think that is a bug due that it works with 6.1.1

I would suggest that when people do not have permissions to the session browser:

  1. the option is grayed
    or
  2. an explicit warning is given explaining what can be done to active it (or having that info in the help)

Regards
Filipe

Message was edited by: Fsilva


#4

Hi Filipe,

Is Session Browser doesn’t works in 6.2 at all or just in a particular tab? I cannot reproduce your problem in our environment. Can you send me the screen capture and the SQL that you captured in SQL Monitor. We will try to fix this problem in next release.

Btw, when people do not have permissions to the session browser, we will display a message “You don’t have privilege to access v$session” but you can still open Session Browser.

Thanks
Jeff


#5

sql monitor

Timestamp: 19:37:16.312
SELECT S.SchemaName,
S.UserName,
S.STATUS,
S.SERVER,
S.SID,
S.SERIAL#,
S.AUDSID,
S.OSUSER,
S.MACHINE,
S.TERMINAL,
UPPER (S.PROGRAM) PROGRAM,
S.TYPE,
S.PADDR,
S.TADDR,
S.LOGON_TIME,
S.MODULE,
S.ACTION,
S.CLIENT_INFO,
S.LAST_CALL_ET,
S.INST_ID
FROM GV$SESSION S
WHERE ( (S.USERNAME IS NOT NULL)
AND (NVL(s.osuser,‘x’) <> ‘SYSTEM’)
AND (S.TYPE <> ‘BACKGROUND’)
)
ORDER BY “PROGRAM”, OWNERID
Runtime error occurred: 942 (ORA-00942: tabela ou vista não existe)

regards
filipe
session browser.jpeg


#6

Hi Filipe,

The reason we changed from V$SESSION to GV$SESSION because there is a requirement to support RAC. And we implemented this change since April. Can you grant select privilege on GV$SESSION for this user?

Regards,
Jeff


#7

Hi Jeff

I thought soo (that why I mention it was not a rac machine)

trying to give that permission (grant select on GV$SESSION to …)
I got an ORA-02030

Any idea?
Thanks
Filipe

PS: in the console it would be nice to show the object name as it happend with V$SESSION.

Message was edited by: Fsilva


#8

Hi Filipe,

Can you try “grant select on gv_$session to USER”?

Regards,
Jeff


#9

Hi Jeff and Filipe,

I don’t think Oracle will enable user to perform GRANT operation on those dynaimc views. Since the user cannot get access to the gv$session, I guess it cannot get access to v$session either. Can you try a select from v$session to confirm this, Filipe?

In my mind, to get access to those views, we can only at least grant select any dictionary to user, or grant select any table to user when O7_DICTIONARY_ACCESSIBILITY is true.

hope this helps,
Vincent


#10

Hi guys, Jeff’s already right. Sorry I missed the underscore in his statement gv_$session.


#11

hi all

I could do
select * from v$session (it was working with 5.5)

jeff was right: grant select on gv_$session to was the solution
Session browser now works!

Maybe add that to the help/manual (or to the console, when error found?)

thanks
Filipe


#12

Hi Filipe,

We will make changes to display the message in the app in the next release, and we will add notes to the Releas Note in this release.

Thanks
Jeff