Oracle (SecureCRT) : Temp Tablespace Monitoring Queries

Dear Readers, In this article, we will see Oracle (SecureCRT) : Temp Tablespace Monitoring Queries. Menubar : TEMP Tabname : Def_temp

Tabname : TS_Temp_Usage

Tabname : Temp_Space_Usage_SQLID

Tabname : Temp_sort_users

Tabname : Temp_Space_Usage_SQLID_Login_Active_InActive

Tabname : Addspace… Read More

Oracle (SecureCRT) : Important Queries for UNDO Management

Dear Readers, In this article, we will see the following Oracle (SecureCRT) : Important Queries for UNDO Management. MenuBar : UNDO Tab Name : Undo_Usage

Tab Name : Undo_Contetion

Tab Name : Undo_Trend_Today

Tab Name : Undo_Usage_For_Sessions

Tab… Read More

Excluding tables while performing datapump import from Full schema backup

Hello Everyone, In this article , we will learn Excluding tables while performing datapump import from full schema backup. Database : AVPROD Schema : OT Check objects count  in OT Schema.

Take full schema backup using schema=OT

Full schema backup completed ,… Read More

SQL Joins

Dear Readers, In this article, we will see the SQL Joins. Joins A join is a query that combines rows from two or more tables Join Conditions Most join queries contain WHERE clause conditions that compare two columns, each from a different table. Such a… Read More

Oracle : Important ASM Commands

Dear Readers, In this article, we will see the following Important ASM Commands. Tab Name : asm_free

Tab Name : ASMCMD>find file find +DATA01 undo* Tab Name : WhatInstances

Tab Name : Rebalance_status

Tab Name : ASM_Candidate

Tab… Read More