You can pass multiple inst_id,SID tuples to the snapper though: ash 5 1 (2,1234),(4,5678),(3,999) Note that the brackets are important, as otherwise snapper thinks that you want to measure SID 2 and SID 1234 in the local instance. … it will still query only local instance’s sessions.īut if you want to measure all tanel’s sessions in let’s say instance #2 only, you can just add to the session filter condition: ash 5 1 if you want all instances then use ash 5 1 you want to measure a single session with sid 1234 in instance #2, you can do it in two ways: ash 5 1 use the inst_id,sid tuple syntax: ash 5 1 (2,1234) I have kept the syntax backwards-compatible, so when you run Snapper like this … ash 5 1 user=tanel I will keep adding new averages over the coming weeks. average bytes sent/received per roundtrip etc). Useful averages in the right side of the output (e.g.No need to use DBMS_LOCK to sleep for a certain number of seconds between snapshots Manually taken “before” and “after” snapshot support.RAC support (query remote instance’s sessions performance data via GV$).I have not updated the snapper documentation yet, but here are the main improvements: I have also uploaded the launch party hacking session video to : I have fixed most of the bugs that showed up during the Snapper launch party session and uploaded the new version (v4.02) of Snapper here:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |