apt-rdbms-01.co.uk:APTDB\sys> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
apt-rdbms-01.co.uk:APTDB\sys> select file#, maxiortm from v$filestat;
FILE# MAXIORTM
------------------ ------------------
1 71
2 131
3 8
4 1
5 1
apt-rdbms-01.co.uk:APTDB\sys> exec dbms_system.kcfrms();
PL/SQL procedure successfully completed.
apt-rdbms-01.co.uk:APTDB\sys> select file#, maxiortm from v$filestat;
FILE# MAXIORTM
------------------ ------------------
1 0
2 0
3 0
4 0
5 0
Search This Blog
Total Pageviews
Thursday, 30 June 2011
Subscribe to:
Post Comments (Atom)
Oracle DBA
anuj blog Archive
- ▼ 2011 (362)
No comments:
Post a Comment