Articles from October 2009
October 18, 2009 | Posted by Asher
1 Multiplexing the control file when using SPFILE
Firstly, Obtain the information of your control file
SQL> select * from v$controlfile;
STATUS
NAME
IS_
BLOCK_SIZE
FILE_SIZE_BLKS
/u01/oradata/helen/control01.ctl
NO
16384
430
/u01/oradata/helen/control02.ctl
NO
16384
430
also you can issue this command show parameter control_files to get the information of your control file.
Secondly, Make sure that your server is using [...]
Categories: Experiments, Oracle | 
Tags: | 
2 Comments »
October 17, 2009 | Posted by Asher
Who you cared about ?
Categories: Life | Tags: Life | No Comments »
October 16, 2009 | Posted by admin
How to use Google Chrome ?
Categories: Google | Tags: Google Chrome | No Comments »
October 15, 2009 | Posted by admin
Control File
The control file is a small binary file necessary for the database to start and operate successfully. Each control file is associated with only one Oracle database. Before a database is opened, the control file is read to determine whether the database is in a valid state to use.
A control file is updated continuously by the [...]
Categories: Oracle | Tags: | 1 Comment »
October 13, 2009 | Posted by admin
感情就像开车，什么车和什么乘客都是搭配着来的。你的车要去“幸福”的，人家想去“财富”，自然就不会搭你的车。也有的人想去“幸福”的，但觉得你还要去“奋斗”绕一圈太远，就自己打的走了。或者愿意跟着你的车绕一圈，但是发现你这车不好看，又没空调，就会再等一辆。你到了站台，别看到有那么多人就一定要停，上面可能根本没有属于你的乘客，没人上车你就果断地往前开，前面的站台会有人等，别浪费时间。如果你非要等非要拉上来一个，半路也会下去换车。而你现在就是这么一辆车，一辆外表普通的小巴，但是里面有最好的设施，有温度最适宜的空调，但这些你都不要告诉别人，只有想坐这辆车的人才会上来然后发现，如果有些人因为这些设施上来，最后也只能因为目的地不同而无奈下车。你这辆车会先到“奋斗”，然后“成功”，再到“财富”和“幸福”。告诉站台上的所有人，如果不想去“奋斗”的，不要上车，自己找直达的车，因为你要在那边停很久。
感情就像开车，什么车和什么乘客都是搭配着来的。你的车要去“幸福”的，人家想去“财富”，自然就不会搭你的车。也有的人想去“幸福”的，但觉得你还要去“奋斗”绕一圈太远，就自己打的走了。或者愿意跟着你的车绕一圈，但是发现你这车不好看，又没空调，就会再等一辆。
Categories: Life | Tags: | 3 Comments »
October 13, 2009 | Posted by admin
Backup the Oracle Control File
Categories: Oracle | Tags: Oracle | No Comments »
October 12, 2009 | Posted by admin
USER_TAB_MODIFICATIONS describes modifications to all tables owned by the
current user that have been modified since the last time statistics were gathered on the
USER_TAB_MODIFICATIONS describes modifications to all tables owned by the current user that have been modified since the last time statistics were gathered on the tables.
使用User_tab_modifications来获取数据表的DML过程：
1，SQL> select * from USER_TAB_MODIFICATIONS ;
no rows selected
2, SQL>insert into test values(1,’Asher’);
one [...]
Categories: Oracle | Tags: | 1 Comment »
New Comments