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

Apps DBA

Query To Find Number Of Users Connected To EBS

Query To Find Number Of Users Connected To EBS SELECT … Read more

Query To Find Who Is Connected When to Which Responsibilities

Query To Find Who is Connected When to Which Responsibilities … Read more

Query For Workflow Mailer Configurations

Query For Workflow Mailer Configurations SELECT p.parameter_id,p.parameter_name,v.parameter_value valueFROM apps.fnd_svc_comp_param_vals_v v,apps.fnd_svc_comp_params_b … Read more

Query To Find All Responsibilities Assigned To a User

Query To Find All Responsibilities Assigned To a User SELECT … Read more

Query To Find All Users Assigned To Given Responsibility

Query To Get All Users Assigned To Given Responsibility SELECT … Read more

Query To Find All Reports Registered Within Given Application

Query To Find All Reports Registered Within Given Application SELECT … Read more

Query To Find Responsibility Name from a Concurrent Program

Query To Find Responsibility Name from a Concurrent Program SELECT … Read more

Query Count the number of reports registered In Each Module

Query To Count the number of reports registered In Each … Read more

Query To Find Scheduled Concurrent Request

Query To Find Scheduled Concurrent Request SELECT cr.request_id,Decode(cp.user_concurrent_program_name, ‘Report Set’, … Read more

Query To Find All Reports Status With User Name

Query To Find All Reports Status With User Name SELECT … Read more

Older posts
Newer posts
← Previous Page1 … Page5 Page6 Page7 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.