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

Popular posts from this blog

html - How to style widget with post count different than without post count -

How to remove text and logo OR add Overflow on Android ActionBar using AppCompat on API 8? -

javascript - storing input from prompt in array and displaying the array -