Profile cover photo
Profile photo
Adelva Jr
376 followers -
Learning from Sharing
Learning from Sharing

376 followers
About
Posts

Post has attachment

Post has attachment

Post has attachment

Post has attachment

Post has attachment
Why We Need PCTFREE instead of PCTUSED at Index ?
Basically, a table is a "heap". We stick data WHERE EVER. an index is a structure, we have to stick data where it belongs.

When we take an index block off of the free list -- it is "empty". We will then totally fill it up until we have to split it. It ...

Post has attachment
Oracle Performance Tuning Best Advice #1
The first important advance in Oracle optimization technology follows from a simple mathematical observation: You can't extrapolate detail from an aggregate. Here's a puzzle to demonstrate my point. Imagine that I told you that a collection of 1,000 rocks c...

Post has attachment

Post has attachment

Post has attachment
Detect Gap on Oracle Data Guard 11gR2
Gap can occur if LNS is unable to keep pace and the log buffer is recycled before the redo can be transmitted to the standby. so how can we detect gap on our Dataguard environment? some people use this method. SQL> archive log list; SQL> select  max(sequenc...

Dream More, Complain Less, Talk Less, Love Less, Argue Less, Hope More, Fear Less, Relax More, Worry Less, Believe More, Doubt Less, Play More, Work Less.
Wait while more posts are being loaded