SCRIPTS

Oracle database Health check scripts

Post author By Ramkumar
Post date 13th February 2021
7 Comments on Oracle database Health check scripts

PERFOMANCE TUNING SCRIPTS

MONITOR SESSION
SQL PROFILE & BASELINE
ALL IN ONE SCRIPT
HISTORY OF EXECUTED QUERIES
SQL HISTORY
WAIT EVENTS, AWR ,ASH , TIME MODEL SCRIPTS
MONITOR SQL’S

MAIL SCRIPTS

Get DDL ‘s For All objects in oracle database

TEMP TABLESPACE scripts

UNDO TABLESPACE scripts

Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter : https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8

Tags ACL, ALL Privileges for a SINGLE user, Archive generation per hour, ash, attachment, awr, block, Cannot reuse the password, Check Installed RDBMS components, Check the Characterset info of database, create a role and assign all privileges to the role, Database growth per month, dba_network_acl_privileges, dblink ddl, DBMS_NETWORK_ACL_ADMIN, DBMS_NETWORK_ACL_ADMIN.add_privilege, dbms_network_acl_admin.assign_acl, DBMS_NETWORK_ACL_ADMIN.check_privilege, DBMS_NETWORK_ACL_ADMIN.delete_privilege, DBMS_NETWORK_ACL_ADMIN.drop_acl, Disable or enable all triggers of schema, email, email procedure, Error code -24247, Error: You cannot change password, explain plan, Failed to send mail, Find active transactions in db, Find duplicate rows in table, Find who locked your account, Generate Bulk AWR reports in database, Generate resize datafile script, Get ACL details in database, Get Database incarnation information in database, Get database link details in database, Get database uptime, Get DDL of all tablespaces, Get DDL of privileges granted to user, GET INDEX USAGE, Get installed sqlpatches in database, Get redo log member info, Get size of the database, Get sql query to html format, Get timezone information in database, Granted role permissions, hash value, How to Cleanup orphaned datapump jobs., How to find current redo log size in database, How to Find the optimal undo retention size in database, How to Get Alert log location in db, How to get CPU memory info in server, How to Modify window_size/ window baseline size, How to purge AWR old snapshot details in database, How to View / Modify AWR retention period, List of Roles having privilege on TABLE, List of Users having privilege on TABLE, List of Users/Roles having privilege on TABLE, mail, network access denied by access control list (ACL), No of users have a particular role, ORA-06512, ORA-20000, ORA-20009, ORA-24247, ORA-28003, oracle 12c, oracle 19c, oracle 20c, oracle 21c, oracle agent, oracle agent shrink, oracle database, Oracle Zero Downtime, Oracle Zero Downtime Migration, Oracle Zero Downtime Migration 21c, oracleagent, other privs, other privs granted to user, Password DDL, password verification for the specified password failed, Profile DDL, Roles, Roles & privs for a user, Roles comparison between databases, Roles DDL, Row count of all the tables of a schema, Scn to Timestamp and Timestamp to Scn, send email, send mail, Sequence DDL, session, shrink, Single Objects Grants, SMTP, smtp_out_server, sql baseline, sql hint, sql history, sql plan, sql profile, sql_text, System privileges to roles and users, system privs, table ddl, tablespace, Tablespace DDL, temp, transaction, undo, User DDL, Users DDL, user_network_acl_privileges, UTL_FILE_DIR, View hidden parameters, wait events, when was the password was changed for a user?, with attachment, Zero Downtime Migration, Zero Downtime Migration 21c

7 replies on “Oracle database Health check scripts”

nice job

LikeLike

nice post, I love oracleagent.wordpress.com !

Oracle database Health check scripts

LikeLike

good job, I love oracleagent.wordpress.com !

Oracle database Health check scripts

LikeLike

I enjoy reading through an article that will make men and women think. Also, many thanks for allowing me to comment!

LikeLike

Hi Team,

Links is very useful. But unable to open this below topics.

Get DDL ‘s For All objects in oracle database

TEMP TABLESPACE scripts

UNDO TABLESPACE scripts

LikeLike

Sorry, It’s working now.

LikeLike

[…] SCRIPTS […]

LikeLike

Leave a comment Cancel reply

Design a site like this with WordPress.com