hi, basic oracle architecture is devided in 3 stages 1. storage structure

please explain database architecture..

Question Posted / rahul khanke

1 Answers
12610 Views
Infosys, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

Which is faster view or stored procedure?

895

Can 2 queries be executed simultaneously in a distributed database system?

1099

Is it possible for a table to have more than one foreign key?

993

Is coalesce faster than isnull?

916

What is sql character function?

1015

Explain 3 basic parts of a trigger.

1269

Is delete faster than truncate?

974

give the syntax of grant and revoke commands? : Sql dba

1098

Can you inner join the same table?

948

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

2036

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

1003

First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.

1553

How to test for null values?

999

What does bitemporal mean?

1020

Define the select into statement.

1002