All 20 entries tagged Review

View all 0 entries tagged Review on Warwick Blogs | View entries tagged Review at Technorati | There are no images tagged Review on this blog

July 15, 2006

Coach for diversity

Title:
Rating:
2 out of 5 stars

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.


April 27, 2006

Hibernate 3

Title:
Rating:
3 out of 5 stars
  • 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


March 06, 2006

Cost Based Oracle

Title:
Rating:
4 out of 5 stars

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

P69 Index-driven access path:
 
 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”


February 21, 2006

My first English crime story

Title:
Rating:
4 out of 5 stars
Very interesting. I read it through in one day.

January 27, 2006

Refactoring

Title:
Rating:
5 out of 5 stars

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.


STATSPACK

Title:
Rating:
2 out of 5 stars

Not very good

£36.99


10g Complete Reference

Title:
Rating:
2 out of 5 stars

Not very good. Superficially cover too many contents.

£41.99


Oracle BAckup & Recovery Handbook

Title:
Rating:
4 out of 5 stars

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

It once helped me a lot and the pricipals still apply


RMAN

Title:
Rating:
4 out of 5 stars

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');

High Availability

Title:
Rating:
4 out of 5 stars

Search this blog

Search Warwick Blogs

 

Tags

Most recent comments

  • Oracle 11g is the clear leader in this area. Oracle has invested heavily into self–tuning capabiliti… by shaane on this entry
  • All the features are very nice.I like Repair Advisors the most.Oracle 10G introduced some of the dat… by lucy on this entry
  • "logical standby failed to re–start, I am also getting the same error. I have search on internet and… by anemia on this entry
  • Thanks for the nice information because from last three days i am stuck on this problem…. by robot vacuum on this entry
  • So what happen City speed dating when you tried this coding once in your PC.. Please tell me so i am… by John Bergeron on this entry
RSS2.0 Atom
Not signed in
Sign in

Powered by BlogBuilder
© MMXXII