D
Dmitri Levin
Guest
George I believe there are two ways to look at database log files. One is browsing it like a DBA would do and an other one is parsing log file with a tool. For parsing it with a tool PSC added time stamps, PID and other info. Browsing log file on a system that has thousands of users by a human DBA is very difficult. That is why the suggestion came at the conference to make it easy for a rank-and-file DBA to see a system-wise issues with the database. May be PSC could come up with something that works for both, a human DBA reading the log for database issue and a script parsing the log for a specific code issues. For example dbanalys in 11.4 has two outputs, one for human reading and an other one for load into Excel and further processing. May be PSC could leave the current log as it is for script processing and create a new "short" log for critical database wise issues ( which couldl probably just exclude connect/disconnect ).
Continue reading...
Continue reading...