I have a question about pipelined functions. I want to write a
recursive functions that should return some records. I also would like
to write it as a pipelined functions but it doesn't work. Has someone
an example or a link for me? I succeeded to write it in PL/SQL as a

When I open a prompt on my PC I can do this:
C:\>tnsping snd.world
TNS Ping Utility for 32-bit Windows: Version 9.0.1.3.1 - Production on
19-AUG-20

Is there are a way to alter constraint so that it doesn't cascade
deletes?
Thanks.
.......

All,
Could someone give me a clue on some data that I am seeing in Oracle
Enterprise Manager (Capacity Planner)?
We are using an IBM Shark (RAID) and have Vpaths setup etc. (the

Anyone have a good reference for installing the 10g EM agent in a
clustered unix environment? I'm using Veritas Cluster Services on
Solaris 2.8.
For that matter does anyone have a good reference for the emctl utility?

when I exec a "list backup;" with RMAN the shown Size value of a backup
piece are not equal to file size of the backup piece if the filesystem.
Sometimes there are differences up to 50%.
I found no reason why both values differ, as "Size" is sometomes

We're running 817 under Solaris.
Circumstances are forcing us to drop the DRSYS tablespace. The only
thing in it is the CTXSYS schema, which was installed by a third party
and isn't required in the current version of their software. Since

hope I can explain it.
Is there a way an application can store any variable in a session so
that any function/trigger can use this?
f.e.

http://www.unixreview.com/documents/s=9846/ur0508l/ur0508l.html
I had the great fortune of attending the 1983 seminar in the
Opera House in Sydney with Ken Thompson, Brian, Dennis and
IIRC Rob Pike, where Unix was "officially" launched in Australia.

It used to be a rule of thumb that one wanted no more than five or so
values in a check constraint.  Has that changed?  I am in a discussion
with a developer over this, and cannot find a reference in the doc set.
TIA -

I am just learning how to use traces and TKPROF.  My problem is that it
is not giving me the explain plans (with row counts and timings) for my
SQL.  Sometimes I will get a few explain plans but typically I get
none.  When I do get explain plans sometime they will have timing

Vennela Technologies is a Global Oracle Technologies and Oracle
Applications services Provider with a good customer base in Middle East
and Europe
Vennela started its Training division very recently. We are very happy

I was asked to write a general procedure to estimate the space
requirements of a database .The database may be an OLTP or OLAP .The
database may grow very large .
I was in the process of finding out all the components which are to be

can anybody tell me a situation where a normalization RDBMS is not good?

I am using Oracle 9i, Rel 9.0.1, running on Windows 2000 Server. Server
is HP Proliant, with 1 GB Memory.
My Buffer Cache Size was initially set to 80 MB, and I turned the
Buffer Cache Advice on. After couple of days, from the Advise, I saw