Protected: Shell :EXPORTING DATA FROM REMOTE DATABASE USING NETWORK_LINK
There is no excerpt because this is a protected post.
Oracle DB Admin
RMAN Commands in Oracle 12c
Dear Readers, In this article, we will see the following RMAN Commands in Oracle 12c. RECOVERY MANAGER(RMAN) COMMANDS. In this article , we will see all the best practices of RMAN commands. Oracle Recovery Manager (RMAN) satisfies the most pressing demands of performance, manageable backup… Read More
HOW TO EXPORT DATA FROM REMOTE DATABASE USING DATAPUMP.
HOW TO EXPORT DATA FROM REMOTE DATABASE USING DATAPUMP. In this article, we will see how to export data from remote database and import in source database. Source Database : iP address : 192.168.0.51 Instance Name : primary Remote Database : iP address : 192.168.0.61… Read More
Oracle: Scheduling Rman backup jobs through DBMS_SCHEDULER.
Oracle: Scheduling Rman backup jobs through DBMS_SCHEDULER. In this article we will learn how to schedule RMAN backup jobs through DBMS_SCHEDULER. Before reading this article Please check previous article on DBMS_SCHEDULER. Oracle: Scheduler Jobs in Oracle Database Step 1 : Create the Script That Invokes RMAN Create… Read More
ORACLE ANALYTICAL FUNCTIONS – 1
ORACLE ANALYTICAL FUNCTIONS – 1 In this article, we will see how Analytical functions works in Oracle. Analytical Function : Analytical function is used to compute the aggregate values and perform aggregate operations it returns more than value in each group In sql we have… Read More
Protected: How to kill Long Running Query using scripts.
There is no excerpt because this is a protected post.
Protected: Shell : Automate killing Blocking Sessions
There is no excerpt because this is a protected post.
Oracle :Batch updates using PLSQL Blocks.
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
Protected: Shell :Automated Gathering Stats using Shell Scripting for STALE STATS.
There is no excerpt because this is a protected post.
Oracle: Scheduler Jobs in Oracle Database-2
Oracle: Scheduler Jobs in Oracle Database-2 In this article we will learn how to create jobs with different options in dbms_scheduler. Before reading this article please check previous article. Oracle: Scheduler Jobs in Oracle Database Lets check options available in create_job procedure Use desc dbms_scheduler… Read More
