skip to main
|
skip to sidebar
木匠的天空 Database Architect and Developer
A man who has imagination has wings. The sky's the limit. DBA + data modeler + developer
No posts.
Show all posts
No posts.
Show all posts
Home
Subscribe to:
Posts (Atom)
木匠的天空 -- Oracle Architect and Developer
2nd blog
Blog Archive
▼
2011
(3)
▼
June
(1)
Question to AskTom on Oracle Magazine
►
May
(1)
Explore MongoDB
►
April
(1)
What should the top five priorities be for new DBA...
►
2010
(12)
►
October
(1)
effective index selectivity 2
►
September
(1)
Throttle big result set
►
August
(1)
IN_EXISTS Correlated Subquery
►
May
(2)
Collection_Array
Benchmark with RunStats
►
April
(4)
Find and delete duplicate rows by Analytic Functio...
Reclaim deleted LOB data storage
Pl/SQL Development Workflow
Why Transactional Database API approach?
►
March
(3)
Setup StatsPack to monitor standby database perfor...
Query paging row count
SOA - Transactional Database API - Database access...
►
2009
(21)
►
December
(1)
Turn on INTERVAL PARTITIONING on a range partition...
►
November
(3)
Effective table selectivity index selectivity and ...
row level timestamp implementation
Tune SQL with SQL plan baseline
►
June
(1)
single INSERT vs array BULK INSERT
►
April
(5)
Benchmark row-by-row and set based process
table stats tool script
debug.f to instrument PL/SQL code
New efficient HASH FULL OUTER join in 11g
PL/SQL instrument utility u$err package
►
March
(1)
How to display SQL code in text format exactly
►
February
(3)
NO_INDEX hint and deprecated ROWID hint
update and undo
External table benchmark fixed-length vs. delimite...
►
January
(7)
Output from 10053 trace and dbms_xplan.display_cur...
Fix SQL index access path issue with 10053 trace a...
Overview asynchronous process change data
How to generate testing data
Why asynchronous process?
cross rows comparing
3 PL/SQL approaches fetch data into ADT collection...
►
2007
(3)
►
September
(1)
Good practice: Middle-tier DAL or Database API – D...
►
July
(2)
我年轻时所不了解的事情
PL/SQL 在 Oracle 11g 里面的功能完善: "continue"
►
2006
(6)
►
December
(1)
Database developers and Database API
►
November
(3)
Cascade DELETE
General Knowledge
Oracle Data Guard and 11g database
►
October
(2)
Data API -- Data access and process interface
木匠铺子开张啦
Labels
10053 trace
(1)
11g
(1)
ADT
(1)
Analytic
(1)
array
(1)
asynchronous process
(2)
BASE
(2)
benchmark
(2)
CBO
(3)
collection
(2)
compress
(1)
consistency
(1)
data guard
(1)
Database API
(1)
DBA priority
(1)
dbms_rowid extent
(1)
dbms_xplan
(1)
density
(1)
external table
(1)
generate
(1)
hint
(1)
histogram
(1)
html
(1)
instrument
(1)
Oracle
(2)
Oracle DBA
(1)
partition
(2)
passion creative life
(1)
PL/SQL
(4)
selectivity
(1)
set based process
(1)
split function
(1)
SQL
(1)
standby
(1)
test
(1)
undo
(1)
work
(24)
About Me
Charlie 1 木匠
Design and develop scalable database applications. Build efficient data model and Transactional database API. 为什么鄙人自称为"木匠"? -- 软件架构师和土木工程的建筑师一样(都是architect),是一个项目的设计首脑,通常由技术部门的高手担任,有很崇高的地位. 因为架构师的工作影响深远,他们往往牵制连连. 工程人员对他们的设计有意见,项目经理对他们的设计有意见,营业部门对他们的设计有意见,客户对他们的设计有意见,层层经理对他们的设计有意见,财政部门对他们的设计也有意见。 -- "我们架构师要为技术负责,我们出席会议,同主要利害关系人(stakeholders)开会一同决定,讨论技术方案的利弊,辅导他们做决定." -- "我们必须考虑每个决定可能造成的各种影响,得听听大家的意见,每个决定需要多方考量,我们只能努力争取利害关系人的信任,辅导他们做正确的决定" -- "要争权和要服务是非常不同的心态,不是几句话能改变的。一个人要有相当的智慧,信心和耐心才能从争权的心态里走出来" == 有权负责,无权决定. -- Hope,love,work, ride these waves like a surfer in an adventure journey 结交天下朋友. -- 打击日货 匹夫有责, 有正义感 有骨气 有良知的中国人. -- 来自 商州 西安,珠海,广州,厦门, 香港,深圳 北京Victoria,BC,Canada... -- 待到他日山花烂漫时
View my complete profile