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???
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
Today suddenly an issue popped up where in users started saying that 'APPLICATION SEEMS TO BE HANGING', the front end users were not getting the output on there screens.Whenever i hear things like query is slow or seems to have hanged , the first thing i check is the SESSION WAITS, and it was interesting … Continue reading library_cache_lock and library_cache_pin