Having issues running this query.
In 8i iam using the rule optimzer and this query runs in 6 minutes
Have imported all the data into a 10g database running a optimzer mode as all_rows and the...
http://www.experts-exchange.com/Database/Miscellaneous/Q_23532877.html
I have an existing Oracle 10 G installation. In an effort to increase response spped, I would like to add an additional CPU to the system the database is running on. Are there any remifications to...
http://www.experts-exchange.com/Database/Oracle/10.x/Q_23813013.html
Zones:
Oracle 10.xDate Answered: 10/23/2008 Grade: A Views: 0
Database; Oracle 10G R2
I check the weekend windows group in the resource manager it was scheduled to run on saturday i changed it to run on thursday and still the activity screen in performace ta...
http://www.experts-exchange.com/Database/Oracle/10.x/Q_23113049.html
Zones:
Oracle 10.xDate Answered: 02/13/2008 Grade: C Views: 120
Ive created an exceptions table using the Oracle script and I try to create a constraint, which fails. But when I look in the exceptions table there are no entries.
Any ideas?
SQL> ALTER TAB...
http://www.experts-exchange.com/Database/Oracle/Q_23117868.html
Zones:
OracleDate Answered: 02/05/2008 Grade: B Views: 0
I have a pl/sql web application that uses the mod_plsql and http server in 9 IAS.
the application is all stored procedures in 9i database.
a decision was made to upgrade the app server to 10g I...
http://www.experts-exchange.com/Software/Server_Software/Application_Servers/Java/Oracle_I...
I have a HP Server with 2 Quad Processors and Windows 2003 32 it, I would like to install Oracle 10g on it, is there any problem ?
http://www.experts-exchange.com/Database/Oracle/10.x/Q_23266182.html
Hello,
I have 1XP machine on my network that is having problems connecting to an oracle db after an ip change. I have updated the tnsnames file with the correct ip but tnsping still resolves th...
http://www.experts-exchange.com/Database/Oracle/Q_23283587.html
My production dabase is about 30 GB .
I want to Oracle 's export tool to make database test.
What about the performance if i run EXP. i am afraid it makes db slow .
http://www.experts-exchange.com/Database/Oracle/10.x/Q_23517712.html
Zones:
Oracle 10.xDate Answered: 06/26/2008 Grade: A Views: 0
In the past , i write trigger to catch changes with condition on a table and insert to new table .
It finishs but it afftects to a lot of procedure and functions , would anybody advise other solu...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23572350.html
Hi,
Can I have 2 entries int he tnsnames.ora for the same service name? (In other words in the following tnsnames.ora after the horizontal line like the last entry, can I have an additional ent...
http://www.experts-exchange.com/Database/Oracle/Q_23776558.html
Zones:
Oracle,
LinuxDate Answered: 11/07/2008 Grade: A Views: 25
