I am writing an Oracle performance tracking utility -- oramon. And I have finished the first version of it, to make it more powerful, I compiled a windows version binary for free download. What this utility do is query some data from Oracle performance views periodically and write them out to some OS files. Then we can analyze the Oracle performance problem with the data stored in these files.
As we cannot keep eye on the database server for whole a day, we should have a tool to track some data for later analyze. The another reason is that when you login to the database after get a performance complain, every seems fine, because the load spike time may be very short. As a DBA, this is not a reason that you cannot get it resolved.
Now you can try it, if you get a performance problem, just send the generated files to me, and tell me the time (no exact time required) you get bad performance, I can do some analyze remotely without accessing your database server. To use it, create an oracle user with select_catalog_role role granted.
For remote database, run the following command.
oramon -u username/password@tnsname [-v version]
For local database, run the following command.
oramon [-v version]
For Oracle 8i or 9i, specify "-v 9", "-v 10" for Oracle 10g. I promise you will be interested with this utility.
Comments (4)
You don't need to specify the "-v" option any more, it will be auto detected.
Posted by anysql | February 20, 2008 11:22 PM
Hi,
I was aiming to use your product OCIULDR for unloading data from Oracle. One of our tables has around 2995 rows.
When unloading the records I noticed that some columns that are supposed to be int have the varchar values. This is when using the csv format.
Has anyone encountered this problem before?
Thank you so much for sharing this product with us.
Any help would be greatly appreciated.
Thanks,
-swathi
Posted by Swathi sharma | April 10, 2008 2:53 AM
to sharma:
ociuldr does not generate strictly CSV format file, so if your column values contains "," character, then the columns mapping is broken.
Thanks for choose ociuldr as unloading tools.
Posted by anysql | April 10, 2008 10:56 AM
pls give me some sql commands for queries
Posted by azam | July 22, 2009 9:52 PM