- 博客(2)
- 资源 (9)
- 收藏
- 关注
create detail report for SQL execution
利用SQL monitor生成的运行报告,远远胜过 trace 10046,尤其在RAC的环境里, 方法如下:
1) run your SQL
2) get sql_id and sql_exec_id from gv$sql_monitor
3) create html report by dbms_sqltune.report_sql_monitor
2013-03-19
exadata-compress
Basic Table Compression
•Introduced in Oracle Database 9i Release 2
–Compression during bulk load operations (Direct Load, CTAS)
–Data modified using conventional DML not compressed
•Improved performance for queries accessing large amounts of data
–Fewer I/Os
–Buffer Cache efficiency
•Data is compressed at the database block level
•Compression enabled at either the table or partition level
•Completely transparent to applications
2013-03-19
Exadata and Optimizer
So what operations can actually be offloaded?
–Full table scan
–Fast full index scan of a B-Tree or bitmap index
–Bloom filters
2013-03-19
Asynchronous Web Service Invocation with JAX-WS 2.0
Asynchronous Web Service Invocation with JAX-WS 2.0
2010-03-25
rule user guide
Business rules are statements that describe business policies. For example, a car rental
company might use the following business rule:
If the age of a driver is younger than 21, then decline to rent.
2009-05-15
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人