Differences
This shows you the differences between the selected revision and the current version of the page.
| wiki:howto 2008/09/26 16:34 | wiki:howto 2012/01/12 23:24 current | ||
|---|---|---|---|
| Line 301: | Line 301: | ||
| - | ===== See the memmory usage ===== | + | |
| + | ===== See the memory usage ===== | ||
| Command: onstat -g seg | Command: onstat -g seg | ||
| Line 349: | Line 350: | ||
| + | |||
| ===== See if there is a Memory Shortage ===== | ===== See if there is a Memory Shortage ===== | ||
| Line 391: | Line 393: | ||
| - | If the bfr column is not increasing then the thread is probably not doing any work i.e. it's stopped. On most UNIX based systems this number can easily increase at over 5000 per second on multi-table queries. It obviously varies between machines but it is a good rule of thumb. Remember a rapid rate of climb only indicates the machine is working hard and not the SQL is efficient. | + | If the bfr column is not increasing then the thread is probably not doing any work i.e. |
| + | it's stopped. On most UNIX based systems this number can easily increase at over 5000 per second on multi-table queries. It obviously varies between machines but it is a good rule of thumb. Remember a rapid rate of climb only indicates the machine is working hard and not the SQL is efficient. | ||
| ===== Find the thread id for a session ===== | ===== Find the thread id for a session ===== | ||
| Line 436: | Line 439: | ||
| AP.idxname AND AP.tabid = 183 AND AP.constrtype = 'P' | AP.idxname AND AP.tabid = 183 AND AP.constrtype = 'P' | ||
| - | + | ||
| + | |||
| + | |||
| + | |||
| + | |||
| + | ===== Where is the next SERIAL value stored ===== | ||
| + | |||
| + | systabinfo.serialv | ||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
