Using Multiple Tablespaces (46)
A very small database may need only the SYSTEM tablespace; however, Oracle
recommends that you create at least one additional tablespace to store user data
separate from data dictionary information. This gives you more flexibility in
various
database administration operations and reduces contention among dictionary
objects
and schema objects for the same datafiles.
1. 一個資料庫最少需要system表空間
2. 使用多個表空間 , 你可以將使用者資料與資料欄位分開
,減少同一資料檔案在系統和使用者物件之間的競爭[@more@]
recommends that you create at least one additional tablespace to store user data
separate from data dictionary information. This gives you more flexibility in
various
database administration operations and reduces contention among dictionary
objects
and schema objects for the same datafiles.
1. 一個資料庫最少需要system表空間
2. 使用多個表空間 , 你可以將使用者資料與資料欄位分開
,減少同一資料檔案在系統和使用者物件之間的競爭[@more@]
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-973524/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 2.5 Overview of Tablespaces and Database Files in a CDBViewDatabase
- [MetalKit]46-Introduction to compute using Metal 用 Metal 進行計算的簡介
- JavaScript select multipleJavaScript
- Logstash Multiple Pipelines
- 46
- Small Multiple(最短路)
- 2.3.6.2 Synchronization of Multiple ApplicationsAPP
- LLM multiple modal applicationsAPP
- kubernetes traefik multiple namespacesnamespace
- innodb_undo_tablespaces導致Mysql啟動報錯MySql
- MySQL 索引優化 Using where, Using filesortMySql索引優化
- MySQL explain結果Extra中"Using Index"與"Using where; Using index"區別MySqlAIIndex
- 淺談mysql中各種表空間(tablespaces)的概念MySql
- Multiple Books多賬薄
- POJ1426-Find The Multiple
- vue46Vue
- FastAPI(46)- JSONResponseASTAPIJSON
- Using hints for PostgresqlSQL
- String interpolation using $
- using的用法
- Using mysqldump for backupsMySql
- MySQL 之 USINGMySql
- Lowest Common Multiple Plus hd 2028
- 【OCP最新題庫解析(052)--題8】Which two are true about undo tablespaces?
- pdf crop using pythonPython
- MGTSC 212 using ExcelExcel
- Video Division with using OpenCvIDEOpenCV
- Dictionary application using SwingAPP
- What are the benefits of using an proxy?
- 淺談Using filesort和Using temporary 為什麼這麼慢
- HDU 6298 Maximum Multiple(找規律)
- sim3d multiple component example3D
- Leetcode——46. 全排列LeetCode
- 46_docker-compose_nginxDockerNginx
- LeetCode系列46—全排列LeetCode
- 【LeetCode】46. 全排列LeetCode
- ARS Reinforcement Learning using Gymnasium
- Using MATLAB with CANoe 快讀Matlab
- input file multiple 批量上傳檔案