In this post I will write the steps I took to configure a Physical Standby Database on two Ubuntu Hosts versions Breezy Badger or Dapper Dra...

Oracle employs a very nice compression algorithm on database block level which is quite efficient and can yield threefold compression ratio ...

I use the ANALYZE command to calculate quickly and to see what effect on the execution plan of a query the new statistics will have. The sta...

Cool and straightforward tutotrial to use when installing apex installation. There is a better version of this technology nowadays and will ...

Did you ever wanted to get the Data Definition Language of an object in Oracle from SQL*Plus. There is package called DBMS_METADATA which yo...