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|
|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
|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.
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