pl/sql连接数据库报错:ORA_00604:递归SQL级别%s出现错误
查询表空间使用率,发现system表空间基本完全被使用
SQL> set linesize 300
SQL> col tablespace_name for a30
SQL> select a.tablespace_name,a.total "total_size(MB)",round((a.total-b.free),2) "used_size(MB)",round(b.free,2) "free_size(MB)",round((
tablespace_name,sum(bytes)/1024/1024 total from dba_data_files group by tablespace_name) a,(select tablespace_name,sum(bytes)/1024/1024
lespace_name=b.tablespace_name(+) order by ((total-free)/total) desc;
TABLESPACE_NAME total_size(MB) used_size(MB) free_size(MB) percent_used(%)
------------------------------ -------------- ------------- ------------- ---------------
SYSTEM 32710 32704.25 5.75 99.98
USERS 5 4.38 .63 87.5
EXAMPLE 103.125 78.75 24.38 76.36
SYSAUX 1710 920.06 789.94 53.8
UNDOTBS1 4270 25.25 4244.75 .59
已选择9行。
查看表空间容量,发现system表空间只用32G,确实空间不足
SQL> set linesize 300
SQL> col file_name for a60
SQL> col tablespace_name for a30
SQL> select file_name,tablespace_name,bytes/1024/1024,autoextensible,maxbytes/1024/1024 from dba_data_files order by tablespace_name;
FILE_NAME TABLESPACE_NAME BYTES/1024/1024 AUTOEX MAXBYTES/1024/1024
------------------------------------------------------------ ------------------------------ --------------- ------ ------------------
D:\APP\ADMINISTRATOR\ORADATA\ORCL\EXAMPLE01.DBF EXAMPLE 103.125 YES 32767.9844
D:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSAUX01.DBF SYSAUX 1710 YES 32767.9844
D:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSTEM01.DBF SYSTEM 32710 YES 32767.9844
D:\APP\ADMINISTRATOR\ORADATA\ORCL\UNDOTBS01.DBF UNDOTBS1 4270 YES 32767.9844
D:\APP\ADMINISTRATOR\ORADATA\ORCL\USERS01.DBF USERS 5 YES 32767.9844
已选择9行。
对system表空间扩容
SQL> ALTER TABLESPACE SYSTEM ADD DATAFILE 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSTEM02.DBF' SIZE 10G AUTOEXTEND ON NEXT 128M;