How to add the following parameter into ORACLE database, please provide the script:
_optimizer_enhanced_filter_push = FALSE
How to remove the above parameter from ORACLE database, please provid...
http://www.experts-exchange.com/Database/Oracle/10.x/Q_24877734.html
Zones:
Oracle 10.xDate Answered: 11/06/2009 Rating: 9.0 Views: 5
Our developer construct the SQL statement (refer to ALL_SQL.sql) using UNION ALL and it returns inconsistent data on certain policy.
When I split the source code into 2, it returns consistent da...
http://www.experts-exchange.com/Database/Oracle/10.x/Q_24877357.html
Zones:
Oracle 10.xDate Answered: 11/23/2009 Rating: 6.5 Views: 6
Dear Experts,
I need to copy couple of schemas (can be one at a time or all at the same time) from a 10.2.0.2 db server to another. I would like to use data pump , i read somewhere that by creatin...
http://www.experts-exchange.com/Database/Oracle/Q_23247531.html
Zones:
OracleDate Answered: 03/19/2008 Rating: 8.4 Views: 19
Hi all,
I implemented all the segment advisor recommendations but the warning icon is still visible showing 23 recommendations.
How can I clear the Segment Advisor Recommendations displayed in th...
http://www.experts-exchange.com/Database/Oracle/10.x/Q_23350127.html
Zones:
Oracle 10.xDate Answered: 10/08/2008 Rating: 7.4 Views: 10
Hi,
I have 5 normal non partitioned indexes on a partitoned table ( Partiton by range). I had some maintenance to do on the table, where i need to drop some partitions, truncate some partitions an...
http://www.experts-exchange.com/Database/Oracle/10.x/Q_23969878.html
Zones:
Oracle 10.xDate Answered: 02/25/2009 Rating: 9.4 Views: 0
I have inherited a database with a partitioned table containing 750M rows. It is currently range partitioned with 350 million rows in the last partition for maxvalue.
I also have one local inde...
http://www.experts-exchange.com/Database/Oracle/10.x/Q_23161043.html
Hi, I am trying to crate a script which currently shows all the output of SQL fine. however i have been requested to add the 'last date run' into the html which the sql output prints on to. So at t...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23184147.html
Hi,
how easy it would it be to implement a table that logs when a certain user logs in and out along with the date/times of this activity. I imagine it will be accomplished with triggers but i'...
http://www.experts-exchange.com/Database/Oracle/10.x/Q_23319980.html
Zones:
Oracle 10.xDate Answered: 04/15/2008 Rating: 9.0 Views: 0
Hi Everyone,
My question is regarding the usage/benefits of Global index or local index.
We have 10-12 FACT tables paritioned by date column and have 12 monthly partitions.
Also ...
http://www.experts-exchange.com/Database/Oracle/Q_23623450.html
Hi Experts,
I'm looking into the options of Parallelism in our datawarehouse. We have 4 CPUs in development and 8 CPUs planned in the PROD environment.
The whole datawarehouse has 12 FACT...
http://www.experts-exchange.com/Database/Oracle/Q_23630276.html
Zones:
OracleDate Answered: 08/09/2008 Rating: 8.8 Views: 0
