Re: Finding top 20 large objects/tables in database
- From: "LS Cheng" <exriscer@xxxxxxxxx>
- To: shastry17@xxxxxxxxx
- Date: Sun, 7 Oct 2007 19:27:50 +0200
Cant you get that information using DBMS_SPACE, DBA_SEGMENTS?
Thanks
--
LSC
On 10/7/07, Anant (DBA) <shastry17@xxxxxxxxx> wrote:
>
> Hi all,
>
> How to find the top 20 large objects/tables in production database. I
> found some script in google for that, but its going to create a stage table
> to do the sortings and atlast drops a table after giving the result. As our
> DB is in SOX..we will have problem. Can anyone please help me if you have
> any queries?.
>
> Thanks,
> Ann
>
Other related posts:
