All 20 entries tagged Review

Coach for diversity

I recently participated a pilot project "Coach for diversity" organized by Warwick and LSE.

This book is the one I must read before next stage started. It is the first time after graduation I will be forced to read a book.

Hongfeng Sun : 15 Jul 2006 23:44 |  Tags: Life Review Training |  Comments (0) |  Close comments |  Report a problem

Hibernate 3

• P151: Open Session view is not the first choice. Should fecht the completed required graph in the first place, using HQL or criteria queries, with a sensible and optimized defualt fetching strategy in the maping metadata for all other cases

• P110: Line10 How to interpret that?

Thus if we noly call items.getBids().add(bid), no changes will be made persistent

With cascade=”all”, hibernte will persist the bid instance. However, the value of the foreign key column is not set

Hongfeng Sun : 27 Apr 2006 16:07 |  Tags: Review Spring-Hibernate-Jboss |  Comments (0) |  Close comments |  Report a problem

Cost Based Oracle

I began to read this book. I attended several presentations by this book’s author,Johnathan Lewis, in UKOUG conference and some were quite impressive.
This book is definitely a dream-killer. I cannot fall asleep after reading this, for you have to be very vigilant. I brought this book back to office.

P101: Columns order: put columns that appear with a range-based predicate toward the end of index definition; improve the compressibility of an index by putting the least selective(most repetitive) columns first

 
 cost  = blevel + 
            leaf_blocks * effective_index_selectivity +
           clustering_factor * effective_table_selectivity

effective_index_selectivity MIGHT = 1/distinct_keys (in user_indexes table)

P52 selectivity = “required range”divided by “total available range”

Hongfeng Sun : 06 Mar 2006 21:04 |  Tags: Oracle-Tune Review |  Comments (0) |  Close comments |  Report a problem

My first English crime story

Hongfeng Sun : 21 Feb 2006 20:40 |  Tags: Review |  Comments (0) |  Close comments |  Report a problem

Refactoring

Great Book.It bring me the whole world of refactoring.

Eclipse IDE makes refactoring job a joyable task. I can seriously say: it is fun.

Hongfeng Sun : 27 Jan 2006 14:56 |  Tags: Java Review |  Comments (0) |  Close comments |  Report a problem

STATSPACK

Not very good

£36.99

Hongfeng Sun : 27 Jan 2006 14:51 |  Tags: Oracle-Tune Review |  Comments (0) |  Close comments |  Report a problem

10g Complete Reference

Not very good. Superficially cover too many contents.

£41.99

Hongfeng Sun : 27 Jan 2006 14:49 |  Tags: Oracle Review |  Comments (0) |  Close comments |  Report a problem

Oracle BAckup & Recovery Handbook

A old version Oracle book, talking about Oracle 9i, 2 generations behide now.

It once helped me a lot and the pricipals still apply

Hongfeng Sun : 27 Jan 2006 14:47 |  Tags: Oracle-Availability Review |  Comments (0) |  Close comments |  Report a problem

RMAN

A good book, but it is not very well organized.

Duplicate to a Remote Server P408

• have to either copy backups to or NTF mount backups at the remote serve
• copy archivelogs from target to auxiliary
• On target server, configure tnsnames.ora to point auxilariy instnce; On auxiliary sitse, need to edit listener.ora
• rman target / auxiliary system/*@auxi_server
• sql 'alter system switch logfile';
• duplicate target database to nofilenamecheck pfile=/pfile/init.ora logfile '/loca1' size 100m, '/loca2' size 100m
• Other clauses include: 1) skip tablespace 'users','tools' ; 2) until sequcne =1 thread = 1

Duplicate to a Same Server P406

• make sure db_file_name_convert = ('target','aux');

Hongfeng Sun : 27 Jan 2006 12:35 |  Tags: Oracle-Availability Review |  Comments (0) |  Close comments |  Report a problem

High Availability

Hongfeng Sun : 27 Jan 2006 12:34 |  Tags: Oracle-Availability Review |  Comments (0) |  Close comments |  Report a problem