Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Optimizer SORT Operations Oracle
  • Session_info.ksh Linux/Unix
  • Find All internal Parameters Oracle
  • Backup and Recovery Scenarios Oracle
  • Check_recovery.sh program to run sqlplus and return its values remotely. Linux/Unix
  • export import with parameter file. Oracle
  • Find execution plan from dba_hist_sql_plan for a specific SQL_ID and PLAN_HASH_VALUE fplan.sql Oracle
  • v$backup.status information Oracle
  • Jai Shree Ram Oracle
  • Monitor Long Running Job Oracle
  • Updated LCK.SQL file. Oracle
  • Pending Distributed Transations Oracle
  • Best approach for Oracle database patching sequence to latest/required patchset along with CPU/PSU/any-other-one-off patch ID 865255.1 Oracle
  • Does DBMS_JOB recompute the NEXT_DATE interval after or before Oracle
  • kill all processes from specific user in solaris. Linux/Unix

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
  • Explain Plan Output 2 Oracle
  • Exadata Basics Oracle
  • sesswait.sql Oracle
  • Building Our Own Namespaces with “Create Context” Oracle
  • Temporary Tablespsace Temp tablespace behaviour Oracle
  • Is It Recommended To Apply Patch Bundles When PSU Is Available? -ID 743554.1 Oracle
  • This is from Temi Oracle
  • kill all processes from specific user in solaris. Linux/Unix

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme