whenever commit,checkpoint or redolog buffer is 1/3rd full
Latest Answer : LGWR writes:1) COMMIT/ ROLLBACK2) 1 MB of large transaction3) Before DBWR writes4) 1/3 of REDO LOG is full5) time out occurs6) Check Point encounters ...
Hi, I've recently commissioned a hosted system from a developer who has recommended using J2EE and Oracle. Their J2EE system is quite slick and works very well in preproduction. It uses annotations
Latest Answer : Changing VARCHAR2(255) to precise required width is good table design. Though it will not improve performance as such. ...
exp userid=system/manager file=expfile.dmp log=expfile.log full=Y compress=Y buffer=1000000If i do't mention compress & buffer parameter , then this query will run/not.
Latest Answer : Yes, exactly it will run perfectly because compress and buffer both are optional. ...
What do you do when tempdb is full?
There are about a 10,000 records in a table. A user 1 runs a query which is doing a full table scan. While doing the full table scan, user 2 changes some value x to y using a DML statement in record. What
Latest Answer : in full table scan, if another user updates the value for a given row does not affect the full table scan if the user finishes the update by the time the oracle reads that particular record will get updated value otherwise it has the old value. ...
If the large table contains thousands of records and the application is accessing 35% of the table which method to use: index searching or full table scan?
Latest Answer : To improve the performance we have to go for index searching. ...
