Re: What is Oracle's version of MS SQL Profiler

On Jun 25, 8:56 am, RS <rohithshe...@xxxxxxxxx> wrote:
On Jun 25, 9:49 am, "fitzjarr...@xxxxxxx" <fitzjarr...@xxxxxxx> wrote:

On Jun 25, 8:36 am, RS <rohithshe...@xxxxxxxxx> wrote:

Does Oracle have its version of Profiler.

Thank you.

What, exactly, are you attempting to do? What do you want to
accomplish?

David Fitzjarrell

Tracking code path of a stored procedure (find out what is being
executed). I'm new to Oracle coming in from Sql Server. Profiler is
what I use to debug stored procedures and track performance.

Thanks

There is dbms_profiler, however the code must be instrumented with
calls to this package before you'll see any 'benefit'. There is also
event 10046 which can be set at the session level, so 'see' what the
session is doing (including the SQL queries). If you're using the
Cost-based optimizer (CBO) event 10053 can be set to reveal the
decisions it is making with respect to the queries submitted. Explain
plan can reveal what the optimizer will likely do with a given query,
and, from the SQL> prompt (with the proper privileges and roles)
autotrace can be set to provide query plans and query statistics but
it won't provide much information (if any) for stored procedures,
functions or packages.

Oracle also provides Enterprise Manager (not the same as what you're
used to with SQL Server) which can provide similar information through
a GUI. Depending upon which release of Oracle you're using there is
also Statspack (which can capture stats at varying intervals) and AWR
(automatic workload repository -- requies a separate license). You
can visit:

http://tahiti.oracle.com

for the online documentation and

http://www.psoug.org/library.html

to find working examples of packages and procedures supplied by
Oracle.


David Fitzjarrell

.

Relevant Pages

  • Re: Migrate SQL Server Stored Procedures
    ... SQL Server uses Transact-SQL as a language and Oracle uses PL/SQL. ... > How can I migrate all SQL server Stored Procedures to Oracle adn Oracle ...
    (microsoft.public.sqlserver.programming)
  • Re: Get all stored procedures
    ... Does anyone know the specific select for Sql Server and/or Oracle to get the ... >> Is there a way under ADO .NET to get all stored procedures in a database. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Migracion de Oracle a SQL2000 Server
    ... stored procedures are not going to be compatible with SQL Server. ... I know the people at DBBest have tools and expertise migrating from Oracle ... > Migra todos los datos y objetos?. ...
    (microsoft.public.sqlserver.dts)
  • Re: Please help!! How to get parameter back in ADO.NET
    ... Jet/Access, SQL Server, Oracle, 3x5Card? ... Note the OUTPUT parameters ONLY work with stored procedures. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: IOT, memory and transaction time
    ... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle ... were pretty consistent no matter how big the table (this transaction ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... Oracle provides read consistency and SQL Server ...
    (comp.databases.oracle.misc)