Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • S3 Basic info AWS
  • Is It Recommended To Apply Patch Bundles When PSU Is Available? -ID 743554.1 Oracle
  • temp_use.sql diplays usage of temp ts Oracle
  • PLSQL Table Syntax 1 Oracle
  • remove archfiles only when it is applied to DR rm_archfiles.sh Linux/Unix
  • Single character replacement in Unix Linux/Unix
  • Sequence Resetting Oracle
  • Find Time Consuming SQL Statements in Oracle 10g Oracle
  • Passing from Unix to PLSQL using bind variables Linux/Unix
  • Implementing Listener Security Oracle
  • Looping for remote servers and find its database from oratab file. Linux/Unix
  • Privilege to describe the table. Oracle
  • grep multuple patterns Linux/Unix
  • Example of How To Resize the Online Redo Logfiles Note:1035935.6 Oracle
  • copying/removing directory with all its subdirectory 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 (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
  • SQLPLUS COPY command Precautions. Oracle
  • Giving Grant on v$DATABASE Oracle
  • Virtual Indexes in Oracle Oracle
  • Jai Shree Ram Oracle
  • How to find who is using which Rollback segment and how many rows or blocks in that rollback segments, Oracle
  • Very clear article about oracle dataguard Oracle
  • DETERMINING WHICH INSTANCE OWNS WHICH SHARED MEMORY & SEMAPHORE SEGMENTS Oracle
  • avail.sh ( find filesystem spae usage) Linux/Unix

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme