Tags » Oracle

Redo Logfile Size Advisor

Redo Logfile Size Advisor

For checking the optimal logfile size you need to set the
FAST_START_MTTR_TARGET parameter.If its zero then optimal_logfile_size not returned any row. 87 more words

Oracle

Real Application Testing - SPA

Lately I took part in Oracle Real Application Testing Workshop managed by Oracle product management team.

I’d like to tell you a little bit about the feature beyond the introduction I posted before… 1,564 more words

Oracle

Oracle Call for April 2015

My Gods ask that I offer oracular service each month when I feel healthy enough. This is your oracle call for April. Please send a single question to answersfromthemists at gmail dot com.

The Work

Advanced Constraint Options

Constraint are objects we all know, we use them a lot when creating tables and they allow us to:

  1. Keep data integrity at the table level, like disallow null values using the “not null” constraint, enforcing unique values using “unique” constraint or allowing only values that meet conditions using the “check” constraint.
  2. 946 more words
Oracle

trigger to trace user activity

CREATE OR REPLACE TRIGGER SYS.logon_trigger
after logon on database
begin
if (user = ‘TDUSER’ ) then
execute immediate ‘ALTER SESSION SET TRACEFILE_IDENTIFIER=”TDUSER_sixth”';
execute immediate ‘alter session set timed_statistics=true'; 25 more words

ORACLE

Modify & Delete Table

Let’s assume we already have the following table. 224 more words

Oracle

SHUTDOWN IMMEDIATE HANGS

You may use shu abort in another session, but first it’s better so set 10400 event to see what’s going on:

SQL> ALTER SYSTEM SET EVENTS '10400 trace name context forever, level 1';
… 18 more words
ORACLE