Blogs

Tuning with equivalent SQLs - a little challenge

articles: 

I am fascinated by what I call "equal SQL": statements that are equivalent, in that they deliver the same result but may have hugely different performance characteristics. Here's a little case study.

Compression test, 12cR2

articles: 

Just how effective is Hybrid Columnar Compression? This test shows that HCC is impressive, but that thought needs to be put into choice of compression algorithm.

12cR2 lots of new instance parameters

articles: 

Comparing database 12cR1 release 12.1.0.2 to 12cR2 release 12.2.0.0.3, I see these new parameters:

12cR2 new feature: online table move

articles: 

Move a table without locks and without breaking indexes. That's pretty cool.

Transport Tablespace Testing from Msocial (Sparc) to STS VMWare (x86_64)

1. Platform
- Msocial: Sparc Solaris 10
- STS_VMWare: x86_64 Solaris platform
2. Utility: RMAN
3. Task list details
3.1. On Source (MSocial)
3.1.1. Create test user schema & generate data in

sys@MSOCIAL> create user msocialtest identified by msocial
  2  default tablespace users
  3  temporary tablespace temp
  4  quota unlimited on users
  5  /

User created.

sys@MSOCIAL> grant connect, resource, create session, dba to msocialtest;

Grant succeeded.

Is row-by-row processing really slow-by-slow? Emphatically: YES

articles: 

Developers who come to Oracle with a background in procedural languages sometimes do not understand how efficient SQL's set oriented processing can be. This little demonstration should convince them: never use PL/SQL when SQL will do.

How to change column order when using SELECT *

articles: 

We all know that using SELECT * is bad programming. One reason is that you cannot control the order in which columns are returned. Well, you can in release 12c.

Oracle 12cR2 - the next release, cloud only?

articles: 

We are all waiting for database release 12.2 - but you won't get it on your own hardware.

Send SMTP Mail using UTL_SMTP Package

articles: 

In this first my blog entry I wish to post the code for send an Email message from one sender to one receiver.
The code is the follow:

DECLARE
  v_From      VARCHAR2(80) := 'sender.mail.com';
  v_Recipient VARCHAR2(80) := 'receiver.mail.com';
  v_Subject   VARCHAR2(80) := 'test subject';
  v_Mail_Host VARCHAR2(30) := 'smtp.libero.it';
  v_Mail_Conn utl_smtp.Connection;
  crlf        VARCHAR2(2)  := chr(13)||chr(10);
BEGIN
 v_Mail_Conn := utl_smtp.Open_Connection(v_Mail_Host, 25);
 utl_smtp.Helo(v_Mail_Conn, v_Mail_Host);

Pages

Subscribe to RSS - blogs