ORA-01722 with Full Table Scan

My application developers approached me with an issue which is very unique to me. They were complaining about a query which was failing with ORA-01722 "invalid number" after an upgrade…

Continue Reading ORA-01722 with Full Table Scan

Effect Of Multiple SHMMAX Settings

Last week I saw a warning message at database startup time saying: WARNING: EINVAL creating segment of size 0x000000000f0020xx fix shm parameters in /etc/system or equivalent It is an Oracle…

Continue Reading Effect Of Multiple SHMMAX Settings