07 2017 档案

Oracle死锁
摘要：查看锁表进程SQL语句1： select sess.sid, sess.serial#, lo.oracle_username, lo.os_user_name, ao.object_name, lo.locked_mode from v$locked_object lo, dba_objects ao, v$session s... 阅读全文

posted @ 2017-07-26 17:06 Leis 阅读(157) 评论(0) 推荐(0)

Oralce新建用户及表空间维护
摘要：--1.创建临时表空间 create temporary tablespace AUTOMONITORV5_temp tempfile 'D:\ORACLE\KARL\ORADATA\ORCL\AUTOMONITORV5_temp.DBF' size 50m autoextend on next 5 阅读全文

posted @ 2017-07-26 14:21 Leis 阅读(328) 评论(0) 推荐(0)