Email Alerts
-
Online tablespace reorganization in Oracle 9i
What is the procedure to do online tablespace reorganization in Oracle 9i? Ask the Expert
-
Difference between driving table and driver table in Oracle
I need to know the difference between the driving table and driver table in Oracle. Ask the Expert
-
Best design for E-Business Suite on hard drive
I'm planning to install an Oracle E-Business Suite application on a 300GB hard drive. What would be the best design for me to implement on the disk drive? Ask the Expert
-
Index on table that is truncated/repopulated daily
Since I truncate and repopulate the data in my table every day, is the index of much use? Ask the Expert
-
Select on Oracle table takes hours
A user complains that every time he tries to access a table (select only), it takes more than two hours to get the results. There are no DML operations performed on the table. Ask the Expert
-
Can I use TKPROF in Oracle 10g?
I have always used TKPROF to do SQL tuning in previous versions of Oracle (7,8 and 9). Can I still use TKPROF in Oracle 10g R2? Ask the Expert
-
How to improve performance of column update
I have a table with 1.5 million records that needs to have a column updated based on a correlated subselect. This update is currently sitting at four hours and counting. What can I do to improve this performance? Ask the Expert
-
What is the difference between left outer join and (+) outer join?
What is the difference between left outer join and (+) outer join? Ask the Expert
-
Import of database dump takes 13 hours
I tried to import a database dump onto my Oracle server using the imp script. The import process currently takes 13 hours for a 3 GB dump file. Ask the Expert
-
Slow query performance for customer with large data volume
I have a critical performance issue due to the large volume of data for a specific customer. Whenever customer XYZ's data is being fetched the query takes about half an hour to execute, whereas it fetches the data in seconds for the rest of the custo... Ask the Expert