Dear Readers, In this article, we will see the Oracle : Important Queries for Parallel Feature (SecureCRT). Menubar Name : Parallel Tab Name : Create table show parameter parallel_max_servers create table owner.tablename_bkp as select /*+ parallel(tablename,64) */ * from owner.tablename ; create table vinod.tablename_bkp as… Read More
Dear Readers, In this article, we will see the Oracle: Important commands for Lock/Unlock Stats and Backup/Restore Old Stats (SecureCRT). MenuBar Name : Lock/Unlock Stats and Backup/Restore Old Stats Tab Name : Check Stats for Table –example : ‘DEPT’,’EMP’,’SALGRADE’ set linesize 300 set pagesize 100… Read More
In this article, we will see Oracle 19c (19.3) Software Installation On Linux 7.6 Click here to Download Oracle 19c Software from Oracle Support. Create a directory for ORACLE_HOME [oracle@oracle19c ~]$ mkdir -p /oracle/app/product/19.3.0/dbhome_1 Unzip the oracle 19c software [oracle@oracle19c ~]$ unzip -d /oracle/app/product/19.3.0/dbhome_1/LINUX.X64_193000_db_home.zip Goto Oracle… Read More
Dear Readers, In this article, we will see the Transport Plan from One Database to Another Database in Oracle . Transport Good Execution Plan(Hash Plan) from one database to another database Requirement: ETL was taking longer period of time in Prod database where as in… Read More
Dear Readers, In this article, we will see the STANDALONE to RAC Conversion. 1)Take the existing database backup using the crontab job 2) Take the database information. (i.e datafile,tempfile,redolog & Controlfile) 3) Take the pfile backup to any location from spfile. 4) Export the SID… Read More
Dear Readers, In this article, we will see the Oracle : Important Queries to check Table Fragmentation (SecureCRT). Menubar Name : Fragmentation Tab name : Fragmented_tablesList in HTML col spoolname new_value spoolname select ‘Fragmented_tables’||to_char(sysdate, ‘YYYYMONDD’)||’.html’ spoolname from dual; spool ‘&spoolname’ set pagesize 200 set markup… Read More
Dear Readers, In this article, we will see the Oracle : Important Queries to check Blocking sessions (SecureCRT). Menubar : Blocking Tab : Blocking Sessions set linesize 300 select B.USERNAME ||’ (‘||B.SID||’,’||B.SERIAL#||’,@’||B.INST_ID||’) is Currently ‘||B.STATUS||’ for last ‘||B.LAST_CALL_ET||’ Sec and it”s BLOCKING user ‘|| W.USERNAME||… Read More
Please check below articles to get good knowledge on SecureCRT . SNO DESCRIPTION ARTICLE LINK 1 Ease of DB Administration Via SecureCRT https://www.ktexperts.com/ease-of-db-administration-via-securecrt/ 2 SecureCRT Buttons for Default https://www.ktexperts.com/securecrt-buttons-for-default/ 3 Oracle : TableSpace Menu Bar in SecureCRT https://www.ktexperts.com/oracle-tablespace-menu-bar-in-securecrt/ 4 Oracle : Important ASM Commands https://www.ktexperts.com/oracle-important-asm-commands/… Read More
Dear Readers, In this article, we will see the following Important Monitoring commands for EXPDP/IMPDP (SecureCRT). MenuBar : Datapump (Exports and Imports) Tab : DataPump_Sessions SET TERMOUT OFF; COLUMN current_instance NEW_VALUE current_instance NOPRINT; SELECT rpad(instance_name, 17) current_instance FROM v$instance; SET TERMOUT ON; PROMPT PROMPT +————————————————————————+… Read More
Dear Readers, In this article, we will see the following Important commands for Flashback (SecureCRT). Menubar : Flashback (FB) Tab : FRA_Usage set linesize 300 col file_type for a40 select * from V$FLASH_RECOVERY_AREA_USAGE; FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES CON_ID —————————————- —————— ————————- ————— ———- CONTROL FILE… Read More
Dear Readers, In this article, we will see the following Install Python Boto3 On AWS EC2. Collecting Cluster Health Monitor Data 👉 Oracle recommends that you run the diagcollection.sh script on all nodes in the cluster to collect Cluster Health Monitor data. 👉 Running the… Read More
Dear Readers, In this article, we will see the following Daily Tips for Linux. Tip-1 Date: 05-Feb-21 Provided By: Sridhar What is Operating System ? 👉 Operating system is an interface between user and the computer hardware.… Read More
Dear Readers, In this article, we will see the following Install Python Boto3 On AWS EC2. Steps to Follow : Logging to AWS Account Launch Linux Server Connect to Linux EC2 Instance by Using Putty Install Python Package Install Boto3 Package Verify boto3 Package … Read More
Dear Readers, In this article, we will see SQL Server Database Architecture. SQL Server MDF Files In the SQL Server Primary Data Files are the basic data files which are related to the database for the storing and supervision of the information. MDF file in… Read More
Dear Readers, In this article,we will see Download and Install Maven Plugin In Jenkins. Steps to Follow Logging to Jenkins. Download and Install Maven Plugin. Restart Jenkins. Logging to Jenkins. Verify plugin “maven integration” and “green balls”. First,we need to go Jenkins Logging page… Read More
Hello everyone, In this article, we will learn Generating DDL using existing dumpfile. To generate DDL of a schema or table from a dumpfile we use a parameter called SQLFILE. Purpose: SQLFILE is a paramater which can be used in IMPDP utility to generate DDL… Read More
Dear Readers, In this article, we will see the Upgradation and Data Migration in SQL Server. We have to download the Sql server patches from Sql server Builds site. (https://sqlserverbuilds.blogspot.com/) What is Cumulative updates (CU) 👉 Each new CU contains all the fixes that were… Read More
Dear Readers, In this article, we will see Oracle (SecureCRT) : Temp Tablespace Monitoring Queries. Menubar : TEMP Tabname : Def_temp set linesize 300 col property_name for a35 col property_value for a20 col description for a45 SELECT * FROM DATABASE_PROPERTIES where PROPERTY_NAME=’DEFAULT_TEMP_TABLESPACE’; PROPERTY_NAME PROPERTY_VALUE DESCRIPTION… Read More
Dear Readers, In this article, we will see the Upgradation and Data Migration in SQL Server. Version upgradation 2014 to 2016 SQL 2014 evaluation edition….. Enterprise edition. In SQL server 2014 standard edition to enterprise edition The upgrading the version in SQL server 2014 it… Read More
Dear Readers, In this article, we will see the following Oracle (SecureCRT) : Important Queries for UNDO Management. MenuBar : UNDO Tab Name : Undo_Usage set linesize 200 pagesize 200 compute sum of “Total Space in GB” on report select tablespace_name, status segment_status, count(extent_id) “Extent… Read More
