DIFFERENCE BETWEEN ORACLE AND MySQL.
- The Oracle Database is an object-relational database management system (ORDBMS).
- MySQL is an open source relational database management system (RDBMS).
Both the Oracle Database and MySQL are database management systems currently produced and managed by the Oracle Corporation. - The Oracle Corporation is a multinational computer technology corporation based in Redwood City, California, USA.
- It specializes in developing and marketing computer hardware systems and enterprise software products.
- The company also builds tools for database development and systems of middle-tier software, enterprise resource planning software (ERP), customer relationship management software (CRM) and supply chain management (SCM) software.
Here i’m listing 10 differences between ORACLE & MySQL.
Differences between Oracle and MySQL | ||
SNO | ORACLE | MySQL |
1 | The Oracle Database is an object-relational database management system (ORDBMS). | MySQL is an open source relational database management system (RDBMS). MySQL is the world’s most used RDBMS, and runs as a server providing multi-user access to a number of databases. |
2 | In Oracle, Database and schema have different meanings. | In MySQL, Database and schema are same. |
3 | In Oracle we have pfile and spfile to make changes to database(Parameters) | In MySQL we have my.cnf file to make changes (Variables) |
4 | Default location of Pfile or SPfile is $ORACLE_HOME/dbs Ex : cat $ORACLE_HOME/dbs/init$ORACLE_SID.ora |
Default location of my.cnf file is /etc/my.cnf. Ex :$ cat /etc/my.cnf |
5 | Oracle will run with default port 1521 | MySQL will run with default port 3306. port=3306 in my.cnf file |
6 | Oracle have Tablespace,Role Managment,Snapshots, Synonyms and Packages. |
MySQL does not have Tablespace, Role management, snapshots, synonym and packages. |
7 | Oracle requires username, password, and profile validation at the time of logging. Sqlplus / as sysdba For remote connection Ex : Sqlplus scott/tiger@tnsname Connecting to different databases on same server. net_service_name= (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=host1)(PORT=1630)) (CONNECT_DATA= (SERVICE_NAME=service_name))) Ex :sqlplus scott/tiger@net_service_name |
MySQL requires username, password, and host.(Mentioning host is not mandotory ) Ex : $mysql -uroot -ppassword To connect remotely. Ex :$ mysql -uroot -ppassword -h 192.168.0.150Connecting to different instances on same server. Ex :$ mysql -uroot -ppassword -h 192.168.0.150 -p 4205 Note :We need to use different port numbers to connect different instances. |
8 | In Oracle to check database details we have v$database dictionary views | In MySQL we have show databases command. Ex : mysql> show databases; |
9 | In Oracle to check currently connected session we use v$Session view |
In MySQL to check currently connected session we use
Ex : mysql> show processlist; |
10 | Oracle Support Pl-SQL, in addition to SQL | MySQL also support SQL & Pl-SQL. |
Thank you for giving your valuable time to read the above information. Please click here to subscribe for further updates
KTEXPERTS is always active on below social media platforms.
Facebook : https://www.facebook.com/ktexperts/
LinkedIn : https://www.linkedin.com/company/ktexperts/
Twitter : https://twitter.com/ktexpertsadmin
YouTube : https://www.youtube.com/c/ktexperts
Instagram : https://www.instagram.com/knowledgesharingplatform