摘要：--sqlselect dbf.tablespace_name,dbf.totalspace "总量(M)",dbf.totalblocks as 总块数,dfs.freespace "剩余总量(M)",dfs.freeblocks "剩余块数",(dfs.freespace / dbf.totalspace) * 100 "空闲比例"from (select t.tablespace_name,sum(t.bytes) / 1024 / 1024 totalspace,sum(t.blocks) totalblo 阅读全文

摘要：在liunx下启动oracle1.连接到liunx2.切换到oraclesu - oracle3.启动监听lsnrctl start 4.login到sqlplussqlplus /nolog5.连接conn /as sysdba6.启动数据库startup进入到sqlplus关闭数据库shutdown immediate退出sqlplusexit关闭监听lsnrctl stop 阅读全文

摘要：1.查询被锁对象：select object_name,machine,s.sid,s.serial# from v$locked_object l,dba_objects o ,v$session swhere l.object_id　=　o.object_id and l.session_id=s.sid; 2.将查找的被锁会话结束：alter system kill session '130... 阅读全文