|
|
Wednesday, July 2nd, 2008
| |
2:25 pm - cpulimit
|
http://cpulimit.sourceforge.net
root@pitsu:/temp/cpulimit# cpulimit --exe java --limit 40
Priority changed to -10
Process 1840 found
- любопытная штука, вот только консоль потом не отдает... может оно должно быть постоянно запущено, т.е.
cpulimit --exe java --limit 40 & ?
|
|
(comment on this)
|
| Tuesday, June 24th, 2008
| |
3:45 pm - памятка по oracle scheduler
|
Как найти слетевшие джобы?
select * from DBA_SCHEDULER_JOB_RUN_DETAILS where status='FAILED'
select * from DBA_SCHEDULER_JOB_RUN_DETAILS where additional_info like '%ORA-04031%'
ORA-04031: unable to allocate ORA-04031: unable to allocate 4112 bytes of shared memory ("shared pool","FT_USER_PAGE_VISIT","pacdHds_kkpaco","stP_kkpacd: kkpodPacdInit")
ORA-06512: at "SYS.PRVT_ADVISOR", line 1624
ORA-06512: at "SYS.DBMS_ADVISOR", line 186
ORA-06512: at "SYS.DBMS_SPACE", line 1500
ORA-06512: at "SYS.DBMS_SPACE", line 1566
bytes of shared memory ("","","","")
и т.д. - more at http://www.orafaq.com/wiki/Scripts
|
|
(comment on this)
|
| Thursday, June 19th, 2008
| |
7:23 pm - command history in sqlplus
|
|
| |
3:39 pm - tablespace free %
|
SELECT a.tablespace_name,
round(b.bytes / c.full_size * 100) "FREE SPACE %"
FROM dba_tablespaces a,
(SELECT tablespace_name,
SUM(bytes) bytes
FROM dba_free_space
GROUP BY tablespace_name) b,
(SELECT tablespace_name,
SUM(bytes) full_size
FROM dba_data_files
GROUP BY tablespace_name) c
WHERE a.tablespace_name = b.tablespace_name(+)
AND a.tablespace_name = c.tablespace_name
( Read more... )
|
|
(1 comment | comment on this)
|
| Tuesday, June 10th, 2008
| |
6:49 pm - datapump example
|
Дамп:
[oracle@svor1 ~]$ expdp report_prod/report@DWRPT tables=adj_campaign,adj_advertiser,adj_adspot,adj_publisher directory=DATAPUMP5 dumpfile=minsk.dmp logfile=minsk.log
И восстановление дампа на другой машине:
[root@linuxtest ~]# impdp report_prod/report@nebuad tables=report_prod.adj_campaign,report_prod.adj_advertiser,report_prod.adj_adspot,report_prod.adj_publisher directory=myimp dumpfile=minsk.dmp logfile=minsk.log REMAP_SCHEMA=report_prod:nebuad REMAP_TABLESPACE='DATA01_DEFAULT':'USERS'
|
|
(comment on this)
|
| Sunday, June 8th, 2008
| |
10:58 pm - svn
|
PATH=/usr/local/bin:$PATH
alias CHE="svn stat | grep -v '?'"
alias DAY="svn update"
alias NA="svn commit"
alias CHEZANAH="svn diff"
alias KAKOYMUDAK="svn blame"
|
|
(comment on this)
|
| Monday, May 26th, 2008
| |
2:34 pm - Памятка по flashback
|
Почему-то это прокатывает в sqlplus, но не работает в sqldeveloper:
forester@TSH1> variable SCN number
forester@TSH1> exec :scn := dbms_flashback.get_system_change_number
PL/SQL procedure successfully completed.
( Read more... )
|
|
(comment on this)
|
| Friday, May 23rd, 2008
| |
3:39 pm - маленькая памятка по tune2fs
|
root@forester:~# /sbin/tune2fs -m 2 /dev/sda4
tune2fs 1.39 (29-May-2006)
Setting reserved blocks percentage to 2% (74059 blocks)
root@forester:~# /sbin/tune2fs -l /dev/sda4|grep Reserved
Reserved block count: 74059
Reserved blocks uid: 0 (user root)
Reserved blocks gid: 0 (group root)
root@forester:~#
|
|
(comment on this)
|
| Tuesday, May 20th, 2008
| |
7:23 pm - мдеее...
|
[root@svor1 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda5 82G 28G 51G 36% /
/dev/sda1 99M 26M 68M 28% /boot
tmpfs 16G 0 16G 0% /dev/shm
/dev/sda3 20G 173M 19G 1% /tmp
/dev/sdb1 660G 319G 308G 51% /u01
/dev/emcpowera1 5.9T 5.8T 33G 100% /u200
/dev/emcpowerb1 264G 24G 227G 10% /u201
/dev/emcpowerd1 264G 3.4G 248G 2% /u202
/dev/emcpowerc1 528G 302G 199G 61% /u203
/dev/emcpowere1 793G 681G 72G 91% /u300
/dev/emcpowerf1 793G 518G 235G 69% /u301
/dev/emcpowerg1 793G 662G 92G 88% /u302
/dev/emcpowerh1 793G 744G 9.1G 99% /u303
/dev/emcpoweri1 793G 667G 87G 89% /u304
/dev/emcpowerj1 793G 722G 32G 96% /u305
/dev/mapper/SAS_MD1000_VG-SAS_MD1000_LV
3.5T 1.7T 1.8T 49% /u02
/dev/emcpowerk1 793G 569G 184G 76% /u306
/dev/emcpowerl1 793G 570G 184G 76% /u307
/dev/emcpowerm1 793G 565G 188G 76% /u308
/dev/mapper/md_backup_lg-md_backup_lv
12T 12T 476G 97% /ora_backup0
/dev/emcpowero1 793G 501G 252G 67% /u309
[root@svor1 ~]# cat /etc/issue
Red Hat Enterprise Linux Server release 5.1 (Tikanga)
Kernel \r on an \m
[root@svor1 ~]#
|
|
(comment on this)
|
| Tuesday, May 13th, 2008
| |
6:08 pm - console md5
|
|
echo -n my_very_secret_password | md5sum | cut -d ' ' -f 1
|
|
(comment on this)
|
| Wednesday, May 7th, 2008
| |
5:12 pm - Oracle dblink - analog MSSQL "linked tables"?
|
drop database link FILEDB2;
create database link FILEDB2 connect to report_prod identified by report using '172.16.200.172/filedb2';
памятка: по exp содержимое таблиц таких линков не экспортируется, экспортируются только сами линки...
надо подумать, как экспортировать DDL+data.
|
|
(comment on this)
|
| Tuesday, May 6th, 2008
| |
2:19 pm - памятка по failower
|
|
| Tuesday, April 29th, 2008
| |
1:59 pm - памятка по Oracle+++
|
SYS @ DWRPT >select owner, sum(bytes) from dba_segments group by owner order by sum(bytes) desc ;
OWNER SUM(BYTES)
------------------------------ ------------------------------
REPORT_PROD 4856619008000
AZIZ 352841564160
SPBURG1 231708295168
REMI 196575690752
DATAMART 181323497472
DEEPAK 45232226304
SYS 15725625344
DATAMART_STAGING 10146414592
QUALIFIER_DATAMART 3894673408
REPORT_JOBS 3693740032
SYSMAN 215351296
XDB 149487616
... и т.д.
показывает, кто сколько скушал.
|
|
(comment on this)
|
| Thursday, April 24th, 2008
| |
12:59 pm - ssh without terminal allocation
|
А ведь не знал, что бывает такое:
[root@sandbox ~]# w
01:56:57 up 27 days, 12:05, 1 user, load average: 3.28, 3.20, 3.18
USER TTY FROM LOGIN@ IDLE JCPU PCPU WHAT
root pts/2 10.50.51.175 01:53 0.00s 0.02s 0.00s w
[root@sandbox ~]# ssh root@localhost -T
root@localhost's password:
w
01:57:14 up 27 days, 12:05, 1 user, load average: 3.27, 3.20, 3.18
USER TTY FROM LOGIN@ IDLE JCPU PCPU WHAT
root pts/2 10.50.51.175 01:53 0.00s 0.02s 0.00s ssh root@localh
ps aux|grep ssh
root 2102 0.0 0.0 57588 480 ? Ss Mar27 0:00 /usr/sbin/sshd
root 21054 0.0 0.1 85112 3168 ? Ss 01:52 0:00 sshd: root@pts/2
root 21312 0.0 0.1 51188 2956 pts/2 S+ 01:57 0:00 ssh root@localhost -T
root 21313 0.0 0.1 82916 3088 ? Ss 01:57 0:00 sshd: root@notty
crtl+D
[root@sandbox ~]#
Apr 24 01:57:11 sandbox sshd[21313]: Accepted password for root from 127.0.0.1 port 40636 ssh2
так что век живи, век учись ;)
|
|
(comment on this)
|
| Monday, April 21st, 2008
| |
9:13 pm - Oracle works!
|
|
| |
8:40 pm - памятка по Oracle++
|
create user some_user identified by "123";
grant create session, resource to some_user;
или: grant dba to some_user;
|
|
(comment on this)
|
| |
2:57 pm - vnc
|
Дооолго искал, кто съел весь спейс.
Оказалось - я сам:
du -h |grep G
62G ./.vnc
current mood:  accomplished
|
|
(comment on this)
|
| Friday, April 18th, 2008
| |
3:25 pm - памятка по Oracle
|
в PL/SQL Developer:
begin
dbms_output.put_line(to_char(dbms_metadata.get_ddl('TABLE', 'LOG_FILE_ETL')));
end;
вернет DDL для для таблички LOG_FILE_ETL;
+++ CLI:
( Read more... )
current mood:  working
|
|
(1 comment | comment on this)
|
| Tuesday, April 1st, 2008
| |
7:12 pm - Мне определенно нравится их "usbdisk" ;))
|
[root@svutil1 admin]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
29G 28G 131M 100% /
/dev/sda3 99M 23M 72M 24% /boot
none 2.0G 0 2.0G 0% /dev/shm
/dev/sdb1 459G 318G 141G 70% /media/BACKUP_VOL
/media/BACKUP_VOL/misc
459G 318G 141G 70% /misc
/dev/sdd1 459G 455G 3.8G 100% /media/usbdisk
[root@svutil1 admin]#
|
|
(comment on this)
|
| Thursday, January 24th, 2008
| |
5:08 pm - фильм ужасов ;)
|
17:07:26 up 1 day, 18:59, 1 user, load average: 44.46, 43.31, 42.80
157 processes: 108 sleeping, 44 running, 5 zombie, 0 stopped
CPU0 states: 75.0% user 24.5% system 0.0% nice 0.0% iowait 0.0% idle
CPU1 states: 73.4% user 26.1% system 0.0% nice 0.0% iowait 0.0% idle
CPU2 states: 74.3% user 25.2% system 0.0% nice 0.0% iowait 0.0% idle
CPU3 states: 75.0% user 24.5% system 0.0% nice 0.0% iowait 0.0% idle
CPU4 states: 77.4% user 22.0% system 0.0% nice 0.0% iowait 0.1% idle
CPU5 states: 67.4% user 32.0% system 0.0% nice 0.0% iowait 0.1% idle
CPU6 states: 78.1% user 21.3% system 0.0% nice 0.0% iowait 0.1% idle
CPU7 states: 72.1% user 27.4% system 0.0% nice 0.0% iowait 0.0% idle
Mem: 2068768k av, 1895768k used, 173000k free, 0k shrd, 266224k buff
551148k active, 269880k inactive
Swap: 979956k av, 0k used, 979956k free 554692k cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
31674 transd2 10 0 0 0 0 Z 14.3 0.0 0:00 1 transd2
31714 transd2 11 0 0 0 0 Z 6.7 0.0 0:00 1 transd2
31713 transd2 10 0 0 0 0 Z 6.1 0.0 0:00 0 transd2
31715 transd2 10 0 0 0 0 Z 6.0 0.0 0:00 7 transd2
31719 transd2 9 0 0 0 0 Z 3.8 0.0 0:00 7 transd2
|
|
(2 comments | comment on this)
|
|
|
|
|
![[info]](http://p-stat.livejournal.com/img/userinfo.gif){kind=small}
protei's journal
amused