Oracle analytic functions are great! There is a few of them which I like particularly and would like to post here. I always need to check ta...

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 ...