What is a Database instance ? Explain?
Answers were Sorted based on User's Feedback
Answer / sawant
A database instance (Server) is a set of memory structure
and background processes that access a set of database files.
The process can be shared by all users.
The memory structure that are used to store most
queried data from database. This helps up to improve
database performance by decreasing the amount of I/O
performed against data file.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / nishi
A database instance is a set of memory structures that manage database files. A database is a set of physical files on disk created by the CREATE DATABASE statement. The instance manages its associated data and serves the users of thedatabase.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / krishna mohan mishra
The database instance refers to a complete database
environment. It includes RDBMS software, table structure,
stored procedures and other functions. It is normally used
when administrators tend to describe multiple instances of
the same database. It is also called as environment in
technical terms.
---Krishna Mohan Mishra
Is This Answer Correct ? | 1 Yes | 2 No |
What is execute immediate in oracle?
How to loop through a cursor variable?
I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?
In which language oracle has been developed?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
How to call a stored procedure inside a trigger? Give an example.
3. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.
What is snapshot is too old? Give and example for better understand.
How to convert dates to characters in oracle?
How would you begin to troubleshoot an ORA-3113 error?
What are advantages fo Stored Procedures?