| Tablespace question, need the answer [message #661935] |
Thu, 06 April 2017 10:37  |
 |
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 #661938 is a reply to message #661937] |
Thu, 06 April 2017 10:48  |
John Watson
Messages: 8960
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 #661940 is a reply to message #661939] |
Thu, 06 April 2017 11:04 |
John Watson
Messages: 8960
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'; |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
