When did a datafile autoextend? [message #486969] |
Tue, 21 December 2010 15:57 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Is there a way to find out when a datafile for an undo tablespace with autoextend enabled actually extended? I've done a few tests, and nothing is written to the alert log or any trace file that I've found. I can't find any V$ or DBA view that will give me the history of a file's size.
Probably a simple question, but I can't find the answer.
|
|
|
|
|
Re: When did a datafile autoextend? [message #487046 is a reply to message #487019] |
Wed, 22 December 2010 03:20 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Thank you, but log miner does nothing for me: I can extract details of manually issued commands to resize datafiles, but not automatically generated commands.
I looked at the alert system too, but I can't get anything out of that either.
|
|
|
|
Re: When did a datafile autoextend? [message #487082 is a reply to message #487063] |
Wed, 22 December 2010 10:28 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Well, I can't get anything out of logminer that describes file extension. Segment extension, yes: that is described as updates to seg$, though only for data segments, not undo segments. But nothing for the files. So I guess I'm stuck: no way to tell when an undo tablespace extended. You can get an approximation by looking at dba_hist_tbspc_space_usage.
|
|
|