Why We Need PCTFREE instead of PCTUSED at Index ?

by Unknown 8:05 PM

Basically, a table is a "heap". We stick data WHERE EVER. an index is a structure, we have...

Read More

Oracle Performance Tuning Best Advice #1

by Unknown 3:57 AM

The first important advance in Oracle optimization technology follows from a simple mathematical observation: You can't extrapolate detail...

Read More

Detect Gap on Oracle Data Guard 11gR2

by Unknown 7:09 PM

Gap can occur if LNS is unable to keep pace and the log buffer is recycled before the...

Read More

Manually Resolving Gaps - Oracle Data Guard 11gR2

by Unknown 7:24 PM

for simplicity, Gap is a range of archived redo logs that were created at a time when the standby...

Read More

Arsitektur Database Oracle (2)

by Unknown 12:26 AM

Background Proses Untuk memaksimalkan kinerja dan untuk mengakomodasi kepentingan banyak user, sistem Multiproses Oracle menggunakan proses yang disebut...

Read More

Arsitektur Database Oracle (1)

by Unknown 11:39 PM

Arsitektur Database Oracle terdiri dari 2 bagian: Instance Database Database Instance database adalah segala hal yang berhubungan dengan...

Read More