[AIX 5.3 TL12] sys user "select program from v$session" show question mark
Oracle 9i
After upgrade from AIX v5.2 to AIX v5.3 TL12 ,
the "select program from v$session" show question mask
original AIX 5.2 ==>"select program from v$session" , OK
migration AIX 5.3 ML04==>"select program from v$session" , OK
migration AIX 5.3 ML12==>"select program from v$session" , NG
for example :
######################################
on AIX 5.3 ML04 , SQL>"select program from v$session"
PROGRAM
--------------------------------------------------
oracle@testdb (PMON)
oracle@testdb (DBW0)
sqlplus@testdb (TNS V1-V3)+
########################################
on AIX 5.3 ML12 , SQL>"select program from v$session"
PROGRAM
--------------------------------------------------
oracle@testdb (PMON)
oracle@testdb (DBW0)
*?*@testdb (TNS V1-V3)
any one have advise if this is cause by upgrade to AIX v5.3 TL12 ?
any solution to show NO question mask like " *?* @testdb (TNS V1-V3) " ?