Oracle Production Support Scripts

Share via:

Post Views: 0

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/