What view permissions required for Sessions tool?

[Stew Stryker]

Whenever I use the Sessions tool with any default queries, the Cursors and SQL Text tabs at the bottom always show:

ORA-00942: table or view does not exist

Can someone tell me what dictionary views this is using for these? I can see Statistics and Locks fine.

Thanks,

Stew

 

[Roeland]

Stew,

If you go to the Sessions -> "Define Session Queries..." (at the top of your sessions window) you can check it yourself.

Roeland

 

[Stew Stryker]

Roeland,

Thanks for the speedy response. I tried that, but it only shows it's using v$session, which I definitely have access to. I can see all the sessions in the list view above.

I was expecting that the tab windows below use a different set of tables, which is where I see the error I reported.

Thanks anyway,

Stew

 

[William Robertson]

You can check the detail queries yourself as well :wink:

I'd check them myself but I rewrote all mine ages ago - I have about 40.

 

[Stew Stryker]

William,

Thanks for pointing that out! I totally missed seeing the Details tab in the setup window.

Roeland, my apologies for not realizing you were pointing it me in the right direction.

Stew

 

[Roeland]

Stew,

No prob. I should have pointed better. I thought it was obvious though.

Roeland

 

[Stew Stryker]

Not to someone the most-casual observer, which would be me at that moment! :-(