How well can multiple sessions access the same data
simultaneously ?
Answer Posted / ganesh sawant from finacle
oracle allows many session to work simultaneously and store computer rescues. To have multiple session oracle has control concurrency i.e. maintain data integrity when multiple sessions access the same data at same time.
For example consider a railway reservation system where table is maintained and showing availability of reservation .
Oracle controls the concurrency using locking
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can we insert delete data in view?
How does postgresql compare to oracle/db2/ms sql server/informix?
What is sql partition?
what are myisam tables? : Sql dba
what is data control language? : Sql dba
Explain aggregate functions are available there in sql?
Can we insert data into materialized view?
How do I remove all records from a table?
What is hibernate and its relation to sql?
What does fetching a cursor do?
What is composite primary key in sql?
Can cursors be part of a trigger body?
what is a database? : Sql dba
Explain the working of primary key?
How is indexing done in search engines?