jurongport.blogspot.com
Oracle: ADDM
http://jurongport.blogspot.com/2009/06/addm.html
Monday, June 15, 2009. ADDM (Automatic Database Diagnostic Monitor) is used to diagnose database performance issues. Its analysis can be performed across any two AWR snapshots. Three ways to run ADDM analysis:. Option 1 , Running ADDM Using addmrpt.sql. SQL @$ORACLE HOME/rdbms/admin/addmrpt.sql. Listing the last 3 days of Completed Snapshots. Instance DB Name Snap Id Snap Started Level. Ctgbu2 CTGBU2 6611 14 Jun 2009 00:00 1. 6612 14 Jun 2009 01:00 1. 6613 14 Jun 2009 02:00 1. 6614 14 Jun 2009 03:00 1.
jurongport.blogspot.com
Oracle: Killing DBMS_JOB
http://jurongport.blogspot.com/2009/07/killing-dbmsjob.html
Thursday, July 30, 2009. To check scheduled job:. Scheduled dbms jobs.sql. Set line 200 pages 200. Col log user for a10. Col job for 9999999 head 'Job'. Col broken for a1 head 'B'. Col failures for 99 head "fail". Col last date for a18 head 'LastDate'. Col this date for a18 head 'ThisDate'. Col next date for a18 head 'NextDate'. Col interval for 9999999.000 head 'RunInterval'. Col what for a60. From dba jobs dj) j;. What Jobs are Actually Running. Select * from dba jobs running;. Col log user for a10.
mysql0.blogspot.com
My SQL: September 2009
http://mysql0.blogspot.com/2009_09_01_archive.html
Monday, September 7, 2009. MySQL Command Line 2. To check mysql software version:. Root@192.168.33.121(none)]- select version();. 1 row in set (0.00 sec). Root@192.168.33.121mysql]- INSERT INTO user (Host,User,Password) VALUES('%','nbpm',PASSWORD('nbpm') ;. ERROR 1364 (HY000): Field 'ssl cipher' doesn't have a default value. Root@192.168.33.121mysql]- INSERT INTO user (Host,User,Password,ssl cipher,x509 issuer,x509 subject) VALUES ('%','nbpm',PASSWORD('nbpm'), 'NULL', 'NULL', 'NULL');.
mysql0.blogspot.com
My SQL: MySQL Backup Script
http://mysql0.blogspot.com/2009/03/mysql-database-backup-script.html
Sunday, March 29, 2009. This script is used on Windows 2003 (MySQL 5.0). It uses mysqldump. To create a *.sql backup then sends a notification e-mail.It works online.Its Pre-Requisites are BLAT and GZIP, for e-mail and compression. ECHO = = = = = = = = = = = = = = = = = = = = = = = =. ECHO MySQL Backup Script. ECHO Description: This scrip does the following:. ECHO - Backs up the specified database. ECHO - Compresses the backup. ECHO - Backup dump @ d :backups. ECHO - Writes to a log file. If not exist %b...
mysql0.blogspot.com
My SQL: Improve Hard Disk Speed
http://mysql0.blogspot.com/2009/03/to-improve-hard-disk-speed.html
Friday, March 27, 2009. Improve Hard Disk Speed. If hard disk of your computer or. Is taking too much time to get the result, then to improve your hard disk speed you will need to configure a special buffer in the computers memory in order to enable it to better deal with interrupts made from the disk. This tip is only recommended if your computer or. Has 256MB RAM or higher. Run SYSEDIT.EXE from the Run command. Expand the system.ini file window. Press Enter to make one blank line, and in that line type.
northoaks2.blogspot.com
FireBird: Is it dangerous to run sweep on live database with active users?
http://northoaks2.blogspot.com/2009/01/firebird-faq.html
Tuesday, January 27, 2009. Is it dangerous to run sweep on live database with active users? Subscribe to: Post Comments (Atom). How to repair a corrupt Firebird database? Firebird SuperServer running at 100% CPU? Why are sweep and mend exclusive operations? Is it dangerous to run sweep on live database with.
jurongport.blogspot.com
Oracle: test
http://jurongport.blogspot.com/2009/09/test.html
Thursday, September 3, 2009. Subscribe to: Post Comments (Atom). View my complete profile.
northoaks2.blogspot.com
FireBird: January 2009
http://northoaks2.blogspot.com/2009_01_01_archive.html
Wednesday, January 28, 2009. How to repair a corrupt Firebird database? Disconnect users and disable incoming connections to the database. Make a copy of database file (or two copies) and work on that. Use GFIX with -v option to validate the database file. Use GFIX with -v and -f to do full validation. If problem is not too serious, you can try to backup the broken db and restore under a new name:. Use GFIX -mend to prepare corrupt database for backup. Use GBAK -c to restore backup to a new database.
jurongport.blogspot.com
Oracle: June 2009
http://jurongport.blogspot.com/2009_06_01_archive.html
Tuesday, June 16, 2009. Basically, AWR (Automatic Workload Repository) is an Oracle built-in tool that collects performance related statistics and derives performance metrics from them to track a potential problem. Unlike Statspack, snapshots are collected automatically every hour by a new background process called MMON and its slave processes. Be default, the collected data is automatically purged after 7 days. Col SNAP INTERVAL format a30;. Col RETENTION format a30;. Select * from dba hist wr control;.