What are the components of Logical database structure of
ORACLE database?

Answer Posted / rameshkumar.k

The logical DB contains shared pool(library cache,data dictionary cache),data buffer cache,redolog buffer,java buffer and large pool.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to clone 9i Database on to 10g Database.

2088


How to select some columns from a table in oracle?

738


How to insert a record into a table?

838


What is oracle open database communication (odbc)?

759


how to do daily transactions with out sql* loader control file regesterd in apps?

1444


What are a query and state the different types of queries and their uses?

742


I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

3099


Can you assign multiple query result rows to a variable?

750


What happens to the current transaction if a ddl statement is executed?

773


what is the dual table in oracle?

737


How is it different from a normal table?

785


What are the ansi data types supported in oracle?

710


What is a server parameter file in oracle?

796


What happens to the data files if a tablespace is dropped?

807


How to start an oracle instance?

781