Database » June 10, 2008

Feeds

14827 items (1495 unread) in 26 feeds

Database (1495 unread)

• DBA's notes (111 unread)
• $Pete Finnigan's Oracle security weblog (56 unread)
• Ask Tom MOST RECENT ARTICLES (350 unread)
• Databases News (83 unread)
• DBAzine.com - Oracle Articles Archive (4 unread)
• Eddie Awad's Blog (31 unread)
• FeuerThoughts (36 unread)
• Mark Rittman's Oracle Weblog
• MR. ED's blog (1 unread)
• MySQL Performance Blog (133 unread)
• Niall's Oracle Pages (17 unread)
• OraBlogs
• Oracle + Open Source
• Oracle HTML DB Studio Recent Additions (20 unread)
• Oracle Security Alerts (2 unread)
• Oracle Software Downloads (62 unread)
• Oracle Technology News (34 unread)
• Oracle's OTN TechCasts (21 unread)
• Orawin.Info
• OTN TechBlog (72 unread)
• OTN/DBA
• Published Security Alerts
• The Dizwell Blog
• The Tom Kyte Blog (18 unread)
• TheServerSide.com (444 unread)
• Upcoming Security Alerts

(4 unread)

• June 10, 2008
• 22:36

  Oracle's Arch2Arch Newsletter

   » ‎ OTN TechBlog

  As I have mentioned previously, BEA did a good job reaching out to the "Architect" constituency, better than OTN does. For that reason, one of our main goals this summer is to fork-lift BEA's "Arch2Arch" community to OTN, and we have big plans in that area.
  
  For one, shortly you will see new "Architecture Centers" and discussion forums on the OTN Website, focusing on areas such as SOA Governance and Enterprise 2.0. Existing centers covering SOA and Virtualization will also be beefed up considerably.
  
  But even better, we have decided to maintain the Arch2Arch community's newsletter, Arch2Arch Advisor going forward in its new incarnation as "Oracle's Arch2Arch Newsletter", under the editor-ship of Bob Rhubart. You can subscribe to this newsletter right now (see "Electronic Subscriptions" section; first edition in August).
  
  Who knows, you may even see "OTN Architect Day" workshops later this year. Stay tuned.
  

• 19:36

  Oracle's Arch2Arch Newsletter

   » ‎ OTN TechBlog
  As I have mentioned previously, BEA did a good job reaching out to the "Architect" constituency, better than OTN does. For that reason, one of our main goals this summer is to fork-lift BEA's "Arch2Arch" community to OTN, and we have big plans in that area.
  
  For one, shortly you will see new "Architecture Centers" and discussion forums on the OTN Website, focusing on areas such as SOA Governance and Enterprise 2.0. Existing centers covering SOA and Virtualization will also be beefed up considerably.
  
  But even better, we have decided to maintain the Arch2Arch community's newsletter, Arch2Arch Advisor going forward in its new incarnation as "Oracle's Arch2Arch Newsletter", under the editor-ship of Bob Rhubart. You can subscribe to this newsletter right now (see "Electronic Subscriptions" section; first edition in August).
  
  Who knows, you may even see "OTN Architect Day" workshops later this year. Stay tuned.
  

• 17:44

  I don't know...

   » ‎ The Tom Kyte Blog

  I don't know if

  a) I'm getting grumpier as I get older

  b) people are losing the ability to phrase a question. 

  It just seems to me that day by day, the quality of the questions goes down.  I don't remember people asking questions like this just 8 years ago.  I've been participating in forums since 1994.  "Back in the day", the questions were mostly thought out, with examples - with some background, with some thought.  In the last couple of years - this seems to be changing - universally.

  Oh well, it is probably related to both bullet points... Anyway here is the QOD - question of the day.

  Subject: query is not using particular partition and index despite use full table scan

  Entire question:

  SELECT count(*)
  FROM
  DIM_BANK RIGHT OUTER JOIN FACT_JRNL_ACTG ON (DIM_BANK.BANK_ID=FACT_JRNL_ACTG.BANK_ID)
  LEFT OUTER JOIN DIM_BSA ON (FACT_JRNL_ACTG.BSA_ID=DIM_BSA.BSA_ID)
  LEFT OUTER JOIN DIM_FY ON (FACT_JRNL_ACTG.FY_ID=DIM_FY.FY_ID)
  LEFT OUTER JOIN DIM_APD ON (FACT_JRNL_ACTG.APD_ID=DIM_APD.APD_ID)
  LEFT OUTER JOIN DIM_PSCD ON (FACT_JRNL_ACTG.PSCD_ID = DIM_PSCD.PSCD_ID)
  WHERE
  (
  (DIM_BANK.BANK_ACCT_CD IN ('33')
  OR '*' IN ('33'))
  AND DIM_PSCD.PSCD_CLOS_CL_CD IN ('1', '4', '5')
  AND CASE DIM_BSA.CASH_ACCT_FL WHEN 0 THEN 'No' WHEN 1 THEN 'Yes' END = 'Yes'
  AND DIM_APD.PER != 0
  AND DIM_APD.PER != 99
  AND DIM_APD.FY < 2008
  OR DIM_FY.FY = 2008
  AND DIM_APD.PER <= 6
  AND DIM_APD.PER != 0
  AND CASE DIM_BSA.CASH_ACCT_FL WHEN 0 THEN 'No' WHEN 1 THEN 'Yes' END = 'Yes'
  AND DIM_PSCD.PSCD_CLOS_CL_CD IN ('1', '4', '5')
  AND (DIM_BANK.BANK_ACCT_CD IN ('33')
  OR '*' IN ('33'))
  );

   

  That's it folks.  "My query isn't doing partition elimination (probably, I'm sort of GUESSING) and isn't using some index (on some column of some table)"

  Before anyone says anything - this comes from the US.

  Some wows from reading the query:

  • "(DIM_BANK.BANK_ACCT_CD IN ('33') OR '*' IN ('33')) - why would you do that?
  • "CASE DIM_BSA.CASH_ACCT_FL WHEN 0 THEN 'No' WHEN 1 THEN 'Yes' END = 'Yes'" - why would you do THAT?
  • "CASE DIM_BSA.CASH_ACCT_FL WHEN 0 THEN 'No' WHEN 1 THEN 'Yes' END = 'Yes'" - just in case you didn't believe us the first time
  • wow, more duplicated predicates...
  • outer joins to DIM_BSA, but we have that neat predicate using CASE - if we actually needed to outer join to DIM_BSA then all of the attributes would be NULL - the predicate would never be true - hence, we do not need or want to outer join to DIM_BSA
  • Same comment about DIM_FY, we outer join to DIM_FY, but if we make up a row - then DIM_FY's attributes will all be null and DIM_FY.FY = 2008 cannot be true (or false, it is unknown)
  • Ditto for DIM_APD
  • and of course DIM_PSCD
  • and just to make it 100% complete, the outer join to DIM_BANK - ditto. every single outer join in this query, should not be there.

  I've responded with:

  My car won't start.  Now we are even, we have shared the same level of detail regarding our respective problems.

• 14:08

  How accessible is JSF ?

   » ‎ TheServerSide.com
  Question raised to the JSF community: how accessible is JSF ? In a world focussing on AJAX and Javascript, how do browsers with Javascript support fit in?