Support Forums

Hammering Oracle server

Product support for PrimalSQL users
Forum rules
DO NOT POST SUBSCRIPTION NUMBERS, LICENSE 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.
User avatar
sproctor
Posts: 17
Joined: Tue Aug 25, 2009 1:45 am

Hammering Oracle server

Postby sproctor » Wed Feb 11, 2015 9:48 am

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
Joined: Wed Dec 03, 2014 2:26 pm

Hammering Oracle server

Postby SAPIEN Support Forums » Wed Feb 11, 2015 9:48 am

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: 4354
Joined: Thu Aug 18, 2011 4:56 am

Re: Hammering Oracle server

Postby davidc » Wed Feb 11, 2015 10:27 am

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: 17
Joined: Tue Aug 25, 2009 1:45 am

Re: Hammering Oracle server

Postby sproctor » Wed Feb 11, 2015 11:26 am

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: 4354
Joined: Thu Aug 18, 2011 4:56 am

Re: Hammering Oracle server

Postby davidc » Wed Feb 11, 2015 12:05 pm

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.

Return to “PrimalSQL”

Who is online

Users browsing this forum: No registered users and 2 guests