Is there a script or optimal way of figuring out what the following 2 Oracle parameters should be set to in an Oracle 10gR2 Database that is considered a hybrid (Both Database Warehouse and OLTP) Database: optimizer_index_cost_adj and optimizer_index_caching.
My Database is quite small, only 27 GB in size but is run on a very powerful machine that has 32GB of RAM and 8 CPUs.
How to Create User-Defined Aggregates in Oracle
Before we begin creating these things, what are user-defined aggregates? They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime? I'm talking things like:
* Dropping columns
* Shrinking allocated space
* Removing chained blocks and restoring the PCTFREE