ITPub博客

1.建立SQL TUNE任务 SET SERVEROUTPUT ON DECLARE l_sql_tune_task_id VARCHAR2(100); BEGIN l_sql_tune_task_id := DBMS_SQLTUNE.create_tuning_task ( sql_id => 'aaz58jt1sgjk3', scope => DBMS_SQLTUNE.scope_comprehensive, time_limit => 60, task_name => 'aaz58jt1sgjk3_tuning_task', description => 'Tuning task for statement aaz58jt1sgjk3.'); DBMS_OUTPUT.put_line('l_sql_tune_task_id: ' || l_sql_tune_task_id); END; /[@more@]2.执行任务，并查看执行状态EXEC DBMS_SQLTUNE.EXECUTE_TUNIN

RMAN-06207: WARNING: 11 objects could not be deleted for DISK channel(s) dueRMAN-06208: to mismatched status. Use CROSSCHECK command to fix statusRMAN-06210: List of Mismatched objectsRMAN-06211: ==========================RMAN-06212: Object Type Filename/HandleRMAN-06213: --------------- ---------------------------------------------------RMAN-06214: Datafile Copy /u01/backup/ORCL_20110907_data_D-ORCL_I-1288914708_TS-SYSAUX_FNO-3_0dmlv7ia.bakRMAN-06214: Datafile Copy /u01/backup

Redhat Linux的网络配置，基本上是通过修改几个配置文件来实现的，虽然也可以用ifconfig来设置IP，用route来配置默认网关，用hostname来配置主机名，但是重启后会丢失。相关的配置文件/ect/hosts 配置主机名和IP地址的对应/etc/sysconfig/network 配置主机名和网关/etc/sysconfig/network-scripts/ifcfg-eth0 eth0配置文件，eth1则文件名为ifcfg-eth1，以此类推一、网卡配置假设我们要配置主机名为test，eth0的IP地址192.168.168.1/24，网关地址192.168.168.250则/etc/sysconfig/network文件内容如下：NETWORKING=yesHOSTNAME=testGATEWAY

oracle数据库字符集设置的查询语法Oracle客户端NLS_LANG设置1. NLS_LANG 参数组成NLS_LANG参数由以下部分组成:NLS_LANG=<Language>_<Territory>.<Clients Characterset>NLS_LANG各部分含义如下:LANGUAGE指定:-Oracle消息使用的语言-日期中月份和日显示TERRITORY指定-货币和数字格式-地区和计算星期及日期的习惯CHARACTERSET:-控制客户端应用程序使用的字符集通常设置或者等于客户端(如Windows)代码页 或者对于unicode应用设置为UTF8在Windows上查看当前系统的代码页可以使用chcp命令:E:>chcp 活动的代码页: 9362. 查

create or replace procedure smp_d as begin Delete from sfcs_defects_backup where org_id=51 and i_time<sysdate-90;Commit;end; DECLARE X NUMBER;BEGIN SYS.DBMS_JOB.SUBMIT ( job => X ,what => 'smp.smp_d;' ,next_date => to_date('22/03/2011 12:00:00','dd/mm/yyyy hh24:mi:ss') ,interval => 'sysdate+1' ); SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || to_char(x));COMMIT;END;/SQL> select job,next_date,next_sec,failures,broken from user_jobs; JOB NEXT_DATE

SQL> select segment_name,bytes/1024/1024/1024 Gb from dba_segments where segment_type='TABLE' and bytes/1024/1024/1024>=1 order by bytes/1024/1024/1024 desc;SEGMENT_NAME GB---------------------------------------- ----------SFCS_SN_SITE_STATISTICS 56.75KP_KEYPART_RUNCARD 23.75CELL_SORT_INFO_BY_CUSTOMER 20.7246094WIP_RUNCARD 12.75KP_KEYPART_FLEX

stcsapp:ora103:/ora103 >lscfg -vpl hdisk2 hdisk2 U789D.001.DQD5P31-P1-C6-T1-W203500A0B847E174-L0 IBM MPIO DS4800 Array Disk Manufacturer................IBM Machine Type and Model......1815 Serial Number...............600A0B800047E174000004654B4BF27D EC Level....................0914 Device Specific.(Z0)........50 PLATFORM SPECIFIC Name: disk Node: disk Device Type: block[@more@]----------DS4800----------Logical Drive "ARRAY2_LUN

umount /dev/xxxsmtty fs --del fssmtty vg --del hdisk0516-016 for aixmigratevg hdisk2 hdisk5migratevg hdisk3 hdisk5rmdev -dl hdisk2 -Rrmdev -dl hdisk3 -Rvaryoffvg stdoradata[@more@]

10g em中给出了memory advisor，其中如果设置了sga_target的值的话，那么该顾问通过图表的形式给出的是sga的建议值，该建议值是如何被计算的呢，其实是通过下面公式：select sga_size,100* round(((estd_db_time1 - estd_db_time)/estd_db_time1),2)from (select sga_size,estd_db_time ,(select estd_db_time from v$sga_target_advice where sga_size_factor=1) estd_db_time1 from v$sga_target_advice where sga_size_factor<>1order by sga_size)[@more@]通过上面查询可以获得sga_size以及db_time的改善百分比，在excel中以sga

　　alter any cluster 修改任意簇的权限 　　alter any index 修改任意索引的权限 　　alter any role 修改任意角色的权限 　　alter any sequence 修改任意序列的权限 　　alter any snapshot 修改任意快照的权限 　　alter any table 修改任意表的权限 　　alter any trigger 修改任意触发器的权限 　　alter cluster 修改拥有簇的权限 　　alter database 修改数据库的权限 　　alter procedure 修改拥有的存储过程权限 　　alter profile 修改资源限制简表的权限 　　alter resource cost 设置佳话资源开销的权限 　　alter rollback

查看当前用户的缺省表空间　　SQL>select username,default_tablespace from user_users; 　　查看当前用户的角色　　SQL>select * from user_role_privs;　　查看当前用户的系统权限和表级权限　　SQL>select * from user_sys_privs;　　SQL>select * from user_tab_privs;　　查看用户下所有的表　　SQL>select * from user_tables; 查看用户下所有的表的列属性 SQL>select * from USER_TAB_COLUMNS where table_name=:table_Name;　　显示用户信息(所属表空间)　　select default_tablespace,temporar

find . -name "*.aud" -print|xargs rm在系统中如果想用tar打包时，有时会遇到：0403-027 The parameter list is too longfind . -name "*.aud"| cpio -ocB > aud.cpiofind详解：http://www.linuxsir.org/main/?q=node/137[@more@]

OS check for AIX6.1-----------------------------#Collect NMON Data5 0 * * * /worktmp/nmon/nmon.ksh //通过nmon工具进行系统性能监控#!/bin/kshcd /worktmp/nmon/nmon -s 300 -c 287 -F /worktmp/nmon/daily_`hostname`_`date +"%Y%m%d"`.nmon -f -d -texit 0[@more@]0,15,30,45 * * * * /root_cmd/checkdiskspace.sh > /dev/null 2>&1 //监控磁盘的使用#!/bin/shLOG_FILE=/tmp/d_log`date +%Y%m%d`echo >>$LOG_FILEecho "***************************************** check disk space *************

// 执行跳过，跳过的结果在 execute dbms_logstdby.skip(stmt => 'DML',schema_name => '%', object_name => '%'); stmt的取值可以是： http://download-west.oracle.com/docs/cd/B14117_01/appdev.101/b10802/d_lsbydb.htm#997290 // 跳过的内容记载在下面 select * from dba_logstdby_skip // 停止apply [@more@]alter database stop logical standby apply; alter database abort logical standby apply; // 执行apply alter database start logical standby apply; // 实时apply alter database start logical standby apply

•–b 当file存在并且是块文件时返回真 •-c 当file存在并且是字符文件时返回真 •-d 当pathname存在并且是一个目录时返回真 •-e 当pathname指定的文件或目录存在时返回真 •-f 当file存在并且是正规文件时返回真 •-g 当由pathname指定的文件或目录存在并且设置了SGID位时返回为真 •-h 当file存在并且是符号链接文件时返回真，该选项在一些老系统上无效 •-k 当由pathname指定的文件或目录存在并且设置了“粘滞”位时返回真 •-p 当file存在并且是命令管道时返回为真 •-r 当由path

DBNEWID UtilityPrior to the introduction of the DBNEWID utility alteration of the internal DBID of an instance was impossible and alteration of the DBNAME required the creation of a new controlfile. The DBNEWID utility allows the DBID to be altered for the first time and makes changing the DBNAME simpler. Changing the DBID is necessary when you want to use an RMAN catalog to backup a cloned instance. RMAN identifies instances using the DBID, preventing the original and cloned instance being mana

#############################################################################RMAN 增量备份优化 for ORACLE 10G#############################################################################1.未打开块改变记录，进行差异增量备份，测试如下：SQL> select status from v$block_change_tracking; STATUS----------DISABLED$ rman target /Recovery Manager: Release 10.2.0.4.0 - Production on Thu Dec 23 14:23:06 2010Copyright (c) 1982, 2007, Oracle. All rights reserved.connected to target database: ASRSLC (DBID=4

OS Info----------# cat /etc/redhat-releaseRed Hat Enterprise Linux Server release 5.5 (Tikanga)# cat /etc/issue.netRed Hat Enterprise Linux Server release 5.5 (Tikanga)Kernel r on an m# uname -rm2.6.18-194.el5 x86_64# echo $MACHTYPEx86_64-redhat-linux-gnu# cat /proc/cpuinfo|grep "model name"model name : Intel(R) Core(TM) i7 CPU 950 @ 3.07GHzmodel name : Intel(R) Core(TM) i7 CPU 950 @ 3.07GHzmodel name : Intel(R) Core(TM) i7 CPU 950 @ 3.07GHzmod

1.shutdown immediate2.startup mount3.rename file:alter database rename file '/ora104/oradata/APPSTB/users01.dbf' to '/ora104/oradata/FAB1STB/APPSTB/users01.dbf';alter database rename file '/ora104/oradata/APPSTB/users02.dbf' to '/ora104/oradata/FAB1STB/APPSTB/users02.dbf';alter database rename file '/ora104/oradata/APPSTB/users03.dbf' to '/ora104/oradata/FAB1STB/APPSTB/users03.dbf';alter database rename file '/ora104/oradata/APPSTB/users04.dbf' to '/ora104/oradata/FAB1STB/APPSTB/users04.dbf';alt

col job_name format a30col LAST_START_DATe format a40select job_name,last_start_date from dba_scheduler_jobsJOB_NAME LAST_START_DATE------------------------------ ----------------------------------------AUTO_SPACE_ADVISOR_JOB 29-NOV-10 10.00.02.408609 PM +08:00GATHER_STATS_JOB 29-NOV-10 10.00.02.442664 PM +08:00FGR$AUTOPURGE_JOBPURGE_LOG 30-NOV-10 03.00.00.143774 AM ASIA/TAIPEIMGMT_STATS_CONFIG_JOB 01-NOV-10 01.01.02.003099 AM +08:00MGMT_CONFIG_JOB 29-NOV-10 10.00.02.520259 PM +08:00RLM$SCHDNEGA