我会吹泡泡,你会吗?

我100天了,干吗喊我起来,我还没睡醒列

我100天了,妈妈在干吗,给我拍照吗?我还没准备好,等我摆个好点的POSE不行呀.

我是个男孩子,如假包换

饿了,我爸爸把我的奶粉钱都花完了,只能自己吃手指了,看看能不能饱.

嘘,我睡着了,别吵,梦里好多漂亮MM呀.

LOGMNR的一个很实用的小功能，简单记录一下。手工进行LOGMNR分析，大多数是为了寻找被意外修改的数据，或者寻找哪条SQL修改了哪些数据。一般这种情况，关注点都比较明确，甚至可以确定到字段的值，比如需要找到字段A从1变成0的所有修改。而这种情况使用LOGMNR提供的MINE_VALUE就再合适不过了。一个简单的例子：SQL> CREATE TABLE T (ID NUMBER, NAME VARCHAR2(30), FLAG NUMBER(1));表已创建。SQL> INSERT INTO T SELECT ROWNUM, OBJECT_NAME, 1 FROM DBA_OBJECTS;已创建50668行。SQL> COMMIT;提交完成。SQL> UPDATE T SET FLAG = CASE MO...

Here’s a little sneak preview of some of the educational sessions at this year’s Summit. And who better to outline their talks than the speakers themselves? In this first installment, Rik van Riel talks about computing speed; Fedora developer (and Red Hat engineer) Bill Nottingham outlines his thoughts on the most recent Fedora release; and Tom Callaway sums up his plans to speak about the simplest ways to use RPM. Want more? Come see us at the Summit, and check out the full schedule.

---

Why Computers Are Getting Slower (And What We Can Do About It)
Rik van Riel
Wednesday, June 18, 10:15 a.m.

Common wisdom holds that everything about computers gets faster with time. Over the last 20 years, processors have gotten about a thousand times faster, a typical PC has two thousand times more memory, and hard disks are a hundred thousand times times larger.

However, it has become a common experience for people to buy a new faster computer–only to find out that it takes longer to boot up (or do other common system tasks) than it took on the older, supposedly slower computer.

This year at the Red Hat Summit, I will start by explaining some of the fundamental hardware and software reasons for the observed slowdowns. The most obvious reasons have to do with the fact that hardware designs are approaching the limits of what is possible within the laws of physics.

A less obvious reason is that the capacity of most components in a computer has increased far more than the speed at which the components operate. This has caused several operating system algorithms and system administration practices to become impractical on today’s hardware.

Besides showing how bad things can get, my Red Hat Summit presentation also will also discuss operating system improvements to alleviate the problem, as well as deployment and application development practices that can solve the rest of the problem.

---

Fedora 9 Overview and Demonstration
Bill Nottingham
Wednesday, June 18, 11:30 AM

One of the most often asked questions in the software world is:

“What’s coming in the next release?”

Red Hat® Enterprise Linux® is no different. Sure, you can wait for the beta release, and pore through the release notes and the package changelogs. You can corner a product manager at the right moment and get the scoop. But the best way to find out what’s coming up in future Red Hat Enterprise Linux releases? Look at Fedora.

Fedora–for those who don’t know–is a freely available and freely distributable Linux-based operating system that showcases the latest in free and open-source software. It’s developed by people across the globe as part of the Fedora project community, and it’s where Red Hat does their innovation.

In this talk, we’ll look at some of the features that are in Fedora 9 that preview the things to come in later releases of Red Hat Enterprise Linux. Just some of the things you can now do in Fedora 9 that you can’t do in Enterprise Linux 5:

As a IT executive:

• You can run hardware accelerated virtualization, including your old Xen guests, all on the stock kernel

As a systems administrator:

• You can delegate and restrict routine administrative tasks to your users on a task-by-task basis, while simultaneously reducing the amount of security conscious code that runs as root
• You can set up your systems to easily have guest users, that run in a restricted mode where everything they do is reset upon their logout

As a road warrior:

• You can now install to an encrypted filesystem, and use encrypted filesystems for your user data
• Your laptop will use less power than it did before, extending your battery life
• You can now configure your freshly-attached projector without worry of offending all those within earshot

As a user:

• You can now lock your user session and easily let another user log in, without having to close anything you’re doing
• You can transparently move audio streams at runtime from your built-in sound card to your USB headset, or mute your music player when you have an incoming SIP call

At the Red Hat Summit, we’ll discuss all of these and more, with demos. Stop by and see if I actually use Yanni for the audio demos.

---

How to Make Good RPM Packages
Tom “Spot” Callaway
Wednesday, June 18, 1:30 p.m.
RPM Packaging can help make your life easier, but good packages are the key to success. Using good packages means that you spend less time
installing, patching, and tracking software. In my session, I try to peel back the myths and the mystery that surrounds the process of making good, reliable, and maintainable RPM packages. I cover the basics and explain the different sections of an RPM spec, as well as providing some tips and tricks from the Fedora Packaging Guidelines. RPM is powerful, but it doesn’t have to be complicated.

---

Sound like a good time? Then you should join us at this year’s Red Hat Summit. Geeks. Execs. Educators. Everyone. There’s still time to register. (But I’d hurry if I were you.)

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.

Aside from Oracle's own documentation covering Oracle Apps and a few books covering specific modules, the published books landscape regarding EBS is fairly barren. There are two notable generalist coverage books available that can help you get a good jump on learning Oracle Applications.

新浪博客系统升级 揭开众多明星博客造假内幕