FIELD NOTESTHE ORA-600 BLOGSearch /BROWSE THE FIELD NOTES
29 field notes / page 3 of 3
Recently one of my students asked me if there is any correlation between the AU size in ASM diskgroup and parameter db_file_multiblock_read_count. I made some tests but results are very strange. I have 4 same t
There is a new feature in Oracle Spatial 12c, called "Spatial Vector Acceleration". According to Oracle: One of the most notable improvements with Oracle Spatial and Graph 12c can be seen in performance increas
Hash and sort operations are perfomed in PGA. Quoting after the documentation: A sort operator uses a work area (the sort area) to perform the in-memory sorting of a set of rows. Similarly, a hash-join operator
Oracle Cost Based Optimizer consists of three main components: Query Transformer, Esitmator, Plan Generator. In this article I will try to show you some interesting features of the first component – Query Trans
Prowdząc niedawno optymalizację wydajności jednego RACa, natknąłem się na ciekawe zachowanie w trakcie parsowania zapytań odwołujących się w predykacie do typu TIMESTAMP – niecodzienne zachowanie dotyczy ustawi