Author: Admin

get_vmstat_linux

Posted on By Admin No Comments on get_vmstat_linux

CREATE TABLE STATSUSER.STATS$TOTALUSERS ( MEASURED_DATE DATE, TOTAL_USERS NUMBER, ACTIVE_USERS NUMBER, UOCWEBSPHERE_USERS NUMBER, UOCSCRIPTS_USERS NUMBER ); CREATE TABLE STATSUSER.STATS$USERSESSIONS ( START_DATE DATE, SYSTEM_SESSIONS NUMBER, ACTIVE_USERS NUMBER, INACTIVE_USERS NUMBER, DEDICATED_SERVERS NUMBER, USER_SESSIONS NUMBER, TRANSACTIONS NUMBER ); CREATE INDEX STATSUSER.STATS$USERSESSIONS_STDTE_I ON STATSUSER.STATS$USERSESSIONS (START_DATE); /* Following procedure and shell program is for Solaris */ #!/bin/ksh # This is the…

Read More “get_vmstat_linux” »

Oracle, SQL scripts

get_vmstat_solaris

Posted on By Admin No Comments on get_vmstat_solaris

CREATE TABLE STATSUSER.STATS$TOTALUSERS ( MEASURED_DATE DATE, TOTAL_USERS NUMBER, ACTIVE_USERS NUMBER, UOCWEBSPHERE_USERS NUMBER, UOCSCRIPTS_USERS NUMBER ); CREATE TABLE STATSUSER.STATS$USERSESSIONS ( START_DATE DATE, SYSTEM_SESSIONS NUMBER, ACTIVE_USERS NUMBER, INACTIVE_USERS NUMBER, DEDICATED_SERVERS NUMBER, USER_SESSIONS NUMBER, TRANSACTIONS NUMBER ); CREATE INDEX STATSUSER.STATS$USERSESSIONS_STDTE_I ON STATSUSER.STATS$USERSESSIONS (START_DATE); /* Following procedure and shell program is for Solaris */ CREATE OR REPLACE PROCEDURE STATSUSER.vmstat3…

Read More “get_vmstat_solaris” »

Oracle, SQL scripts

272332.1 CRS 10g Diagnostic Collection Guide

Posted on By Admin No Comments on 272332.1 CRS 10g Diagnostic Collection Guide

CRS 10g Diagnostic Collection Guide =================================== This document contains guidelines for collecting diagnostic information from a CRS installation. The diagnostics listed in the sections below are necessary for development to be able to help with TARs, bugs and other problems that may arise in the field. CRS Collect all CRS log files, trace files and…

Read More “272332.1 CRS 10g Diagnostic Collection Guide” »

Oracle, RAC

284785.1 How to check RAC Option is currently linked into the Oracle Binary

Posted on By Admin No Comments on 284785.1 How to check RAC Option is currently linked into the Oracle Binary

Applies to: Oracle Server – Enterprise Edition – Version: 9.2 to 11.1 Information in this document applies to any platform. Goal The goal of this articale is to find whether rac option is linked into Oracle binary or not. Solution steps to check ——————————— 1.Go to $ORACLE_HOME/rdbms/lib 2.run the following command nm -r libknlopt.a |…

Read More “284785.1 How to check RAC Option is currently linked into the Oracle Binary” »

Oracle, RAC

556976.1 Oracle Clusterware: Components installed

Posted on By Admin No Comments on 556976.1 Oracle Clusterware: Components installed

In this Document Purpose Scope Oracle Clusterware: Components installed. What is the Oracle Clusterware? Components. Components creation. Conclusion. References Applies to: Oracle Server – Enterprise Edition – Version: 10.2.0.3 to 11.1.0.6 Information in this document applies to any platform. Purpose This document is aimed to explain the different parts of the Oracle Clusterware (sometimes also…

Read More “556976.1 Oracle Clusterware: Components installed” »

Oracle, RAC

276434.1 Modifying the VIP or VIP Hostname of a 10g or 11g Oracle Clusterware Node

Posted on By Admin No Comments on 276434.1 Modifying the VIP or VIP Hostname of a 10g or 11g Oracle Clusterware Node

In this Document Purpose Scope and Application Modifying the VIP or VIP Hostname of a 10g or 11g Oracle Clusterware Node Planning for VIP changes Verifying Current VIP configuration Stopping Resources Syntax for modifying nodeapps Starting Resources Back Up References Applies to: Oracle Server – Enterprise Edition – Version: 10.1.0.2 to 11.1.0.* Information in this…

Read More “276434.1 Modifying the VIP or VIP Hostname of a 10g or 11g Oracle Clusterware Node” »

Oracle, RAC

Kill a session dynanically using execute immediate

Posted on By Admin No Comments on Kill a session dynanically using execute immediate

In this Document Goal Solution References Applies to: PL/SQL – Version: 8.1.7.4 to 10.1.0.2 Information in this document applies to any platform. Goal This article presents one suggested way of killing a session using an “ALTER SYSTEM KILL SESSION ‘sid,serial#’ ” statement in PL/SQL dynamically where the sid and serial# are values being passed in…

Read More “Kill a session dynanically using execute immediate” »

Oracle, SQL scripts

How to start CRS manually

Posted on By Admin No Comments on How to start CRS manually

In this Document Purpose Scope How To Manually Start Oracle CRS Clusterware References Applies to: Oracle Server – Enterprise Edition – Version: 10.1.0.2 to 11.1.0.7 Information in this document applies to any platform. Information in this document applies to Unix platforms only. Purpose This article is intended for DBAs having problems to start the CRS…

Read More “How to start CRS manually” »

Oracle, RAC