I'm involved in performance analysis for an application that calls a
stored procedure that contains if logic. I need to log how many times
logic conditions within the procedure are met so I need to write
information to a log. So it would be something like this...

Dear Group
my problem is the following. i wanna use the oracle BI spreadsheet to
include a datawarehouse cube into my excel.
all of my dimensions, cubes and measures will be created by Oracle

We have some performance Problems due to heavy load in an oracle database
10g.
Our Server is Hewlett Packard Proliant  ML380  OS:  SuSE Linux Professional
9.1.

we have an asp application using oracle 9.2 database. rowid's are used
to reference the rows and they are stored as foreign keys. application
is working fine but we are not sure about backing up database without
getting the rows moved so the rowid's not changed. we looked for this

What is the best way to speed up query looks like:
SELECT DISTINCT COLUMN1, COLUMN2, COLUMN3, COLUMN4 FROM TABLE WHERE COLUMN5
= 5

VSATYA,
Here is my solution to your Data integrity issues. I think you should in essence normalize your Master table to something
as described below....
Sample Data:

What's the purpose of this hint ?
And WHO can explain me why we don't get the ORA-01722 error
at the end of the following in spite of the use of this
hint (because saying first to Oracle "filter out everything

Heya
Do someone got some experience implementing Webutil on Oracle 9 to work with
Forms 6 ?
Regards

A statement in an ORACLE book really baffles me.
"The information for a dynamic performance view is gathered from the
control file"
Can anybody tell me how the stuff in, say, v$sqlarea can be gathered

In the same instance, on Oracle 8.1.7.4, I want to copy all data owned by
user user1 in a tablespace tbs1 to another tablespace tb2 owned by user2. Is
it possible? How can I do?
Regards,

In the same instance, on Oracle 8.1.7.4, I want to copy all data owned by
user user1 in a tablespace tbs1 to another tablespace tb2 owned by user2. Is
it possible? How can I do?
Regards,

I have moved into a new office a couple of days back (meaning the
network has been just set up)
While installnig Oracle 10g server (AND client), I got an error window
saying:"Thrown when IP address of a host cannot be determined". But

Hello users.
In delphi 7 I'm using TADOQuery control in which I put SQL but I have
problem. I can run and see the result on the grid on design time (in Delphi
7 using ), but when I run the program I get the folowing message:ORA-00979:

e.g. would like to know if Oracle Spatial or Oracle Text are
installed?
Thought it would be a view containing 'feature' or 'option' but
nothing came up.

  I am curious how other expert DBA do.
What is the best method to collect EXPLAIN PLAN data?
Let me explain what I am going to archieve.
I have this TEST ORACLE UPGRADE PROJECT from 8.1.7.4 to 10g (or 9.2).