Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Changing the Global Database Name Oracle
  • Proc Compilation Oracle
  • Good Oracle Architecture In Short and point to point Oracle
  • How to find who is using which Rollback segment and how many rows or blocks in that rollback segments, Oracle
  • ipcs -l Linux/Unix
  • 556976.1 Oracle Clusterware: Components installed Oracle
  • Unix command for system configuration Linux/Unix
  • Btee and Bitmap Plans in Oracle 9i and higher Oracle
  • replace alphabets using sed Linux/Unix
  • How to Use DBMS_STATS to Move Statistics to a Different Database Oracle
  • Rename Tablespace Oracle
  • How to collect CPU usage on Linux using Shell script Linux/Unix
  • create PLAN_TABLE command. Oracle
  • Distributed Transaction Troubleshooting. Oracle
  • Database logon trigger issue Oracle

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 … 44 45 46 … 56 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
  • SYSOPER Mystery Oracle
  • Multiple listeners Oracle
  • usnsql.sql Displays information about UNDO segments with sql statements Oracle
  • Distributed Transaction Troubleshooting. Oracle
  • OEM-Commnds Oracle
  • tuning commmand for cpu, ip and memory stats Linux/Unix
  • online_bkup.sql Oracle
  • Read CSV File using Python Python/PySpark

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme