Tags » Oracle

Investigating the full table direct path / buffered decision.

A lot of blogposts and other internet publications have been written on the full segment scan behaviour of a serial process starting from Oracle version 11gR2. 2,739 more words

Oracle

Send Email from Oracle

Below is the procedure used to send email from Oracle. This proc takes email content in varchar datatype or clob datatype.

CREATE OR REPLACE PROCEDURE myschema.send_email( 524 more words

Oracle

Segment advisory in Oracle

Segment Advisory Script:

=======================================

SET SERVEROUTPUT ON SIZE 1000000
SET LINESIZE 200
SET VERIFY OFF

DECLARE
l_object_id NUMBER;
l_task_name VARCHAR2(32767) := ‘SEGMENT_ADVISOR_TASK';
l_object_type VARCHAR2(32767) := UPPER(‘&Object_type’); 245 more words

Oracle

Starting with Oracle In-Memory (aka IM) new Feature


I recommend that DBA be aware of this feature, because this feature will really bring a HUGE difference in performance matter to our databases.

Note: This feature is available starting with Oracle Database 12c Release 1 (12.1.0.2). 108 more words

Database

BIPublisher - Output file was found but is zero sized - Deleted

Issue

Created RTF template for the report using BI Publisher Desktop 10.1.3.2

Had to download ┬áBI Publisher Desktop 11g to work on Oracle Fusion Reports… 125 more words

Oracle

rman merged backup script for windows environment:

rman merged backup script for windows environment:

ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ‘C:\blockchangetracking.dbf’ REUSE;

run {
CONFIGURE RETENTION POLICY TO REDUNDANCY 10; 186 more words

SOA & BPM Community Newsletter June 2015

Dear SOA & BPM Partner Community member,

New Oracle PaaS offerings became available, including Integration Cloud Service (ICS) and Process Cloud Service (PCS). We do offer complete ICS and PCS partner kits including demo accounts, ppt material and… 533 more words

OPN