???????????????????
???????????? ???????[ 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
??????
???路???
??????????????????
2023/3/23 14:23:39???写?貌??????????
2023/3/22 16:17:39????????????????????些??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???路???????路
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11