How to check failed login attempts count in oracle database ?
To Check Failed login attempts count in oracle database for security purpose. It helps you to identify the username and […]
Uncategorized
Uncategorized
How to create a DBlink in oracle database
In this blog I shared the command to check the details of existing DBlink and create the new DBlink in
Scripts
tblspc_temp_files.sql
This script help you to find the information about temp tablespace files in oracle database.Call the script @tblspc_temp_files.sql Click here
Scripts
tblspc_temp_free.sql
This script help you to find the information about temp tablespace usage in oracle database.Call the script @tblspc_temp_free.sql Please share
Scripts
tblspc_files.sql
This script help you to find the information about tablespace usage in oracle database.Call the script @tblspc_files.sql Click here for
Scripts
tblspc_free.sql
This script help you to find the information about tablespace usage in oracle database. Call the script @tblspc_free.sql Please share
Scripts
Displays information about PGA usage for each session
This script help you to find the PGA usage in oracle database. Call the script @pga_usage.sql Lists all invalid objects
Scripts
Lists all invalid objects in the database
This script share the details of all invalid objects in oracle database. Displays temp usage for all session currently using
Scripts
Displays temp usage for all session currently using temp space
You can create this script and call it @temp_usage on sqlplus prompt to check the all session are currently using
ORA-ERROR, RAC
ORA-02049: timeout: distributed transaction waiting for lock
ORA-02049: timeout: distributed transaction – Application team reported this error ORA-02049. Some of the jobs are getting failed which are