--查询表空间大小
select SEGMENT_TYPE, owner, sum(bytes) / 1024 / 1024
  from dba_segments
 where tablespace_name = 'GROUPEC'
 group by segment_type, owner
--查询表空间文件位置          
select name from v$datafile;

--增加改表空间文件
--alter tablespace GROUPEC add datafile '/data/oradata/ecuatdb/groupec26.dbf' size 10m;

--指定表空间的可用空间，使用视图SYS.DBA_FREE_SPACE，视图中每条记录代表可用空间的碎片大小
Select file_id,block_id,blocks,bytes from sys.dba_free_space where tablespace_name='GROUPEC';

--查看一下缺省的表空间参数
SELECT INITIAL_EXTENT,NEXT_EXTENT,MIN_EXTENTS,PCT_INCREASE FROM SYS.DBA_TABLESPACES WHERE TABLESPACE_NAME='GROUPEC';

--检查数据文件的状态。
select file#,status from v$tempfile;

---检查死锁
select username,lockwait,status,machine,program from v$session where sid in (select session_id from v$locked_object);

--可以确定哪些object被locK住
select rpad(oracle_username, 10) o_name,
       session_id sid,
       decode(locked_mode,
              0, 'None',
              1, 'Null',
              2, 'Row share',
              3, 'Row Exclusive',
              4, 'Share',
              5, 'Share Row Exclusive',
              6, 'Exclusive') lock_type,
       object_name,
       xidusn,
       xidslot,
       xidsqn
  from v$locked_object, all_objects
 where v$locked_object.object_id = all_objects.object_id;
--解锁
--alter system kill SESSION '250，200';