Search results for query: *

papadba i have until april 1st to have the course paperwork all signed off by the trainer and into the grant people!! not much time! i dont intend to work in the next 9 months to be honest- just travel- then i have a years visa in canada for 2012... alvechurchdata - thanks for that input- i am...

Hi I have a grant to do a training course after being made redundant - but I can't decide what the hell is the wisest thing to do!! I have some database oracle admin experience (setting up database, importing, cronjobs), some business objects experience (admin, security, report writing) and a...

Thanks Dagon...thought that might be the case alright! I'll have to go with a nightly dump of data in my database from live it seems!

hi I have a problem with my materialized view on my replicated database- its taking about 20 hours to update every day! I've noticed it does a COMPLETE refresh every day and want it to do a fast refresh but I need to implement a log for this I've read....the DBAs for the live master database...

ahh I didn't realise it would be anything to do with extra licensing costs- that will be a definite no then as I've been asking for a new server to host the db for 2 years with no hope of getting one! When you mean a redesign of the database- what roughly do you mean please?

No the table isn't partitioned- but should be!!The problem is I don't know how to do it and neither does our DBA (long story dont ask!! - small company not willing to spend money - my database not a priority etc!) Is partitioning something I could read up on and do myself or is it a very...

Hi i need to count the number of people who are logged in over and including 3 minutes eg user a logs in at 9:00 and logs out at 9:05 user b logs in at 9:00 and logs out at 9:01 user c user a logs in at 9:00 and logs out at 9:03 from example above that would be users a and c! the row data...

Well THANK YOU! I added an index to b.usagetimestamp , b.channelid, b.externalno and also just seached addate alone for the date parts (as LKBrwnDBA suggested) - and it takes 30 seconds!! I only wish now I had done it incrementally and worked out which made it work best- I'm guessing the index...

My brain wasn't all there yesterday- there is a second (function based) index on the massive table B TO_DATE(TO_CHAR("ADDATE",'dd/mm/yyyy')||' '||"ADTIME",'dd/mm/yyyy hh24:mi:ss')-.006944444444444444444444444444444444444444,TO_DATE(TO_CHAR("ADDATE",'dd/mm/yyyy')||' '||"ADTIME",'dd/mm/yyyy...

Sorry Mufasa- I was a big vague!!! Thanks for helping me out! Execution Plan: Plan SELECT STATEMENT ALL_ROWSCost : 20,080 Bytes : 59,400 Cardinality : 495 11 FILTER 10 HASH JOIN Cost : 20,080 Bytes : 59,400 Cardinality : 495 8 HASH JOIN Cost : 19,513 Bytes : 55,278...

Hi all This query takes WAY too long to run (over an hour) - can anyone think of any other way to write it please?!! SELECT to_Date((to_char(A.ADDATE,'dd/mm/yyyy')||' '||A.ADTIME),'dd/mm/yyyy hh24:mi:ss'), B.ACCOUNTID, A.CAMPAIGN, ( C.TITLE ), A.WEEK, C.TITLE, D.TITLE FROM A, B, C, D, E WHERE...

LKBrwnDBA - that didnt work :( BJCooperIT - thanks for taking the time to reformat my query in a more user friendly way! However as you have written it, they are the correct links and pst.hjid does link to both ppd.transactions_transactions_id and ptl.parent_transactions_id - and should also...

Hi I have this following SQL statement where tables can join in various ways but I cannot get the data to return when I add in the last join The sql is as follows SELECT PURCH_ORDER.ACCOUNTID, PURCH_ORDER.ORDERDATEELEMENT, PURCH_ORDER.TOTALRATEDAMOUNT,PURCH_SUBSCRIPTION.FREQUENCY...

Hi Chris It doesnt go in a specific order of start stop start stop - there could be 2 start watchings on 2 TVs (this is the idea of sessionid but it isn't a field to rely on unfortunately) I am counting customer's not TVs I will work on getting some test data up here to show different...

Hi taupirho I hate to ask you this but my brain is just not working anymore today and I think I've looking at this query too long and can't see the wood for the trees anymore! Could you give me a helping hand and help me with the code I need to log to generate a secondary table which contains...

Hi Sem I need data for all minutes but could live without empty minutes(ie 0 viewers for a certain minute) A single account could have multiple sessions open at one time- I can't use sessionid to link with in the join You can pretty much ignore sessions for this query. I've being playing...

I've been working hard on all your suggestions and have come up with this so far- its reduced the runtime to 8 mins but this is still too long! Any other ways to make it run faster?! sem- I don't understand what you mean about the minute thing - and I'm not familiar with jobs but can they...

What do you mean by SQL joins? and I would still have to use one loop to increase the time period by a minute? Thanks for an alternative tho :)

Hi I'm trying to count the number of people watching TV at a specific minute in time (well I need to do it for every minute in an entire month!) My data shows when people started and stopped watching TV- so I need to check for every person when they started watching it and whether they shud be...

Hello! I've been working on making my query work with lag and lead and I've finally gotton it! (sorry had to finish work in a hurry on Friday so just getting stuck into it today!) Now my next problem is the outer join I mentioned earlier! I also need to bring back the rows where a localcallid...