Durham Oracle
An eclectic view of the world of Oracle.
Main Pages
(Move to ...)
Home
General tips
Java tips
A bit of Perl
Cloud Computing
Useful Links
All things ASM
SQL Tips
▼
dbcli commands crib sheet
›
cd /opt/oracle/dcs/bin ./dbcli list-dbhomes ./dbcli describe-component ./dbcli list-databases -j ./dbcli describe-database -in <db_...
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...
‹
›
Home
View web version