DIFFERENCE BETWEEN ORACLE AND MySQL -01

Share via:

Post Views: 0

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.