Answer Posted / su
-Oracle is a database, you can store data(RDBMS, since it
follows more than 8 rule out of 12 proposed by E F Codd).
-Made up of memory structures and back ground processes.
-Memory structure - SGA (system global area) and PGA
(Process Global Area)
-Background Process are Database writer (DBWR) which
actually writes to the physical files (Data files), Log
Writer (LGWR) which writes to the physical log files
(important to get the database in consistent state if there
is a crash)
-Combination of memory structure and backgroung processes
gives us oracle instances , which is instrumental in
helping us work with the oracle database
:)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
How would you determine what sessions are connected and what resources they are waiting for?
What view would you use to determine free space in a tablespace?
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
What is db_recovery_file_dest in oracle? When do you need to set this value?
What is auto invoicing? : oracle accounts receivable
what are basic modules required to implement oracle application in any oraganisation?
what is semphore explian it?
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
Are These Dff's Flexible?
What is the sql query to find the employee who has Nth maximum salary?
difference of using cursor for loop and open,fetch,close.which one is better
Where in the Oracle directory tree structure are audit traces placed?