sql - Get database session expire time -
how value of database session expire time?
i have session want kill, don't have enough privileges it. can see session in v$session:
select * v$session osuser = 'osuser' , username='username';
as far understand session expire time set in sqlnet.ora. (obviously don't have access check.) there select can execute value of session expire time? i'm using oracle database 10g.
yes, indeed, sqlnet.expire_time
set in sqlnet.ora configuration file.
is there select can execute value of session expire time?
unfortunately no, there no data dictionary view available allow display content of sqlnet.ora. so, if have no access file view content, , has not been granted alter system
privilege, should ask system administrator or dba help.
Comments
Post a Comment