QUERYING ORACLE HIDDEN PARAMETERS
QUESTIONS How to query the hidden initialization parameters? How to view list of hidden parameters? How to view hidden parameters in Oracle? How to find oracle hidden parameters? List all hidden database parameters. View hidden initialization parameters. See all initialization parameters. REQUEST A…
RESETTING AN ORACLE ACCOUNT PASSWORD
QUESTIONS How do I reset a password for a user in Oracle? How do I restore a user password if the account has expired? How do I change the password for a user in Oracle? How do I recover a lost password on Oracle?…
WHO IS LOCKING MY ACCOUNT?
QUESTIONS Who is locking my account? Who locked a user account? How to track account lock? Who specifies a wrong password during login? Identifying a process which is locking an oracle account by using an incorrect password. SYMPTOMPS A user complains about his…
ORA-00060: DEADLOCK DETECTED WHILE WAITING FOR RESOURCE
QUESTIONS What is a deadlock? How to identify sessions involved in a deadlock? How to eliminate a deadlock in a database? SYMPTOMPS You observe one or more ORA-00060 error in an alert log ORA-00060: Deadlock detected. See Note 60.1 at My Oracle Support…
A BLOCKING SESSION
QUESTIONS What is a blocking session? What is a waiting session? How to find a blocking session? Why my transaction hangs when I try to update a row? Who blocked my transaction? SYMPTOMPS Users complain about an application completely hangs. A user complains…
Categories
- Linux (8)
- Iptables (2)
- Memory Usage (1)
- Postfix (1)
- Yum (4)
- Networker (2)
- Oracle (65)
- Account (2)
- AWR (2)
- Database Errors (6)
- Database Performance (9)
- Datapump (4)
- Enterprise Manager (24)
- Enterprise Manager Metrics (4)
- Environments (4)
- High CPU Usage (2)
- High IO Load (4)
- Initialization Parameters (5)
- job_queue_processes (1)
- Processes (3)
- NLS (1)
- Objects (1)
- Objects DDL (2)
- OJVM/PSU/DRU Patches (1)
- PL/SQL (5)
- UTL_FILE (4)
- Prerequisites (1)
- Privileges (1)
- Profile (1)
- Queries (2)
- Redologs (1)
- Resource Limits (1)
- Segment Shrink (1)
- Session (6)
- Spfile (3)
- SQL PLUS (1)
- Spooling (1)
- Standard Queries (7)
- Statistics (2)
- Tablespaces (1)
- Temporary Tablespace (2)