Category: oracle utilities

How to Detect Block Corruption in Oracle?

How to Detect Block Corruption in Oracle?

April 12, 2012 | By | Add a Comment

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 […]

Read More

Oracle Utility – isqlplusctl

Oracle Utility – isqlplusctl

October 14, 2011 | By | Add a Comment

Hi Friends, Today we discuss about isqlplusctl utility of Oracle. Use isqlplusctl to start and top the iSQL*Plus application server. The iSQL*Plus application server requires to be started before you can use iSQL*Plus utility of Oracle. Syntax Isqlplusctl   [start/stop] Parameters: Start Starts the iSQL*Plus application Server. Stop Stops the iSQL*Plus application Server. Example: To start […]

Read More

select for update

select for update

August 30, 2011 | By | Add a Comment

select for update in Oracle

Read More

Maxmem the undocumented Oracle Utility

Maxmem the undocumented Oracle Utility

January 20, 2011 | By | 6 Comments

maxmem the oracle undocumented feature utility for Unix and Linux

Read More

Undocumented Oracle Utility-dbhome

Undocumented Oracle Utility-dbhome

December 16, 2010 | By | Add a Comment

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 […]

Read More