Tags » Oracle

WHAT DOES "STARTUP UPGRADE" DO INTERNALLY?

ALTER SYSTEM enable restricted session;
ALTER SYSTEM SET _system_trig_enabled=FALSE SCOPE=MEMORY;
ALTER SYSTEM SET _undo_autotune=FALSE SCOPE=MEMORY;
ALTER SYSTEM SET undo_retention=900 SCOPE=MEMORY;
ALTER SYSTEM SET aq_tm_processes=0 SCOPE=MEMORY;
ALTER SYSTEM SET enable_ddl_logging=FALSE SCOPE=MEMORY;
ALTER SYSTEM SET resource_manager_plan='' SCOPE=MEMORY;
ALTER SYSTEM SET recyclebin='OFF' DEFERRED SCOPE=MEMORY;
ORACLE

Today's Nugget: Materialized Views

As I’m still trying to get my feet under the door at my new gig, here’s another nugget in place of a real blog entry. While troubleshooting for a client, I noted that there were three types of materialized view. 110 more words

General DBA


Problem:

PLS-00363: expression 'string1' cannot be used as an assignment target


While:

begin
 pkg1('string1');
end;
/
PLS-00363: expression 'string1' cannot be used as an assignment target
… 16 more words
ORACLE

HOW TO CREATE A PRIMARY KEY PARALEL

1. Create the primary key constraint (disabled)

alter table t1 add (
constraint t1_pk
primary key (col1))
disable primary key;

2. Create a unique index with the same name & columns as the primary key… 21 more words

ORACLE

Banking on Analytics

Bangladesh’s banking industry is on the cusp of a major transformation, with lots of new regulations from the Bangladesh Bank. In addition, the slowdown in economy continues to increase the pressure on banks’ profitability, especially due to the rise in NPAs across corporate and retail sector lending. 1,402 more words

ERP