[Todd Corley]

Eclipse 3.1.1
MyEclipse 4.1
Oracle 9i

Connecting with thin drivers.
jdbc: latest classes12.jar

I can connect fine to the db.
If I click on the tree expand [+] it will show the columns in a table.
I can even use the sql file to manipulate the db.
BUT
If I left or right click on any of the table nodes DBBrowser it a wait cursor is shown and Eclipse locks up.

I will note that I am working with a fairly complex db. Talking with our Oracle person and he suggested using optimizer options, but I don’t know if the DB browser allows customization.

Any suggestions?

[Todd Corley]

After I posted I updated to ojdbc14.zip drivers for 92. It didn’t help.

[Riyad Kalla]

Can you paste the result of MyEclipse > About > Configuration Summary for us?

[Todd Corley]

@support-rkalla wrote:

Can you paste the result of MyEclipse > About > Configuration Summary for us?

*** Date: Wed Feb 15 10:29:52 EST 2006

*** System properties:
OS=WindowsXP
OS version=5.1
Java version=1.5.0_06

*** MyEclipse details:
MyEclipse Enterprise Workbench

Version: 4.1.0 GA
Build id: 20060122-4.1-GA

*** Eclipse details:
Eclipse SDK

Version: 3.1.1
Build id: M20050929-0840

Eclipse Platform

Version: 3.1.1
Build id: M20050929-0840

Eclipse RCP

Version: 3.1.1
Build id: M20050929-0840

Eclipse Java Development Tools

Version: 3.1.1
Build id: M20050929-0840

Eclipse Plug-in Development Environment

Version: 3.1.1
Build id: M20050929-0840

Eclipse Project SDK

Version: 3.1.1
Build id: M20050929-0840

Eclipse startup command=-os
win32
-ws
win32
-arch
x86
-launcher
C:\todd\eclipse\eclipse.exe
-name
Eclipse
-showsplash
600
-exitdata
d6c_38
-vm
C:\WINDOWS\system32\javaw.exe

[Todd Corley]

This comment is just so I can add notification for replies.

[Haris Peco]

Todd,

Click on table node read table information : columns, indexes, pk,fk (you see this in Table Info view).It have to work good for very complex table and i suppose that you have non-optimized database.
I will try help you that optimize your database, if you can send us any data

First, you can try call analyze database statistics, but is likely to take quite a while (hours), special if your database isn’t optimized.

Please call this command in sql editor (you must have dba privilege for some commands)
and send us results from ‘Sql Results’

1) for currently parameters

select * from v$parameter

2) for introduction in complexity your database

select object_type,count(*)
from all_objects
group by object_type

3) I suppose that you have bad settings for a temporary tablespace
Send us this :

select *
from dba_tablespaces

select file#,status,blocks,name
from v$tempfile

Best

[Todd Corley]

I am contracting on a project that I have no control over the db.
I am pming you the results of the query’s you suggested.

SQL is not my strongest suite, but the DBA said that if I can get the DB Browser tool to inject an optimizer call that it would help.

Any idea of what he is talking about?

[Todd Corley]

Could you delete that last post, I clicked the wrong button. That was supposed to be a pm.

[Riyad Kalla]

*deleted*

[Haris Peco]

SQL is not my strongest suite, but the DBA said that if I can get the DB Browser tool to inject an optimizer call that it would help.

this is command, but i think that it isn’t problem

alter system set optimizer_mode=choose

you can set rule, first_rows, but CHOOSE is fine – you can see parameter in ‘select * from v$parameter’
I suppose that is ‘CHOOSE’ already and it will not help us

I haven’t saw this parameter, because you send me firts 100 rows only .
never mind – see optimizer_mode and if it CHOOSE, it is fine

you need dba privilege for change parameter

[Haris Peco]

select object_type,count(*)
from all_objects
group by object_type

your database is relative complex, but it isn’t problem – for MyEclipse ‘click’ performance depend from number of tables,views,index,columns – it work perfect on bigger database

your database is bad optimized or your default temporary tablespace is small (do you have one or more usernames) ?

Do you have sqlplus ?

Best

[Haris Peco]

SQL is not my strongest suite, but the DBA said that if I can get the DB Browser tool to inject an optimizer call that it would help.

What does that mean? How can we know the database features and inject calls, if oracle guys can’t do it in their JDBC driver ?

Best

[Haris Peco]

Todd,

Have you resolved this problem ?

Best

[Author]

Posts