Oracle (thin) DB discovery is very slow

Note: please leave bug reports and feature requests on

Oracle (thin) DB discovery is very slow

Postby b0c1 » Wed Oct 26, 2011 10:23 pm

Hi!

I have a little problem. I dunno why but the database (schema, tables) discovery is veeeeery slow.
I press the table expand button, and I wait.... about many-many minutes (!!!)

Any idea? I miss some configuration? (I see the select .... background task is working, so it's doing something...)

Thanks
b0c1
 
Posts: 22
Joined: Tue Mar 01, 2011 1:13 pm

Re: Oracle (thin) DB discovery is very slow

Postby Serge » Thu Oct 27, 2011 6:51 am

It's quite a strange behaviour. We've tested Oracle plugin in many different environments and Oracle versions and it worked fine.
Moreover - DBeaver doesn't perform any database roundtrips on table expand action.

Could you open QueryManager view and check what query exactly is executed at that moment?

Thanks!
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: Oracle (thin) DB discovery is very slow

Postby b0c1 » Wed Nov 02, 2011 7:56 am

I not run any query. I simply want to browse the database tables... (the query executed automatically).
b0c1
 
Posts: 22
Joined: Tue Mar 01, 2011 1:13 pm

Re: Oracle (thin) DB discovery is very slow

Postby Support » Wed Nov 02, 2011 9:13 am

DBeaver logs every query it executes.
You may configure it on page Preferences -> Database Configuration -> Query Manager.
Check all query types and object types.
Each time DBeaver reads any metadata you will see it in the query manager view.

Could you check which query executes so long?

Thanks a lot!
Support
 
Posts: 49
Joined: Thu Mar 17, 2011 10:11 am

Re: Oracle (thin) DB discovery is very slow

Postby b0c1 » Fri Nov 18, 2011 10:21 am

Hi!

This query is NOT listed in the query manager. (When I expand the "Tables" level in the database).
I attached a screenshot with the SQL (shown on the background tasks):
2011-11-18_002.png
Veeeeery long running query
2011-11-18_002.png (10.52 KiB) Viewed 29455 times


This step (open the tables level on the tree) in 1.3 is work very well and fast...

Thanks
b0c1
b0c1
 
Posts: 22
Joined: Tue Mar 01, 2011 1:13 pm

Re: Oracle (thin) DB discovery is very slow

Postby Support » Sat Nov 19, 2011 9:33 am

Oh. Thank you for detailed report!

Some Oracle databases contains a lot of metadata and in some Oracle versions metadata reading may be not so fast as in others.
I can't reproduce this problem in my environments but I think I know the cause of this problem.
We'll simplify tables/views metadata reading, fix will be available in next EA version (will be available at Nov 20-21).

Thanks!
Support
 
Posts: 49
Joined: Thu Mar 17, 2011 10:11 am

Re: Oracle (thin) DB discovery is very slow

Postby b0c1 » Sat Nov 19, 2011 10:36 am

Thanks, we are waiting the next version...

b0c1
b0c1
 
Posts: 22
Joined: Tue Mar 01, 2011 1:13 pm

Re: Oracle (thin) DB discovery is very slow

Postby Serge » Mon Nov 21, 2011 7:56 pm

EA version is available here - .
Note - it contains some new features (db tools, native clients management and some other) which are partially implemented at he moment. I'd suggest not to use them :) All existing features should be stable.

Please check Oracle metadata reading performance in this version.

Thanks!
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: Oracle (thin) DB discovery is very slow

Postby Support » Wed Nov 30, 2011 2:23 pm

Oracle metadata reading was fixed in 1.4.5
Support
 
Posts: 49
Joined: Thu Mar 17, 2011 10:11 am

Re: Oracle (thin) DB discovery is very slow

Postby b0c1 » Mon Apr 16, 2012 9:57 am

b0c1
 
Posts: 22
Joined: Tue Mar 01, 2011 1:13 pm

Next

Return to Support



Who is online

Users browsing this forum: Google [Bot] and 11 guests