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: 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.
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.
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;.
mysql0.blogspot.com
My SQL: Date
http://mysql0.blogspot.com/2009/03/mysql-command.html
Monday, March 30, 2009. Mysql SELECT YEAR('2003-03-31');. Mysql SELECT YEAR('2003-03-31') 5;. Mysql SELECT NOW();. Mysql SELECT CURRENT DATE();. Mysql SELECT MONTH(NOW() AS m, DAYOFMONTH(NOW() AS d, HOUR(NOW() AS h, MINUTE(NOW() AS m, SECOND(NOW() AS s;. 3 31 1 53 38. Mysql SELECT DAYNAME('2000-01-01');. Mysql SELECT DAYOFWEEK('2000-01-01');. Mysql SELECT DAYOFYEAR('2000-12-31');. Mysql select (TO DAYS('2009-03-30')-TO DAYS('2009-03-01') ;. Mysql SELECT (TO DAYS(CURRENT DATE() -TO DAYS('2009-03-01') ;.
mysql0.blogspot.com
My SQL: MySQL Command Line 2
http://mysql0.blogspot.com/2009/09/mysql-command-line-2.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). Subscribe to: Post Comments (Atom). MySQL Command Line 2. View my complete profile.
mysql0.blogspot.com
My SQL: MySQL Command Line
http://mysql0.blogspot.com/2009/03/command-line.html
Monday, March 30, 2009. C: mysql -h [hostname] -u [username] -p [password]. Mysql show databases;. Mysql use [one database name];. Eg mysql use test;. To view Tables and Table Structure:. Mysql show tables;. Mysql desc [tablename]; = show columns from [tablename];. Mysql show index from test.zoo; (= show keys from test.zoo; ). AUTO INCREMENT is used to generate a unique identity. Mysql CREATE TABLE zoo (. MEDIUMINT NOT NULL AUTO INCREMENT. Name CHAR(30) NOT NULL,. Auto increment = 100. Mysql use mysql;.
jurongport.blogspot.com
Oracle: April 2009
http://jurongport.blogspot.com/2009_04_01_archive.html
Wednesday, April 1, 2009. The Oracle Password File ($ORACLE HOME/dbs/ orapw. Stores passwords for users with administrative privileges. One needs to create a password files before remote administrators (like OEM) will be allowed to connect. Follow this procedure to create a new password file:. Log in as the Oracle software owner. Run command on OS level:. Orapwd file=$ORACLE HOME/dbs/orapw$ORACLE SID password=. Shutdown the database (SQLPLUS SHUTDOWN IMMEDIATE). Adding users to Password File:.