Oracle jobs

SELECT JOB_NAME, OWNER, ENABLED FROM DBA_SCHEDULER_JOBS;

When I tried to recompile a package in sqlplus, the sqlplus window freezes and has not responding.

When I tried to recompile a package in sqlplus, the sqlplus window freezes and has not responding.

The reason is that some objects you are trying to use is locked. Go and check what locks the object.

AIX 6.1 Time Zone and Daylight Saving Time

Time Zone:

http://www-01.ibm.com/support/docview.wss?uid=isg3T1000252

DST problem:

http://www-01.ibm.com/support/docview.wss?uid=isg3T1013017#formatcompare



Summary:

TZ=EST5EDT,M3.2.0/2:00:00,M11.1.0/2:00:00

If you change the System TZ, you need to reboot the machine for activating the change.
If you change the date, you don't need to do rebooting.

SP2-1503: Unable to initialize Oracle call interface

Problem:

Install everything correctly, but can't use sqlplus from both double-click and command line.

Solution:

Run as adminstrator

Set AIX date and time

# date 0819092612
           mmddHHMMyy

all see the man page

mm-month
MM-minutes
yy-last two digits of year

Vim setting

set tabstop=4
set shiftwidth=4
set number
set backupdir=c:\vim_backup

vi/vim tips

1.Copy and paste

In normal model:

10yy     --Copy next 10 lines
p           --Paste the content


2. Tab multiple lines

v           -- Go into Visual Mode
shift + direction(h,j,k,l or arrows)    -- select lines
> or <      -- indent or unindent