Hello Friends,
Below Test I have done for those people, who are curious to know or monitor free and total tablespace size when autoextend on. Because most of our DBA use below generic script to monitor tablespace which actually don't show till what extent or size this tablespace will grow and they add another datafile.
Tried to show how, you can check and can avoid datafile addition. You may test below steps at on your own lab and see the result.
1. Create a test tablespace.
2. Check the used size of newly created tablespace, it will now show when you will run below query. Because tablespace this time does not contain any segment. 
See below how tablespace is growing when we insert data into tablespace.
3. Create a dummy table and run query from step 2, now it will show test1 tablespace because it has a dummy segment in this tablespace.
4. start in insert data in table1 and open another terminal when you will continually have to monitor (from step2) how tablespace test1 is gowning.
No comments:
Post a Comment