- 博客(22)
- 收藏
- 关注
RSS订阅转载 rebuild index online for SQL server
ALTER INDEX index_name ON table_name REBUILD WITH (ONLINE = ON); ...
2016-05-26 08:13:09
311
转载 How to find which process is holding certain port #
netstat -ap | grep <port #> ...
2015-11-19 10:55:55
125
转载 how to create a table from select query in sql server
Select * into new_table from old_table ...
2015-05-27 09:19:50
111
转载 svn revert to a previous revision
A very good description. https://aralbalkan.com/1381/ http://svnbook.red-bean.com/en/1.5/svn.branchmerge.b...
2015-04-30 09:56:46
173
转载 XML CDATA
All text in an xml document will be parsed by the parser. But text inside a CDATA section will be ignored by ...
2013-02-27 14:43:02
97
转载 show line numbers in vim
:set number or :set nu:set number! or :set nu! ...
2013-02-22 08:30:33
155
转载 How to find final blocking session
SELECT s.sid, S.BLOCKING_SESSION, S.FINAL_BLOCKING_SESSION FROM v$session s WHERE s.blocking_session I...
2013-02-17 09:20:55
345
转载 oracle Merge
http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_9016.htmMERGE INTO bonuses D...
2013-02-05 16:52:51
107
转载 How to back up partial data in a table
create table [tablename] asselect * from [another_TableName] ...
2013-02-05 14:55:54
119
转载 how to resolve performance issue caused by locks
please refer to this following article,http://www.oracle.com/technetwork/issue-archive/2012/12-jul...
2013-02-04 19:43:28
121
转载 How to find blocking sessions
please refer to the following article.http://www.oraclerecipes.com/monitoring/find-blocking-sessions/...
2013-02-01 18:42:48
115
转载 How to find the size of files and directories on linux
du -sh name where name could be the name of a fileor the name of a directory ...
2013-01-28 16:52:54
168
转载 zip and unzip
archive files or update files in an archive file:zip zipfile file1 file2 ...extract a file ...
2013-01-24 15:56:27
144
转载 how to look at the locales and charset in linux
locale -a locale -mecho $Langtemporarily set Lang: LANG='zh_CN.GBK'; export LANG ...
2013-01-24 15:07:14
101
转载 generate AWR report
1. see if AWR is enabled show parameter statistics_level 2. modify interval and ret...
2013-01-15 15:37:33
135
转载 How to manually start and stop enterprise manager
emctl start dbconsole emctl stop dbconsole emctl status dbconsole ...
2013-01-15 10:52:45
146
转载 How to manually set up oracle enterprise manager
emca is used to configure enterprise manager. Please refer tohttp://space.itpub.net/2094342...
2013-01-15 09:13:43
111
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人