Select Any Dictionary vs Select_Catalog_Role

Allways we want give to a user access to data dictionary and system views, we find two  privileges to grant select any dictionary and grant select_catalog_role with both we acomplish with the job, but, why there two options? are the same options? no, they arent the same and one is not over. Is a role vs direct privilege and yes is diferent.

Continue reading

Advertisements

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

Storage Benchmark with Oracle ORION

Finaly we have easy oracle tool to do the job of testing IO performance, very easy to use. ORION (ORcle IO Numbers) mimics the type of I/O performed by Oracle databases, which allows you to measure I/O performance for storage systems without actually installing Oracle. It used to be available to download for a number of platforms from OTN, but since 11.2.0.1 is included in the “$ORACLE_HOME/bin” directory of Grid Infrastructure (GI) and database installations, download is no longer available.

Continue reading

Benchmark Oracle database to the end with HammerDB

We have new faster machine and need a performance test, we can write our scripts/querys that do the measure job,
and measure performance with a 3rd party monitor tool (nagios,zabbix,etc..), but here comes HammerDB for save our
time and do the benchmark. Want to measure only storage performance with out oracle? better use IOmeter.

Continue reading