You are heresqlplus

sqlplus


SQL*Plus 10.2.0.1 Hangs, When System Uptime Is Long Period of Time

Today, my colleague told me, Why I can't use "sqlplus" (Oracle client) on my application server connect your database, But I can use "tnsping"... And I'd ever connected!

I remoted on this server and found "sqlplus" hung ... and sqlplus used more CPU %

$ ps aux
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
oracle 12722 96.4 0.2 19560 4600 pts/5 R 15:36 0:06 sqlplus

So, found out on metalink... (338461.1)
SQL*Plus 10.2.0.1 Hangs, When System Uptime Is Long Period of Time (Linux x86)

Used "strace" :

$ strace sqlplus -V 2>&1 |less

SQL*Plus 10.2.0.1 Hangs, When System Uptime Is Long Period of Time

Today, my colleague told me, Why I can't use "sqlplus" (Oracle client) on my application server connect your database, But I can use "tnsping"... And I'd ever connected!

I remoted on this server and found "sqlplus" hung ... and sqlplus used more CPU %
$ ps aux
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND



Syndicate

Syndicate content

Follow DatabasesLA on Twitter

Who's online

There are currently 0 users and 0 guests online.

Estadisticas

Locations of visitors to this page

hidden hit counter