ITPub博客

All text in an xml  document will be parsed by the parser. But text inside a CDATA section will be ignored by the parser. A CDATA section starts with "<![CDATA[" and ends with "]]>"...

:set number  or :set nu :set number! or :set nu!

lsof

:syntax on :syntax off

SELECT s.sid, S.BLOCKING_SESSION, S.FINAL_BLOCKING_SESSION  FROM v$session s  WHERE s.blocking_session IS NULL AND exists( select 1 from v$session s2 where S2.BLOCKING_SESSION =...

 http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_9016.htm  MERGE INTO  bonuses D   USING  (SELECT employee_id, salary, department_id FRO...

create table [tablename] asselect * from [another_TableName]

please refer to this following article, http://www.oracle.com/technetwork/issue-archive/2012/12-jul/o42dba-1566567.html How to find locked objects:1. Get row lock inf...

please refer to the following article. http://www.oraclerecipes.com/monitoring/find-blocking-sessions/  

du -sh name where name could be the name of a file or the name of a directory 

archive files or update  files in an archive file: zip zipfile file1 file2 ... extract a file in an archive file: unzip zipfile fileToExtract eg. unzip wmserve...

locale -a  locale -m echo $Lang temporarily set Lang:  LANG='zh_CN.GBK'; export LANG/etc/sysconfig/i18n records the system default locale ....

1. see if AWR is enabled show parameter statistics_level 2. modify interval and retention exec DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS(retention=>43200, interv...

emctl start dbconsole emctl stop dbconsole emctl status dbconsole

emca is used to configure enterprise manager.Please refer to http://space.itpub.net/20943428/viewspace-628782 to set up enterprise manager.You will pe...