Query about PDB space consumption in XE [message #679985] |
Thu, 16 April 2020 02:35 |
|
Akhtar Usman
Messages: 4 Registered: April 2020
|
Junior Member |
|
|
Hi,
I just installed Oracle18c XE and storage is limited to 12G.
But I am confused about space occupied by PDB XEPDB1 & SEEDPDB. Both these are having their own datafiles and I can see physical size of datafiles on disk is in GBs.
Does it mean all this space will be consumed for 12G of total space?
|
|
|
|
|
Re: Query about PDB space consumption in XE [message #680023 is a reply to message #680022] |
Sun, 19 April 2020 01:02 |
John Watson
Messages: 8960 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Have you read the docs on Multitenant yet? When you do, it will become clear that there should be no user data in cdb$root: that is what pluggable containers are for.
As for your second question, you would need to give some evidence to support your assertion.
|
|
|
|
Re: Query about PDB space consumption in XE [message #680027 is a reply to message #680025] |
Sun, 19 April 2020 11:28 |
John Watson
Messages: 8960 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
I have no idea what you are trying to show. Please use SQL*Plus, and copy/paste the queries and the results. Remember to enclose the text within [code] tags.
Also, when you work out an answer to something it is good forum etiquette to post the solution in order to help others who may have the same questions.
|
|
|
Re: Query about PDB space consumption in XE [message #680114 is a reply to message #680027] |
Wed, 22 April 2020 07:44 |
|
Akhtar Usman
Messages: 4 Registered: April 2020
|
Junior Member |
|
|
Well I regret i wasn't able to explain the query properly as I was unable to display images in my last response.
I will try to elaborate a bit further:
1st query:
After new installation of Oracle XE, how pdb$root, pdbseed & xepdb1 will contribute to storage limit of 12G?
Answer:
pdbseed -> It is a system template. So it wont contribute to user data & space limit.
pdbroot -> Yes, if any user tables or data is created here, it will contribute to space limit.
xepdb1 -> Yes, if any user tables or data is created here, it will contribute to space limit.
2nd query:
I changed max size of tablespace TEMP datafile to 1GB with b/m command:
alter database tempfile 'C:\ORACLE\ORADATA\XE\XEPDB1\TEMP01.DBF' autoextend on maxsize 1024M;
Then I verified above change from dba_temp_files and it was correctly set to 1GB:
select FILE_NAME, TABLESPACE_NAME, MAXBYTES/1024/1024/1024 from dba_temp_files;
But when I am verifying same thing from sql developer tablespaces, TEMP is showing MAXBYTES as 9216M
This can be either some sql developer issue or may be I am missing something here.
|
|
|
Re: Query about PDB space consumption in XE [message #680128 is a reply to message #680114] |
Thu, 23 April 2020 04:03 |
John Watson
Messages: 8960 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Quote:This can be either some sql developer issue or may be I am missing something here. Stop messing about with GUI tools, and use SQL*Plus. That way you can show what queries you are running and what the results are.
|
|
|