SQL> SQL> CREATE OR REPLACE PROCEDURE AlterSession( 2 p_SessionString IN VARCHAR2) AS 3 4 v_CursorID INTEGER; 5 v_Dummy INTEGER; 6 BEGIN 7 v_CursorID := DBMS_SQL.OPEN_CURSOR; 8 9 DBMS_SQL.PARSE(v_CursorID, p_SessionString, DBMS_SQL.NATIVE); 10 v_Dummy := DBMS_SQL.EXECUTE(v_CursorID); 11 END AlterSession; 12 / Procedure created. SQL> SQL> column sysdate format a30 SQL> SELECT SYSDATE FROM dual; SYSDATE —————————— Jun…
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…
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…
set lines 132 set pagesize 3000 spool lob_mvmt select ‘alter table ‘ || table_name || ‘ move lob(‘|| column_name || ‘) store as ( tablespace pnet_data ) ;’ from user_tab_columns where data_type like ‘%LOB%’; spool off
Hello Buddy
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…
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” »
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” »
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” »
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” »
