Re: why administrator refuse to give permission on PLUSTRACE

From: <fitzjarrell_at_cox.net>
Date: Fri, 26 Oct 2007 06:39:42 -0700
Message-ID: <1193405982.763710.125330@50g2000hsm.googlegroups.com>

Comments embedded.
On Oct 26, 7:21 am, zino <antony6..._at_gmail.com> wrote:
> why our DBA refuse to give us permission on PLUSTRACE ???

Don't ask that question here, ask your DBA to explain.

> does that role expose the database to any security flaw ???

Not to my knowledge.

> I need to set the AUTOTRACE to understand how the sql script is
> functionning, but our DBA refuse to give us permission to PLUSTRACE.

Again, ask your DBA.

> View that I'm new to oracle, is there other way to analyse what the
> script is doing other than setting AUTOTRACE.

Certainly. Use EXPLAIN PLAN:

explain plan
set statement_id = 'sometexthere' for
<your query here>;

select * from table(dbms_xplan.display);

You won't see the statistics that AUTOTRACE would produce but you will get the query plan.

> thanks for help

David Fitzjarrell Received on Fri Oct 26 2007 - 08:39:42 CDT