Monthly Archives: September 2008
dbms_mview.explain_mview to figure out why fast refresh failed with ORA-32314
Q: Fast refresh failed with message "ORA-32314: REFRESH FAST of "U1"."MV_T1" unsupported after deletes/updates"A: DBMS_MVIEW.EXPLAIN_MVIEW is for this purpose. CaseSQL> conn u1/***Connected.SQL> @?/rdbms/admin/utlxmv.sqlTable created.SQL> EXEC dbms_mview.explain_mview(‘"U1"."MV_T1"’);PL/SQL procedure successfully completed.SQL> desc MV_CAPABILITIES_TABLE Name Null? Type —————————————– ——– —————————- STATEMENT_ID VARCHAR2(30) MVOWNER VARCHAR2(30) MVNAME VARCHAR2(30) CAPABILITY_NAME VARCHAR2(30) POSSIBLE CHAR(1) RELATED_TEXT … Continue reading
sar + ksar to generate system statistics graph report on LINUX
Q: I want to have graph report on CPU/Memory/Disk/Swap from timeA to timeBA: KSar will format sar output and make html/pdf report with graph. Save your time. Step 1 decide system statistics snapshoton 32-bit architectures:/usr/lib/sa/sa1 [ interval count ]on 64-bit … Continue reading
How does ‘create database’ command generate files one by one
Oracle doesn’t tell you exact answer in document. However it is straightforward in this way:.controlfile.redo log.system tablespace.undo tablespace.sysaux datafile.temporary tablespace.default user tablespaceYou get to review your concept in mind if it doesn’t make sense :-))
Moved to new house
day, night, packing, unpacking, moving, moving,When moving to new house, I found I owned so many stuff than expected. Wow, I am so rich!
AIG go to nothing
AIG, one of the top insurance company go to nothing. As we expected, the U.S. government take over it and inject TONS of MONEY to save it only temporarily. Market is far from security. It is not the beginning or … Continue reading
Etimemachine installation in Oracle 10g
It is not unusual I can’t stop frowning at what developer did. Looks what Etimemachine guys play with oracle database:They can’t catch up with Oracle new features and break security rules obviously. create tablespace ***_datdatafile ‘??PATHNAME??**.dbf’ size 500M reusedefault storage … Continue reading
Top 1 Canadian beer: MooseHead
"MOOSE-HEAD"! the most fantastic factor of this NUMBER 1 beer is they never try to be in any stock market. Instead, "Today, Derek Oland’s sons Andrew and Patrick are the sixth generation of Olands to own and work for the … Continue reading
no change in interest rate
The Bank of Canada kept the status quo on it’s current 4.75%. That clearly means economy worsen because we all know oil price fallen recently. On the other hand, it is good for home owner like me. 🙂
the latest DST patch + Security patch for 10.2.0.4 (10gR2)
Q: I want to apply the latest patch to database 10.2.0.4 (the latest 10gR2)A: 3 things to do: DST patch (timezone and OJVM), Critical Patch. The key is: correct version. The proved sequence is as I listed here, timezone, OJVM … Continue reading
I get32-Inch Flat Panel LCD HDTV as PC monitor : HDMI
Yeah, my combination is PC (exclude monitor) + 32-inch TV. It definitely surprised future-shop guys. What I get?1. watch 32-inch Flat Panel LCD HDTV2. run PC as normal And I can plug blue-ray DVD player with another HDMI cable. Perfect … Continue reading
老庞闲话 