Thursday, October 1, 2015

To change memory size in db when amm is enabled

to change sga, memory and everything..

Use

alter system set memory_target=628M;


By at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Featured Post

Apply Patch 22191577 latest GI PSU to RAC and DB homes using Opatch auto or manual steps

Patch 22191577: GRID INFRASTRUCTURE PATCH SET UPDATE 11.2.0.4.160119 (JAN2016) Unzip the patch 22191577 Unzip latest Opatch Version in or...

  • (no title)
    NTP change on  Exadata db nodes # grep ^server /etc/ntp.conf server 10.120.0.10 prefer iburst burst minpoll 4 maxpoll 4 server 10.120....
  • Scan listener down even if it is up
    Some times oem shows scan listener status down even if it is up. Problem is with configuration. While creating a listener_scan target i...
  • Cleaning Sysaux tablespace
    Cleaning SYSAUX tablespace 1. Running @?/rdbms/admin/awrinfo.sql –> Detailed Info like Schema breakdown, SYSAUX occupants space usage ...