Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • How does one SELECT a value from a table into a Unix variable? From SQL to Shell Linux/Unix
  • tab.sql Oracle
  • Adding Datafile on Primary Server and Impact on Standby Server Oracle
  • Find_table_size.sql Oracle
  • catall.sh Linux/Unix
  • SQL Server: How to see current transactions or requests SQL Server
  • Good Link from metalink 1 Oracle
  • scripts to take listener.log backup Linux/Unix
  • login.sql Oracle
  • How to find password change date for user Oracle
  • Implementing Listener Security Oracle
  • Locally Managed Tablespace and Dictionary managed tablespace (LMT-DMT) Oracle
  • ENQ: KO – FAST OBJECT CHECKPOINT tips Oracle
  • Monitor and Trace Unix processes using truss Linux/Unix
  • Rownum with Order by Oracle

logminer and my_lbu

Posted on 18-Apr-2007 By Admin No Comments on logminer and my_lbu

dbms_logmnr.add_logfile(‘/export/home/oracle/paresh/arch1_558809894_83113.arc’, options => dbms_logmnr.new); dbms_logmnr.add_logfile(‘/export/home/oracle/paresh/arch1_558809894_83114.arc’, options => dbms_logmnr.addfile); dbms_logmnr.add_logfile(‘/export/home/oracle/paresh/arch1_558809894_83115.arc’, options => dbms_logmnr.addfile); dbms_logmnr.add_logfile(‘/export/home/oracle/paresh/arch1_558809894_83116.arc’, options => dbms_logmnr.addfile); execute DBMS_LOGMNR.START_LOGMNR(options => dbms_logmnr.dict_from_online_catalog); Then rename v$logmnr_contents to logminer_bak. Then run my_lbu.sql

Oracle, SQL scripts

How to Use DBMS_STATS to Move Statistics to a Different Database

Posted on 19-Mar-2007 By Admin No Comments on How to Use DBMS_STATS to Move Statistics to a Different Database

Subject: How to Use DBMS_STATS to Move Statistics to a Different Database Doc ID: Note:117203.1 Type: FAQ Last Revision Date: 01-MAR-2007 Status: PUBLISHED To provide Oracle Support Services with statistics for debugging, please refer to the following article: Note 242489.1 Transferring Optimizer Statistics to Support Purpose: ======== The purpose of this article is to explain…

Read More “How to Use DBMS_STATS to Move Statistics to a Different Database” »

Oracle, SQL scripts

export import with parameter file.

Posted on 15-Mar-2007 By Admin No Comments on export import with parameter file.

Export with parameter file and import with same. =============================================== Task : I am exporting some tables from CS and importing thsoe tables into BASKET schema. /**************************************************** FILE NAME: exp_wo_data.par *******************/ userid=cs file=exp_bskt_15MAR07.dmp compress=N grants=N log=bskt_exp_15MAR07.log ROWS=N triggers=N statistics=NONE tables=(BSKT_AGENT_BASKET_CALL_DETAIL , BSKT_AGENT_ORDER_NOTE , BSKT_BASKET_ITEM_TYPE , BSKT_DISCOUNT_APPLY_TYPE , BSKT_DISCOUNT_REASON , BSKT_ITEM_CALC_PRICING , BSKT_ITEM_PRICING_XREF , BSKT_ITEM_SUB_PRODUCT , BSKT_PAYMENT_DETAIL…

Read More “export import with parameter file.” »

Oracle, SQL scripts

chk_space_SID.ksh

Posted on 14-Mar-2007 By Admin No Comments on chk_space_SID.ksh

. $ENV_FILE #sqlplus -silent / as sysdba

Linux/Unix, shell

chk_space_SID.ksh

Posted on 14-Mar-2007 By Admin No Comments on chk_space_SID.ksh

#Description : This script will check whether free space is there for next extent allocation or not. #It checks TS level and OS level for extent allocation. Checks for UNIFORM allocated extents. #For system allocated extents. this script will check 1 GB should be there as free threshold. NODENAME1=`hostname` ORACLE_SID=WEBP18F LOG_FILE_DIR=/home/oracle/oraprocs/logs ENV_FILE=/home/oracle/oraprocs/WEBP18F.env #NOTIFY_LIST=’8774544468@skytel.com’,’8774537913@skytel.com’,’8666714349@skytel.com’,’8774538204@skytel.com’,’dbaoracle@1800flowers.com’,’8774889576@skytel.com’ NOTIFY_LIST=’pmehta@1800flowers.com’ ADMIN_USER=vivek…

Read More “chk_space_SID.ksh” »

Linux/Unix, shell

chk_space_SID.ksh

Posted on 14-Mar-2007 By Admin No Comments on chk_space_SID.ksh

#!/bin/ksh

Linux/Unix, shell

To Find Orphan OS processes.

Posted on 19-Feb-2007 By Admin No Comments on To Find Orphan OS processes.

To Find Orphan OS processes. When a process run from command line its parent process id will be 1. Consider following example: In current session, we are executing SQLPLUS. whose process id = 22833 and parent is 22822. process 22822 is ksh. So this is not orphan process. if you find any process with parent…

Read More “To Find Orphan OS processes.” »

Linux/Unix, shell

Another Tuning Article for subheap of shared pool

Posted on 16-Feb-2007 By Admin No Comments on Another Tuning Article for subheap of shared pool

http://www.mail-archive.com/oracle-l@fatcity.com/msg79721.html Oh yeah, I forgot to say that in 9.2.0.3 the shared pool was broken up into “heaps” (Oracle terminology) but whatever fancy stuff they were trying to accomplish by doing this (I think part of the magical self-tuning initiative) was buggy and this hastened the fatal 4031 situation. There is a parameter (so I…

Read More “Another Tuning Article for subheap of shared pool” »

Oracle, SQL scripts

good note for shared pool tunnig

Posted on 16-Feb-2007 By Admin No Comments on good note for shared pool tunnig

Note:396940.1 How many Subpools will I have by default? The number of subpools is calculated using a simple algorithm. First, a subpool must be at least 128MB in 9i releases and at least 256MB in 10g releases. Bugs and internal tests show that subpools around 500M will work most efficiently and in future versions, we…

Read More “good note for shared pool tunnig” »

Oracle, SQL scripts

When to rebuld B-tree index

Posted on 09-Feb-2007 By Admin No Comments on When to rebuld B-tree index

Here is the syntax: analyze index CUSTOMER_LASTNAME_IND validate structure; It populates the SYS.INDEX_STATS view only. The SYS.INDEX_STATS view can be accessed with the public synonym INDEX_STATS. The INDEX_STATS view will hold information for one index at a time: it will never contain more than one row. Therefore you need to query this view before you…

Read More “When to rebuld B-tree index” »

Oracle, SQL scripts

Posts pagination

Previous 1 … 29 30 31 … 57 Next

Categories

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

Recent Posts

  • 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
  • Checking SQL Server Version25-Jul-2025
  • Oracle vs MYSQL Architecture differences (For DBAs)24-Jul-2025

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • My Minimum Tuning Programs Oracle
  • Distributed Transaction Troubleshooting. Oracle
  • Resolving RMAN Hung Jobs Oracle
  • oradebug ipcrm ipcs Oracle
  • Goldengate document from Porus Oracle
  • Establishing trusted relationship between dbmonitor( central monitoring) and monitoring targets. Linux/Unix
  • Best approach for Oracle database patching sequence to latest/required patchset along with CPU/PSU/any-other-one-off patch ID 865255.1 Oracle
  • eplan.sql Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme