51CTO博客开发
qq QQ 全世界国家和地区代码获取 java 实现
oracle 11g在线重定义 普通表变分区表
ORE install in linux , including connect db
Install R language to windows is very easy, but install R language to linux platform is a complex job which need guide, so I write it down here.
Use udev rules to bind local disk to raw devices.
Oracle Backup And Recovery Lab. There are some viedo, if you have any advances could send mail to me. The mail address in the viedo.
udev for oracle asm
This is a sql script run in sqlplus. You could see the scn on your oracle db using this sql script. All versions available.
Copy this script to /etc/rc.d/init.d/oracled and chmod +x /etc/rc.d/init.d/oracled, then run the command: service oracled start, chkconfig oracled on, everything would be OK.
Backup policy on linux
A sql script to check interval of log switching。
For installing oracle 11.2.0.3 and RHEL5.8 64, prepare os some operation and permissions. Modify the Oracle_SID by yourself!!!
Use tools dbms_xplan.display_cursor() to see the cursor in library cache in shared pool.
There are two method to recreate EM, This is an good example for recreating EM by command line.
Here, it is a good example for your study oracle 11gR2. 11gR2 Preinstallation Operations On RHEL6.2 64bit Only, maybe RHEL6.3 64bit
Installation Guide for Oracle 11g R2 on Linux RHEL5.4 32bit
SQL analytic function, here is basic one.....
Collecting Practical SQL select statements, to be continue......
Load 1 million data into a flat file, Here using three methods. Comparing with them to know how the pipelined function and parallel to effect the performance.
rsync in linux, it is a easy way to backup your data with this command.
Trigger DDL , some skill
after suspend in trigger.
Trigger for DDL. Do not forget the attribute you could use when it is triggered.
Create a insead of trigger for DML view, you had batter do not use DML to view frequently.
sys_context could afford many information about environment variables, which could be used in trigger or sql statement.
Export data as text mode. Here I introduce two methods to export data as text mode with an specified format for sql loader or external table. Obviously, UTL_FILE is faster.
An accident, when I manipulate the huge table, I use too much redo logfile, but the redo logfile size is too small, then errors this come out.
Table Function, use the cursor expression as the input parameter, nested table as the output, then use table function transfer the output to a table, It is a stream, do not cost huge PGA. Eventually, the parallel for DML work best. If you want to know about what is the Table Function and Pipelined, You should see my this blog.
It is easy to understand that, this option in package header is means whether collection is kept in buffer when a anonymous block end or not.
Copyright © 2005-2023 51CTO.COM 版权所有 京ICP证060544号
