Oracle Production Support Scripts

Share via:

Dear Readers,

Please check the below articles to get good knowledge on Oracle Production Support Scripts.

SNO Article Name Article Link
1 Oracle : Check Partition Summary More than N Days (60 Days) https://www.ktexperts.com/oracle-partition-check-summary-more-than-n-days-60-days/
2 UNDO segments not Releasing Space https://www.ktexperts.com/undo-segments-not-releasing-space/
3 Oracle : How to Kill Blocking Sessions in RAC https://www.ktexperts.com/oracle-how-to-kill-blocking-sessions-in-rac/
4 Oracle: Comparison between Python and Shell Script for sending email for the set of SQL commands https://www.ktexperts.com/oracle-comparison-between-python-and-shell-script-for-sending-email-for-the-set-of-sql-commands/
5 ORACLE: PL/SQL script to rebuild Table(s) and it’s corresponding indexes https://www.ktexperts.com/oracle-plsql-script-to-rebuild-tables-and-its-corresponding-indexes/
6 ORACLE : Shell script to rebuild indexes for index fragmentation https://www.ktexperts.com/oracle-shell-script-to-rebuild-indexes-for-index-fragmentation/
7 Shell Script to get EMAIL alerts for ABENDED PROCESSES in Oracle GoldenGate https://www.ktexperts.com/shell-script-to-get-email-alerts-for-abended-processes-in-oracle-goldengate/
8 Automating drop partitions for set of Partition tables(Retention based on Selected Dates) https://www.ktexperts.com/automating-drop-partitions-for-set-of-partition-tablesretention-based-on-selected-dates/
9 Generate DDL for Tables using PLSQL Package. https://www.ktexperts.com/generate-ddl-for-tables-using-plsql-package/
10 ORACLE: GET NOTIFIED FOR TOP SQL’s ORDERED BY ELAPSED TIME https://www.ktexperts.com/oracle-get-notified-for-top-sqls-ordered-by-elapsed-time/
11 Shell :EXPORTING DATA FROM REMOTE DATABASE USING NETWORK_LINK https://www.ktexperts.com/shell-exporting-data-from-remote-database-using-network_link/
12 How to kill Long Running Query using scripts(Version – 2) https://www.ktexperts.com/how-to-kill-long-running-query-using-scriptsversion-2/
13 How to kill Long Running Query using scripts https://www.ktexperts.com/how-to-kill-long-running-query-using-scripts/
14 Shell : Automate killing Blocking Sessions https://www.ktexperts.com/shell-automate-killing-blocking-sessions/
15 Oracle :Batch updates using PLSQL Blocks https://www.ktexperts.com/oracle-batch-updates-using-plsql-blocks/
16 Shell :Automated Gathering Stats using Shell Scripting for STALE STATS https://www.ktexperts.com/shell-automated-gathering-stats-using-shell-scripting-for-stale-stats/
17 Oracle:HEALTH CHECK REPORT(Capturing Archive information) https://www.ktexperts.com/oraclehealth-check-reportcapturing-archive-information/
18 Oracle:HEALTH CHECK REPORT (Capturing Database size) https://www.ktexperts.com/oraclehealth-check-report-capturing-database-size/
19 ORACLE : HOW TO CHECK INDEX FRAGMENTATION https://www.ktexperts.com/how-to-check-index-fragmentation/
20 Oracle : Shell script for Health Check in HTML Format https://www.ktexperts.com/oracle-shell-script-for-health-check-in-html-format/
21 Oracle : Shell Script for sending email for Expired Users https://www.ktexperts.com/oracle-shell-script-for-sending-email-for-expired-users/
22 Oracle : Script for sending email for Invalid Objects https://www.ktexperts.com/oracle-script-for-sending-email-for-invalid-objects/
23 Oracle : Script for Sending email for Blocking Sessions https://www.ktexperts.com/oracle-script-for-sending-email-for-blocking-sessions/
24 Oracle : LongRunningSession https://www.ktexperts.com/oracle-longrunningsession-script/
25 How to move or rename Oracle Home https://www.ktexperts.com/how-to-move-or-rename-oracle-home/
26 Oracle : Scheduling crontab to send EMAIL in Unix https://www.ktexperts.com/oracle-scheduling-crontab-to-send-email-in-unix/
27 Oracle : Setting up glogin.sql https://www.ktexperts.com/oracle-setting-up-glogin-sql/
28 Oracle : Procedure to capture the Tables row count and Actual table size https://www.ktexperts.com/oracle-procedure-to-capture-the-tables-row-count-and-actual-table-size/
29 Oracle : How to Purge CURSORS related to a single SQL_ID from library cache https://www.ktexperts.com/oracle-how-to-purge-cursors-related-to-a-single-sql_id-from-library-cache/
30 Oracle : List all the hidden parameter and their values – &&&&&& – Simulate ORA error in Alert log https://www.ktexperts.com/oracle-list-all-the-hidden-parameter-and-their-values-simulate-ora-error-in-alert-log/
31 Oracle : HOW TO TRACE SESSIONS https://www.ktexperts.com/oracle-how-to-trace-sessions/
32 Oracle : Delete duplicate records from table https://www.ktexperts.com/oracle-delete-duplicate-records-from-table/
33 Oracle : Script for Email alert for Blocking sessions in Database. https://www.ktexperts.com/oracle-script-for-email-alert-for-blocking-sessions-in-database/
34 Oracle Delete Set of rows in a table https://www.ktexperts.com/oracle-delete-set-of-rows-in-a-table/
35 Oracle : Generating Million Random Records for Temporary Table. https://www.ktexperts.com/oracle-generating-million-random-records-for-temporary-table/
36 Executing job in Background for one sql https://www.ktexperts.com/executing-job-in-background-for-one-sql/
37 Generate output in HTML https://www.ktexperts.com/generate-output-in-html/
38 Generate Service and DB Details with one command for N DB’s on one cluster https://www.ktexperts.com/generate-service-and-db-details-with-one-command-for-n-dbs-on-one-cluster/
39 Start All DB’s using script https://www.ktexperts.com/start-all-dbs-using-script/
40 Simple Script to Delete Archive logs https://www.ktexperts.com/simple-script-to-delete-archive-logs/
41 RMAN Full Backup https://www.ktexperts.com/rman-full-backup/
Tools for Administering the Oracle Database https://www.ktexperts.com/tools-for-administering-the-oracle-database/

 

Thank you for giving your valuable time to read the above information. Please click here to subscribe for further updates

KTEXPERTS is always active on below social media platforms.

Facebook : https://www.facebook.com/ktexperts/
LinkedIn : https://www.linkedin.com/company/ktexperts/
Twitter : https://twitter.com/ktexpertsadmin
YouTube : https://www.youtube.com/c/ktexperts

Share via:
Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

Add Comment