Answer Posted / 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 |
Post New Answer View All Answers
What are the set operators union, union all, minus & intersect meant to do?
How do I manually uninstall oracle client?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
what is the difference between data migration and production migration.
Explain the use of show option in imp command.
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
How to download oracle database 10g xe?
How can we find out the current date and time in oracle?
What is the sid in oracle?
What is a dynamic performance view in oracle?
Explain the use of tables option in exp command.
How to rename a tablespace in oracle?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?