9 查锁
select l.session_id sid,l.locked_mode lockmode,l.oracle_username db_user,l.os_user_name os_user,s.machine,s.schemaname,o.object_name tablename,q.sql_text
from v$locked_object l, v$session s, v$sql q, all_objects o
where l.session_id = s.sid
and s.type = 'USER' and s.sql_address = q.address and l.object_id = o.object_id
10 杀锁
alter system kill session 'sid,SERIAL#'
4.查看各个数据文件大小:
SQL> SELECT bytes/1024/1024/1024 AS "大小(G)",NAME FROM v$datafile ORDER BY bytes;
SQL> SELECT bytes/1024/1024/1024 AS "大小(G)",NAME FROM v$tempfile ORDER BY bytes;
1.以sysdba身份登录
2.创建临时中转的临时表空间TEMP2
SQL> create temporary tablespace TEMP2 TEMPFILE D:\ORACLE\ORADATA\KDC\TEM
P02.DBF' SIZE 5M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
2 /
表空间已创建。
3.修改默认临时表空间为TEMP2
SQL> alter database default temporary tablespace temp2;
数据库已更改。
4.drop原来的临时表空间TEMP:
SQL> drop tablespace temp including contents and datafiles;
表空间已丢弃。
5.重新创建临时表空间TEMP:
SQL> create temporary tablespace TEMP TEMPFILE D:\ORACLE\ORADATA\KDC\TEM
P01.DBF' SIZE 4000M(这个地方跟你的需要而定) REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
2 /
表空间已创建。
6.更改默认临时表空间为TEMP:
SQL> alter database default temporary tablespace temp;
数据库已更改。
7.drop临时表空间TEMP2
SQL> drop tablespace temp2 including contents and datafiles;
表空间已丢弃。
su - oracle
// 启动监听程序
lsnrctl start
select l.session_id sid,l.locked_mode lockmode,l.oracle_username db_user,l.os_user_name os_user,s.machine,s.schemaname,o.object_name tablename,q.sql_text
from v$locked_object l, v$session s, v$sql q, all_objects o
where l.session_id = s.sid
and s.type = 'USER' and s.sql_address = q.address and l.object_id = o.object_id
10 杀锁
alter system kill session 'sid,SERIAL#'
4.查看各个数据文件大小:
SQL> SELECT bytes/1024/1024/1024 AS "大小(G)",NAME FROM v$datafile ORDER BY bytes;
SQL> SELECT bytes/1024/1024/1024 AS "大小(G)",NAME FROM v$tempfile ORDER BY bytes;
1.以sysdba身份登录
2.创建临时中转的临时表空间TEMP2
SQL> create temporary tablespace TEMP2 TEMPFILE D:\ORACLE\ORADATA\KDC\TEM
P02.DBF' SIZE 5M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
2 /
表空间已创建。
3.修改默认临时表空间为TEMP2
SQL> alter database default temporary tablespace temp2;
数据库已更改。
4.drop原来的临时表空间TEMP:
SQL> drop tablespace temp including contents and datafiles;
表空间已丢弃。
5.重新创建临时表空间TEMP:
SQL> create temporary tablespace TEMP TEMPFILE D:\ORACLE\ORADATA\KDC\TEM
P01.DBF' SIZE 4000M(这个地方跟你的需要而定) REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
2 /
表空间已创建。
6.更改默认临时表空间为TEMP:
SQL> alter database default temporary tablespace temp;
数据库已更改。
7.drop临时表空间TEMP2
SQL> drop tablespace temp2 including contents and datafiles;
表空间已丢弃。
su - oracle
// 启动监听程序
lsnrctl start