ORACLE 日常维护手册查看数据库版本SELECT * FROM V$VERSION;查看数据库语言环境SELECT USERENV(LANGUAGE) FROM DUAL;查看ORACLE实例状态SELECT INSTANCE_NAME,HOST_NAME,STARTUP_TIME,STATUS,DATABASE_STATUS FROM V$INSTANCE;查看ORACLE监听状态lsnrctl status查看数据库归档模式SELECT NAME,LOG_MODE,OPEN_MODE FROM V$DATABASE;查看回收站中对象SELECT OBJECT_NAME,ORIGINAL_NAME,TYPE FROM RECYCLEBIN;清空回收站中对象PURGE RECYCLEBIN;还原回收站中的对象FLASHBACK TABLE BIN$GOZUQZ6GS222JZDCCTFLHQ=$0 TO BEFORE DROP RENAME TO TEST;闪回误删除的表FLASHBA
