Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • db_status.sql Oracle
  • How To Transfer Passwords Between Databases (ref note: 199582.1) Oracle
  • V$ROLLSTAT status is Full Oracle
  • metalink all dynamic view reference notes. Oracle
  • Search and replace editor command in vi Linux/Unix
  • Important Solaris Commands Linux/Unix
  • Renaming Global Name GLOBAL_NAME Oracle
  • DBA_HIST_SQLSTAT contents Oracle
  • sesswait.sql Oracle
  • Goldengate document from Porus Oracle
  • To see how much time or progress of long transaction Oracle
  • Order by with ROWNUM Oracle
  • How to start CRS manually Oracle
  • Is It Recommended To Apply Patch Bundles When PSU Is Available? -ID 743554.1 Oracle
  • process id based files and processes Linux/Unix

Year: 2009

switchover for primary database

Posted on 31-Dec-2009 By Admin No Comments on switchover for primary database

ALTER DATABASE commit TO switchover TO physical PRIMARY WITH session shutdown nowait;

Oracle, rman-dataguard

Physical Standby switchover with session active

Posted on 30-Dec-2009 By Admin No Comments on Physical Standby switchover with session active

In order to perform a switchover all sessions to the database need to be disconnected. In version 901 this was a manual process. In version 9.2.0 this process has been automated with the “with session shutdown” clause that has been added to the alter database commit to switchover command. If SWITCHOVER_STATUS returns SESSIONS ACTIVE then…

Read More “Physical Standby switchover with session active” »

Oracle, rman-dataguard

Monitor Long Running Job

Posted on 20-Dec-2009 By Admin No Comments on Monitor Long Running Job

SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK, ROUND(SOFAR/TOTALWORK*100,2) “% COMPLETE” FROM V$SESSION_LONGOPS WHERE OPNAME LIKE ‘RMAN%’ AND OPNAME NOT LIKE ‘%aggregate%’ AND TOTALWORK != 0 AND SOFAR TOTALWORK /

Oracle, SQL scripts

checking redhat linux version

Posted on 12-Dec-2009 By Admin No Comments on checking redhat linux version

cat /etc/redhat-release

Linux/Unix, shell

Find_table_size.sql

Posted on 09-Dec-2009 By Admin No Comments on Find_table_size.sql

set lines 120 pages 500 col owner format a30 col segment_name format a30 col tab_sum format 999999999999999 col indx_sum format 999999999999999 col MB format 999999999 accept pvm_owner prompt ‘Enter Owner Name -> ‘ accept pvm_table prompt ‘Enter Table Name -> ‘ select tab.owner, tab.segment_name, tab.tablespace_name, (tab_sum+indx_sum)/(1024*1024) MB from (select p.owner, p.segment_name, p.tablespace_name, sum(p.bytes) tab_sum from…

Read More “Find_table_size.sql” »

Oracle, SQL scripts

Database link password in user_db_links

Posted on 09-Dec-2009 By Admin No Comments on Database link password in user_db_links

Problem Description: ~~~~~~~~~~~~~~~~~~~~ Database link passwords are stored as plaintext. A database link is a mechanism used to provide a method of transparently accessing one server from another. When creating a database link, a user name and password of the account on the remote server can be specified. Creating the database link without credentials works…

Read More “Database link password in user_db_links” »

Oracle, SQL scripts

find_err.sql for finding errors from dba_errors.

Posted on 04-Dec-2009 By Admin No Comments on find_err.sql for finding errors from dba_errors.

set lines 120 pages 200 col line format 9999 col position format 999 col text format a80 select line, position, text from dba_errors where owner= upper(‘&owner_name’) and name = upper(‘&obj_name’) order by SEQUENCE;

Oracle, SQL scripts

More info about /proc folder and its relation with processes.

Posted on 27-Nov-2009 By Admin No Comments on More info about /proc folder and its relation with processes.

One of the most interesting directories on any Linux system is /proc, a virtual filesystem that provides a plethora of information on the hardware of the running system, and of the various processes running. In fact, many programs such as ps and top obtain their information by mining /proc. Some well-known virtual files in /proc…

Read More “More info about /proc folder and its relation with processes.” »

Linux/Unix, shell

process id based files and processes

Posted on 16-Nov-2009 By Admin No Comments on process id based files and processes

Following command can be used to find files used by specific processid. $ pfiles process_id Following command can be used to find files used by specific processid. $ pmap process_id

Linux/Unix, shell

cold backup scripts to copy locally

Posted on 28-Oct-2009 By Admin No Comments on cold backup scripts to copy locally

==>cat SOX_BACKUP.ksh #!/usr/bin/ksh # +———————————————————————— # | Usage : ./SOX_BACKUP.ksh # | Description : Cold Backup of Database. Automatically starts/stop the DB. # +———————————————————————— . /export/home/oracle/FLRSTB.env sqlplus -s /nolog /mnt/ORACLEBACKUP/files.log connect / as sysdba set term off set feedback off; set head off; set pagesize 150 select name||’ /mnt/ORACLEBACKUP/FLRPRD’ from v$datafile; exit; EOF cat /mnt/ORACLEBACKUP/files.log|grep…

Read More “cold backup scripts to copy locally” »

Linux/Unix, shell

Posts pagination

1 2 … 9 Next

Categories

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

Recent Posts

  • load SPM baseline from cursor cache05-Jun-2025
  • Drop all SPM baselines for SQL handle05-Jun-2025
  • Load SPM baseline from AWR05-Jun-2025
  • Drop specific SQL plan baseline – spm05-Jun-2025
  • 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

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • SAN Linux/Unix
  • 339939.1 Running Cluster Verification Utility to Diagnose Install Problems Oracle
  • Transfer SQL Profiles from One database to other database. Oracle
  • scripts to take listener.log backup Linux/Unix
  • secure crt settings Linux/Unix
  • Paste command syntax Linux/Unix
  • Clean up Oracle
  • export import with parameter file. Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme