We run our smaller java apps against a single database with multiple schemas. Not best practice for tuning, but it is a good use of resources for us and if any schema ever starts to have significant traffic/load, we break them off into their own database. Most of these apps run at less than 1% [...]
Archive for March, 2010
Schema refresh script
Posted in Import / Export, Script / Automation, tagged data pump, refresh, schema on March 30, 2010 | 5 Comments »
Index rebuilds in parallel change the parallel DEGREE
Posted in General, Parallelism on March 4, 2010 | Leave a Comment »
As many of the comments to this handy article echo, we got stung by this one today. Definitely check out the article. After a large data shuffle with some new partioning, involving index rebuilds, we saw a huge load on the server. Didn’t take long to see that we had a query utilizing over 80 [...]
Data Guard standby redo logs / resizing the primary’s redo logs
Posted in Dataguard on March 2, 2010 | 7 Comments »
Data Guard standby redo logs are worth a few comments. The misconception that there have to be the exact same number of standby redo logs as there are primary redo logs seems to come up often. In fact, the size has to be the same, but the standby should always have at least one more [...]
