Recent content by Paul F

  1. P

    Sluggish performance - queries Initializing

    Thanks Marco. I have been working with our DBAs. One suggestion was to remove (SERVER=SHARED) in our tnsnames.ora so it defaults to DEDICATED (or change the entry to SERVER=DEDICATED). Not sure this is helping a lot. The other thing they may try is to define more dispatchers and allowed...
  2. P

    Sluggish performance - queries Initializing

    Hi there..We recently moved our Oracle DB to an 11g 2 node RAC. We were previously on the same configuration, but just moved to new hardware in a different location. We've never had problems with PLSQL Developer before, but now we are seeing sluggish performance. Most notably is that queries...
  3. P

    Cannot see detail info (Sql Text) in Session window

    It seems to be a problem handling RAC - i had to make a custom query to go against gv$session in order to see sessions on both nodes. The sql text is not appearing for the node i am not logged in to. The workaround for now is I log into each node separately and view sessions that way. I can...
  4. P

    Cannot see detail info (Sql Text) in Session window

    I seem to have intermittent problems with seeing SQL Text in the session window if I click on a session. Sometimes I can see it, sometimes I can't. Any ideas? Regards, Paul.
See more
Back
Top