Re: Monitor DB Transactions

Refer to www.sqlpower,com.

The Zero Impact Sql and Service Level Monitor products are about to be released for Oracle.

The product line non-intrusively analyzes the SQL network packet flow to the database server for end-user SQL and service level performance monitoring. The product does NOT have to run on the database server, NOR on client workstations connected to the server.

The products require NO intrusive database server monitors, agents, probes, audits, middleware or proxy servers. NO agents are installed on end user workstations. Requires NO intrusive SGA reads.

The products require NO impact upon the database servers, network or end-users. The products require no connections to the database server and end-users connect directly to the database server (not the monitor). Product installation is a three step process that can be completed in a few minutes.

markp7832_at_my-deja.com wrote in message <7ov28j$fkf$1_at_nnrp1.deja.com>...
>In article <7ot7r4$5k7$1_at_nnrp1.deja.com>,
> yhpeh_at_my-deja.com wrote:
>> In one of my projects, I need to monitor real time all database
>> transactions in the Oracle dbms server in real time. The transactions
>> are filtered and transported to interested applications by messaging
>> servers. The constraints are real time monitoring, non intrusive
>> monitoring mechanism (avoid triggers and alerts) and remote
>monitoring.
>> Are there any tools or programs that meet the above requirements?
>> Alternatively, I can implement the program myself but I need some kind
>> souls to give me some pointers. Any references and books would help.
>>
>> Thanks.
>>
>> Sent via Deja.com http://www.deja.com/
>> Share what you know. Learn what you don't.
>>
>You can write a bunch of queries to read the v$ tables, but when the
>database hangs so do your queries.
>
>Oracle's enterprise manager does a lot of this but it is interactive.
>
>Precise software sells an Oracle database monitor that works by reading
>the SGA directly and not via SQL. It does not hang when the database
>experiences problems but I do not know what it any information you can
>select out of it to meet your particular requirements. But it might be
>worth a look. I do not have a number to give you, but I have an e-mail
>address of info_at_precisesoft.com We never followed up on the product.
>
>Platinum had a bunch of Oracle tools. You could check with them also.
>
>
>--
>Mark D. Powell -- The only advice that counts is the advice that
> you follow so follow your own advice --
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Fri Aug 13 1999 - 14:19:21 CEST