How long does it take to connect via sqlplus? [EMAIL PROTECTED] wrote:
>I tried solve it by myself, and I am out of my wits. >Please point me where to look/what to read (RTMF is fine - just what page). > >Problem: >I am running IIS on Win2000 (%.00.2192), + Servce pack 2 >ActiveState Perl 5.6.1 build 631 >DBI 1.14 >Oracle 8.0.5.0.0 for NT >connecting via Oracle ODBC (file has date from 1998) > >I am not sure, but I think my troubles are caused >by installing DBArtisan, rather old version 4.02 >what was lying aroud (from 2/98). > >Since then (or close around), when I run my script, >to connect to a database (over IP) takes 24 sec every time. > >I did not noticed immediately, because I am working >to speed up my query, and it was slow (minutes) anyway, >and I reloaded my table, etc, etc. > >When I am checking my connection using Oracle Net8 Easy Config, >MS Access (linked table via ODBC), or even DBArtisan, >access speed is fine. > >But when I try DBI->connect, it takes 24 secs. >I did not changed "connect" parts of my code. >ALso, exacly the same code, when run >on our production server (Linux box), runs just fine, >so I am pretty much sure some my own local setting are wrong. > >I tried to reinstall Oracle ODBC drivers, no change. >I removed and re-created ODBC data sources, they are fine. > >Just my local perl scripts take 24 secs to connect. > >Another thing we did is oracle databse server was placed >behind firewall. > >Where to look? > >Thanks a lot for any pointers. > >Peter > >