Forum:

Oracle/OAS

user groups for oracle database

Mike Yu

Ranch Hand

Posts: 175

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi,

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

Thanks,<br />Mike

Marilyn de Queiroz

Sheriff

Posts: 9109

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

JavaBeginnersFaq
"Yesterday is history, tomorrow is a mystery, and today is a gift; that's why they call it the present." Eleanor Roosevelt

Barbara Norway

Ranch Hand

Posts: 150

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

The Lazy DBA

and

technet (oracle)

and

SQL for Web Nerds

to name but a few....

farmkitty

Mike Yu

Ranch Hand

Posts: 175

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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?

Thanks,<br />Mike

Jeanne Boyarsky

author & internet detective

Posts: 40797

829

I like...

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

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

[OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2

Java 8 (verified skill)
Skill verified by Jeanne Boyarsky

JUnit 5 (verified skill)
Skill verified by Jeanne Boyarsky

Nicholas Cheung

Ranch Hand

Posts: 4982

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

SCJP 1.2, OCP 9i DBA, SCWCD 1.3, SCJP 1.4 (SAI), SCJD 1.4, SCWCD 1.4 (Beta), ICED (IBM 287, IBM 484, IBM 486), SCMAD 1.0 (Beta), SCBCD 1.3, ICSD (IBM 288), ICDBA (IBM 700, IBM 701), SCDJWS, ICSD (IBM 348), OCP 10g DBA (Beta), SCJP 5.0 (Beta), SCJA 1.0 (Beta), MCP(70-270), SCBCD 5.0 (Beta), SCJP 6.0, SCEA for JEE5 (in progress)

Mike Yu

Ranch Hand

Posts: 175

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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?

Thanks,<br />Mike

You showed up just in time for the waffles! And this tiny ad:

Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop

https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton