Block Corruption in Oracle Analysis and Investigation of Corrupt Block in Oracle Database Oracle has four methods for detecting corruption. The analyze commend with the validate structure option can be used to verify the structure of a table, index, or cluster, and to confirm that a table and its indexes are in sync. The external [...]
Hi Friends, ORA-00600 is always annoying Oracle DBA. Of course, it does. Because always it has different symptoms with different version of Oracle. Some time it occurs due to Oracle bug and some time it occurs due to database corruption. It doesn’t have same reason, cause or resolution for different version of Oracle databases. ORA-00600 [...]
Parallel Operation in Oracle Server- Does it improve Performance or not pros and cons of parallel execution of Oracle.
5 points to be considerable in online oracle training course searching
Hi Friends, Today we are going to discuss one another undocumented Oracle utility called DBHOME. Yes I think you understood usage of utility as per it’s name. Usage of dbhome: For checking $ORACLE_HOME environment variable. This utility is very useful for getting location of Oracle home. We can use dbhome utility instead of “echo” command [...]
This is official Blog of Dbametrix Solutions. Dbametrix is group of companies for providing database services and database dba support to global client with exclusive remote support system using strong and transparent SLA and response time matrix with low cost plans.