Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • process id based files and processes Linux/Unix
  • First Entry in RAC Oracle
  • How to hide author name in WordPress BLOG PHP/MYSQL/Wordpress
  • For Perl DBI installation and testing program PHP/MYSQL/Wordpress
  • proper cpu stats Linux/Unix
  • exp syntax in oracle 10g Oracle
  • Processes parameter and its dependencies on OS kernel parameters Linux/Unix
  • This is im telling Kishore Oracle
  • avail.sh ( find filesystem spae usage) Linux/Unix
  • Passing from Unix to PLSQL using bind variables Linux/Unix
  • import-export with multiple files Oracle
  • Sample WW22 listener.ora Oracle
  • purge_trc.sh Linux/Unix
  • Jai Shree Ram Oracle
  • TNSNAMES entries details Oracle

Tag: database

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

Wait.sql

Posted on 04-Apr-202322-Apr-2025 By Admin No Comments on Wait.sql

/********************************************Author: Paresh MehtaScript Name : waitt.sqlwaits order by sql start time********************************************/set feedback 1set pages 2000set lines 190column event format a45column machin format a12column modul format a10column prg format a10column osuser1 format a10column username format a10column sesinfo format a15column blockedby format a15alter session set nls_date_format=’DDMONRR:HH24:MI:SS’;select /*+ first_rows(100) */ a.sid || ‘,’ || a.serial# || ‘,@’ ||…

Read More “Wait.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
  • tar and untar a dolder with all its subfolder. Linux/Unix
  • online_ts_bkup.sql Oracle
  • xargs use Linux/Unix
  • 10g oem configuration Oracle
  • Import and export statements Oracle
  • get_vmstat_solaris Oracle
  • Wait time tuning research Oracle
  • _B_TREE_BITMAP_PLANS issue during 8.1.7 to 9.2.0.8 upgrade Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme