user groups for oracle database

[Mike Yu]

Hi,

Can you recommand some other user groups or websites for discussion about Oracle Database?

[Marilyn de Queiroz]

http://www.oracle.com/technology/index.html

[Barbara Norway]

The Lazy DBA

and

technet (oracle)

and

SQL for Web Nerds

to name but a few....

[Mike Yu]

Thank you for replying to my question.
I felt that the documentation in Oracle's website is hard to use. I tried to find anwsers to the following two questions, but I did not have luck:
(1) How to view query plan (in addition to Explain plan)?
(2) What is the maximum number of triggers a database can have?

[Jeanne Boyarsky]

Mike,
What's the difference between a query plan and an explain plan?

Google says the maximum number of triggers per table is 12.

[Nicholas Cheung]

What's the difference between a query plan and an explain plan?

Should they refer to the same thing?

Google says the maximum number of triggers per table is 12.[/QB]

Does this limit be changed when the version change? I mean, maybe this limit is for Oracle8i, however, Oracle9i and Oracle10g might support more triggers.

Nick

[Mike Yu]

Hi,

Thank you all for replying to my questions. What I wanted to ask about query plan is:

Which Oracle 9i commands can be used for finding out the query plan of SQL?
Explain Plan is one of the tools in Oracle 9i. Do you know any other tools?