DBA Tools |
|
Writing professional DBA tools and scripts for better DBA life |
|
Tips: Add to Google | Oracle DUL? | AUL License | WebChart | asyncdata | ociuldr
Contact: anysql©yahoo.com/anysql©126.com, MSN: loufangxin©msn.com, AIM: loufangxin
Protect the database connection information in SQLULDR2
Some departments need to extract rows from the production daily for busines analyze, so we decide to open the standby in read only mode for data extracting with database link. The database link can protect the database user...
How to change SQLULDR2 session level's parameters?
Somebody need to change the date type format (default, "yyyy-mm-dd hh24:mi:ss"), and change the numeric characters. For Oracle, you can run some "alter session set ..." commands to make the changes, so I add a new command line...
Get more than expected from oramon performance alert.
Now, we have more performance alert point than previously, we just had performance alert based on the load average and active sessions. I were wondering that we will receive too much performance alert and it may bother our...
Send oracle performance alert based on oramon performance data
For critical online transaction process database, it's very important to find out an effective way to monitor the database performance and alert the database performance problem. Because their are many concurrent sessions, any small problem can make the...
Deploy the new oramon version to production database hosts.
I was changing the code of oramon in recent few weeks, keeping on adding more useful performance data and removing useless performance data, it took me one month to finally release the new version of oramon, and deploy...
SQLULDR2 can compress the output file in GZIP format
Data compress can save a lot of storage for data archiving, GZIP is a good choise between the compress ratio and compress speed, many utilities support GZIP feature, such as rsync with "-z" option. I spent some days...
Load oramon performance data into database for further analyze
The "ANYSQL_OMON_RAW.log" of oramon generated files recorded some performance data for chart type display, but we need to load them into database first. You should create a table with the following structure. CREATE TABLE DATABASE_PERF_STATISTICS ( SID ...
Install and start oramon to gather performance data
oramon contains just one executable binary, no installation is required, just download and extract it. Usually we run this utility on database server side, so it can get the database server's OS load information, which can help you...
Gather and keep Oracle performance data with oramon
As a DBA, sometime we will get high load alert, usually a sudden load spike. After you take several minutes to login to the system, you will see that the load is quiet, when you want to find...
A light way Oracle performance tracking solution
Some DBAs set some alert value for Oracle performance tracking, but that's not enough. For database (not only Oracle) performance, we need gather the performance data, display and analyze the data. DBAs are the critical resource for database...
How to keep given gigabytes of archive log files with Perl
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...
Find archive log file by given sequence with perl
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...
AUL/MyDUL vs. Oracle DUL, which is better?
This year I got few cases that Oracle DUL cannot recover the data well for you, while AUL/MyDUL can do it well. In the following cases, you should choose AUL/MyDUL as the recovery tool. CLOB data...
Save 15 mins downtime by tuning the sequence.
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;...
Recover the table's index structure information.
AUL just focus on the data recovery, it does not generate the SQL of creating the indexes, but we can recover them. Just recover some kernel table's data and load them into new database, then run query to...
Recover the Oracle stored procedures' source code.
AUL just focus on the data recovery, it does not generate the source code of the stored procedures, but we can recover them. Just recover some kernel table's data and load them into new database, then run query...
Linux Kernel Parmaters for Oracle 10g RAC
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...
Mini VMWare Oracle RAC (3GB) on RedHat Linux
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...
Install the basic Linux X-Window for xterm
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...
Get Oracle DDL Script
A lot of DBAs are extracting DDL (table create) script with Toad and PL/SQL Developer utilities. But a lot of database are running on Linux or Unix hosts, and connections directly from desktop are not allowed, then it...
Personal Information
| Name | Fangxin Lou |
| Job | Oracle DBA |
| Loc | Shanghai China (+08:00) |
| Skype | anysql |
| MSN | anysql©live.com |
| AIM | loufangxin |
| anysql©126.com anysql©yahoo.com |