test

1、查看每个表空间剩余空间
select TABLESPACE_NAME, sum(bytes)/1024/1024,sum(blocks)
from dba_free_space group by tablespace_name

2、查看每个表空间总的尺寸
select tablespace_name, sum(bytes) / 1048576
from dba_data_files group by tablespace_name

3、给表空间添加数据文件
alter tablespace service_core_dat add datafile
  '/dev/vgdata/rlv_dat010' size 4000M,
  '/dev/vgdata/rlv_dat011' size 4000M

 

 1、查找失效的对象
select object_name from user_objects
where status = 'INVALID‘

2、编译失效的对象
alter procedure p_my_proc compile