What is SGA ? How it is different from Ver 6.0 and Ver 7.0 ?
Answer / sawant
The System Global Area in a Oracle database is the
area in memory to facilitates the transfer of information
between users. It holds the most recently requested
structural information between users. It holds the most
recently requested structural information about the database.
The structure is Database buffers, Dictionary cache, Redo
Log Buffer and Shared SQL pool (ver 7.0 only) area.
Is This Answer Correct ? | 2 Yes | 0 No |
what are stored procedures?
how can get like this result table A col1 col2 --- ----- a A b B C C .. .. .. ... .. ... wants result like for a single column col1 ------ a,b,c,........n of data and another is col1 ------- A B C D ........ a b b d ........
What is an oracle database table?
Explain the use of full option in exp command.
what is integrity constrains?
5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
How would you begin to troubleshoot an ORA-3113 error?
How do I manually create a database in oracle?
What is a user role in oracle?
What is OCI. What are its uses?
I need to get the values of the previous quarter.how to do this?eg: if my cuurent month is may i need to get the datas of the month jan,feb,march.Can it be done in oracle.I tried with date function q but for the month jan its not retriving the previous quarter(oct-dec).how to solve this.plpz anyone help me?