Database DataWarehousing (MOSC)

MOSC Banner

looking for a critique of my MV

edited Oct 22, 2013 10:10AM in Database DataWarehousing (MOSC) 1 commentAnswered
Hello

I am working on creating an MV; this is my first attempt and I want to make sure I am not missing anything.

the database version is 10.2.03 exadata RAC. The following SQL is using the most of the CPU and the CPU usage have been noticed to be at 80% on one of the nodes

select sum(authhistjp0_.USD_TRAN_AMT) as col_0_0_, count(authhistjp0_.USD_TRAN_AMT) as col_1_0_
from HIST authhistjp0_
where authhistjp0_.ISS_IIC_CDE=:1 and authhistjp0_.REQ_TMS>=:2 and (authhistjp0_.ISO_ACTN_CDE in (:3 , :4 , :5 )) and authhistjp0_.CNTRY_ISO_NBR=840 and (aut
hhistjp0_.PRIM_ACCT_NBR<>:6 or authhistjp0_.SYS_TR_AUDT_NBR<>:7 or authhistjp0_.REQ_TMS<>:8 or authhistjp0_.CNTRY_ISO_NBR<>840)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center