Re: where is PCTUSED in OEM?

Hi Alberto,

In the navigator window, right click the table you wish to modify. Select the View/Edit Details option.

Then select the Storage tab.

In the middle of the screen, you will find the PCTFREE (Percentage free space reserved for updates) and PCTUSED (percentage used space threshold for row insertion candidacy) options.

I don't know of any graphical tool that displays to the data block level.

Cheers

Richard

Alberto Garzas wrote:
>
> Hi!
>
> Where can I configure and change the PCTUSED, PCTFREE parameters in Oracle
> Enterprise manager? I am talking about Oracle 9i
>
> Does OEM show the state of the Oracle blocks?
> I mean, Does OEM show a graphical with all the Oracle block states?
>
> I have to make a graphical tool about this , I dont know if OEM has already
> this tool!
>
> Thank you very much!