Re: Pinning packages

An error in a software document is usually easy to verify: you test it against the software's functionality. In the case of Oracle's documentation, you can even send information about errors you find to infodev_at_us.oracle.com. They are very responsive and courteous.

When it comes to terminology, however, there is nothing to verify it against. Oracle is just a piece of software. There is no higher ground. If the documentation uses the term, the term is correct. Trying to make a case to the contrary, and claiming this as some sort of knowledge is just absurd.

Frank Hubeny

"Howard J. Rogers" wrote:

> "Frank Hubeny" <fhubeny_at_ntsource.com> wrote in message
> news:3B494761.92CC6321_at_ntsource.com...
> > Since Oracle documentation refers to the term "pin", it is reasonable to
> > consider the term "correct".
> >
>
> Bollocks.
>
> Oracle documentation also tells you that it is possible to create a SYSTEM
> tablespace as locally managed. Care to give it a try???
>
> Oracle documentation also suggests that every segment should have a STORAGE
> clause. Care to give that a try with locally managed tablespaces??
>
> I can point you to two slides in the Performance tuning course. Both
> produced by Oracle. One says "to pin a package..." and the other says
> "...to keep a package". What does that say about Oracle documentation???
>
> Actually, of course, the term "pin" means a specific thing. The term "keep"
> means a specific thing.
>
> It seems a triviality to make sure that we use the correct term to refer to
> the correct thing. But apparently, this is beyond the wit of most DBAs. I
> suppose this is why we keep getting posts about 'shutting down a database'
> or 'closing an Instance'.
>
> HJR
>
> > See Designing and Tuning for Performance, Oracle 8.1.6 (a76992.pdf)
 Chapter 13,
> > Managing Shared SQL and PL/SQL Areas, page 380:
> >
> > "To use the DBMS_SHARED_POOL package to pin a SQL or PL/SQL area, complete
> > the following steps."
> >
> > Frank Hubeny
> >
> > "Howard J. Rogers" wrote:
> >
> > > First, and just to be pedantic, it's called 'keeping' packages, not
> > > 'pinning' (though since everyone and his dog uses the incorrect term, I
> > > guess I'm just fighting a losing battle)...
> > >
> >
Received on Sat Jul 21 2001 - 16:37:07 CDT