oracle安装、配置和网络
文章平均质量分 77
jiawancai
IT
展开
-
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 · 674 阅读 · 0 评论 -
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 · 712 阅读 · 0 评论 -
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 · 769 阅读 · 0 评论 -
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 · 642 阅读 · 0 评论 -
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 · 776 阅读 · 0 评论 -
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 · 1015 阅读 · 0 评论 -
Capture the total CPU consumptions for an Instance
Create a file as bellow named cpu.sh--------------------:/u01/app/oracle=>cat cpu.sh for para1 in $*dotcpu=`ps -afe -o user -o pcpu -o comm -o args | grep $ORACLE_SID|cut -c10-14 |awk {ounces += $原创 2007-12-04 13:01:00 · 479 阅读 · 0 评论