Home » RDBMS Server » Server Administration » Tablespace question, need the answer (Windows)
Tablespace question, need the answer [message #661935] Thu, 06 April 2017 10:37 Go to next message
simon_zhao
Messages: 4
Registered: April 2017
Junior Member
Hi All, anyone can help me with this question, it's better to leave some comments to explain why you choose that option, from my opinion, I think it's D. Correct me if I'm wrong. Thanks.

Create tablespace g1_tabs datafile 'u01/oradata/g1_tabs_01.dbf' Size 1000m
autoextend on next 100m maxsize 2000m;

If the critical alert for tablespace usage is set to 90 percent, when will the alert be raised?

A. When the space used by segments that have not been dropped reaches 900MB
B. When the space used by segments that have not been dropped and segments in
the recycle bin reaches 900MB
C. When the space used by segments that have not been dropped reaches
1,800MB
D. When the space used by segments that have not been dropped and segments in
the recycle bin reaches 1,800MB
Re: Tablespace question, need the answer [message #661937 is a reply to message #661935] Thu, 06 April 2017 10:45 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
You need to comment first! Why do you think it id D? Why do you think that A/B/C are incorrect?
Re: Tablespace question, need the answer [message #661938 is a reply to message #661937] Thu, 06 April 2017 10:48 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
You should also work on your problem solving technique. For this example, you could run the statement (or similar) to create the tablespace; define an alert on 90% full; create and drop a few segments. Then you will know the answer for sure.
Re: Tablespace question, need the answer [message #661939 is a reply to message #661938] Thu, 06 April 2017 10:56 Go to previous messageGo to next message
simon_zhao
Messages: 4
Registered: April 2017
Junior Member
Size 1000m
autoextend on next 100m maxsize 2000m;

The reason I choose D is because the initial size is 1000M, the size increases by 100M until reach to 2000M. This is what I understand then 90%*2000=1800M, so A and B are impossible. And overtime, you drop a segment, it will go to the recycle bin first. But I'm not sure C or D.
Re: Tablespace question, need the answer [message #661940 is a reply to message #661939] Thu, 06 April 2017 11:04 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
So you are not certain whether dropped objects count towards the space budget? You need to test. For example:
create tablespace ts1 datafile size 50m;
select sum(bytes) from dba_Free_Space where tablespace_name='TS1';
create table t1 tablespace ts1 as select * from all_objects;
select sum(bytes) from dba_Free_Space where tablespace_name='TS1';
drop table t1;
show recyclebin;
select sum(bytes) from dba_Free_Space where tablespace_name='TS1';
Re: Tablespace question, need the answer [message #661943 is a reply to message #661939] Thu, 06 April 2017 11:59 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
And overtime, you drop a segment, it will go to the recycle bin first.
Depends on the instance and session configuration.
See recyclebin parameter.

Previous Topic: How would you describe the ORACLE_HOME environment variable?
Next Topic: Tablespace Not re utilize space
Goto Forum:
  


Current Time: Thu Mar 28 11:04:14 CDT 2024