Month: December 2020

PGA_AGGREGATE_LIMIT

The initialization parameter PGA_AGGREGATE_LIMIT has been introduced since Oracle Database 12c 12.1.0.1. It is used to put a hard limit on PGA memory usage. If PGA usage exceeds the PGA_AGGREGATE_LIMIT value defined, Oracle Database aborts or terminates the sessions or processes that are consuming the most untunable PGA memory. In Oracle 12.1.0.1, although the Oracle … Continue reading PGA_AGGREGATE_LIMIT

SGA_MAX_SIZE specified is high ORA-00700: soft internal error, arguments: [sms physmem limit]

I have a new Linux 7 system when Oracle 19C starts, it throws the following errors in the alert.log SGA_MAX_SIZE specified is highErrors in file /opt/oracle/diag/rdbms/prod/PROD/trace/PROD_ora_10899.trc (incident=208027):ORA-00700: soft internal error, arguments: [sms physmem limit], [103079215104], [101163243929], [], [], [], [], [], [], [], [], []Incident details in: /opt/oracle/diag/rdbms/prod/PROD/incident/incdir_208027/PROD_ora_10899_i208027.trc Other than the error itself, everything seems … Continue reading SGA_MAX_SIZE specified is high ORA-00700: soft internal error, arguments: [sms physmem limit]

Process running with Bequeath (beq) Protocol?

The Bequeath Protocol is a SQL*Net protocol which enables local clients to connect to a database without using the network listener. Oracle's Bequeath protocol internally spawns a server process for each client application. It does the same operation that a remote network listener does for the connection locally. It has the following characteristics: Does not … Continue reading Process running with Bequeath (beq) Protocol?

Create symbolic link on CIFS share under Linux

Oracle archive logs can be put under flash recover area when one of log archive destination parameter (by default it is log_archive_dest_10) is set to "LOCATION=USE_DB_RECOVERY_FILE_DEST". Then Oracle will use the directory specified by the parameter db_recovery_file_dest to hold files like backup, archivelog, flashback log etc. However sometimes you want to put archive logs somewhere … Continue reading Create symbolic link on CIFS share under Linux