In Oracle 18c and up, the space allocated to the MGA (Managed Global Area) is included in total amount of memory allocated to the PGA. This can be see from v$pgastat:Therefore it follows that when upgrading from
TEMP /home/oracle/app/oracle/oradata/cdb1/orcl/orcl_temp01201 4-07-30_04-39-23-PM.dbf Create another Temporary Tablespace TEMP1 CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE ‘/u01/app/oradata/DBACLASS/temp01′ SIZE 2G; Move Default Database temp tablespace ALTER DATABASE DEFAULT TEMPORARY TABL...
pga_aggregate_target = 3600M memory_max_target takes the value of memory_target as it is not set explicitly. We hit a situation once when a poorly created SQL stmt made oracle exe use 28g of memory. Running the following query we knew that PGA took 3 times more that was allocated: SQ...
a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. b.The password entered is a keyword that Oracle does not recommend to be used as password ACTION: Specify a strong...
=)> Note 136697.1 “hcheck8i.sql” script to check for known problems in Oracle8i, Oracle9i, and Oracle10g 2. Parameter file --- The parameter file can exists in 2 forms. First of all we have the text-based version, commonly referred...
Oracle say that a 10g Instance can address 16 Exabytes of RAM!The Unix support guys do not hev mutch Oracle experience.I suspect the problem is with the OS, in some way.Do we need to make use of HP Memory Windows?Does any-one out there have a full set of kernel parameters used ...