logs archiveIRC Archive / Freenode / #oracle / 2015 / August / 13 / 1
atriv
Xgc: truthfully i'd rather just drop the timezone completely and assume UTC throughout.
Xgc
atriv: Well, given that you were using tz, your result was off by 8 hours. It makes a big difference when you generate +4 instead of -4.
undah
any consensus on the 12.1.0.2 optimizer? just migrated production a couple of weeks ago, i've had to use _optimizer_ads_use_result_cache and i'm a bit paranoid about the new adaptive features in general as far as performance goes
set _optimizer_ads_use_result_cache=FALSE, that is - was seeing high "Result Cache: RC Latch" wait times
Dormir
undah: haven't seen a lot of performance related issues so far. our performance issues lately have been related to SQL profiles
undah
Dormir: as in, SQL profiles you kept from before the upgrade?
Dormir
undah: some were from before, some were after
« prev