Dear All,
I want to implement AI on a 9.1b database. Before I actually do that I am trying to find how the AI extents are filled. My question is
Q: How can I tell what A1 extent is being used and how much space is left before it gets filled. I need to do this automatically, via a script, which might sample the extent usage every 30 mins. I know there are virtual system tables but where, if anywhere, is the info I require.
If any of you bright guys can help then I am all ears.
Harj
I want to implement AI on a 9.1b database. Before I actually do that I am trying to find how the AI extents are filled. My question is
Q: How can I tell what A1 extent is being used and how much space is left before it gets filled. I need to do this automatically, via a script, which might sample the extent usage every 30 mins. I know there are virtual system tables but where, if anywhere, is the info I require.
If any of you bright guys can help then I am all ears.
Harj