ITPub博客

PARALLEL_EXECUTION_MESSAGE_SIZE specifies the size of messages for parallel execution (formerly referred to as parallel query, PDML, Parallel Recovery, replication).On most platforms, the d...

1. If possible, please use CACHE + NOORDER for sequences on RAC:This setting has the least performance impact on RAC, and it is the default when creating a new sequence wihtout options. Each...

SQL> grant unlimited tablespace to dba_role;grant unlimited tablespace to dba_role*ERROR at line 1:ORA-01931: cannot grant UNLIMITED TABLESPACE to a roleThe Error ORA-01931: cannot grant UNLIM...

RMAN-06094 Datafile does not exist Applies to:oracle server version 10.2.0.2 and later.Symptomeswhen trying to recover the database from an incremental backup,the following error is encounted.Star...

MRP0: Background Media Recovery terminated with error 1274 [ID 739618.1] Modified 10-APR-2011 Type PROBLEM Status PUBLISHED In this Document Symptoms Cause Solution...

set up a standby quickly by duplicate.1.Create an Oracle Password File for the Auxiliary InstancePassword of user sys must be the same as primary side,so i copy the password file from primary,...

edit pfile and append an entry like *.asm_diskgroups='DG01'startup asm by spfilecreate spfile from pfile='/dms01/app/oracle/dbs/init+ASM2.ora';srvctl start  asm -n dms01done.

alias doesn't work on solaris.solaris10 use shell sh default,so alias doesn't work.we can change the shell to bash by edit /etc/passwd to make it effect.like :oracle:x:100:101::/dms01/app:/bin...

ORA-00600 [Kfgfinalize_2] While Mounting Diskgroups In Rac [ID 418063.1] Modified 14-MAY-2008 Type PROBLEM Status PUBLISHED In this Document Symptoms Cause Solution ...

Oracle Clusterware and Oracle Real Application ClustersInstallation Guide10g Release 2 (10.2) for Solaris10 x86-64 Operating System#In this article I'll describe the installation of Oracle Clusterware...

In my previous organization, after upgrading the databases from Oracle 9i to 10g, we had a few performance issues. In Oracle 9i, some Queries used to give full reasults in few minutes but th...