Durham Oracle

An eclectic view of the world of Oracle.

Main Pages

▼

Performance issues on different nodes in RAC cluster - SQL execution plan

›
So query runs on node 1 - generates a fast query plan which is then cached - large load takes place meaning stats are out of date.  Query ru...

›
Upgrading a single PDB to use a new DST file (Credit to Mike C. for these notes) When trying to refresh a db which was at a db level 2 below...

›
SCAN Listener info Have not touched scan listeners for ages so some very quick background commands to show scan listener info. That long too...
‹
›
Home
View web version

About Me

Ian Smith
View my complete profile
Powered by Blogger.