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 [...]
Archive for the ‘Parallelism’ Category
Index rebuilds in parallel change the parallel DEGREE
Posted in General, Parallelism on March 4, 2010 | Leave a Comment »
Blogroll
-
Recent Posts
- Mining listener logs
- OGG-00360 Oracle GoldenGate 11.2: EXT TRAIL/FILE cannot be used with REPLICAT GROUP.
- Oracle GoldenGate tip: DDL INCLUDE/EXCLUDE and comments
- Oracle GoldenGate v11 and RMAN-08137
- DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE runs and evolves successfully, but errors when returning output (ORA-06502)
Tags
Categories
- Access / Users (2)
- Baselines / Profiles (1)
- Code (2)
- Collaborate10 (5)
- Dataguard (4)
- Enterprise Manager (2)
- Flashback (1)
- General (5)
- GoldenGate (4)
- How Oracle Works (1)
- Import / Export (2)
- Listener (1)
- Memory (1)
- oracle (1)
- Parallelism (1)
- Performance (2)
- RAC (1)
- rman (2)
- Script (1)
- Script / Automation (3)
- Statistics (1)
- Tracing (1)
- Tuning (1)
- Uncategorized (2)
- unix (4)
- Upgrade (1)
Archives
-
Top Posts
- Data Guard standby redo logs / resizing the primary's redo logs
- See all external directories in Oracle 10g
- Upgrading small databases on big servers (ORA-04031 / 11g)
- ORA-01309: invalid session in dataguard logical standby
- Listener queuesize and Solaris tcpip
- Oracle GoldenGate tip: DDL INCLUDE/EXCLUDE and comments
