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

Gaute wrote:
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

Gaute wrote:
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

Gaute wrote:
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

Gaute wrote:
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

Gaute wrote:
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

Gaute wrote:
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

Gaute wrote:
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

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

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