EVISWANG的博客

1.>SELECT A.TABLESPACE_NAME,          A.BYTES TOTAL,       B.BYTES USED,       (B.BYTES) / A.BYTES "USED %"  FROM SYS.SM$TS_AVAIL A, SYS.SM$TS_USED B, SYS.SM$TS_FREE C WHERE A.TABLESPACE_N

1.问题描述： 2个undo表空间使用严重不均，一直这样，怎么优化下呢UNDOTBS1是实例1的，UNDOTBS2是实例2的SQL> show parameter undoNAME TYPE VALUE------------------------------------ ----------- -------------------------

检查alert发现ORA-01555报错确实和下文描述的很像ORA-01555 caused by SQL statement below(SQL ID: 9ggx5zvjkgd1t, Query Duration=0 sec, SCN: 0x0570.57568308):IF: ORA-1555 Reported with Query Duration = 0

SQL> set linesize 1000SQL> set pagesize 1000SQL> explain plan for SELECT "A1"."EMPL_CLASS",  2         "A1"."DESCR1",       "A1"."DEPTID",       "A1"."DEPT_DESCR",       "A1"."JOBCODE",

ALERT日志报错如下：Thu Nov 26 15:34:28 2015ORA-01555 caused by SQL statement below(SQL ID: 9ggx5zvjkgd1t, Query Duration=0 sec, SCN: 0x0570.57568308):SELECT"A1"."EMPL_CLASS","A1"."DESCR1","A1"."DEPTID"

1.概述在oracle 10g中引入了临时表空间组的概念，对临时表空间组的概念理解要点如下：1.> 临时表空间组是一组临时表空间2.> 临时表空间组和临时表空间之间的名字不能相同3.> 不能显示的创建和删除临时表空间组，即当第一个临时表空间分配给临时表空间组时临时表空间组自动创建，当最后一个临时表空间从临时表空间组退出时临时表空间组自动删除。2.临时表空间组的优势    默

Thu Nov 19 14:07:11 2015ORA-1652: unable to extend temp segment by 16 in tablespace                 APPS_TS_MEDIA Thu Nov 19 14:10:11 2015

1.问题描述检查alert日志发现近期大量ORA-1652报错截止上午10:00近2天报错次数为19次Wed Feb 17 01:32:03 2016ORA-1652: unable to extend temp segment by 16 in tablespace                 TEMP1 Wed Feb 17 01:32:03 2016ORA

SQL> select file_name, bytes/1024/1024/1024 gb , tablespace_name ,AUTOEXTENSIBLE from dba_data_files;FILE_NAME GB TABLESPACE_NAME AUT---------------------------------------------

查看当前临时表空间：SQL> select PROPERTY_VALUE   from database_properties where PROPERTY_NAME='DEFAULT_TEMP_TABLESPACE';PROPERTY_VALUE----------------------------------------------------------------------

SQL> SELECT d.tablespace_name,            to_char(nvl(a.bytes / 1024 / 1024 / 1024, 0), '99,999,990.00') size_g,            to_char(nvl(f.bytes, 0) / 1024 / 1024 / 1024, '99,999,990.00') free_g,

SQL> create unique index fqzrule.PK_DD_POLICY122T on fqzrule.DD_POLICY (TRIM(POLICY_ID))  tablespace FQZDATATBS ;  2  create unique index fqzrule.PK_DD_POLICY122T on fqzrule.DD_POLICY (TRIM(POLIC...