Recent content by dcookie

Okay, after chasing this down for a while, I've come up with the privileges necessary for each of the tabs in the session tool (10g R2): Main window: v_$session Cursors tab: v_$open_cursor SQL Text tab: v_$sqltext_with_newlines Statistics tab: v_$sesstat and v_$statname Locks tab: v_$lock It...

Can anyone tell me what sys tables/views I need access to in order to get the session browser tabs for cursors, sql text, etc. to populate correctly? I get the list of sessions correctly, but the tabs show ora-00942. Thanks. ----dale

Thanks Mike. I did notice that feature when I was looking for what I wanted ;-) I would make more use of it except I don't like storing passwords for certain instances. If I could do like TOAD (is that a cussword in this forum? Should I say "That other DB product" :D ) and save passwords on a...

I appreciate the reply. Okay, I think I see the problem. If I have multiple PSD windows open (and I've found the need to have as many as 6 going at a time), the last window closed appears to be the one that controls what is saved. That's one problem with requiring multiple PSD windows for...

Howdy. We just purchased PSD (defecting from TOAD). The one thing I really miss is the ability to open connections to multiple instances within a single invocation of PSD, and swap the connection for a particular window to any of the open sessions. For illustration, I would like to open a PSD...