I got a chance to drop a 4TB size table on dictionary managed tablespace (DMT), this table comes from a very old design, and the partition design is not good for data purge, and delete cannot catch up...
When installing Oracle RAC on VMWare hosts, I don't want to install any desktop management system (both KDE and GNOME) for Oracle installer or other Java based configuration tools, it will make the VMWare host too big and...
I created a 4GB disk for the first node, choose the minimum installation of OS (RedHat Advanced Server 4 Update 5), and then installed the development packages and X-Window packages. But for the second node, I just created...
When installing Oracle RAC or database software, you need to make some changes to the Linux kernel parameters. # For Oracle 10g RAC kernel.sem=250 32000 100 128 kernel.shmmax=1048576000 kernel.shmmni=4096 kernel.shmall=2097152 fs.file-max=65536 net.core.rmem_default=262144 net.core.rmem_max=262144 net.core.wmem_default=262144 net.core.wmem_max=262144 net.ipv4.ip_local_port_range=1024 65000 Just...
I were doing some Oracle tuning jobs in last two weeks, and got a SQL like following : INSERT /*+ APPEND */ INTO B SELECT /*+ PARALLEL(A,4) FULL(A) */ SEQ_B.NEXTVAL, A.* FROM A;...
I am writing some DBA scripts with perl, one of them is the archive log file related. I have to implement this feature for more works. The first version is implemented by UNIX find command. # # Get...
When managing a lot of databases, finding a good policy to manage the archive log files is very important to make the work easy. Usually archive log files are placed on dedicate volumns, purge by space will help...
The SQLULDR2 improved the support of unloading in delimited and fix length text file. There are some difference for the SQL*Loader (sqlldr) control files. Here is a sample control file for delimited format. LOAD DATA INFILE 'uldrdata.txt' "STR...
I did a performance comparation of Oracle datapump, export and SQLULDR2 on a linux machine, the CPUs' frequency is 3G HZ. When running exp and SQLULDR2, the relative process take almost 100% of one CPU, so for data...
It's quite easy to display database data with WebChart utility. After loading the oramon performance data into database, I create a sample WebChart page to show the performance data, following is the CPU utilization chart. We...
