Monday, February 15, 2010

Tools for making the vedio demo

1. CamStudio - Free Streaming Video Software

2. Subtitle Workshop - The most complete, efficient and convenient freeware subtitle editing tool.

3. AutoGK -  THE tool for XviD / DivX conversion

4. WinAVI Vedio Converter - A complete solution for video-file converting

Saturday, February 06, 2010

Some tools to speeding up the productivity

1. Powerpro - A windows tool to imitate the key typing with a keyboard shortcut.

http://powerpro.webeddie.com/

2. AutoFill forms - A Firefox Add-on that enables you to fill out web forms with a keyboard shortcut.

3. Ubiquity -  A Firefox Add-on that lets you give commands to Firefox by entering command words into a special input box.

Thursday, July 16, 2009

sqlplus tip

1. DEFINE_EDITOR=vi  - define the vi editor
2. EDIT - edit the sql statement in current buffer with using vi editor
3. save file <filename> - save the sql statement in current buffer to a file
4. get file <filename> - load the sql statement from file to current buffer
5. / - execute the sql statement in current buffer

Wednesday, July 15, 2009

Some tools

Ganglia - a tools to monitor the system performance

http://ganglia.info/

Hudson - A tools to perform the build and automation functional test

http://hudson.com/

nmon - a tools to monitor the Linux performance

http://blog.csdn.net/chinalinuxzend/archive/2009/06/03/4238526.aspx

Selenium - a tool to do the web automation test

http://seleniumhq.org/

Thursday, July 09, 2009

Some sql tips

sequence and streams

CREATE SEQUENCE some_sequence
  START WITH -1
  INCREMENT BY -100

Convert the delimited string to list

select (column_value).getstringval()
from xmltable('"a","b","c"');

Monday, June 29, 2009

Recreate capture process

select * from dba_queue_tables

BEGIN

  dbms_capture_adm.drop_capture(capture_name          => 'RSA_STREAMS_CAPTURE',
                                drop_unused_rule_sets => TRUE);

END;


BEGIN
  dbms_streams_adm.add_schema_rules(queue_name         => 'RSA_STREAMS_CAPTURE_Q',
                                    streams_type       => 'CAPTURE',
                                    streams_name       => 'RSA_STREAMS_CAPTURE',
                                    schema_name        => 'RSA_REP',
                                    include_dml        => TRUE,
                                    include_ddl        => FALSE,
                                    include_tagged_lcr => TRUE,
                                    inclusion_rule     => TRUE);

END;


list Opatch on non-default folder

/opatch lsinventory -invPtrloc /export/home/qeuser/AuthMgr/db/oraInst.loc

Friday, June 26, 2009

Using RMAN to deregister the missing archived log files

rman

connect target sys/<>
crosscheck archivelog all
delete expired archivelog all