Truncate Takes A Long Time -- Waits on RO enqueue [metalink ID 286363.1]
1. For 10g slow truncate issues, switch off the new feature and revert to 9i functionality model:
ALTER SYSTEM SET "_db_fast_obj_truncate"=FALSE SCOPE=BOTH;
or change the initora/pfile as appropriate.
2. If the performance is to be improved in 9i, try improving the throughput of DBWR.
Setting db_writer_processes can help.
New Tool: xstack - Completely Passive eBPF Linux Stack Profiling Without
Any Tracepoints
-
I just added another tool into my 0x.tools toolset: xstack is a
lightweight, completely passive stack profiler for Linux that uses eBPF
task iterators to s...
Acum 3 zile
Niciun comentariu:
Trimiteți un comentariu