Oracle DBA Daily Routine Checklist and Daily Check Scripts
Hi, I will explain what are the Oracle DBA Daily/Weekly/Monthly or Quarterly Routine Checklist and Tasks in this article.
Read more
Oracle DBA Scripts
ORA-00020: maximum number of processes (%s) exceeded
baranyildiz
0 Comments
maaximum number of processes (%s) exceeded, ORA-00020, ORA-00020: maximum number of processes (%s) exceeded
How to increase PROCESSES initialization parameter : Check Current Setting of Parameters 1)show parameter sessions 2)show parameter processes 3)show parameter
Read more
Grant Privileges
You can grant users various privileges to tables. These privileges can be any combination of SELECT, INSERT, UPDATE, DELETE, REFERENCES,
Read more
Revoke Privileges
The privileges to revoke. REVOKE EXECUTE ANY PROCEDURE FROM BARANYILDIZ; REVOKE create ANY table FROM BARANYILDIZ; REVOKE SYSDBA FROM
Read more
Oracle DBA Scripts All in One -7 – Useful Linux Scripts for Oracle DBA
Mehmet Salih Deveci
3 Comments
all dba scripts, database tutorial, Dataguard Monitoring Script, Dataguard Script, dba scripts, dba scripts all in one, Find Active User Sessions in Oracle, find oracle load, find oracle performance load, Find queries not using bind variables Oracle, goldengate tutorial, How to Find Active And Inactive User Sessions in Oracle, How to Find Active User Sessions in Oracle, how to find bind variables oracle, how to find not using bind variables queries, How to Monitor Long Operations in Oracle How to Monitor RMAN Backup and Long Operations in Oracle, How to Monitor RMAN Backup, How to Monitor RMAN Backup and Long Operations in Oracle, it tutorial, linux tutorial, MEHMET SALİH DEVECİ, monitor oracle backup, Oracle 19c, Oracle 19c Cloud database, Oracle 19c error codes, Oracle active session history, oracle active session load, oracle active session load profile, Oracle Average Active Session Load, oracle bind variable usage, oracle bind variables, oracle database automation scripts, Oracle Dataguard Monitoring Script, Oracle Dataguard Monitoring Scripts, oracle dba daily activities scripts, oracle dba queries, oracle dba scripts, Oracle DBA Scripts All in One, Oracle DBA Scripts All in One - Useful Database Administration Scripts, oracle dba scripts all in one pdf, oracle dba scripts pdf, oracle find bind variables, oracle find historical sql, Oracle Find queries not using bind variables, oracle find sql, oracle hard parse, oracle historical find sql, Oracle Historical SQL, Oracle Historical SQL Search, oracle last_call_et, oracle literal, oracle long operations, oracle monitoring and tuning script collection pdf, oracle monitoring scripts, Oracle Performance scripts, Oracle Performance TOP SQL, Oracle Performance TOP SQL Scripts, oracle rman backup monitor, oracle rman completion time, oracle rman monitor, oracle scripts, oracle sql find, Oracle SQL Search, Oracle TOP SQL script, oracle tutorial, oracle V$ARCHIVED_LOG, oracle V$ARCHIVE_GAP, oracle v$bgprocess, oracle v$database, oracle v$dataguard_stats, oracle v$managed_standby, oracle v$recovery_progress, oracle V$SESSION_LONGOPS, oracle Wait Event, programming language tutorial, shell scripting for oracle dba, sql server tutorial, Useful Database Administration Scripts, useful oracle scripts, v$recovery_progress, V$SESSION_LONGOPS, Wait Event Scripts
Hi, I will share all Oracle DBA Scripts ( Oracle RAC, Dataguard, Performance Tuning, Monitoring and etc.. ) in this
Read moreOracle DBA Scripts All in One -5 – Useful RMAN Backup Restore Scripts
Mehmet Salih Deveci
0 Comments
all dba scripts, database tutorial, Dataguard Monitoring Script, Dataguard Script, dba scripts, dba scripts all in one, Find Active User Sessions in Oracle, find oracle load, find oracle performance load, Find queries not using bind variables Oracle, goldengate tutorial, How to Find Active And Inactive User Sessions in Oracle, How to Find Active User Sessions in Oracle, how to find bind variables oracle, how to find not using bind variables queries, How to Monitor Long Operations in Oracle How to Monitor RMAN Backup and Long Operations in Oracle, How to Monitor RMAN Backup, How to Monitor RMAN Backup and Long Operations in Oracle, it tutorial, linux tutorial, MEHMET SALİH DEVECİ, monitor oracle backup, Oracle 19c, Oracle 19c Cloud database, Oracle 19c error codes, Oracle active session history, oracle active session load, oracle active session load profile, Oracle Average Active Session Load, oracle bind variable usage, oracle bind variables, oracle database automation scripts, Oracle Dataguard Monitoring Script, Oracle Dataguard Monitoring Scripts, oracle dba daily activities scripts, oracle dba queries, oracle dba scripts, Oracle DBA Scripts All in One, Oracle DBA Scripts All in One - Useful Database Administration Scripts, oracle dba scripts all in one pdf, oracle dba scripts pdf, oracle find bind variables, oracle find historical sql, Oracle Find queries not using bind variables, oracle find sql, oracle hard parse, oracle historical find sql, Oracle Historical SQL, Oracle Historical SQL Search, oracle last_call_et, oracle literal, oracle long operations, oracle monitoring and tuning script collection pdf, oracle monitoring scripts, Oracle Performance scripts, Oracle Performance TOP SQL, Oracle Performance TOP SQL Scripts, oracle rman backup monitor, oracle rman completion time, oracle rman monitor, oracle scripts, oracle sql find, Oracle SQL Search, Oracle TOP SQL script, oracle tutorial, oracle V$ARCHIVED_LOG, oracle V$ARCHIVE_GAP, oracle v$bgprocess, oracle v$database, oracle v$dataguard_stats, oracle v$managed_standby, oracle v$recovery_progress, oracle V$SESSION_LONGOPS, oracle Wait Event, programming language tutorial, shell scripting for oracle dba, sql server tutorial, Useful Database Administration Scripts, useful oracle scripts, v$recovery_progress, V$SESSION_LONGOPS, Wait Event Scripts
Hi, I will share all Oracle DBA Scripts ( Oracle RAC, Dataguard, Performance Tuning, Monitoring and etc.. ) in this
Read moreOracle DBA Scripts All in One -6 – Database Envanter Scripts
Mehmet Salih Deveci
0 Comments
all dba scripts, database tutorial, Dataguard Monitoring Script, Dataguard Script, dba scripts, dba scripts all in one, Find Active User Sessions in Oracle, find oracle load, find oracle performance load, Find queries not using bind variables Oracle, goldengate tutorial, How to Find Active And Inactive User Sessions in Oracle, How to Find Active User Sessions in Oracle, how to find bind variables oracle, how to find not using bind variables queries, How to Monitor Long Operations in Oracle How to Monitor RMAN Backup and Long Operations in Oracle, How to Monitor RMAN Backup, How to Monitor RMAN Backup and Long Operations in Oracle, it tutorial, linux tutorial, MEHMET SALİH DEVECİ, monitor oracle backup, Oracle 19c, Oracle 19c Cloud database, Oracle 19c error codes, Oracle active session history, oracle active session load, oracle active session load profile, Oracle Average Active Session Load, oracle bind variable usage, oracle bind variables, oracle database automation scripts, Oracle Dataguard Monitoring Script, Oracle Dataguard Monitoring Scripts, oracle dba daily activities scripts, oracle dba queries, oracle dba scripts, Oracle DBA Scripts All in One, Oracle DBA Scripts All in One - Useful Database Administration Scripts, oracle dba scripts all in one pdf, oracle dba scripts pdf, oracle find bind variables, oracle find historical sql, Oracle Find queries not using bind variables, oracle find sql, oracle hard parse, oracle historical find sql, Oracle Historical SQL, Oracle Historical SQL Search, oracle last_call_et, oracle literal, oracle long operations, oracle monitoring and tuning script collection pdf, oracle monitoring scripts, Oracle Performance scripts, Oracle Performance TOP SQL, Oracle Performance TOP SQL Scripts, oracle rman backup monitor, oracle rman completion time, oracle rman monitor, oracle scripts, oracle sql find, Oracle SQL Search, Oracle TOP SQL script, oracle tutorial, oracle V$ARCHIVED_LOG, oracle V$ARCHIVE_GAP, oracle v$bgprocess, oracle v$database, oracle v$dataguard_stats, oracle v$managed_standby, oracle v$recovery_progress, oracle V$SESSION_LONGOPS, oracle Wait Event, programming language tutorial, shell scripting for oracle dba, sql server tutorial, Useful Database Administration Scripts, useful oracle scripts, v$recovery_progress, V$SESSION_LONGOPS, Wait Event Scripts
Hi, I will share all Oracle DBA Scripts ( Oracle RAC, Dataguard, Performance Tuning, Monitoring and etc.. ) in this
Read moreOracle DBA Scripts All in One -4 – Performance Tuning and Monitoring Scripts
Mehmet Salih Deveci
3 Comments
all dba scripts, database tutorial, Dataguard Monitoring Script, Dataguard Script, dba scripts, dba scripts all in one, Find Active User Sessions in Oracle, find oracle load, find oracle performance load, Find queries not using bind variables Oracle, goldengate tutorial, How to Find Active And Inactive User Sessions in Oracle, How to Find Active User Sessions in Oracle, how to find bind variables oracle, how to find not using bind variables queries, How to Monitor Long Operations in Oracle How to Monitor RMAN Backup and Long Operations in Oracle, How to Monitor RMAN Backup, How to Monitor RMAN Backup and Long Operations in Oracle, it tutorial, linux tutorial, MEHMET SALİH DEVECİ, monitor oracle backup, Oracle 19c, Oracle 19c Cloud database, Oracle 19c error codes, Oracle active session history, oracle active session load, oracle active session load profile, Oracle Average Active Session Load, oracle bind variable usage, oracle bind variables, oracle database automation scripts, Oracle Dataguard Monitoring Script, Oracle Dataguard Monitoring Scripts, oracle dba daily activities scripts, oracle dba queries, oracle dba scripts, Oracle DBA Scripts All in One, Oracle DBA Scripts All in One - Useful Database Administration Scripts, oracle dba scripts all in one pdf, oracle dba scripts pdf, oracle find bind variables, oracle find historical sql, Oracle Find queries not using bind variables, oracle find sql, oracle hard parse, oracle historical find sql, Oracle Historical SQL, Oracle Historical SQL Search, oracle last_call_et, oracle literal, oracle long operations, oracle monitoring and tuning script collection pdf, oracle monitoring scripts, Oracle Performance scripts, Oracle Performance TOP SQL, Oracle Performance TOP SQL Scripts, oracle rman backup monitor, oracle rman completion time, oracle rman monitor, oracle scripts, oracle sql find, Oracle SQL Search, Oracle TOP SQL script, oracle tutorial, oracle V$ARCHIVED_LOG, oracle V$ARCHIVE_GAP, oracle v$bgprocess, oracle v$database, oracle v$dataguard_stats, oracle v$managed_standby, oracle v$recovery_progress, oracle V$SESSION_LONGOPS, oracle Wait Event, programming language tutorial, shell scripting for oracle dba, sql server tutorial, Useful Database Administration Scripts, useful oracle scripts, v$recovery_progress, V$SESSION_LONGOPS, Wait Event Scripts
Hi, I will share all Oracle DBA Scripts ( Oracle RAC, Dataguard, Performance Tuning, Monitoring and etc.. ) in this
Read moreOracle DBA Scripts All in One -3 – Blocking Sessions and Lock Kill Scripts
Mehmet Salih Deveci
0 Comments
all dba scripts, database tutorial, Dataguard Monitoring Script, Dataguard Script, dba scripts, dba scripts all in one, Find Active User Sessions in Oracle, find oracle load, find oracle performance load, Find queries not using bind variables Oracle, goldengate tutorial, How to Find Active And Inactive User Sessions in Oracle, How to Find Active User Sessions in Oracle, how to find bind variables oracle, how to find not using bind variables queries, How to Monitor Long Operations in Oracle How to Monitor RMAN Backup and Long Operations in Oracle, How to Monitor RMAN Backup, How to Monitor RMAN Backup and Long Operations in Oracle, it tutorial, linux tutorial, MEHMET SALİH DEVECİ, monitor oracle backup, Oracle 19c, Oracle 19c Cloud database, Oracle 19c error codes, Oracle active session history, oracle active session load, oracle active session load profile, Oracle Average Active Session Load, oracle bind variable usage, oracle bind variables, oracle database automation scripts, Oracle Dataguard Monitoring Script, Oracle Dataguard Monitoring Scripts, oracle dba daily activities scripts, oracle dba queries, oracle dba scripts, Oracle DBA Scripts All in One, Oracle DBA Scripts All in One - Useful Database Administration Scripts, oracle dba scripts all in one pdf, oracle dba scripts pdf, oracle find bind variables, oracle find historical sql, Oracle Find queries not using bind variables, oracle find sql, oracle hard parse, oracle historical find sql, Oracle Historical SQL, Oracle Historical SQL Search, oracle last_call_et, oracle literal, oracle long operations, oracle monitoring and tuning script collection pdf, oracle monitoring scripts, Oracle Performance scripts, Oracle Performance TOP SQL, Oracle Performance TOP SQL Scripts, oracle rman backup monitor, oracle rman completion time, oracle rman monitor, oracle scripts, oracle sql find, Oracle SQL Search, Oracle TOP SQL script, oracle tutorial, oracle V$ARCHIVED_LOG, oracle V$ARCHIVE_GAP, oracle v$bgprocess, oracle v$database, oracle v$dataguard_stats, oracle v$managed_standby, oracle v$recovery_progress, oracle V$SESSION_LONGOPS, oracle Wait Event, programming language tutorial, shell scripting for oracle dba, sql server tutorial, Useful Database Administration Scripts, useful oracle scripts, v$recovery_progress, V$SESSION_LONGOPS, Wait Event Scripts
Hi, I will share all Oracle DBA Scripts ( Oracle RAC, Dataguard, Performance Tuning, Monitoring and etc.. ) in this
Read more