Oracle 11 beginner questions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gaute - 01 Oct 2008 11:38 GMT

Hi

I am used to "SQL Server 2005" and have just installed Oracle 11. I wonder
how/where I can do "normal" things to find performance issues in my SELECT
quereries:

A) In "SQL Serve Profiler" I can see all my SQL queries from my program and
used time per query. How do you do this in Oracle?

B) In "SQL Server Mangement studio" I can write a query, rightclick and
select "Display estimated Execution Plan" to find for example which indexes
is in use. How do you do this in Oracle?

Best regards from Gaute

Reply to this Message

DA Morgan - 01 Oct 2008 14:57 GMT

> Hi
>
[quoted text clipped - 10 lines]
>
> Best regards from Gaute

In Oracle there are two major interfaces. For a beginner asking the
questions you are asking I would suggest DBCONSOLE, also known as
OEM or Oracle Enterprise Manager: The other is SQL*Plus.

Good places to start your exploration of Oracle are at:
http://tahiti.oracle.com
http://docs.oracle.com
http://asktom.oracle.com
http://www.psoug.org/library.html

And the best general advice I can give you ... Oracle is nothing like
SQL Server. Don't do anything until you read the concepts and
architecture books. Trying to make Oracle work like, or behave like,
a Microsoft product is as productive as trying to teach a pig to sing.

Daniel Morgan
Oracle Ace Director

Reply to this Message

Gaute - 01 Oct 2008 15:16 GMT

Thank you

Sqlplus "set autotrace on explain" solves my second question (B). I also
found it in "Oracle SQL Developer".

But is there a quick way to see all SQL queries sent to oracle from my
application with time per query?
I have been looking around in OEM without luck...

Best regards from Gaute

Reply to this Message

Gerard H. Pille - 01 Oct 2008 17:45 GMT

Gaute schreef:

> Thank you
>
[quoted text clipped - 6 lines]
>
> Best regards from Gaute

Activate trace and analyze the trace-file on the database-server with tkprof

Reply to this Message

fitzjarrell@cox.net - 01 Oct 2008 18:29 GMT

On Oct 1, 8:57 am, DA Morgan <damor...@psoug.org> wrote, among other
things:

> Trying to make Oracle work like, or behave like,
> a Microsoft product is as productive as trying to teach a pig to sing.
>
> Daniel Morgan
> Oracle Ace Director

This one seems to be doing an admirable job in the singing department:

http://www.youtube.com/watch?v=PP7aoPhED6U

David Fitzjarrell

Reply to this Message