Somebody says they've improved the performance by sequence caching? what does it mean?
I understand that there'r multpile processes which tries to insert a table using seq.nextval and they'r ge...
http://www.experts-exchange.com/Database/Oracle/Q_21595332.html
Zones:
OracleDate Answered: 10/14/2005 Grade: A Views: 0
SQL> desc all_sequences
Name Null? Type
----------------------------------------------------- -------- ------------------------------------
...
http://www.experts-exchange.com/Database/Oracle/Q_21327311.html
Zones:
OracleDate Answered: 02/26/2005 Grade: A Views: 0
Hi.
I have an Oracle database backend to Sage, that has some sequences defined. As the caching of the sequence numbers has caused some problems, they were altered to have NOCACHE.
Yet it appe...
http://www.experts-exchange.com/Database/Oracle/10.x/Q_23196646.html
