Explain oracle instance.
- 1 Answers
- 1278 Views
- I also Faced
- E-Mail Answers
Answer / Anurag Chaturvedi
An Oracle instance is the runtime environment of an Oracle database. It consists of a SGA (System Global Area) and one or more background processes that manage various tasks such as recovery, memory management, and file I/O. The Oracle instance communicates with clients through SQL*Net protocol.nnWhen you start the database, both system global area (SGA) and background processes are allocated, creating an Oracle instance.
| Is This Answer Correct ? | 0 Yes | 0 No |
Is postgres faster than oracle?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
how can find the second max sal for every group(i.e i want group the data based on key and find the second max sal for every group
write sql query following source are EmpID, Salary 101 1000 102 2000 103 3000 I want the output format like following empid,sal,composite_sal 101 1000 1000 102 2000 3000 103 3000 6000
pls explain connect by prior with example and its real time use
Why is oracle database so popular?
What are the advantages of oracle?
defination of bitmap index
14. Display the item_cost and then round it to the nearest hundred, ten, unit, tenth and hundredth
There is a big table with "n" of rows and 40 + columns .It doesn't have primary key.How do you select the primary key. In other words how do you get the duplicate records.
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.
How to convert a string to a date in oracle database?
Oracle General 
