>It seems to me it is issue with connection to the ORACLE over the network ( TCP/IP ).
This would be my guess. Do you have 'Share Connection' checked? If so, when you open a single remote view (rv) a connection will be established. When you close that view the connection is closed. If you open a second rv while the first rv is open, the second rv will use the connection established by the first rv and will open much more quickly than if it had to open its' own connection.
In a large application we just completed installing, an rv is opened in the beginning of the framework and left open. All subsequent rv's (and any SQL pass through statements) then share this same connection and open rapidly.
For your test program open one rv and then time how long it takes to open a second rv. This will let you know whether it is a problem with establishing a connection or some other problem.
>Maybe it is ORACLE Listener i need to configure correctly.
We used the default settings and had no problems.
Good Luck,
Gerry
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only