ORACLE:PL/SQL script to rebuild Table(s) and it’s corresponding indexes. Note : Please implement in lower environments before proceeding to Production. Pre requisites : Please download and check below file for pre-requisites. Table creation scripts The below script will be used for 1.Rebuild table(s) 2.Rebuild… Read More
There is no excerpt because this is a protected post.
Dear Readers, In this article, we will discuss Tools for Administering the Oracle Database Please Fill below Google Form (If we missed any Products, Tools, and Utilities that you use in achieving your goals as a Cassandra Administrator.) 👇🏻👇🏻👇🏻👇🏻👇🏻 https://forms.gle/oracledba Monitoring Tools: OEM Nagios EM… Read More
There is no excerpt because this is a protected post.
Hello Reader In this article , we will cover SecureCRT Buttons for Default. ############Setting up Format (format): To convert invalid timestamp value and to check current date.
|
1 2 |
alter session set nls_date_format='MM/DD/YYYY HH24:MI:SS'; Session altered. |
######### Instance Information (inst_info): This SQL outputs the information of instance that is up and running like… Read More
There is no excerpt because this is a protected post.
There is no excerpt because this is a protected post.
TOP SQL’s In this article,we will get notified for TOP SQL’s ORDERED BY ELAPSED TIME Step 1 : Create temporary tables to store TOP SQL’s
|
1 2 3 4 5 |
SYS>>CREATE TABLE dbmon.TOP_ELAPSEDTIME_SQLIDS ( SQL_ID VARCHAR2(20 CHAR), LASTMODIFIEDDATE DATE DEFAULT SYSDATE NOT NULL ); |
Another table to store ALL SQL’s.
|
1 2 3 4 5 |
SYS>>CREATE TABLE dbmon.ALL_ELAPSEDTIME_SQLIDS ( SQL_ID VARCHAR2(20 CHAR), LASTMODIFIEDDATE DATE DEFAULT SYSDATE NOT NULL ); |
Step 2 : Create the below scripts to capture TOP SQL’s in tables… Read More
There is no excerpt because this is a protected post.
Oracle :Batch updates using PLSQL Blocks. In this article , we will learn how to update million records in a table using plsql blocks. Aim : To avoid Undo errors –> For every 200 transactions we are keeping commit to avoid snapshot too old error.… Read More
