Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • scripts to take listener.log backup Linux/Unix
  • OEM-troubleshooting on 20-MAY-08 Oracle
  • setting prompt display with .profile Linux/Unix
  • Find long Running Transaction Linux/Unix
  • sid_wise_sql.sql Further explaination Oracle
  • Locktree.sql Oracle
  • How To Limit The Access To The Database So That Only One User Per Schema Are Connected (One Concurrent User Per Schema) Oracle
  • Standby Database File Management in 10g with STANDBY_FILE_MANAGEMENT Oracle
  • findobj.sql Oracle
  • Disbaling DBA_SCHEDULER_JOBS Oracle
  • Error Handling in Proc Oracle
  • dbms_job.submit example Oracle
  • All Hints for Oracle Databases Oracle
  • Find all users who have DML privileges Oracle
  • Virtual Indexes in Oracle Oracle

Tag: SQL

ENQ: KO – FAST OBJECT CHECKPOINT tips

Posted on 25-May-202325-May-2023 By Admin No Comments on ENQ: KO – FAST OBJECT CHECKPOINT tips

On reporting queries, there are too many “enq: KO – fast object checkpoint” wait event. All reporting queries are doing full table scans concurrently. Oracle uses direct path reads instead of db file scattered reads. And direct path reads require a checkpoint “_serial_direct_read”=NEVER Parameter Session Value Instance Value ————————————————– —————————— —————————— _serial_direct_read auto auto

Oracle

GSQ.sql

Posted on 19-May-202325-May-2023 By Admin No Comments on GSQ.sql

This SQL will be used to identify SQL details of given Session. You need to pass SID and INSTANCE_ID as INPUT. This query will provide session details, SQL_ID, SQL_EXEC_START time and other transaction level details. set echo off feedback off verify offcol Transaction_id format a20col username format a8col days format 99.99col hours1 format 999999col TX_HRS…

Read More “GSQ.sql” »

Oracle, SQL scripts

Sending SQLPLUS output in HTML format

Posted on 17-Feb-201025-May-2023 By Admin No Comments on Sending SQLPLUS output in HTML format

SET MARKUP HTML ON SPOOL ON generates an HTML page for each subsequently spooled file. The HTML tags in a spool file are closed when SPOOL OFF is executed or SQL*Plus exits. You can use SET MARKUP HTML ON SPOOL OFF to generate HTML output suitable for embedding in an existing web page. HTML output…

Read More “Sending SQLPLUS output in HTML format” »

Oracle, SQL scripts

Categories

  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • Oracle (388)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (337)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
  • SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
  • How to connect to Oracle Database with Wallet with Python.21-Mar-2025
  • JSON/XML Types in Oracle18-Mar-2025
  • CPU Core related projections12-Mar-2025
  • Exadata Basics10-Dec-2024
  • Reading config file from other folder inside class24-Sep-2024
  • Python class import from different folders22-Sep-2024
  • Transfer SQL Profiles from One database to other database.05-Sep-2024
  • Load testing on Oracle 19C RAC with HammerDB18-Jan-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Remove duplicate rows from table Oracle
  • Oracle Release Explaination Oracle
  • TNSNAMES entries details Oracle
  • fdisk -l explaination about Primary-Logical-Extended Partitions Linux/Unix
  • good linux notes Linux/Unix
  • SQL_PROFILE – I explaination Oracle
  • Gathering statistics with DBMS_STATS Oracle
  • eplan.sql Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme