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
DOCKER FUNDAMENTALS. Docker Fundamentals Session – Dec 1st and Dec 2nd -10:15 p.m to 11:45 pm IST ( 90 mins on both the days).
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.
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
INTRODUCTION TO AWS SECURITY.
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
DIFFERENCE BETWEEN ORACLE AND MySQL. Please refer previous article . DIFFERENCE BETWEEN ORACLE AND MySQL -03 In this article will see few more differences between ORACLE and MySQL. Differences between Oracle and MySQL SNO ORACLE MySQL 1 How to check metadata of table ? SYS>> desc <objectname> “;”… Read More
In this article will have a look on different database editions in ORACLE & MySQL . DATABASE EDITIONS IN ORACLE : ENTERPRISE EDITION (EE) : Most powerful with a vast array of tools and features of the largest corporation. STANDARD EDITION (SE) : Oracle SE… Read More