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
Month: December 2020
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?
Time to move to Oracle Linux for CentOS user?
Since CentOS announced the following statement on Dec. 8th, 2020 last week: The future of the CentOS Project is CentOS Stream, and over the next year we’ll be shifting focus from CentOS Linux, the rebuild of Red Hat Enterprise Linux (RHEL), to CentOS Stream, which tracks just ahead of a current RHEL release. CentOS Linux … Continue reading Time to move to Oracle Linux for CentOS user?
Delete a snapshot control file?
From Oracle Database Backup and Recovery User's Guide “When RMAN needs a read-consistent version of the control file, it creates a temporary snapshot control file. RMAN needs a snapshot control file when resynchronizing with the recovery catalog or when making a backup of the current control file.” Usually we see the snapshot control file created … Continue reading Delete a snapshot control file?
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
JoeLi's TechLife 