HOW TO CHECK INDEX FRAGMENTATION. When a database is frequently updated via UPDATE, or DELETE statements we can expect it to become fragmented over the time. If database indexes are fragmented, the SQL query optimizer may chose a non-optimal execution plan when using an index to… Read More
Startup & Shutdown process in Oracle Apps in R12. STARTUP PROCESS 1.Start Database Tier Services –Start Database Listener $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/addlnctl.sh start <listener_name> –Start Database $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/addbctl.sh start or alternatively you can use lsnrctl start/stop <listener_name > sqlplus “/as sysdba” SQL> startup Then 2.Start Application/Middle Tier Services… Read More
BACKUP AND RECOVERY IN MySQL USING MYSQLDUMP UTILITY. Please Refer the previous article. BACKUP AND RECOVERY IN MySQL (Article -17). Using mysqldump utility we can take the backup of only data(ignoring structure ) Check the databases list.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | ctg | | mysql | | performance_schema | | sys | | trg | | trg2 | +--------------------+ 7 rows in set (0.00 sec) |
To take the backup of only data… Read More
There is no excerpt because this is a protected post.
There is no excerpt because this is a protected post.
There is no excerpt because this is a protected post.
There is no excerpt because this is a protected post.
BACKUP AND RECOVERY IN MySQL. What is backup ? Backup is nothing copying the data into another location . Why we need backup ? If you’re storing anything in MySQL databases that you do not want to lose, it is very important to make regular backups… Read More
Oracle vs MySQL DBA Checklist/Tasks Note : Proper Documentation which is very important in order to save time and act on issue immediately. DB health check list for Day to Day Activities. Differences between Oracle and MySQL SNO ORACLE MySQL 1 –> Check Alert… Read More
DIFFERENCE BETWEEN ORACLE AND MySQL -05 Please refer my previous articles. DIFFERENCE BETWEEN ORACLE AND MySQL -04 In this article will see few more differences between ORACLE and MySQL. Differences between Oracle and MySQL SNO ORACLE MySQL 1 In Oracle ,we need to write Parameters to set (or)… Read More
