Category: architecture

oracle table parameters pctused and pctfree – notes for the new oracle dba

you are a new oracle dba or developer and you are creating or managing tables and would like to know what the terms pctused and pctfree are and how they impact the space in a table block

transportable tablespaces – knowledge article for the new oracle dba

you are a new oracle dba and you would like to know about transportable tablespace limitations , transporting tablespaces between platforms with different endian format etc

shutdown abort and uncommitted changes – interesting article for the new oracle dba

came across this interesting discussion in oracle forums. As a new dba if you are wondering what happens to the uncommitted changes in case the database crashes or someone accidentally issues a shutdown abort then read on.

Oracle Table and Index Compression – Everything an Oracle DBA needs to know

Oracle Table and Index Compression – Everything an Oracle DBA needs to know

Oracle Clusters – for the new oracle dba

Learn all about Oracle Clusters – for the new oracle dba

ASM-Automatic Storage Management – for the new oracle dba career

A new oracle dba can learn about what ASM or Automatic storage management is. Grow your career

oracle database architecture – online reference

oracle dictionary views , parameters and concepts online reference