Hammering Oracle server

This forum can be browsed by the general public. Posting is limited to current SAPIEN license holders with active maintenance and does not offer a response time guarantee.
Forum rules
DO NOT POST LICENSE NUMBERS, ACTIVATION KEYS OR ANY OTHER LICENSING INFORMATION IN THIS FORUM.
Only the original author and our tech personnel can reply to a topic that is created in this forum. If you find a topic that relates to an issue you are having, please create a new topic and reference the other in your post.

Any code longer than three lines should be added as code using the 'Select Code' dropdown menu or attached as a file.
This topic is 9 years and 1 month old and has exceeded the time allowed for comments. Please begin a new topic or use the search feature to find a similar but newer topic.
User avatar
sproctor
Posts: 20
Last visit: Thu Jul 22, 2021 11:12 am

Hammering Oracle server

Post by sproctor »

I am using PSQL 4.1.39 x64 on Windows 7 x64.

When I pull up a query that connects to the Oracle server, the browser starts is "walk" through all the DB's and tables and is overloading the server. Is there a way to stop or limit this behavior? There are a lot of db's and tables on this server and it takes too long for that process to complete on top what it is doing to the server.
User avatar
SAPIEN Support Forums
Posts: 945
Last visit: Thu Oct 22, 2015 1:10 pm

Hammering Oracle server

Post by SAPIEN Support Forums »

This is an automated post. A real person will respond soon.

Thank you for posting, sproctor.

Did you remember to include the following?
  • 1. Product, version and build (e.g. Product: PrimalSQL 2014, Version & Build: 4.0.36. Version and build information can be found in the product's About box accessed by clicking the blue icon with the 'i' in the upper right hand corner of the ribbon.)
    2. Specify if you are running a 32 or 64 bit version
    3. Specify your operating system and if it is 32 or 64 bit.
    4. Attach a screenshot if your issue can be seen on the screen
    5. Attach a zip file if you have multiple files (crash reports, log entries, etc.) related to your issue.
If not, please take a moment to edit your original post or reply to this one.

*** Make sure you do not post any licensing information ***
User avatar
davidc
Posts: 5913
Last visit: Mon Jul 08, 2019 8:55 am
Been upvoted: 2 times

Re: Hammering Oracle server

Post by davidc »

By the browser, do you mean the query build or the Database Browser panel that shows all the databases?

You could open a SQL Text Document and that should load faster than the Query builder.

If there isn't a cache of the metadata the Database Browser will attempt to build one. You can reduce the time it takes to build the cache by making sure the following option is un-checked:

Options->Panels->Database Browser->Cache All Fields

But once the cache is made it should not build it again unless you instruct it to.

David
David
SAPIEN Technologies, Inc.
User avatar
sproctor
Posts: 20
Last visit: Thu Jul 22, 2021 11:12 am

Re: Hammering Oracle server

Post by sproctor »

Yes I mean the database browser that I am referring too and I am loading a previous text query a *.sql file and when I do the browser gets the spinning circle icon.

Also, both items under database browser are un-checked. I have always had this issue, but this is the first time I get a call from the dba complaining about what it's doing to the server.
User avatar
davidc
Posts: 5913
Last visit: Mon Jul 08, 2019 8:55 am
Been upvoted: 2 times

Re: Hammering Oracle server

Post by davidc »

It should only query the tables, but if they are so many, then yes it can take a while.

I will add a wish list request for an option to prevent caching.

David
David
SAPIEN Technologies, Inc.
This topic is 9 years and 1 month old and has exceeded the time allowed for comments. Please begin a new topic or use the search feature to find a similar but newer topic.