|
|
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 ~]# - и все, в last никаких следов... но в /var/log/secure кое-что есть:
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)
|
|
|
|
|