P
Paul Koufalis
Guest
Peter and Mary are busy. This is Paul. 
proGetStack: the protrace. file is written to the processes working directory. If you run lsof -p | grep cwd you'll see the current working directory. In ProTop, the help screen is "h" (ProTop is case sensitive). Hit P and enter the PID of one of the agents. Then hit U to display the User Information Viewer. proGetStack will tell you the program stack trace of dot-ps. ProMon will tell you what tables and indexes are being used, assuming you have -tablerangesize and -indexrangesize set correctly as database startup parameters. If not, at the very least you'll see userIO data at the top - but take note to add -tablerangesize and -indexrangesize to your DB startup parameters.
Continue reading...
proGetStack: the protrace. file is written to the processes working directory. If you run lsof -p | grep cwd you'll see the current working directory. In ProTop, the help screen is "h" (ProTop is case sensitive). Hit P and enter the PID of one of the agents. Then hit U to display the User Information Viewer. proGetStack will tell you the program stack trace of dot-ps. ProMon will tell you what tables and indexes are being used, assuming you have -tablerangesize and -indexrangesize set correctly as database startup parameters. If not, at the very least you'll see userIO data at the top - but take note to add -tablerangesize and -indexrangesize to your DB startup parameters.Continue reading...