Jump to Navigation


SGA_TARGET is a database initialization parameter (introduced in Oracle 10g) that can be used for automatic SGA memory sizing.
This feature is known as  Automatic Shared Memory Management (ASMM).

By using one parameter we don't need to use all other SGA parameters like.

* DB_CACHE_SIZE (DEFAULT buffer pool)
* SHARED_POOL_SIZE (Shared Pool)
* LARGE_POOL_SIZE (Large Pool)
* JAVA_POOL_SIZE (Java Pool)

1. Check STATISTICS_LEVEL    --  Get DB Statistics

223 - java.lang.OutOfMemoryError (Tomcat)

You ran out of memory and GC stands for Garbage Collector. If your garbage collector is spending too much time freeing memory
because of a memory shortage, you'll get this error.

* java.lang.OutOfMemoryError: GC overhead limit exceeded

To solve this issue :

Edit the file /usr/local/apache-tomcat-6.0.26/bin/catalina.sh and alter the following line, substituting for the desired values.

222 - Manage file attributes

A file attribute is metadata that describes or is associated with a computer file.

1. chattr - change file attributes on a Linux second extended file syst

chattr [ -RV ] [ -v version ] [ mode ] files...

# chattr -a myfile

-----a------- myfile

# chattr +i myfile

2. lsattr - list file attributes on a Linux second extended file system


221 - Fatal NI connect error 12170

You found an error 12170 in an alert.log.

1:23:41am -  Fatal NI connect error 12170
ns secondary err code: 12606
ns main err code: 12535



220 - Enterprise Manager Repository

1. Add your host name & IP Address to /etc/hosts correctly.   myserv01.mydomain.net myserv01

2. Set the environment variable ORACLE_UNQNAME to Database unique name.

3. Start dbconsole

/u01/app/oracle/product/11.2.0/db_1/bin/emctl start dbconsole

Maybe you get a error.


219 - File and directory timestamps in Linux System

Linux keeps 3 timestamps for each file: mtime, ctime, and atime. Most people seem to understand atime (access time), it is when the file was last read.
There does seem to be some confusion between mtime and ctime though. ctime is the inode change time while mtime is the file modification time. "Change"
and "modification" are pretty much synonymous. mtime changes when you write to the file. It is the age of the data in the file. Whenever mtime changes,

218 - APP-FND-00500 noprint

Oracle EBS has the following error when you print out noprint with more than 0 copy.

217 - mod_ossl: Child could not open SSLMutex lockfile

Intermittently, over a period of several days or weeks, HTTP Server will suddenly lock up - neither processing connections, nor rejecting them. 
The error_log may contain thousands (typically one per user click) of the following entries :

216 - How to use mpstat

The mpstat command writes to standard output activities for each available processor, processor 0 being the first one. Global average activities
among all processors are also reported. The mpstat command can be used both on SMP and UP machines, but in the latter, only global average
activities will be printed. If no activity has been selected, then the default report is the CPU utilization report.

mpstat [ -P { cpu | ALL } ] [ -V ] [ interval [ count ] ]

-P : cpu number(0, 1, ...) or ALL
-V : Version Number


215 - nmap

nmap is a powerfull scanner available in Unix/Linux system. It’s very usefull for network exploration and security auditing.
It was designed to rapidly scan large networks, although it works fine againts single hosts.

Usage: nmap [Scan Type(s)] [Options] {target specification}



Subscribe to LAMP, Database and Cloud Technical Information RSS

Main menu 2

by Dr. Radut