Oracle Scripts
jxzkin
这个作者很懒,什么都没留下…
展开
-
Oracle Script-GetHparDes.sql
set pagesize 9999 set line 130 col NAME for a20 col VALUE for a20 col DESCRIB for a80 SELECT x.ksppinm NAME, y.ksppstvl VALUE, x.ksppdesc DESCRIB FROM SYS.x$ksppi x, SYS.x$ksppcv y WHERE原创 2012-12-26 11:49:13 · 690 阅读 · 0 评论 -
Oracle-script-ShowEvents.sql
select event, total_waits, time_waited from v$session_event where sid = &sid order by 3 desc /原创 2012-12-26 11:51:32 · 557 阅读 · 0 评论 -
Oracle Script-ShowSessionWait.sql
set linesize 300 set pagesize 9999 col event for a50 select sid,event,wait_time from v$session_wait where sid=&sid order by 3 desc /原创 2012-12-27 09:07:16 · 644 阅读 · 0 评论 -
Oracle Script-Shell调用SQLplus输出结果
#!/bin/bash # Author:Zhang Jian # Date:2012/12/28 count=1 while [ ${count} -lt $1 ] do sqlplus -S kin/kin <<EOF spool /tmp/result.log @wait.sql spool off exit EOF coun原创 2012-12-28 09:43:12 · 1425 阅读 · 0 评论 -
Oracle incremental backup shell scripts
0备份脚本 #!/bin/bash # incremental level 0 backup script source /home/oracle/.bash_profile current_day=`date +%Y%m%d` mkdir /home/oracle/RMANBACKUP/$current_day rman target / <<EOF run {原创 2013-02-26 11:03:50 · 619 阅读 · 0 评论 -
Python-Excel+Oracle
import xlrd import cx_Oracle """ all indexs's number in excel begin with 0 """ __excel = xlrd.open_workbook(r"E:\areaid_list.xlsx") __table = __excel.sheet_by_index(0) __data = __table.col_values原创 2014-07-28 17:19:46 · 1634 阅读 · 0 评论 -
Oracle-hugepages_settings.sh
#!/bin/bash # # hugepages_settings.sh # # Linux bash script to compute values for the # recommended HugePages/HugeTLB configuration # on Oracle Linux # # Note: This script does calculation for all sha翻译 2016-05-11 15:15:29 · 773 阅读 · 0 评论