- 博客(25)
- 收藏
- 关注
RSS订阅转载 CGML
I saw this from OTN and found it very useful...every programmer wants to be a lazy one, me too...[@more@] ...
2009-05-19 06:19:00
222
转载 PGA details --- From itpub.net
PGA分两种管理模式：1) 手动PGA内存管理，用户指定排序区和散列区所使用的内存，每个连接使用相同的内存。2) 自动PGA内存管理，告诉Oracle可以使用的PGA的总量，由Oraclce根据系...
2009-05-06 02:06:44
127
转载 Upgrade Oracle from 10.2.0.1 To 10.2.0.4
Steps to Upgrade Oracle from 10.2.0.1 To 10.2.0.4[@more@]/* Style Definitions */ table.MsoNormalTable {mso-style...
2009-02-25 06:24:09
133
转载 Rman实现数据库迁移 -- ZZ from itpub.net
(从库A迁移到库B)环境:服务器A:Oracle10.1.0.3+AS3服务器B:Oracle10.2.0.1+AS4[@more@]Rman实现数据库迁移(从库A迁移到库B)环境:服务器A:Oracle10.1...
2009-01-27 02:55:39
101
转载 Analytic Functions in Oracle
Analytic Functions in Oracle (http://www.akadia.com/services/ora_analytic_functions.html#Example:%20Calculate%20a%...
2008-07-22 07:00:01
118
转载 Recover a 9i database from RMAN backup
Recover a 9i database from RMAN backup[@more@]QUESTION=========We suffered a disk failure last week and have to re...
2008-06-24 14:42:01
112
转载 常用SQL
常用SQL[@more@]数据库各个表空间增长情况的检查：SQL>SELECT A.TABLESPACE_NAME,(1-(A.TOTAL)/B.TOTAL)*100 USED_PERCENTFROM (SELECT TA...
2007-12-04 07:51:03
82
转载 runInstaller core dumped
ERROR: Unable to convert from "UTF-8" to "646" for NLS! Bus Error - core dumped [@more@]$>ls /usr/lib/iconv |gr...
2007-11-17 00:25:16
116
转载 何去何从？
做了两年DBA，一直在问自己类似的问题。路在何方？34岁了。要在美国扎根，前面的路该怎么走？[@more@]做了两年DBA，一直在问自己类似的问题。路在何方？34岁了。要在美国扎根，前面的路该怎么走？1） 钻DBA技术，肯定可以...
2007-11-16 13:25:09
108
转载 VERITAS conflicts with ASM?
ASM could not find the diskgroup on VERISTA...[@more@]Subject: Create Partitions in Solaris and add them as disks...
2007-10-12 03:15:10
118
转载 Start up CSS for ASM instance creation
The CSS was killed and could not be started up. Got ORA-29701 error during ASM creation using dbca. I checked meta...
2007-10-11 07:20:33
79
转载 How to run GUI in Unix
To use DBCA to install an Oracle instance, you have to enable the Xterm. This article tells you how to use your wi...
2007-09-28 00:39:28
70
转载 Look inside ASM disk groups
In 10g, Oracle introduced a new kind of storage for its database product. Automatic Storage Management (ASM) is a ...
2007-09-27 06:56:50
96
转载 Linux Rescue Mode
When things go wrong, there are ways to fix problems. However, these methods require that you understand the syste...
2007-08-29 06:22:55
354
转载 Adding Swap Space
Sometimes it is necessary to add more swap space after installation. For example, you may upgrade the amount of RA...
2007-08-29 06:15:25
117
转载 To deal with Hanging sessions
1) Hanging sessions broken by network issue--find the sessions whose wait time has been over 10K seconds.--killl t...
2007-08-28 06:56:56
149
转载 To disable the '^H^H^H^H' characters in Unix when you press backspace
stty erase ^H(backspace)[@more@] ...
2007-08-28 06:28:17
83
转载 open database with corrupted reset logs
**********Warning*************Be careful and think, think, and think again before using this parameter!!!Backup th...
2007-08-28 06:25:27
130
转载 Get hardware data
1)uname -aSample output: SunOS oradev03 5.8 Generic_117350-46 sun4u sparc SUNW,Sun-Fire-V2402)ip addressnetstat -n...
2007-08-03 14:30:13
141
转载 System monitoring
1) check if a session is running2)check CPU and Memorytop[@more@] ...
2007-08-03 14:29:53
142
转载 Finding tips
1) Find some files and execute other commands on them;find / -name scpfind ./ -atime +2 -exec rm '{}' ';'2)Find wh...
2007-08-03 14:27:55
73
转载 告别基督教
2006年我受浸，2007年我告别基督徒生活，回归为自由思想者。[@more@]我不是无神论者，但也不再相信基督耶稣和圣经。我是在一次团契中听一位姐妹讲她和签证官吵架的感想后，突然发现基督徒的哲学架构原来是这么脆弱的不堪一击。1...
2007-08-03 14:25:18
511
转载 Imp/Exp-Basic rules
Always use the lower version to export.[@more@]Whenever you are moving data between different releases of the Orac...
2007-08-02 06:05:37
147
转载 Clone a Database
1, generate txt control file;2,edit the txt control file with the new name;3,edit init.ora file with the new name;...
2007-07-28 06:27:57
79
转载 ORA-12705 - Solutions
1. ORA-12705 with incorrectly specified NLS_LANG2. ORA-12705 with incorrectly specified ORA_NLSx3. ORA-12705 due t...
2007-07-28 05:41:52
76
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人