Monthly Archives: April 2014

Why use Particioning ?

“If double his strength, divide him” writed Sun tzu, Oracle particioning is a matter of “divide and conquer” aproach to improving Oracle maintenance and SQL performance. Oracle partitioning has become the de-facto standard for systems over 500 gigabytes. without Oracle partitioning, databases can perform poorly and become unmanageable, SQL queries with full-table scans take lot of hours to complete, in a full scan, the smaller the Oracle partition, the faster the performance and serious problems occur:

Continue reading

Advertisements

Check alert log, monit alerts in alertlog?

One duty of DBA is to monit the databases often, one place with lot of value information is the alert log file,  errors and any other problems are writed to this file by the datbase.

What happend when u have lot of databases? this process can be a high spend of time. We have the solution.

Other day i configure scripts to atomatic check alert log files and send to dbas email box if any ORA appears.

Continue reading

Larry Ellison, the ‘god’ of Oracle II

El enfant terrible of Silicon Valley

Few senior executives of the tech world are as controversial as Ellison, loved by some and hated by others. Boy Giorgio Armani (fashion brand that usually wears) has earned the epithet bad boy terrible enfant Silicon Valley. Several of his relatives have stated that there is only one thing that exceeds his fortune: his ego.

Continue reading

Oracle BEST Practices I

A best practice is a method or technique that has consistently shown results superior to those achieved with other means, and that is used as a benchmark. In addition, a “best” practice can evolve to become better as improvements are discovered. Best practice is considered by some as
a business buzzword, used to describe the process of developing and following a standard way of doing things that multiple organizations can use.

ORACLE company write his own “Best Practices” here que can summarize in a list some:

Continue reading

Tips to get a dba job II

Like we talk in last post is a catch22, u need experience for get a good oracle dba jobs, would you pay someone a high salary, to operate, maintain, and run one of the biggest, most important pieces of your IT infrastructure if they didn’t have any experience?.

The hardest part will be landing that first DBA job. we try help to solve this, again some tips.

Continue reading