Question about Oracle RDBMS - help me please?
I get constantly confused about Oracle. What is a database and an instance? Which of these stores the "real information"? And what about the redo logs, etc? Can someone help me clarify these please? Many Thinks.
- 1 decade agoFavorite Answer
Oracle Database is Oracle Files + Oracle Memory (known as SGA)
Oracle Instance is Oracle Memory (known as SGA)
Both store real information
Oracle database files consists of
1. Datafile (file that store your records)
2. Redolog file (and archived redo log files, to undo and redo database changes)
3. controlfiles (to keep track of oracle status, condition)
4. and other files (binary file - sqlplus, exp/imp, parameter file - setting of the database, alert files - database activity including error)Source(s): http://e-dba.blogspot.com
- hyunLv 44 years ago
Unix isn't a prerequisite for discovering Oracle RDBMS. you need to use homestead windows OS with Oracle RDBMS. here you may get Oracle understanding yet no longer able to apply the OS functionalities greater effectively. In unix, you are able to write an effective shell script for oracle,time table a script in crontab, able to set atmosphere variables for dissimilar databases by skill of working a single shell script, swap between diff clients, and many issues are there. in case you pick to benefit Oracle alongside with OS, initiate utilising unix OS with Oracle RDBMS.
- 4 years ago
What is in a RDBS?