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...

website storage error

›
Not enough storage is available to process this command If you recieve multiple storage alerts within the event log, the below procedure sho...

LD bank holiday old billing

›
01/04/2011 holiday existing 30/03/2011 financial posting is 05/04/2011 31/03/2011 financial posting is 06/04/2011 30/03/2011 old financial p...

LD ASP YEAR END PROCESS FY 1112

›
LD ASP YEAR END PROCESS FY 1112 Before processing for New Year financial process for ASP. We have to log into the local LD and follow the fo...

LD CLIENTLEVEL YEP1112

›
Create Role ClientPassEdit ; Grant update on Accountemaildetail to ClientPassEdit ; Grant clientpassedit to cllvl; OTHERWISE ...