After the scale out installation is completed by default no processes are active.
A couple of days ago I found several referrals coming in from a question about indexing on the Russian Oracle Forum. Reading the thread I found a pointer to a comment I’d written for the Oracle-L list server a couple of years ago about Advanced Queueing and why you might find that it was necessary [...]
Oracle Locator Express is a replacement tool for the standard Oracle Home Selector. It sits in the system tray and allows you to easily switch between multiple Oracle Homes with just one click.
Oracle Locator Express is also compatible with Oracle Instant client. What's new in this version: Version 2.0.1 fixes a bug where the version of the Oracle client was displayed incorrectly for a 11gr2 client
In past few weeks i have been involved in RAC as well as non-RAC databases upgrade from 10.2.0.5 to 22.214.171.124.With every upgrade i come to learn something new After an upgrade to 126.96.36.199, for one of the development database which is a 2-node RAC, EMGC started showing Swap Utilization 99.99%.The “TOP” command showed node 1
PL/SQL subprograms can be thought of as shortcuts that help you to perform certain kinds of Oracle queries less painfully as your applications increase in size and complexity. Keep reading to learn how you can use them to make your programming life a little easier. This article is excerpted from chapter 36 of the book Beginning PHP and Oracle: From Novice to Professional, written by W. Jason Gilmore and Bob Bryla (Apress; ISBN: 1590597702).
- Throughout this book youve seen quite a few examples where the Oracle queries are embedded directly into the PHP script.
Just a quick note that if you see in your executions plans via DBMS_XPLAN that “CPU costing is off”, then it might not be, you might just have old versions of PLAN_TABLE hanging around. I’ve just spent a little while trying to figure out why CPU costing might be off, after which a quick drop [...]
Finally I got around to providing a useful example for a cluster callout script. It is actually on the verge of taking too long-remember that scripts in the $GRID_HOME/racg/usrco/ directory should execute quickly. Before deploying this, you should definitely ensure that the script executes quickly enough-the “time” utility can help you with this. Nevertheless this has been necessary to work around a limitation of Grid Control: RAC One Node databases are not supported in GC 11.1 (I complained about that earlier).
Test to drop disk in ASM Disk Group and found error: ORA-15041
SQL> alter diskgroup TEST_DG drop disks in failgroup EXACEL02 rebalance power 11 NOWAIT;
SQL> select * from gv$asm_operation;
INST_ID GROUP_NUMBER OPERA STAT POWER ACTUAL SOFAR EST_WORK EST_RATE EST_MINUTES ERROR_CODE