Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • create database link syntax Oracle
  • tblwopk.sql tablewopk.sql Oracle
  • Find nth max and min. Oracle
  • Composite Index creation tip from Vivek Oracle
  • Important Solaris Commands Linux/Unix
  • v$event_name Oracle
  • Load testing on Oracle 19C RAC with HammerDB Oracle
  • Goog notes on X$ tables Oracle
  • Korn Shell Arithmatic Linux/Unix
  • Drop specific SQL plan baseline – spm Oracle
  • CTAS with LONG Column for 9i and higher Oracle
  • Jai Shree Ram Linux/Unix
  • Logic to chech # of parameters command line parameters Linux/Unix
  • When error comes for temporary tablespace with version <= 9i Oracle
  • checking connectivity between two servers Linux/Unix

Author: Admin

Building Our Own Namespaces with “Create Context”

Posted on 11-Oct-2005 By Admin No Comments on Building Our Own Namespaces with “Create Context”

************************************** **** Building Our Own Namespaces ***** ************************************** The USERENV namespace does store extensive information, but the power of SYS_CONTEXT does not stop there. You can also create secured namespaces and store context in them for retrieval within a session or across the instance. For example, if I create a new namespace via the CREATE…

Read More “Building Our Own Namespaces with “Create Context”” »

Oracle, SQL scripts

Roles and Stored Object behaviour

Posted on 10-Oct-2005 By Admin No Comments on Roles and Stored Object behaviour

Note : 1011899.6 – Roles and Creating Stored Objects / Views Note : 180028.1 – Set up a Secure Access to Application Data within a Database: DBAs, Schemas and Users.

Oracle, SQL scripts

Implementation of key based authentications

Posted on 07-Oct-2005 By Admin No Comments on Implementation of key based authentications

*******************************************************************************************Step by Step Implementation of key based authentications from Source A to Destination B. ******************************************************************************************* (1) At source A (1-A) Generate a Key ssh-keygen -t dsa Above command creates a public key file called : id_dsa.pub and private key called id_dsa (1-B) Cat id_dsa.pub to the destination B and save as a file called authorized_keys…

Read More “Implementation of key based authentications” »

Linux/Unix, shell

Find Command

Posted on 06-Oct-2005 By Admin No Comments on Find Command

Following command gives, all files that are modified in last 4 days. find /IOTTOARCH/*.arc -mtime -4 -exec ls -rlt {} ; Following command gives, all files that are modified before last 4 days. find /IOTTOARCH/*.arc -mtime +4 -exec ls -rlt {} ;

Linux/Unix, shell

SAN

Posted on 04-Oct-2005 By Admin No Comments on SAN

For Example, Db size : 461 GB. On SAN EMC FC4700

Linux/Unix, shell

OPENING A STANDBY DATABASE IN READ-ONLY MODE

Posted on 30-Sep-2005 By Admin No Comments on OPENING A STANDBY DATABASE IN READ-ONLY MODE

OPENING A STANDBY DATABASE IN READ-ONLY MODE ——————————————— In order to perform queries on a read-only standby database, the database needs to be able to perform on-disk sorting operations. Locally managed temporary tablespaces do not record transactions in the data dictionary. Steps to create a locally managed temporary tablespace 1. Create a temporary tablespace on…

Read More “OPENING A STANDBY DATABASE IN READ-ONLY MODE” »

Oracle, rman-dataguard

Oracle Standby Database Library Index from Metalink

Posted on 30-Sep-2005 By Admin No Comments on Oracle Standby Database Library Index from Metalink

267931.1

Oracle, rman-dataguard

Test Case for Inserting Multiple (2.3 Million rows in 26 Seconds)

Posted on 29-Sep-2005 By Admin No Comments on Test Case for Inserting Multiple (2.3 Million rows in 26 Seconds)

========================= Test case On 29-SEP-2005 ========================= Original Statement: INSERT INTO pvm SELECT * FROM pvm1; Source table : pvm1 has 2.3 million rows. If statement executes normally it will take long time to execute. So i modified following statement and 2.3 Million rows processed in Approx 30 seconds. 10:39:11 CIF@CIF:-> set feedback 1 10:39:11 CIF@CIF:->…

Read More “Test Case for Inserting Multiple (2.3 Million rows in 26 Seconds)” »

Oracle, SQL scripts

Removing Blank lines from file using grep

Posted on 28-Sep-2005 By Admin No Comments on Removing Blank lines from file using grep

grep -v “^$” filename > newfilename

Linux/Unix, shell

Useful Solaris Commands on 28-SEP-2005

Posted on 28-Sep-2005 By Admin No Comments on Useful Solaris Commands on 28-SEP-2005

* To Print System Configuration /usr/sbin/prtconf Above command is useful to view Memory available to this system as following. /usr/sbin/prtconf | grep “Memory size” You can also use “top” command to see total RAM and swap info. * To see Available Processor Info. (Processor Info). psrinfo

Linux/Unix, shell

Posts pagination

Previous 1 … 46 47 48 … 58 Next

Categories

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

Recent Posts

  • runon_allpdbs_show_conname.sh23-Apr-2026
  • runon_allcdbs_find_pdbs.sql23-Apr-2026
  • Running PDB on single node in RAC09-Apr-2026
  • find_arc.sql09-Apr-2026
  • pvm_pre_change.sql08-Apr-2026
  • find_encr_wallet.sql08-Apr-2026
  • find_pdbs.sql08-Apr-2026
  • Creating a Container Database using dbaascli08-Apr-2026
  • track_autoupgrade_copy_progress.sql01-Apr-2026
  • refre.sql for multitenant01-Apr-2026

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • pvm_pre_change.sql Oracle
  • chk_space_SID.ksh Linux/Unix
  • Roles and Stored Procs II Oracle
  • prepfiles.sh for step by step generating pending statistics files Oracle
  • Pending Distributed Transations Oracle
  • Good Doc 28-JUN-2006 Oracle
  • chk_space_SID.ksh Linux/Unix
  • TRUNCATE table and disabling referential constraints. Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme