- 博客(143)
- 收藏
- 关注
RSS订阅转载 guarantee restore points-Flashback after RMAN restore
记录下, 在rman restore后, guarantee restore points仍然可以使用would guarantee restore points be lost after the rman ...
2019-01-23 10:00:12
193
转载 判断standby日志是否同步primary
Verify standby STB_DB is in synch with Primary PROD_DB Confirm physical stan...
2019-01-08 15:39:39
355
转载 adrci -age后面的参数单位是分钟
echo "INFO: adrci purge started at `date`"AGE1DAY=1440AGE7DAYS=10080AGE10DAYS=14400AGE15DAYS=216...
2019-01-08 09:21:45
413
转载 并行处理 Parallel Processing
Parallel Processing当执行一个sql语句时,缺省是用一个cpu来连续执行,不管有多少个...
2019-01-04 17:03:59
1381
转载 性能分析大全
性能分析动态视图的3大类型Current State Views Counter/Accumulator Views Information Views...
2019-01-03 00:46:27
342
转载 (重要)关于性能的几个主要动态视图
Dynamic Performance ViewsOS Statistics 操作系统统计v$osstat对检测数据库服务器是否有其它应用在...
2019-01-01 10:14:45
630
转载 Learning MySQL and MariaDB
PART IIDatabase StructuresTo start, let’s create a database that will contai...
2018-12-30 22:54:10
450
转载 RAC中的并行查询 DOP(Degree of Parallelism)
以下查询显示在执行并行查询的session, 和DOP (degree of parallelism)WITH px_session...
2018-12-29 19:57:00
256
转载 Finding Trace Files v$diag_info & TKPROF
Finding Trace FilesTrace files are produced by database engine server processes running on the datab...
2018-12-29 12:18:14
128
转载 oracle.Performance.Tuning笔记
oracle.Performance.Tuning笔记 第二章 The Method Behind the Madness当出...
2018-12-25 03:10:46
246
转载 SCAN
1.1.1. SCANThe single client access name (SCAN) is the address used by all clients connecting to the cluster...
2018-12-21 10:10:33
121
转载 批量起停数据库脚本
unix 服务器上可能有10多个数据库，可以用脚本批量启动，停止： start_all_dbs.sh， shutdown_all_dbs.sh.[@more@]******************************...
2013-05-02 15:59:15
98
转载 Oracle 11g Default Schemas
http://www.oracle-wiki.net/startdocsdefaultschemasACKGROUNDWhen an 11g database is created without tweaking any ...
2013-04-24 11:04:27
335
转载 Database Clone by rebuilding control file.
前面我们用了rman 里的duplicate方法去在本机clone个db, 这里我们用CREATE CONTROLFILE 方法在另一台服务器上Clone. 缺点是用这个方法clone， 需要shutdown 原数据库，传输da...
2013-04-23 15:21:01
100
转载 nohup not working, another way to get the script run in the background
echo "/path/scriptname.sh"|at now[@more@]echo "/path/scriptname.sh"|at now ...
2013-04-18 17:15:30
92
转载 批量改文件名
使用for 循环，sed给文件批量改名。[@more@]FILES=/u04/oradata/BBBC1DF7/*for f in $FILESdo echo "***************************" ec...
2013-04-17 10:39:52
94
转载 scp 在后台运行
如果scp的文件很大，想让scp在后台运行。通常我们要建立ssh 信任关系，不用输入密码以让scp在后台运行，但可能没条件建立public key，两台机器无需密码，比如root身份。用以下方法可以让不需要建立ssh信任，而让s...
2013-04-12 17:46:57
665
转载 oracle JRE issue using runInstaller
In AIX, use below command to run installer, but always says jre issue. ...
2013-04-12 13:45:02
250
转载 Date 格式化 in Unix
bash-4.2$ DATE=`date +%Y-%m-%d`bash-4.2$ echo $DATE2013-04-11[@more@]*****************************************bash...
2013-04-09 16:00:00
115
转载 Install db in silent mode
First, please remember that the most difficult part is not this installation, but the preparation for this install...
2013-03-29 17:09:35
164
转载 Clone a database on the same server
How to clone a db on the same server:1. First to determine the existing db's datafiles, controlfiles location. And...
2013-03-29 17:06:53
97
转载 Create database manually
1. first create directories for oradata and core_dump_dest etc, set ORACLE_HOME, ORACLE_SID in .profle and creat...
2013-03-29 16:39:45
119
转载 X windows for Unix
https://www.ibm.com/developerworks/mydeveloperworks/blogs/paixperiences/entry/remotex11aix?lang=enForward GUI inst...
2013-03-29 16:25:42
182
转载 Oracle audit
Audit CREATE PROFILE Audit CREATE SESSION ...[@more@]查看哪些privs设置audit了。SQL> select * from DBA_PRIV_AUDIT_OP...
2013-03-20 17:16:32
69
转载 shell 脚本读多个oracle_sid
shell 脚本读多个oracle_sid， 并连接数据库的脚本[@more@]#! /bin/kshset -xexport oratab_file=/var/opt/oracle/oratabexport ORACLE_HO...
2013-03-15 11:20:25
403
转载 Oracle RESETLOGS 和 NORESETLOGS 区别说明
resetlogshttp://blog.youkuaiyun.com/tianlesoftware/article/details/7753546[@more@]一．创建控制文件时：Resetlogs和Noresetlogs当我们将控制文...
2013-03-04 23:14:49
69
转载 imp,exp
here are some examples on exp/imp:[@more@]1. after drop the user, use below to create first. create user cog84cs i...
2013-03-04 17:24:17
81
转载 Oracle Flashback技术总结
http://www.cnblogs.com/coohoo/archive/2011/01/16/1936888.html通向架构师之路--Victor Guan ...
2013-03-02 06:27:06
53
转载 Cursor游标，Ref Cursor
http://hi.baidu.com/edeed/item/e6ba1fddb94bb0f793a97486PLSQL中显示Cursor、隐示Cursor、动态Ref Cursor区别 今天简单的总结一下PL/SQL中...
2013-01-18 17:35:27
84
转载 优化scenarios
1. 外键的列没加索引，当对主表键进行DML, 会锁住整个子表。...........................[@more@] Normal 0 false false ...
2013-01-17 15:45:52
107
转载 外键有必要加索引
Expert Oracle Database Architecture死锁的头号原因：不加索引的外键(第6章.锁)[@more@]http://www.cnblogs.com/angzi/archive/2006/12/...
2013-01-16 15:27:45
379
转载 ITL(Interested Transaction List)
一、ITL描述： ITL(Interested Transaction List)是Oracle数据块内部的一个组成部分， 位于数据块头（block header），itl由xid(Transaction XID)，ub...
2013-01-16 10:31:34
260
转载 Oracle Profile and PASSWORD_VERIFY_FUNCTION
ALTER PROFILE default LIMIT PASSWORD_LIFE_TIME 90 PASSWORD_GRACE_TIME 5 PASSWORD_REUSE_TIME 100 PASSWORD...
2013-01-15 16:45:20
492
转载 Oracle中的SCN详解
pre.Oracle中的SCN（system change number）和我们的北京时间的意义是相同的，SCN是Oracle中的时间号。 为什么Oracle不用时间来界定呢？我在北京时间8：00的时候执行一...
2013-01-15 15:33:01
924
转载 Histograms
Histograms 就是柱状图在你不收集Histograms信息的时候如果存在一个表 表中的记录从1到9，一共900条记录由于没有收集Histograms信息oracle会假设记录是平均分配的 就是说1有100...
2013-01-15 10:24:28
189
转载 PLSQL questions
here are some general questionsPL/SQL Questions: 1. Describe the difference between a procedure, function and ano...
2013-01-13 15:26:30
162
转载 recover database until cancel using backup controlfile
recover database until cancel using backup controlfile的一些知识点。[@more@]QAPROD_arch15342.dbf 已经在归档地址，但用rman里的recover提...
2013-01-10 15:10:20
479
转载 oracle 监听
The listener supports no serviceshttp://tc.itkee.com/database/detail-cba.html[@more@]lsnrctl start提示:The listener ...
2013-01-10 14:18:57
58
转载 shell 的判断
#!/bin/shfile=/u03if [ "${file}" = "/u03" ]thenecho the filename is /u03#!/bin/shfile=/u03if [ "${file}" = "/u03" ...
2013-01-10 11:00:50
53
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人