-
Extend Tablespace SYSTEM
Hello,
one short question. Could any problem occur if I extend (500MB to 550MB) the tablespace SYSTEM in "live" production (Performance etc)?
Thanks & Regards
-
-
Ok, Thanks.. But I checked the tablespace if it is autoextensible, and I get following:
SUBSTR(FILE_NAME,1,50) AUT
------------------------------------------- ---
D:\ORA\DBNAME\SYSTEM.DBF YES
I still have 1,1 MB space free. 99,8% are occupied. When will Oracle extend the tablespace automatically?
-
-
Originally Posted by davey23uk
when it needs more space
No tresholds?
-
oh boy -- yes, when there is not more space.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
oh boy -- Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|