Indexes – PCTUSED 0 Why???

PCTFREE and PCTUSED are the two space management parameters in manual management of blocks, that control the use of free space for inserts and updates to the rows in all the data blocks. The PCTFREE parameter sets the minimum percentage of the space in the data block to be reserved for possible updates to the … Continue reading Indexes – PCTUSED 0 Why???

OTN Forum SCN discussion

Got to see some interesting discussion on SCN number over OTN Forum.Below is the posted question " I want some light on instance and media recivery in context of SCN no How the following nos in v$database behaves and correlate each other for doing instance & media recovery. How oracle knows and correlate with this … Continue reading OTN Forum SCN discussion