Submitted by John Watson on Fri, 2016-10-21 14:54
Comparing database 12cR1 release 188.8.131.52 to 12cR2 release 184.108.40.206.3, I see these new parameters:
Submitted by John Watson on Wed, 2016-10-19 08:10
Move a table without locks and without breaking indexes. That's pretty cool.
Submitted by trantuananh24hg on Sun, 2016-10-16 23:24
- 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
sys@MSOCIAL> grant connect, resource, create session, dba to msocialtest;
Submitted by John Watson on Fri, 2016-10-14 07:54
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.
Submitted by John Watson on Sun, 2016-10-02 02:57
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.
Submitted by John Watson on Mon, 2016-09-12 12:02
We are all waiting for database release 12.2 - but you won't get it on your own hardware.
Submitted by dancko on Sun, 2016-09-11 09:39
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:
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';
crlf VARCHAR2(2) := chr(13)||chr(10);
v_Mail_Conn := utl_smtp.Open_Connection(v_Mail_Host, 25);
Submitted by trantuananh24hg on Wed, 2016-08-24 21:56
AIX is like an Unix environment awesome original, same to HP-Unix, and, if you have a plan to install Oracle RAC, you need to pay attention. I note some tips in this article to help.
1. Checking Operating System Packages
# lslpp -l bos.adt.base bos.adt.lib bos.adt.libm bos.perf.libperfstat \
bos.perf.perfstat bos.perf.proctools rsct.basic.rte rsct.compat.clients.rte \
If not, install on AIX source by smity. It's easy, but remember, some packaged requires your IBM's account to download.
Submitted by trantuananh24hg on Tue, 2016-08-23 04:34
In previous article, I described the task list of configuration software raid on Solaris. And here, I brief the task list of configuration hardware raid on Sun Sparc model T.
Ofcoruse, the first step is connection to the server with serial console cable, assume the new server.
data bit = 8
baud rate = 9600
Recommend tool: Sercure CRT, Putty.
Submitted by trantuananh24hg on Tue, 2016-08-23 04:02
I worked on Unix many years ago, however, Solaris, AIX and HP-Unix are the platforms I often did with. I'm DBA, but there are not any System Administrator in my company, and I .. do the System's business at all.
Before ZFS becomes popular, UFS was always the best choice for Solaris, especially in M's series, example: Sun M-3000, M-4000, M-5000 ...etc. The M series does not support Hardware Raid, but only software, and this article do the brief of creating the software raid in. It's one of task list before configuration and installation Oracle in Solaris 10.