Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Set Role explaination. Oracle
  • TNSNAMES entries details Oracle
  • find_err.sql for finding errors from dba_errors. Oracle
  • Find_stale_dr.sql finding stale physical DR.. Oracle
  • tblwopk.sql /* Find Tables Without PK */ Oracle
  • Nice notes on wait events Oracle
  • Paste command syntax Linux/Unix
  • move_arch_files.ksh Linux/Unix
  • Difference between SYNC and AFFIRM Oracle
  • SQL Server Vs Oracle Architecture difference SQL Server
  • How to connect to Oracle Database with Wallet with Python. Oracle
  • To find explain plan for a statement that occurred in past. Oracle
  • rm_backup_arch_file.ksh Linux/Unix
  • Sequence Resetting Oracle
  • Search and replace editor command in vi Linux/Unix

Year: 2005

Resolving RMAN Hung Jobs

Posted on 04-Nov-2005 By Admin No Comments on Resolving RMAN Hung Jobs

PURPOSE ======= This note discusses resolving an RMAN Hung Job SCOPE & APPLICATION =================== Anyone involved in running RMAN jobs Resolving an RMAN Hung Job ========================== Components of an RMAN Session The nature of an RMAN session depends on the operating system. In UNIX, an RMAN session has the following processes associated with it: –…

Read More “Resolving RMAN Hung Jobs” »

Oracle, rman-dataguard

Vivek Tuning for Row Locks.

Posted on 03-Nov-2005 By Admin No Comments on Vivek Tuning for Row Locks.

/************************ wait.sql *************************/ set pages 2000 set lines 132 column p1text format a18 column event format a35 column WT format 9999 column SW format 9999 select sid, event,p1text,p1raw,p1,p2,p3,seconds_in_Wait “SW”,Wait_time “WT” from v$session_wait where event not in( ‘KXFQ: Dequeue Range Keys – Slave’, ‘KXFQ: Dequeuing samples’, ‘KXFQ: kxfqcls – consumer closing TQ’, ‘KXFQ: kxfqdeq – dequeue…

Read More “Vivek Tuning for Row Locks.” »

Oracle, SQL scripts

Mutating Table Error while using database trigger

Posted on 03-Nov-2005 By Admin No Comments on Mutating Table Error while using database trigger

The Mutating table error is a well-known problem encountered in development; most developers have come across this error. ORA-04091: table is mutating, trigger/function may not see it The basic reason for this error is the way that Oracle manages a read consistent view of data. The error is encountered when a row-level trigger accesses the…

Read More “Mutating Table Error while using database trigger” »

Oracle, SQL scripts

Adding Datafile on Primary Server and Impact on Standby Server

Posted on 28-Oct-2005 By Admin No Comments on Adding Datafile on Primary Server and Impact on Standby Server

When u add a datafile in Primary then those changes are not immediately propagated to standby. Once Log with this changes applied to standby, standby database create a filename in $ORACLE_HOME/dbs. This is just a file name and does not have physical file. After this even all log apply service will fail as this is…

Read More “Adding Datafile on Primary Server and Impact on Standby Server” »

Oracle, rman-dataguard

USER_TABLES.Freelists

Posted on 28-Oct-2005 By Admin No Comments on USER_TABLES.Freelists

When you are using tablespace with segment space management AUTO then following command will not show FREELISTS. Alter table move tablespace my_data storage (initial 20M freelists 9) initrans 9; If tablespace is crreated with segment space management AUTO Then USER_TABLES.FREELISTS does not show FREELISTs as 9, but it displays blank in FREELISTS column.

Oracle, SQL scripts

My Test Case On 21-OCT-2005

Posted on 21-Oct-2005 By Admin No Comments on My Test Case On 21-OCT-2005

(*) if you grant any role to grantee while grantee is connected to database. He cannot use that role immediately. To use it immediately he needs to execute “Set role role_name” in his session. This will enable that role for him or he needs to logoff and login again. (*) If you have given any…

Read More “My Test Case On 21-OCT-2005” »

Oracle, SQL scripts

TABLE SIZING WITH DB_BLOCK ARCHITECTURE Reference : Metalink note : 10640.1

Posted on 14-Oct-2005 By Admin No Comments on TABLE SIZING WITH DB_BLOCK ARCHITECTURE Reference : Metalink note : 10640.1

=================================================================== STEP-I First, calculate the total block header size: =================================================================== block header = fixed header + variable transaction header + table directory + row directory where: fixed header = 57 bytes (the 4 bytes at the end of the block have already been taken account of in the 24 bytes for the cache header) variable…

Read More “TABLE SIZING WITH DB_BLOCK ARCHITECTURE Reference : Metalink note : 10640.1” »

Oracle, SQL scripts

FGA Part-I

Posted on 13-Oct-2005 By Admin No Comments on FGA Part-I

=========================================================================================================================================== Fine-Grained Auditing Part-I: Reference : from Arup Nanda on http://www.oracle.com/technology/oramag/webcolumns/2003/techarticles/nanda_fga.html ——————————————————————————————————————————————- (*) Traditional Oracle Database auditing options let you track the actions users perform on objects at the macro level for example, if you audit for SELECT statements on a table, you can track who selected data from the table. However, you don’t know…

Read More “FGA Part-I” »

Oracle, SQL scripts

Updated LCK.SQL file.

Posted on 13-Oct-2005 By Admin No Comments on Updated LCK.SQL file.

select c.sid, c.serial#, f.spid as osprocess, c.username, a.object_id, b.object_name, c.program, c.status, d.name, c.osuser, e.sql_text, DBMS_ROWID.ROWID_CREATE(1, c.ROW_WAIT_OBJ#, c.ROW_WAIT_FILE#, c.ROW_WAIT_BLOCK#, c.ROW_WAIT_ROW# ) locked_rowid from v$Locked_object a, All_objects b, v$session c, audit_actions d, v$sqlarea e, v$process f where a.object_id=b.data_object_id and a.session_id =c.sid(+) and c.command=d.action and c.row_wait_obj# != -1 and c.sql_id=e.sql_id and c.paddr = f.addr;

Oracle, SQL scripts

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

Posts pagination

Previous 1 … 3 4 5 … 16 Next

Categories

  • Ansible (0)
  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • MYSQL (5)
  • Oracle (393)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (0)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (342)
  • SQL Server (6)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • Trace a SQL session from another session using ORADEBUG30-Sep-2025
  • SQL Server Vs Oracle Architecture difference25-Jul-2025
  • SQL Server: How to see historical transactions25-Jul-2025
  • SQL Server: How to see current transactions or requests25-Jul-2025
  • T-SQL Vs PL/SQL Syntax25-Jul-2025
  • Check SQL Server edition25-Jul-2025
  • Checking SQL Server Version25-Jul-2025
  • Oracle vs MYSQL Architecture differences (For DBAs)24-Jul-2025
  • V$INSTANCE of Oracle in MYSQL24-Jul-2025
  • Day to day MYSQL DBA operations (Compared with Oracle DBA)24-Jul-2025

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Library cahe Latches and internal explaination Oracle
  • To seee semaphores and shared memory segments in Solaris Linux/Unix
  • Running some SQL on multiple databases connecting using monitoring userid and password Linux/Unix
  • remove archfiles only when it is applied to DR rm_archfiles.sh Linux/Unix
  • ORA-1841 Error Connecting to Upgraded Database After Set PASSWORD_LIFE_TIME Oracle
  • find_pk.sql /* Find Primary Key */ Oracle
  • Windows based Command line mailing program like mailx (Sednmail for windows) PHP/MYSQL/Wordpress
  • Explain Plan Output 2 Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme