:set ignorecase
This site contains information, scripts and instructions related to Oracle database and other technologies. Please use sqlplus and test my scripts on test environment before actual use on production. All relevant comments are welcome.
Страницы
- Main
- Veritas cluster
- AIX
- Solaris
- Linux
- Performance scripts
- RAC
- TNS
- Init parameters
- Dataguard
- ASM
- Unix tips
- VxVM
- Linux HA (hearbeat)
- Oracle internals
- Metalink (useful notes)
- Security
- OGG Oracle Golden Gate
- HTML/JavaScript in sqlplus
- Automatic TSPITR 11.2.0.3 (dropped user)
- 12.1
- SQL Performance Analyzer
- Backup/Recovery
- Alert log
понедельник, 2 ноября 2009 г.
четверг, 15 октября 2009 г.
How to: make fonts in Windows XP bigger
Display Properties --> Settings --> Advanced --> DPI Setting --> Large size
пятница, 25 сентября 2009 г.
четверг, 24 сентября 2009 г.
Top segments (physical reads)
select * from (select OWNER, OBJECT_NAME, STATISTIC_NAME, value from V$SEGMENT_STATISTICS where statistic_name = 'physical reads' order by value desc) where rownum <= 3
пятница, 28 августа 2009 г.
среда, 19 августа 2009 г.
Подписаться на:
Сообщения (Atom)
Update BLOB
set define off DECLARE vb1 CLOB := 'long text'; vb2 CLOB := 'long text'; vb3 CLOB := ...
-
0) Generate the diff plan report We have sql_id gu7rvn4s4rb0m, and 2 child cursors 0 and 2 variable v clob set serveroutput on set auto...
-
aus@linux-nn5t:~/Desktop> su - Password: linux-nn5t:~ # /etc/init.d/vboxdrv setup Stopping VirtualBox kernel modules ...
-
-- After media failure 03:03:25 150 4294967295 SYS@orcl> select * from t_t where object_name = 'test'; select * from t_t where ob...