Create a Virtual Column:
A virtual column applies a function to a column in the table. The database only computes this at runtime. The value is not stored in the table. So instead of…
Read MoreHow to Fix ORA-01450: Maximum Key Length (6398) Exceeded Errors:
The smallest unit of data storage in Oracle Database is the block. This defaults to 8k (8,192 bytes). Each index entry must fit within one block. So the maximum size…
Read MoreHow To Define Connection Filter Settings(t3,t3s) for WebLogic Server Domain Using WLST
APPLIES TO: Oracle WebLogic Server – Version 10.3.6 to 10.3.6 Generic Linux GOAL: If there are a lot of webLogic domains to configure, this document provides an example to define…
Read MoreScript to check temp used by session
set pagesize 10000 set linesize 133 column tablespace format a20 heading ‘Tablespace Name’ column segfile# format 9,999 heading ‘File|ID’ column spid format 9,999 heading ‘Unix|ID’ column segblk# format 999,999,999 heading…
Read MoreFinding Top sqls ordered by elapsed time in a period of time
set head on column module format a20 set lines 1000 pages 1000 prompt SQL Ordered by Elapsed time /*FIND THE SNAP ID*/ set pages 0 col begin_interval_time for a30 col…
Read MoreOracle Statspack Installing and Configuration
Description: This Document for configuring oracle Statspack, schedule auto snapshot and report generation. The Statspack tool is instead of AWR report because AWR is licensed Statspack is non licensed. Steps:…
Read MoreAdding and Configure Printer in Solaris 10 Sparc
Description: Oracle have lot of printing option to configuring in Solaris 10, this is also one method will follow to setup printer on EBSR12 in Solaris Sparc 10 Steps: Login…
Read MoreSession Trace (10064) for a concurrent request
Description: Oracles have lot of trace utility the oradebug is one the utility to trace particular running concurrent request using oracle spid. Steps: Check Request ID from Find Concurrent request…
Read MoreUnable to open user preference file
Description: The user was running RDF report and concurrent completed with error That issue occur on the prefs.ora file is missing or non-accessible owner Solution: copy the prefs.ora file from…
Read MoreHow to resolve ORA-28040: No matching authentication protocol
Error: ORA-28040: No matching authentication protocol Cause: 1. This problem was encountered on database instance version 12.2 and above and clients with version 9g/10g/11g. Example: In my case the development…
Read More