Answer Posted / rahul khanke
hi,
basic oracle architecture is devided in 3 stages
1. storage structure
1. physical storage
a. data file
b. control file etc..
2.logical storage
a. tablespace
b. extents etc..
2. memory structure
a. SGA
b. PGA
2. process structure
1. mandatory process
a. SMON
b. PMON etc
2. optional process
and much more
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What are all the ddl commands?
How do you write a complex sql query?
What is the command used to fetch first 5 characters of the string?
explain the difference between bool, tinyint and bit. : Sql dba
Write the command to remove all players named sachin from the players table.
Why do we use cursors?
What is difference between stored procedures and application procedures?
Why do we use triggers?
Can we insert delete data in view?
how to dump a table to a file with 'mysqldump'? : Sql dba
What is varray in pl sql?
What are the advantages of pl sql?
How delete all data from all tables in sql?
What is pivot table in sql?
What is the difference between delete and truncate statement in sql?
