Find Out Tablespace Least Busy Period [message #653424] |
Tue, 05 July 2016 03:41 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/82920145e40e0c65c671e4d0b8212ab7?s=64&d=mm&r=g) |
juniordbanewbie
Messages: 250 Registered: April 2014
|
Senior Member |
|
|
Dear all,
from https://docs.oracle.com/cd/E11882_01/server.112/e25494/dfiles.htm#ADMIN11430
Procedure for Renaming Data Files in a Single Tablespace
Quote:
ALTER TABLESPACE users OFFLINE NORMAL;
Of course the first step can easily complete if there's no sessions or processes accessing the tablespace.
Unfortunately it can be easily completed if it there are many sessions or processes accessing the tablespace.
also I'm using SE, so DBA_HIS_ views will not be applicable. But statspack has been installed and snapshot taken at 20 minutes interval at 10, 30, 50 minute.
so how do I found the time of the day where the tablespace is accessed the least for a 7 day period?
thanks in advance
|
|
|
|
|
|
|
|
Re: Find Out Tablespace Least Busy Period [message #653439 is a reply to message #653435] |
Tue, 05 July 2016 10:24 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68653 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
More precisely, given you want to put offline the tablespace (I don't know why it is necessary) I'd choose the number of writes (PHYWRTS), access time is not relevant for the question.
|
|
|