- 博客(8)
- 资源 (6)
- 收藏
- 关注
RSS订阅原创 oracle 10g sql tuning advisor 手工执行
1 单个sql 语句： (1)创建 sql tuning taskDECLARE my_task_name VARCHAR2(30); my_sqltext CLOB; v_bind_lst sql_binds;BEGIN v_bind_lst := sql_binds(anydata.convertnumber(1234),
2015-05-29 14:29:44
619
原创 在linux上安装oracle时的limit设定
oracle 10g database在linux安装时，设定oracle用户limit时：为何在pam模组里面添加了limit限制然后又要在login shell里面修改呢，这样相互的设定会被影响。经过测试login shell的设定会覆盖pam模组的设定To increase the shell limits:1. Add the following lines to the /etc/sec
2015-05-28 11:12:46
2534
原创 如何在awr里面查看 log file sync是否是由用户commit太多造成
根据Tanel Põder:Reasons for log file sync waits• Commits wait for log file sync by default• User commits• There’s an user commits statistic in v$sesstat• DDL（如,create table ，但是drop table不会有，可以
2015-05-26 13:47:15
2166
转载 Identifying shared memory segment users using lsof
by TANEL PODER posted on JANUARY 22, 2009Lsof (list open files) is a really useful tool for troubleshooting open file decriptors which prevent a deleted file from being released or a shared me
2015-05-21 22:02:37
466
转载 rlwrap for Command Line History and Editing in SQL*Plus and RMAN on Linux
rlwrap 依赖readline 及readline-devel。可以从redhat的安装光盘装rlwrap for Command Line History and Editing in SQL*Plus and RMAN on LinuxThe rlwrap (readline wrapper) utility provides a command history and e
2015-05-12 16:12:22
519
原创 修改asm_diskgroup无法生效
SQL> show parameter diskgroupNAME TYPE VALUE------------------------------------ ----------- ------------------------------asm_diskgroups
2015-05-11 10:07:57
912
转载 How To Use the Linux Fuser
How To Use the Linux Fuser CommandTags: System ToolsWhat Is The fuser Command?The fuser command is a very smart unix utility used to find which process is using a file, a directory or
2015-05-05 21:41:29
528
转载 Understanding Shared Memory and Semaphores
Understanding Shared Memory and SemaphoresSubmitted by Nidhi Jain on Mon, 2003-12-15 13:03 Operating Systemsby Nidhi JainShared memory and semaphores are two important resource
2015-05-04 22:33:26
510
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人