Alex Fatkulin

Oracle Database Technologist and OakTable Member.

[Alex Fatkulin @AlexFatkulin]

@MartinDBA I’m waiting for 7nm EPYC next year... have too much ECC RDIMMS which are not supported by TR.

[Alex Fatkulin @AlexFatkulin]

Second law of thermodynamics dictates that everybody should use "reply all" on spam emails sent to distribution lists.

[Alex Fatkulin @AlexFatkulin]

Exadata 12.2 TEMP I/O caching in flash... 0.2 ms latency on "direct path write temp"!

[Alex Fatkulin @AlexFatkulin]

@TanelPoder @analyticsmotion Maybe there is that much data in 1 month's worth of partitions (from 2005?...) but the query/example is a little bit ambiguous.

[Alex Fatkulin @AlexFatkulin]

@analyticsmotion @TanelPoder Isn't the table partitioned by day and the query only looks at a month's worth of data? This should be a 5ms query, not 5s query ;-)

[Alex Fatkulin @AlexFatkulin]

@sky_vst Though it does not work the other way around (ACFS wants ADVM volume).

[Alex Fatkulin @AlexFatkulin]

@sky_vst ext4 works too and likely any other FS will work as well.

[Alex Fatkulin @AlexFatkulin]

Always wanted to test if it actually works ;-)

[Alex Fatkulin @AlexFatkulin]

@TanelPoder Did not see kxfxContAdaptOff emitted on non-Exadata so I think it's Exadata only

[Alex Fatkulin @AlexFatkulin]

Exadata 12c Adaptive Offloading: yet another case when you may not see smart scans https://t.co/GHrVFBC7RM

[Alex Fatkulin @AlexFatkulin]

Be careful during OEL 7.3 install/upgrade due to microcode_ctl hang Doc ID 2271275.1

[Alex Fatkulin @AlexFatkulin]

Quick hint: use "crsctl start crs -wait" to see CRS startup progress.

[Alex Fatkulin @AlexFatkulin]

@kevinclosson Yep. 8 schema test. Last test is 2x threads per schema.

[Alex Fatkulin @AlexFatkulin]

@kevinclosson should be fixed now, google photos link quirks :(

[Alex Fatkulin @AlexFatkulin]

@kevinclosson oops let me fix this in a sec

[Alex Fatkulin @AlexFatkulin]

Some device on a network has a nasty ARP reply habit

[Alex Fatkulin @AlexFatkulin]

@ChrisAntognini das keyboards rock.... I've been using one for years :)

[Alex Fatkulin @AlexFatkulin]

@fritshoogland @MartinDBA @kevinclosson also I think the post somewhat confused ashift and recordsize => did not set recordsize properly too

[Alex Fatkulin @AlexFatkulin]

@fritshoogland @MartinDBA @kevinclosson Agree that you can't just run it all defaults vs ASM

[Alex Fatkulin @AlexFatkulin]

@fritshoogland @MartinDBA @kevinclosson so you double buffer and do full checksums and then wonder why CPU is higher than ASM? :-) Really?