Friday, June 22, 2007

HOW TO REMOVE ARCHIVE LOGS ENTRIES FROM V$ARCHIVED_LOG

The archived redo log records are determined by "MAXLOGHISTORY", then when it reach
es the max value it begins to overwrite entries starting from the beginning.

Only way to clean it is by recreate the controlfile

Monday, June 18, 2007

Back from Vietnam Trip

A nice trip back from Saigon, Vietnam. Spent 3 days 2 nights there.

It's a wonderful experience. Things are reasonable priced and cheap. You can get good bargains in the market.

Breakfast on Sunday was a chicken tuna sandwich in the airport.

Evening back to Spore. Wasn't feeling good. Got indigestion. Went to see doc. The relief doc was crappy.