Skip to content

Tutorialwale

  • Home
  • Linux
  • SQL
  • Scripts
  • Oracle DBA
  • Oracle RAC
  • GoldenGate
  • Data Guard
  • Apps DBA
  • PostgreSQL
  • AWS Cloud
  • Oracle Cloud
  • Azure Cloud
  • Interview Questions
  • How To
  • Home
  • Linux
  • SQL
  • Scripts
  • Oracle DBA
  • Oracle RAC
  • GoldenGate
  • Data Guard
  • Apps DBA
  • PostgreSQL
  • AWS Cloud
  • Oracle Cloud
  • Azure Cloud
  • Interview Questions
  • How To

Oracle DBA

Drop all schema objects

Drop all schema objects Be careful when you drop all … Read more

How To Find CPU Usage For a Session

How to Find CPU Usage For a Session? SET linesize … Read more

How To Find Database Objects With Datafiles?

How To Find Database Objects With Datafiles? SELECT DISTINCT t.ts#,t.name … Read more

Find Total Undo Statistics

To Find Total Undo Statistics ALTER SESSION SET nls_date_format=’dd-mon-yy hh24:mi’; … Read more

List All Datafile Of Undo Tablespace

List All Datafile Of Undo Tablespace SELECT tablespace_name,file_name,file_id,autoextensible,bytes / 1048576 … Read more

Datewise Occurrence Of ORA-1555

Datewise Occurrence Of ORA-1555 SELECT To_char(begin_time, ‘mm/dd/yyyy hh24:mi’) “Int. Start”,ssolderrcnt … Read more

Extent Count And Total Blocks

Extent Count And Total Blocks set linesize 152col tablespace_name FOR … Read more

How To Generate ASH Report in Oracle Database?

To generate ASH Report in an Oracle database. It’s simple … Read more

How To Generate ADDM Report in Oracle Database?

To generate ADDM Report in an Oracle database. It’s simple … Read more

How To Generate AWR Report in Oracle Database?

To generate AWR report, ASH report, and ADDM report for … Read more

Older posts
Page1 Page2 Page3 Next →

  • Linux
    • Best Linux Commands For Beginners
    • Best Common Linux Commands
    • Basic Linux commands for Oracle DBA With Examples
    • Top 10 Linux Commands with Examples
    • Top 20 Linux Commands with Examples
    • Top 30 Linux Commands with Examples
    • Top 40 Linux Commands with Examples
    • Top 50 Linux Commands with Examples
    • Top 100 Linux Commands with Examples, Definitions, and descriptions
  • SQL
    • ALTER TABLE
    • SQL Aliases
    • SQL AND Operator
    • SQL ANY and ALL Operators
    • SQL AVG() Function
    • SQL BETWEEN Operator
    • SQL CASE Expression
    • COUNT() Function
    • SQL Delete Statement
    • SQL Functions With Examples
    • SQL GROUP BY Statement
    • SQL HAVING Clause
    • SQL IN Operator
    • SQL INSERT INTO SELECT Statement
    • SQL Joins
    • SQL LIKE Operator
    • MIN() and MAX() Functions
    • SQL NOT Operator
    • SQL Order By Clause
    • SQL SELECT INTO Statement
    • SELECT TOP Clause
    • SUM() Function
    • SQL Update Statement
    • SQL WHERE Clause
    • SQL Wildcards
    • Count Of Active Sessions
    • Datewise Occurrence Of ORA-1555
    • Difference Between DROP, DELETE, and TRUNCATE: DROP vs DELETE vs TRUNCATE
  • Scripts
    • List All Undo Datafiles With Status And Size
    • Inactive Programs With Disk Reads
  • Oracle DBA
    • Drop all schema objects
    • List All Datafile Of Undo Tablespace
    • Extent Count And Total Blocks
    • Find Total Undo Statistics
    • How To Find CPU Usage For a Session
    • How To Find Database Objects With Datafiles?
    • How to Find Scheduled Concurrent Program
    • How to Find The Request Group Associated with a Program
    • How To Generate ADDM Report in Oracle Database?
    • How To Generate ASH Report in Oracle Database?
    • How To Generate AWR Report in Oracle Database?
    • How To Generate Oswatcher Report in Linux?
    • How to Get Counts of All Tables in a Schema in PL/SQL?
    • How To Grant Read Only Access To User in Oracle Database?
    • How To Move a Table To a Different TableSpace
    • How to Resize Temporary Tablespace in Oracle 11g Database
    • How to Resolve ORA-00001: unique constraint violated in Oracle
    • Inactive JDBC Sessions
    • Inactive Modules
  • Oracle RAC
  • GoldenGate
    • Oracle GoldenGate Parameters
  • Data Guard
  • Apps DBA
    • To Find Current Running sqls
    • Find Total Undo Statistics
    • To Check When a Table is Last Analysed
    • How to Get Counts of All Tables in a Schema in PL/SQL?
    • Undo Space Used By All Transactions
    • How To Find CPU Usage For a Session
    • Inactive Session Details More Than 1 Hour
    • SQL Query To Check Active Transactions
    • How To Move a Table To a Different TableSpace
    • Undo Tablespace Utilization By All Sessions
    • List Of Long Running Queries
    • How To Find Database Objects With Datafiles?
    • To Find Toad Sessions
  • PostgreSQL
  • AWS Cloud
  • Oracle Cloud
  • Azure Cloud
  • Interview Questions
  • How To

  • Recent Comments
  • No comments to show.
© Copyright 2023-2028 www.tutorialwale.com. All rights reserved.