[转载]oracle DBA technologies
之前看到一篇文章, 觉得不错! 看了后,发觉自己还有很多地方需要补足, 还需要努力啊！任重而道远！
DBA需要的技能
dba掌握的技术
1. os : linux,solaris或其他unix起码要一种
2. bash (不精通也要熟) LINUX与UNIX SHELL编程指南.pdf
3. perl 包括:
Perl_CD_BookShelf.chm
learning perl
perl pragramming
4. java（掌握）包括jdbc thin,oci等4类不同的连接方式，性能设置，一些中间件的知识
了解一些就够了
5. oracle performance tuning（范围很广）
ocp performance book
下tom的书《Wrox - Expert one-on-one Oracle》，
http://www.ebookcn.net/Soft/Soft_12042.htm
http://zuse.esnig.cifom.ch/database/doc_oracle/Oracle920_Linux/
server.920/a96533/toc.htm[/url]
oracle sql hign performance tuning 2nd editon by guy harrison
6. pl/sql
OReilly_oracle_Bookshelf 包括：
&nb
相关文档：
oracle表空间操作详解
1
2
3作者： 来源： 更新日期：2006-01-04
5
6
7建立表空间
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
按资料说V$BH查看表来显示数据库里每个对象类型的数据缓冲区里数据块的数量.
然后查询V$bh
select
owner, object_name
from
dba_objects o,
v$bh &nbs ......
1. Read the Data Block.
2. Read the Row Header.
3. Check the Lock Byte to determine whether there's an ITL entry.
4. Read the ITL entry to determine the Transaction ID (Xid).
5. Read the Transaction Table using the Transaction ID. If the transaction has been committed and has a System Commit ......
使用模糊查询：
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-mm-dd");
Date startdate = sdf.parse(start_date);
Date enddate = sdf.parse(end_date);
List list = sess.createCriteria(MyTabel.class)
.add( ......
select t.lot_number
from inv.mtl_onhand_quantities_detail t
left join mtl_system_items_b mi
on t.inventory_item_id = mi.inventory_item_id
where mi.segment1 like '101%' and mi.organization_id = 102
group by t.lot_number having count(*)=1 union
select t.lot_number||'x'
......
