Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 367418

Summary:	Data Source Explorer Slow To Open With Large Number Of Schemas In Database
Product:	[Tools] Data Tools	Reporter:	Nicholas Smith <nick.smith>
Component:	Data Source Explorer	Assignee:	dtp.connectivity-inbox <dtp.connectivity-inbox>
Status:	NEW ---	QA Contact:
Severity:	enhancement
Priority:	P3
Version:	1.9
Target Milestone:	---
Hardware:	All
OS:	All
Whiteboard:

Description Nicholas Smith

2011-12-22 08:31:18 EST

Build Identifier: 20110916-0149

We have very large Oracle Databases we have to work with, thousands of schemas in each database.  When using the Data Source Explorer, I create a connection to my desired DB, then click into Database Connections -> Desired DB (Connect) and from there I expand Schemas.  It takes approx 4 minutes to populate.  This is expected as it seems to always query the DB for all available schemas.  Would like to ability to explicitly select a set of schemas to show, and when using that type of filter, only have the DTP component query for those explicity defined schemas.  This would probably be helpful to anyone working with databases housing more than a few hundred schemas. 

Reproducible: Always

Steps to Reproduce:
1.  Connect to a database with hundreds or thousands of schemas.
2.  Expand the Data Source Explorer : Database Connections - Desired DB - Desired SID - Schemas element.
3.  Wait...

Comment 1 Brian Fitzpatrick

2011-12-26 10:19:33 EST

So you're looking for some ways to filter the search a bit so it pulls back a subset of the schemas as opposed to all schemas? I think you can do this now by applying filters to the root schema node and selecting "Properties" and then specifying an expression or selecting particular schemas in the list.

That said, I'm not sure that this will aid in reducing your 4 minute (ouch!) query time by much if any.

Can you give it a shot to see if it helps at all? 

Also, can you tell us whether you're using the default Oracle support in DTP or are using the Oracle-provided DTP plug-ins? (The Oracle plug-ins are available here: http://www.oracle.com/technetwork/developer-tools/eclipse/overview/index.html and may be a bit more optimized for your needs.)