In case you have an oracle exadata database machine, always use 100% percent for collecting optimizer statistics on your tables/schemas , in order to benefit from the smart scans .
http://uhesse.com/2012/07/04/no-smart-scan-with-auto_sample_size/
WAIT Clause for DMLs in 26.2
-
Oracle 26ai 26.2 now introduces the WAIT (and NOWAIT) Clause for INSERT /
UPDATE / DELETE / MERGE DMLs. We have had a WAIT Clause for SELECT FOR
UPDATE...
Acum o săptămână
Niciun comentariu:
Trimiteți un comentariu