2007年02月_jiawancai

转载 Opt_param: a new optimizer hint for 10gR2

"OPT_PARAM" is a new optimizer hint introduced in 10gR2. This hint behaves the same way as setting a parameter (e.g, using alter session) but the effect is for the next statement only. Two IN params a

2007-02-27 21:56:00 931

原创 put your own progress information in V$SESSION_LONGOPS

If only more developers used the DBMS_APPLICATION_INFO package. As a DBA I often see requests to investigate why a particular job is taking longer than expected, or to kill a session running a partic

2007-02-27 21:50:00 1131

转载 show log file info and log switches

column day format a16 heading Daycolumn d_0 format a3 heading 00column d_1 format a3 heading 01column d_2 format a3 heading 02column d_3 format a3 heading 03column d_4 format

2007-02-27 21:38:00 996

转载 How to return a long columns size

create or replace function getLongsize (p_query varchar2) return number as v_cursor integer default dbms_sql.open_cursor; i number; v_temp varchar2(250); v_returne

2007-02-24 22:02:00 624

转载 Retreive new hashvalue and display their load

alter session set nls_territory=france;alter session set nls_numeric_characters=", ";WITHp AS ( SELECT to_date(24/01/07 06:00,DD/MM/YY HH24:MI) /* First start date to compare */ b

2007-02-14 13:26:00 759

转载 Quick check of asm disk space

#!/bin/bash. /home/oracle/set_oraenvsid="+ASM1"echo "Check Space on "$sidexport ORACLE_SID=$sidasmcmd lsdgEOF !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

2007-02-14 13:23:00 630

转载 Complete sessions information

SELECT SID, serial#, username, (SELECT holding_session FROM dba_waiters WHERE waiting_session = s.SID AND ROWNUM = 1 AND holding_session NOT IN (

2007-02-14 13:20:00 699

转载 List sessions and some details about them

set linesize 145set pagesize 1000set trimout onset trimspool onSet Feedback offset timing offset verify offpromptprompt -- ----------------------------------------------------------

2007-02-14 13:18:00 707

转载 How to divide a data set into equal size buckets

Install scripts:drop table INTERVALS/create table INTERVALS(NAME varchar2(100), sal number(10,2))/insert into intervals(NAME,sal)select object_name, dbms_random.value(0,100) from all_objects/commit//*

2007-02-07 21:09:00 660

转载 db duplication (and datafile renaming)

* jijo.sql|| mauro rossolato, 2006|| || >>> FOR DB DUPLICATION || you can use RMAN (copy) or operating system copy command (dd or ocopy)|| In addition creates a controlfile creation script.|| |||| Ma

2007-02-07 21:04:00 720

转载 Quickly check the i/o throughput

SET linesize 132 pagesize 1000column file_name format A60DROP TABLE tmp_iostats_1;REM *** get first snapshot ***create table tmp_iostats_1 as select SYSDATE snaptime,D filetype,t.* from

2007-02-02 13:04:00 505

oursoft的专栏