i have a query which returns me an xml of the rows using xmlagg
i want to limit the rows it return , which is not the problem (using
rownum < num)
the problem is that i want to combine in the same sql , the real rows

I noticed that people asking beginner questions on this forum are
sometimes subjected to unpleasant remarks and comments. The complete
beginners are probably not welcome on comp.databases.oracle.server.
There is, however, a great resource, available to the complete beginners

Good day,
      Just read an article on Oracle Metalink ( DOC ID: 77587.1 ) that
explained some issues with Oracle and UNIX device drivers and
filesystems that cause Oracle block corruptions.

I am familiar with the ability to tune a SQL statement, but is there a
way to tune a procedure?
For example, we have a procedure in PL/SQL that is a few hundred lines.
I would like to test the procedure and capture a benchmark.  I would

I need to view the contents of a DB2 table from Oracle SQL Plus.
Can someone let me know how to do this.
Thank's alot.
John

I am getting Ora-3113 and ora-3114 on the event viewer of the windows
server which is running the .net web application.
I checked all the logs on the oracle server and did not find anything
suspicious. This error stopped on its own after about 3 hours.

Is it possible to call an pl/sql-procedure from an web-page,
which finds an result-set and displays it as an html-page
with diagrams (pie-chart/picture)?
Greetings

Hi, all.
I'm configuring STATSPACK under 8.1.7.4 on AIX.
I've done several dry runs, installing it and uninstalling it, I've
taken snaps, run reports, used oraperf.com, all that jazz.

Iam using ORACLE 9206 on Windows 2000.
I created a virtual drive E by subst command. I can cd to E drive and dir
w/o problme.  Unfortunately, RMAN can not see it while I am testing.
E:> rman target=sys/xxxxxx

Would like to understand what values people have their LOG_BUFFER parm set to.
I read Oracle doc and they are all over the place from 512bytes to 1mb.
I just want to get a flavor to what people are using.
Thanks for any input people can give.

Over time (a few weeks) my Oracle 9i server on Linux begings to take a
long time to open a connection (say 30 seconds to start sqlplus).
I have about 50 remote JDBC connections open that are distributed over
10 or so tomcat web applications and these too begin to cause trouble

Am wanting to know what value to set the Database time zone to so that
it will add on or take off the one hour between GMT and BST.
Will the software add on or take off the hour automatically when times
switch from British Summer Time and GMT?

My company considers using UNICODE databases with
NLS_LENGTH_SEMANTICS=CHAR to avoid problems inserting a value like
'Länge' into a CHAR(5) or VARCHAR2(5) column.
Now I am concerned about space requirements of such a database

I want to deploy an application with Oracle backend on a V240. The server
will have 4 internal drives; the first 2 will be mirrored and used for
root/boot, application and oracle binaries. The other 2 will be mirrored and
used for Oracle data.

The size showed on OEM is the size I allocated, isn't it?
How can I calculate the real size of a table or a tablespace?