天空LP之城的个人资料

REDOLOG 切换一个有趣的现象 SQL> / SEQUENCE# STATUS---------- ---------------- 31 ACTIVE 32 ACTIVE 33 CURRENT SQL> / SEQUENCE# STATUS---------- ---------------- 31 ACTIVE 32 ACTIVE 33 CURRENT SQL> / SEQUENCE# STATUS---------- ---------------- 31 INACTIVE 32 ACTIVE 33 CURRENT SQL> / SEQUENCE# STATUS---------- ---------------- 0 UNUSED 32 ACTIVE 33 CURRENT SQL> / SEQUENCE# STATUS---------- ---------------- 34 CURRENT 32 ACTIVE 33 ACTIVE SQL> / SEQUENCE# STATUS---------- ---------------- 34 CURRENT 32 ACTIVE 33 ACTIVE

ASM striping FINE COARSE COARSE STRIPINGIt is used for all voluminous input/output, e.g. input/output operations on datafiles.The size of the coarse grained data stripes is large.It manages the load balance across the disk groups.The size of the coarse-grained stripe is always equal to the size of ASM Allocation Units (AU).The size for coarse striping can be set using the _asm_ausize parameter. FINE GRAINED STRIPINGIt is used for all small input/output, e.g. input/output operations on online redolog files and control files.The size of the fine grained data stripes is small.It spreads the load on disk groups reducing latency for certain file types.The size of the fine-grained stripe is always 128 KB.The size for fine grained striping can be set using the _asm_stripesize parameter.

OEM 口口口口爱，百度是一楼

11gR2 new features in OTN 一楼百度

pl sql loop BEGIN FOR i IN 3..500 LOOP -- i starts at 10, ends at 1 INSERT INTO T1 VALUES (i,i); -- statements here execute 10 times END LOOP; END; /

share pool的一个比较详细的文章一楼百度呀

利用UDEV服务解决RAC ASM存储设备名 http://tieba.baidu.com/mo/q/checkurl?url=http%3A%2F%2Fwww.oracledatabase12g.com%2Farchives%2Futilize-udev-resolve-11gr2-rac-asm-device-name.html&urlrefer=7486b22fb8a00d8ff1286980993fc4ec

ORACLE 11G 内存自动管理的机制背后 http://tieba.baidu.com/mo/q/checkurl?url=http%3A%2F%2Fwww.oracledatabase12g.com%2Farchives%2Fhow-does-sgapga-allocate-on-amm.html&urlrefer=006fef98872b9532207fc4abfb0981e0

starting sendmail too long redhat chkconfig –level 345 sendmail off

关于ORACLE中的CPU TIME 1楼百度

阅读一楼百度

redo log 大小和组数 redo log 比较大，可以保障在redo log切换时，之前的 redo信息已经大部分checkpoint过了，可以跳过等待。并且减少checkpoint的频率。 redo log 多组，checkpoint频率比较高，但是恢复起来时间就比较短。redo log切换时，下一组也一般完成了数据的checkpoint，由于组数较多。

英语学习 campaign作战，竞选restive 倔强的outskirts市郊

RMAN完成数据文件从文件系统到裸设备的迁移一楼送老百

Oracle 11g new features self gathering By default, the database uses deferred segment creation to update only database metadata when creating tables and indexes. Starting in Oracle Database 11g Release 2 (11.2.0.2), the database also defers segment creation when creating partitions. When a user inserts the first row into a table or partition, the database creates segments for the table or partition, its LOB columns, and its indexes.

redhat 关于mkfs和lvm的摘记 http://tieba.baidu.com/mo/q/checkurl?url=http%3A%2F%2Fhi.baidu.com%2Fvoostar%2Fblog%2Fitem%2Fc69164a793dc728dd04358d9.html&urlrefer=629d27a3768d65d476e216999d54522b http://tieba.baidu.com/mo/q/checkurl?url=http%3A%2F%2Fhi.baidu.com%2Fzpchen%2Fblog%2Fitem%2F1fe9613dad9496c97d1e710b.html&urlrefer=969f599f9926b4fd19665999047bdfde

redhat4 ftp 从Red Hat Enterprise Linux 3.0版本（以及WBEL中的版本）起，FTP服务器(wu-ftpd)不再随xinetd一起提供。它已经被vsftp所取代，并且可以从/etc/init.d/vsftpd启动，如下所示： # /etc/init.d/vsftpd start Starting vsftpd for vsftpd:[ OK ] 如果您希望在重新启动（重新引导）机器时启动和停止vsftpd服务，则可以创建以下的符号链接： # ln -s /etc/init.d/vsftpd /etc/rc3.d/S56vsftpd # ln -s /etc/init.d/vsftpd /etc/rc4.d/S56vsftpd # ln -s /etc/init.d/vsftpd /etc/rc5.d/S56vsftpd

一例数据库无法正常打开 SQL> startup ORACLE instance started. Total System Global Area 2686001108 bytes Fixed Size 454612 bytes Variable Size 687865856 bytes Database Buffers 1996488704 bytes Redo Buffers 1191936 bytes Database mounted. ORA-00600: internal error code, arguments: [kcratr1_lostwrt], [], [], [], [],[], [], [] A spurious ORA-600 [kcratr1_lostwrt] can occur during ALTER DATABASE OPEN preventing the database from being opened. This has been seen more often on HP-UX than other platforms. Workarounds: Set _two_pass=FALSE in the init.ora then try to restart the instance. This will force (the less performant) single-pass recovery and so avoid the spurious assert (which only executes on the 2-pass recovery codepath). SQL> alter database open;alter database open* ORA-16068: redo log file activation identifier mismatch SQL> alter database clear unarchived logfile group 1;数据库已更改。SQL> alter database clear unarchived logfile group 2;数据库已更改。SQL> alter database clear unarchived logfile group 3;数据库已更改。SQL> alter database open;数据库已更改。

关于FLASHBACK疑问在FLASHBACK数据库之后，相关的备份集，和归档文件是否能将数据库还原到FLASHBACK之后的状态？个人猜测是可以的

ASM学习 ASM实例的启停，需要找到ASM对应的，grid的$ORACLE_HOME,用当前bin下的sqlplus启动实例。 pfile: +ASM.__oracle_base='/oracle/database/u01/app/oracle'#ORACLE_BASE set from in memory value*.asm_power_limit=1*.diagnostic_dest='/oracle/database/u01/app/oracle'*.instance_type='asm'*.large_pool_size=12M*.remote_login_passwordfile='EXCLUSIVE'

TMP 61.164.40.59

强吧留名 RT

安装oracle 9204的错误在32位系统上安装64位的oracle软件，报了一大堆错误。看清操作系统位数是多么重要啊。

mysql 沙滩拾贝只有innoDB，BDB存储引擎的表可以采用commit和rollback的模式：窗口1： mysql> create table test( -> id int(3)) ENGINE=INNODB; Query OK, 0 rows affected (0.00 sec) mysql> SET AUTOCOMMIT=0; Query OK, 0 rows affected (0.00 sec) mysql> INSERT INTO test values(12); Query OK, 1 row affected (0.00 sec) mysql> select * from test; +------+ | id | +------+ | 12 | +------+ 1 row in set (0.00 sec) 窗口2： mysql> show tables; +-----------------+ | Tables_in_first | +-----------------+ | books | | gbk | | innoDB | | test | +-----------------+ 4 rows in set (0.00 sec) mysql> select * from test; Empty set (0.00 sec) 窗口1： mysql> commit; Query OK, 0 rows affected (0.00 sec) 窗口2： mysql> select * from test; +------+ | id | +------+ | 12 | +------+ 1 row in set (0.00 sec)

RAC GC BUFER BUSY WAITS 两个节点都要对同一张大表进行大量的插入和SELECT操作，解决方法：加入INST_ID字段，进行该字段上的分区。 http://tieba.baidu.com/mo/q/checkurl?url=http%3A%2F%2Fblog.oraclefans.cn%2Fbaishan1%2Fentry%2Fdba%25E6%2597%25A5%25E8%25AE%25B0_%25E7%25AC%25AC%25E4%25BA%258C%25E9%2583%25A8_9_3%25E6%259C%25887%25E6%2597%25A5_%25E5%2585%25B8%25E5%259E%258B%25E7%259A%2584rac%25E6%2580%25A7%25E8%2583%25BD%25E9%2597%25AE%25E9%25A2%2598&urlrefer=3a387d9d3e3b0462be2f0da66240b9cf

latch free http://tieba.baidu.com/mo/q/checkurl?url=http%3A%2F%2Fwww.dbtan.com%2F2010%2F05%2Flatch-free.html&urlrefer=c2bb5d8e68ab145682927de18d765b3a

redhat as3 oracle dbca dbca建库会无故的被弹出来或者HANG住。操作系统是32 bit的redhat as3，于是检查了ORACLE在该版本下的安装前提。检查软件包。 III. Environment: ================ 1. The first, critical, environment item is related to the gcc v2.96 and g++ v2.96 RPMs that were installed above. Run the following command (as the oracle account) to check the current gcc version... gcc -v If the command above returns any gcc version other than 2.96 or if the command fails, then run these commands as the root account: mv /usr/bin/gcc /usr/bin/gcc.orig mv /usr/bin/g++ /usr/bin/g++.orig ln -s /usr/bin/gcc296 /usr/bin/gcc ln -s /usr/bin/g++296 /usr/bin/g++ If the "mv" (move) command lines above return an error, it only means that your system did not have a pre-existing /usr/bin/gcc or /usr/bin/g++ to rename. 2. Required Environment Variables a.) LD_ASSUME_KERNEL=2.4.19 b.) THREADS_FLAG=native, to avoid Bug 3523046, "REDHAT 3.0 - UNABLE TO CREATE DATABASE USING DBCA" 经过上述操作，并且在$ORACLE_HOME的bin下relink all之后，一切正常了。

/dev/null mysql的文档看起来真吃力啊

buffer http://tieba.baidu.com/mo/q/checkurl?url=http%3A%2F%2Fbbs.cnscg.com%2Fthread-408804-1-3.html&urlrefer=3f76f59b493ddba2b4df9c304378b60c

Oracle 学习日摘开帖子

求一个直播的链接啊有的发一下吧？

请和谐此吧 RT