— ################################################ — # Creator: Cyrille MODIANO — # Created: 2011/11/16 — # Name: Tracking failed logon attempts — ################################################ — # — # Compatible: Oracle 9i 10g 11g — # — ################################################ — # — # This script enable auditing for failed login — # attempts — # — ################################################ — # 1 – […]
Category: Troubleshooting
Connect Hanged Oracle DB
There is an option that is helpful for the Oracle DBA when the database is hanging and we can’t connect to the database. We can execute commands like oradebug and sqlplus -prelim We can connect to the sga but not to the database, in this case no session is created. We wants to connect to […]
ORA-4031 Analysis and Diagnosis
— ################################################ — # Creator: Vincent Fenoll — # Created: 2011/02/24 — # Name: ORA-4031 Analysis and Diagnosis — ################################################ — # — # Compatible: Oracle 8i 9i 10g 11g — # — ################################################ — # — # Steps to find and solve fragmentation issues — # in the shared pool after ORA-4031 raised — […]