Friday, May 6, 2011

LD Billing Porcess Email Notification

›
CREATE OR REPLACE TRIGGER email_nsef_bill AFTER insert on TBLLOCKTABLE DECLARE b VARCHAR2(3) := UTL_TCP.CRLF; l_subject VARCHAR2(50) := ...
Thursday, May 5, 2011

Bulk Client Code Change prg

›
Set Exclusive OFF Set Date BRITISH Set Century on Set Talk OFF Set Safety OFF Close ALL Clear All Clear lcFirmnum='NBS-000001' gnQry...

LD AR > always release to AF > as per formula query

›
Client Master > Der+ Gen VI > Demat > Payout Status Quo Client Master > Der+ Gen VI > Default product > Status Quo AR >...
Wednesday, May 4, 2011

LD LOCKTABLE Email Notification

›
Select * From Tbllocktable Where Dcashbankfinancialentry Not Like ' '; ------------ CREATE OR REPLACE TRIGGER email_lock_table AFT...
Sunday, April 10, 2011

Create Control File Manually

›
CREATE CONTROLFILE REUSE DATABASE "ARI1112" RESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXI...
Saturday, April 9, 2011

Memory management SGA PGA

›
RAM=16 GB WINDOW PROCESS=16*20%=3.2 GB ORACLE SERVICES=12 GB PGA_AGGREGATE_TARGET==(RAM*80%)*50% FOR DSS PGA_AGGREGATE_TARGET==(RAM*80%)*20%...
Friday, April 8, 2011

SGA Tuning

›
There are two parameters SGA_TARGET: RAM SPACE IS ASSIGNED TO ORACLE SERVICES, CAN SEE ON TASK MANAGER PROCESS This parameter is new with O...

Oracle error 14402 : ORA-14402: updating partition KEY COLUMN would cause a partition CHANGE

›
The above error was caused because when you updated the record, it now belongs to a different partition but since row movement between parti...

PGA Tuning

›
Select Name,Value/1024/1024 From V$parameter where name like '%pga%'; Make a first estimate for PGA_AGGREGATE_TARGET , based on a r...

Kill Blocking Session

›
SELECT 'alter system kill session ''||ss.sid||','||ss.serial#||'';' FROM v$process pr, v$session ss, v$sql...

Contra Entry Zero Token

›
Cheque is expired after 6 months 31 Mar 2011 20110331 update cashmain set bankreco=20110331 where firmnumber='ACML-00001' AND CBNUMB...

Shrink datafile space from dropped table

›
Shrink datafile space from dropped table ================================================== select sum(bytes) / 1024 / 1024 / 1024 from dba_...

Primary key Constraints Enable

›
SQL> alter table CLJOBB disable constraint CLJOBB; associated index (CLJOBB) will be dropped automatically. SQL> alter table CLJOBB en...

BRANCH HO roles

›
GRANT BRANCHCHANGE TO USER; GRANT BRANCHMASTER TO USER; GRANT BRANCHCHANGEREQUEST TO USER; GRANT EXECUTE ON SP_BRANCHMASTER TO USER;
Wednesday, April 6, 2011

LD YEP YEAR END DATABASE CREATION 2011-12

›
LD YEAR END DATABASE CREATION FY 1112 STEPS FOR CREATING NEW YEAR DATABASE ‘1112 Step 1 : Create the Database ARI1112 using template LDLARGE...

Premium Brokerage Update

›
CLient Master > Der+Gen VI > option brokerage on > UPDATE Cldetail SET Cderbroktype='P' ,CDERSBROKTYPE='P' WHERE FI...

Constraint Check

›
SPOOL C:\CONS.TXT select 'select '||cc.column_name- ||' from '||c.owner||'.'||c.table_name- ||'...

Check Unused Space

›
SQL> set serveroutput on SQL> set pages 1000 SQL> set lines 160 SQL> DECLARE 2 alc_bks NUMBER; 3 alc_bts NUM...

Constraint stats ORA-02298

›
Alter table CEXIST DISABLE constraint CEXISTBROKBOOK; alter table CEXIST disable constraint CEXISTBOOK; alter table CEXIST ENABLE constraint...
Monday, April 4, 2011

LD duplicate transaction number at time of billing

›
LD duplicate transaction number at time of billing [Microsoft][ODBC driver for Oracle][Oracle]ORA-20014: Bill Financial Posting cannot be Ru...