Submitted by Graham on Wed, 2006-04-26 10:12
Submitted by Graham on Tue, 2006-04-25 16:37
java to get the name of the instance for a db on the local host
(uses shell script similar to the srvcheck solution)
import java.net.InetAddress;
import oracle.ops.mgmt.database.Instance;
import oracle.ops.mgmt.database.ParallelServerConfig;
import oracle.ops.mgmt.operation.GetConfigurationOperation;
import oracle.ops.mgmt.operation.GetConfigurationResult;
public class ClusterLocalInstance {
private static final String USAGE = "checks to see name of local instance for provided db name";
Submitted by Graham on Fri, 2006-04-21 14:32
java to quickly list rac dbs or check if a db is in the rac db list
import oracle.ops.mgmt.operation.ListParallelServersOperation;
import oracle.ops.mgmt.operation.ListParallelServersResult;
public class ClusterCheck {
private static final String USAGE = " no args lists all cluster dbs\n 1 arg checks to see if that db is clustered";
Submitted by Graham on Tue, 2006-04-18 17:54
Metalink article 262353.1
essentially
select count (distinct dbms_rowid.rowid_block_number(r.rowid)) "used blocks", blocks "below hwm", empty_blocks "above hwm"
from <table_name> r, dba_tables
where table_name = '<table_name>'
group by blocks, empty_blocks;
Submitted by Graham on Fri, 2006-03-31 17:14
copy /b SrcFile1+SrcFile2 [+SrcFileN] DestnFile
Submitted by Graham on Tue, 2006-03-14 12:03
Subject:Â Prevent Deadlock in Existing Parent- Child Tables By INDEXING PK and FKÂ
Doc ID:Â Note:16428.1
Submitted by Graham on Fri, 2005-06-24 18:07
the class you've specified cannot be loaded - you're not being silly and trying to load an abstract class are you?
