Monthly Archives: November 2014

Fast Index Creation, Save your time!

 

 

 

 

 

 

One day you face to create a very big table index, the creation time nearly 5-6 hours, but can we do something to speed up this index creation in Oracle database? yes, we can. Lets see some tips that help to speed up the task
and save lot of time.

Continue reading

Health Check tool: ORAchk

Want audit Oracle configuration fast, oracle long time ago create a rac database healtcheck called RACchk. The old RACchk, Oracle decided to extend the utility beyond rac, this software is a oracle scanning tool that look for configuration problems, and return a report showing health risk based on oracle best practices.

Continue reading