???????????????????

???????????? ???????[ 2013/6/17 10:14:34 ] ????????

????Oracle ?????????Oracle????????????????????ò???????cont???????????????????????λ??????????????????????????????????紴???????????????????????????????????????????????????????????????????????????????????????Щ??????????????????????????????????????????

????????????????????????????

????1??????

????????洢???????????

?????????????????????????????????????????????????????????????????????

??????????????д??洢???????????????????洢?????????????????

??????????????????2?????????????????RMAN??????????????????

??????????????????????????????????????????????????

?????????????????????????????????????????

???????????????????????????????NOLOGGING

??????????????????????

????CREATE INDEX??ALTER INDEX ...REBUILD??ORDER BY??GROUP BY??DISTINCT??UNION??INTERSECT??MINUS??SORT-MERGER??JOIN??ANALYZE

????2????????????????????

????a???????????????????????????????????????y??????????齫???????????????????????????

????b?????????????????(???????????????????????????????)???????????????????????????

????c??????????????????????????????????????OLTP????????????

????d??????С????????????????????????????????????

????e????????????佨????????????????????????????μ??????

???????????????????

????1???????????????

SQL> select property_name??property_value from database_properties
2 where property_name like 'DEFAULT%';

PROPERTY_NAME                  PROPERTY_VALUE
------------------------------ --------------------------------
DEFAULT_TEMP_TABLESPACE        TEMP
DEFAULT_PERMANENT_TABLESPACE   USERS
DEFAULT_TBS_TYPE               SMALLFILE

????2?????????????С??λ??

SQL> select s.name tbsname??t.name??(t.bytes/1024/1024) bytes??status
2 from v$tablespace s??v$tempfile t
3 where s.ts# = t.ts#;

TBSNAME    NAME                                               BYTES   STATUS
---------- --------------------------------------------- ----------   -------
TEMP       /u01/app/oracle/oradata/orcl/temp01.dbf               30   ONLINE

SQL> select tablespace_name??file_name??bytes/1024/1024 Size_MB from dba_temp_files;

TABLESPACE FILE_NAME                                        SIZE_MB
---------- --------------------------------------------- ----------
TEMP       /u01/app/oracle/oradata/orcl/temp01.dbf               30

SQL> select tablespace_name??logging??allocation_type
2 from dba_tablespaces where tablespace_name='TEMP';

TABLESPACE LOGGING   ALLOCATIO
---------- --------- ---------
TEMP       NOLOGGING UNIFORM