on 09-21-2010 1:27 PM
Hello,
When i checked using DBA cockpit , it shows
PSAPSR3700 Auto Extended = NO
but, for the data files of PSAPSR3700 tablespace it shows AutoExtensible = YES
So here, when it finishes the allocated amount , will that automatically grows the datafile to its MAXSIZE.
(Here Max Size is specified as 10000 MB)
why the tablespace PSAPSR3700 marked as auto-extend NO !!!
im confusing this.
Pl, help me to resolve this
Hi,
PSAPSR3700 Auto Extended = NO
but, for the data files of PSAPSR3700 tablespace it shows AutoExtensible = YES
So here, when it finishes the allocated amount , will that automatically grows the datafile to its MAXSIZE.
(Here Max Size is specified as 10000 MB)
This could be because all the datafiles might have reached the maxsize. Check the size of all the datafiles, if the sizes are same as that of the maxsize then ur tablespace will show "No" to autoextend.
You can test this by adding a new datafile of size smaller than maxsize with Autoextend "ON" to the tablespace and then refresh the DB02 display. After doing the above procedure, u can see the tablespace changed to Autoextendible "YES".
Hope this clarifies.
Regards,
Varadharajan M
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
This could be because all the datafiles might have reached the maxsize.
Yes , I have check the SIZE and MAXSIZE of the datafiles.
It is SAME - Sizes are same as that of the maxsize. Okay now i got the point .... indicate as AUTOEXTEND = NO
But having little bit of more confusion!
In the same Tablespace (PSAPSR3700) , it show
PSAPSR3700
Size: 86,864 MB
Free: 11,092 MB
Used: 87%
AutoExtend: NO
Total Size: 86,864 MB
Total Used: 87
Here, since SIZE and TOTAL SIZE are same,
and
in all datafiles of this Tablespace SIZE reached to MAXSIZE limit,
How it shows the FREE amount as 11092 MB
Regards,
Zerandib
If ,
Size of the new file == Maximum file size
then it occupies the Full space.
ex: Size of the new file (10 GB) == Maximum file size (10 GB)
then this file gets 10 GB space. But within the file .... free space is there... Oracle will manage this space efficiently.
If ;
Size of the new file (2 GB) == Maximum file size (10 GB) ..... where auto extended is ON on datafile,
then it obtain only 2 GB space.... (in DB02 statistics). Afterward , when ever necessary it will increase the file using auto-extend.
Since all datafiles created according to Size of the new file == Maximum file size, then it shows as,
size == total size.
nevertheless , It correctly shows the free space also.
regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.