Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Oracle Support Metalink ID 161818.1 Oracle
  • Settting up get_vmstat.sh for colletinf CPU Usage. Oracle
  • purge_trc.sh Linux/Unix
  • Useful Solaris Commands on 28-SEP-2005 Linux/Unix
  • Recovering lost SYS password Oracle
  • Handling LOB data in Oracle Oracle
  • How to stop OCSSD Daemon Oracle
  • Resolving RMAN Hung Jobs Oracle
  • To see mem usage and CPU usage system wide. Linux/Unix
  • Find Stale DR Physical Standby Oracle
  • Flowers Resize datafiles Oracle
  • dbms_job.submit example Oracle
  • Updated LCK.SQL file. Oracle
  • pvm_pre_change.sql Oracle
  • 10g RAC: Troubleshooting CRS Root.sh Problems Oracle

Year: 2005

USE_NL and INDEX hints example

Posted on 07-Dec-2005 By Admin No Comments on USE_NL and INDEX hints example

select /*+ USE_NL(A,B) INDEX(a ATS_FLORIST_FITTYPE_I)*/ a.FIT_ID from ATS_FLORISTS a,ATS_FLORISTS_TRACKING b where b.FIN_PROC = ‘N’ AND b.OLD_FRESH_PAY = ‘Y’ and b.NEW_FRESH_PAY=’N’ and a.FIT_TYPE=’P’ and a.ID= b.fit_id

Oracle, SQL scripts

Index Range Scan

Posted on 01-Dec-2005 By Admin No Comments on Index Range Scan

If your index is NONUNIQUE, you cant enforce Index Unique Scan.

Oracle, SQL scripts

SQLPLUS COPY command Precautions.

Posted on 01-Dec-2005 By Admin No Comments on SQLPLUS COPY command Precautions.

One test case today i found with copy command. When we are using sqlplus copy command with “APPEND” clause, and if source table contains any NUMBER datatype without Precision and Scale, then COPY statement fails with error indicating “NUMERIC ERROR and Number data type precision is higher than 38 digit”.

Oracle, SQL scripts

Optimizer_Index init.ora parameter explaination.

Posted on 01-Dec-2005 By Admin No Comments on Optimizer_Index init.ora parameter explaination.

For Index ( Range Scan and Fast Full Scan Setings )in query (1) RULE uses index range scan (2) CBO uses Index fast full scan ( called Index FFS ) Here CBO uses multi block IO reading as per db_file_multi_block_read_count). By default, the CBO costs physical IO and logical IO the same. So it ignores…

Read More “Optimizer_Index init.ora parameter explaination.” »

Oracle, SQL scripts

CTAS with LONG Column for 9i and higher

Posted on 28-Nov-2005 By Admin No Comments on CTAS with LONG Column for 9i and higher

Executing CTAS statement having TO_LOB(LONG COLUMN). For example: create table blah as select GNT_ID.nextval, 1060 as gnt_ref_id, org.gnt_id, org.gnt_group_note, org.gnt_language, to_lob(org.gnt_text_string) as gnt_text_string, org.gnt_text_emphasize from asra_002.gnt_groupnote_txt org where org.gnt_group_note in (select gnr_note from asra_002.gnr_groupnote_ref)

Oracle, SQL scripts

CTAS with LONG Column for 7.x and 8 and 8i

Posted on 28-Nov-2005 By Admin No Comments on CTAS with LONG Column for 7.x and 8 and 8i

How to Copy Data from a Table with a LONG Column into an Existing Table ======================================================================= Purpose: ======== The purpose of this article is to provide a working example of how to COPY data from a table with a LONG column into another existing table with the same structure definition. This document is especially useful…

Read More “CTAS with LONG Column for 7.x and 8 and 8i” »

Oracle, SQL scripts

My FTP Job Scheduling for www.pvmehta.com

Posted on 24-Nov-2005 By Admin No Comments on My FTP Job Scheduling for www.pvmehta.com

/* file : 1 at_command_syntax */ at 00:00 /every:M,T,W,TH,F,S,SU “C:Pvmehsqlfilesftp01.bat” at 09:00 /every:M,T,W,TH,F,S,SU “C:Pvmehsqlfilesftp01.bat” at 12:00 /every:M,T,W,TH,F,S,SU “C:Pvmehsqlfilesftp01.bat” at 15:00 /every:M,T,W,TH,F,S,SU “C:Pvmehsqlfilesftp01.bat” at 18:00 /every:M,T,W,TH,F,S,SU “C:Pvmehsqlfilesftp01.bat” at 21:00 /every:M,T,W,TH,F,S,SU “C:Pvmehsqlfilesftp01.bat” /* file : 2 my.cmd */ open ftp.pvmehta.com pvmehta nupur46 lcd C:pvmehdoc1Z0-030 put oracle_9i_upgrade_certification.htm close open ftp.pvmehta.com pvmehta nupur46 lcd c:websitepvmehtacgi-bin cd cgi-bin get PERLMYSQL.txt…

Read More “My FTP Job Scheduling for www.pvmehta.com” »

PHP/MYSQL/Wordpress

First Entry in RAC

Posted on 24-Nov-2005 By Admin No Comments on First Entry in RAC

Real Application Cluster = OPS in previous oracle versions

Oracle, RAC

Windows based Command line mailing program like mailx (Sednmail for windows)

Posted on 23-Nov-2005 By Admin No Comments on Windows based Command line mailing program like mailx (Sednmail for windows)

Download for free from http://prdownloads.sourceforge.net/blat/Blat250.zip?use_mirror=voxel and installed using following command. Blat -installSMTP mail.pvmehta.com me@pvmehta.com After that i sent a text message using following command. F:UsefulBlat250Blat250full>blat – -body “test” -to me@pvmehta.com Blat v2.5.0 w/GSS encryption (build : Sep 14 2005 22:46:29) Sending stdin.txt to me@pvmehta.com Login name is me@pvmehta.com F:UsefulBlat250Blat250full>

PHP/MYSQL/Wordpress

get_vmstat.ksh

Posted on 23-Nov-2005 By Admin No Comments on get_vmstat.ksh

select a.measured_date, a.total_users, a.active_users, b.user_cpu, b.system_cpu, b.idle_cpu, b.wait_cpu from stats$totalusers a, stats$vmstat2 b where a.measured_date = b.start_date and to_char(measured_date,’DD-MON-YY’)=’22-NOV-05′ and to_char(measured_date,’HH24′) > ’14’ and to_char(measured_date,’HH24′) < '19' order by measured_date desc Script that populates stats$vmstat2 table is dbblkabva01:/export/home/oracle/oraprocs/get_vmstat2.ksh ——– vmstats.ksh ————- #!/bin/ksh # First, we must set the environment . . . . ORACLE_SID=BLINKT export...

Read More “get_vmstat.ksh” »

Linux/Unix, shell

Posts pagination

Previous 1 2 3 … 16 Next

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
  • Logic to chech # of parameters command line parameters Linux/Unix
  • How to specify 2 arch location to avoid any kind of DB hanging. Oracle
  • Removing first line Linux/Unix
  • ORACLE_SID in sqlplus Oracle
  • rm_backup_arch_file.ksh Linux/Unix
  • Rename Tablespace Oracle
  • How to see which patches are applied. Oracle
  • alter database backup controlfile to trace Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme