| issue with disabling block chnage tracking [message #680344] |
Fri, 08 May 2020 06:31  |
janakors
Messages: 232
Registered: September 2009
|
Senior Member |
|
|
Hi,
I want to disable block change tracking and applied the following
alter database disable block change tracking;
my database size is 7.7TB?
someone can help why it is so? is it normal?
Regards
|
|
|
|
|
|
| Re: issue with disabling block chnage tracking [message #680346 is a reply to message #680344] |
Fri, 08 May 2020 07:45  |
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Better see if it is hanging. For example:select u.osuser,u.machine,u.program,u.username,u.sid,u.event,u.seconds_in_wait secs,sql_text sql
from v$session u join v$sql using (sql_id)
where u.wait_class <> 'Idle' and u.wait_time=0
|
|
|
|
| Re: issue with disabling block chnage tracking [message #680378 is a reply to message #680345] |
Sat, 09 May 2020 12:51 |
janakors
Messages: 232
Registered: September 2009
|
Senior Member |
|
|
No clues it saying nothing abnormal . i think it is normal that it would take that much time , i guess, any how i kill the alter database wit ctl+C but still the SQL prompt is not rescued i have opened another window of SQL and when i check the status of block_change_tracking so it says ENABLED. please any clues
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
