Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • replace alphabets using sed Linux/Unix
  • backspace in SQL Plus not working then..? Linux/Unix
  • PLSQL Table Syntax 1 Oracle
  • DBMS_SQL for alter session. Oracle
  • Reading parameter file and printing Linux/Unix
  • Does DBMS_JOB recompute the NEXT_DATE interval after or before Oracle
  • Nice Article about semaphores and init.ora Processes parameter relations Linux/Unix
  • Good Oracle Architecture In Short and point to point Oracle
  • SYSOPER Mystery Oracle
  • CTAS with LONG Column for 7.x and 8 and 8i Oracle
  • to see when crontab is changed. Linux/Unix
  • Create type and Grant on it. Oracle
  • AWR settings- MMON is not taking snapshot. Oracle
  • Database logon trigger issue Oracle
  • Rownum with Order by Oracle

longtx.sql with the flag whether session is blocking any DML locks or not.

Posted on 18-May-2009 By Admin No Comments on longtx.sql with the flag whether session is blocking any DML locks or not.

col machine format a30 col sid format 99999 col serial# format 99999 col sid_info format a14 col Transaction_id format a20 col username format a8 col days format 99.99 col hours1 format 999999 col TX_HRS format 999 col USER_HRS format 999 col LOCK format a2 set lines 120 pages 200 select a.sid || ‘,’ || a.serial#…

Read More “longtx.sql with the flag whether session is blocking any DML locks or not.” »

Oracle, SQL scripts

FRA Information.

Posted on 18-May-2009 By Admin No Comments on FRA Information.

Applies to: Enterprise Manager for RDBMS – Version: 10.1.0.0 to 11.1 Oracle Server – Enterprise Edition – Version: 10.1.0.0 to 11.1 Information in this document applies to any platform. Purpose This article contains FAQ for Flash Recovery Area ( FRA ) Questions and Answers 1. What is a Flash Recovery Area and how to configure…

Read More “FRA Information.” »

Oracle, SQL scripts

Oracle Connections expire_time and firewall

Posted on 05-May-2009 By Admin No Comments on Oracle Connections expire_time and firewall

When the client or server closes the communication it sends TCP FIN type packet, this is a normal socket closure. However, it is not uncommon that the client server communication abruptly ending without closing the end points properly by sending FIN packet, for example, when the client or server crashed, power down or a network…

Read More “Oracle Connections expire_time and firewall” »

Oracle, SQL scripts

secure crt settings

Posted on 04-May-2009 By Admin No Comments on secure crt settings

Copy on Select The Copy on select feature allows you to speed up the process of copying text from the terminal screen to the Clipboard. If this feature is enabled, text is copied to the Clipboard as soon as it is selected. To enable/disable the Copy on select feature: 1. Select the Terminal category in…

Read More “secure crt settings” »

Linux/Unix, shell

scp with ssh2

Posted on 24-Apr-2009 By Admin No Comments on scp with ssh2

scp -p -o ‘protocol 2’ SOURCE_FILE TARGET_HOST:TARGET_FILE

Linux/Unix, shell

Ports used by Oracle Software

Posted on 03-Mar-2009 By Admin No Comments on Ports used by Oracle Software

files are $ORACLE_HOME/install/setupinfo.txt $ORACLE_HOME/install/portlist.ini

Oracle, SQL scripts

Running some SQL on multiple databases connecting using monitoring userid and password

Posted on 08-Feb-2009 By Admin No Comments on Running some SQL on multiple databases connecting using monitoring userid and password

==>cat tns_entry_list DB1 Db2 Db3 db4 ==>cat find_max_dbfs.ksh #!/bin/ksh for tns_entry in `cat tns_entry_list` do echo “–” echo “——— TNS ENTRY ${tns_entry} ———-” /oracle/app/oracle/product/9.2.0.8/bin/sqlplus monioring_user/monitoring_password@${tns_entry} cat find_max_dbfs.sql set lines 120 pages 200 col “-?db_files_value” format a20 col “MAXDATAFILES” format 9999999999999999 col “USED MAXDATAFILES” format 99999999999999 select ‘-?’ || x.value as “-?db_files_value”, y.records_total “MAXDATAFILES”, y.records_used “USED…

Read More “Running some SQL on multiple databases connecting using monitoring userid and password” »

Linux/Unix, shell

All Hints for Oracle Databases

Posted on 05-Feb-2009 By Admin No Comments on All Hints for Oracle Databases

SQL Statement Hints – A Summary See Note 35934.1 for CBO issues. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ General: – Syntax: /*+ HINT HINT … */ (In PLSQL the space between the ‘+’ and the first letter of the hint is vital as otherwise the hint may be ignored so /*+ ALL_ROWS */ is fine but /*+ALL_ROWS */ will cause…

Read More “All Hints for Oracle Databases” »

Oracle, SQL scripts

DBMS_JOB all example

Posted on 21-Jan-2009 By Admin No Comments on DBMS_JOB all example

Job Execution Interval: ‘SYSDATE + 7’ Exactly seven days from the last execution ‘SYSDATE + 1/48’ Every half hour ‘NEXT_DAY(TRUNC(SYSDATE), ”MONDAY”) + 15/24’ Every Monday at 3PM ‘NEXT_DAY(ADD_MONTHS(TRUNC(SYSDATE, ”Q”), 3), ”THURSDAY”)’ First Thursday of each quarter Remobe the job: BEGIN DBMS_JOB.REMOVE(14144); END; / Change the job: In this example, job number 14144 is altered to…

Read More “DBMS_JOB all example” »

Oracle, SQL scripts

dbms_job.submit example

Posted on 21-Jan-2009 By Admin No Comments on dbms_job.submit example

VARIABLE jobno NUMBER BEGIN DBMS_JOB.SUBMIT(:jobno, ‘DBMS_DDL.ANALYZE_OBJECT(”TABLE”, ”HR”, ”EMPLOYEES”, ”ESTIMATE”, NULL, 50);’, SYSDATE, ‘SYSDATE + 1’); COMMIT; END; / PRINT jobno JOBNO ———- 14144

Oracle, SQL scripts

Posts pagination

Previous 1 … 16 17 18 … 58 Next

Categories

  • Ansible (0)
  • AWS (2)
  • Azure (1)
  • Django (0)
  • GIT (1)
  • Linux/Unix (149)
  • MYSQL (5)
  • Oracle (395)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (150)
  • SQL scripts (343)
  • SQL Server (6)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • prepfiles.sh for step by step generating pending statistics files10-Mar-2026
  • tracksqltime.sql05-Mar-2026
  • Complete Git Tutorial for Beginners25-Dec-2025
  • Postgres DB user and OS user.25-Dec-2025
  • Trace a SQL session from another session using ORADEBUG30-Sep-2025
  • SQL Server Vs Oracle Architecture difference25-Jul-2025
  • SQL Server: How to see historical transactions25-Jul-2025
  • SQL Server: How to see current transactions or requests25-Jul-2025
  • T-SQL Vs PL/SQL Syntax25-Jul-2025
  • Check SQL Server edition25-Jul-2025

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Looping for remote servers and find its database from oratab file. Linux/Unix
  • V$CONTROLFILE_RECORD_SECTION reference notes. Oracle
  • CPU speed on solaris Linux/Unix
  • To seee semaphores and shared memory segments in Solaris Linux/Unix
  • How to stop OCSSD Daemon Oracle
  • cache buffer chain latch Oracle
  • How to hide author name in WordPress BLOG PHP/MYSQL/Wordpress
  • ORA-01220 Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme