SHELL : EXPORTING DATA FROM REMOTE DATABASE USING NETWORK_LINK In this article , we will how to automate the script for export data from remote database and import in source database. Check below link for previous article on same topic. HOW TO EXPORT DATA FROM REMOTE… Read More
How to kill Long Running Query using scripts(Version – 2). In this article , we will see how to write script to kill running query on Oracle database. Aim : To kill Long Running Query Step 1 : Create a table
|
1 2 |
DBMON>> CREATE TABLE LONG_RUNNING_TABLE(sno number,hiredate date); Table Created. |
Step 2 :… Read More
How to kill Long Running Sessions using scripts. In this article , we will see how to write script to kill running query on Oracle database. Aim : To kill Long Running Query Step 1 : Create a table
|
1 2 |
DBMON>> CREATE TABLE LONG_RUNNING_TABLE(sno number,hiredate date); Table Created. |
Step 2 : Insert huge… Read More
reference of this article from : www.orskl.com CONDITIONS & INTERACTIVE SCRIPTS IF clause Advanced IF usage CASE statements Display user messages User input 1.IF clause General At times you need to specify different courses of action to be taken in a shell script, depending on the… Read More
Unix Shell Scripting For DBA’s (PART – 08) Continuing from previous article. Unix Shell Scripting For DBA’s (PART – 07) 3.AWK programming This filter is among the most powerful filter which in itself a scripting language this filter was invented by three authors A-aho W-whenenberg… Read More
Unix Shell Scripting For DBA’s (PART – 07) GNU GNU stand for “GNU’s Not Unix!” reference of this article from : www.orskl.com It is a recursive acronym chosen because GNU’s design is Unix-like, but differs from Unix by being free software and containing no Unix code. Here we… Read More
Creation of Directories in Unix file system. What exactly is a directory ? we can say a directory is collection of files where files can be stored which will be helpful for the user to search the file Directory name Typical contents… Read More
Unix Shell Scripting For DBA’s (PART – 06) reference of this article from : www.orskl.com refer previous article https://www.ktexperts.com/unix-shell-scripting-for-dbas-part-05/ Regular expressions What are regular expressions? A regular expression is a pattern that describes a set of strings. Regular expressions are constructed analogously to arithmetic expressions… Read More
Unix Shell Scripting For DBA’s (PART – 05) reference of this article from : www.orskl.com Expansions and aliases General After the command has been split into tokens (see Section 1.4.1.1), these tokens or words are expanded or resolved. There are eight kinds of expansion performed, which… Read More
Unix Shell Scripting For DBA’s (PART – 04) reference of this article from : www.orskl.com BASH ENVIRONMENT In BASH ENVIRONMENT we have sub topics . They are : 1. Initialization 2. Variables and characters 3. Expansions and Aliases 4.Regular expressions 5.Grep examples 6.Pattern matching 1. Initialization … Read More
