|
| | WARNING: TEMP tablespace is not large enough for the upgrade
Apparently Oracle wants the default temporary tablespace to be locally managed when upgrading from 10.1 to 10.2. When running utlu102i.sql script it throughs this warning if your temp tablespace is dictionary managed:
--> SYSTEM tablespace is adequate for the upgrade.
.... minimum required size: 347 MB
WARNING: --> TEMP tablespace is not large ... | | More...
01/23/07 | | | | |
|
| | Unix permissions problem under ORACLE_HOME
Apparently this is a known Oracle bug, after installing Oracle 10.2.0 Unix permissions under ORACLE_HOME are not set correctly, so directories and files are accessible to the installation user and group (i.e. oracle:dba) but not to the reset of the world (others). If you get any of the following errors ... | | 
More...
04/26/06 | | | | |
|
| | Oracle automatic memory management
In Oracle10g memory can be managed automatically by setting parameter sga_target. Oracle will then manage parameters like: db_cache_size, shared_pool_size, java_pool_size, large_pool_size. You will see new '__' parameters created by Oracle:
__db_cache_size, __shared_pool_size, __java_pool_size, __large_pool_size, these are now dynamically managed.
Check what sga_target is set to:
SQL> sho parameter sga_target
NAME ... | | More...
04/10/06 | | | | |
|
| | Oracle Virtual Indexes - How to
Virtual index is a feature of Oracle 10 and Oracle 9. The purpose of virtual indexes is simulate the existence of an index, without actually building it, so you can explain plan as if the index existed. It is important to drop the index after you're done with it.
To build ... | | More...
11/24/05 | | | | |
|
| | Changing shared_pool_size dynamically
On Oracle 10.1.0.4.0 changing shared_pool_size dynamically seems to crash the databases. So if you run
alter system set shared_pool_size = 400M;
or
alter system set shared_pool_size = 400M scope = both;
The database will crash with
ERROR at line 1:
ORA-03113: end-of-file on communication channel
It seems that you still have to modify ini file ... | | More...
10/27/05 | | | | |
|
| | List patches applied to Oracle installation
This is the Oracle 10 utility to list all the patches applied to $ORACLE_HOME:
$ORACLE_HOME/OPatch/opatch lsinventory
The output should look something like this:
Result:
Installed Patch List:
=====================
1) Patch 4291110 applied on Fri Sep 30 12:28:18 EST 2005
[ Base Bug(s): 4291110 ... | | More...
10/03/05 | | | | |
|
|
