• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Ron McLeod
  • Jeanne Boyarsky
Sheriffs:
  • Paul Clapham
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
Bartenders:

user groups for oracle database

 
Ranch Hand
Posts: 175
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,

Can you recommand some other user groups or websites for discussion about Oracle Database?
 
Sheriff
Posts: 9109
12
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
http://www.oracle.com/technology/index.html
 
Ranch Hand
Posts: 150
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
The Lazy DBA

and

technet (oracle)

and

SQL for Web Nerds

to name but a few....
 
Mike Yu
Ranch Hand
Posts: 175
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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?
 
author & internet detective
Posts: 42173
937
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Mike,
What's the difference between a query plan and an explain plan?

Google says the maximum number of triggers per table is 12.
 
Ranch Hand
Posts: 4982
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator


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
Ranch Hand
Posts: 175
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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?
 
They worship nothing. They say it's because nothing is worth fighting for. Like this tiny ad:
Clean our rivers and oceans from home
https://www.kickstarter.com/projects/paulwheaton/willow-feeders
reply
    Bookmark Topic Watch Topic
  • New Topic