Hi,
I have a materialized view in oracle which is a complex view of 4
tables which
belongs to different schemas..
create materialized view materialized_su m
refresh complete
start with sysdate
next sysdate+1/24
as
select ano,sno,count(i d) assigned,
count(decode(ss tno,70,1))compl etes,count(deco de(sstno,75,1)) ftq,
(count(start_da te)-count(complete_ date))breakoffs
from
tab1,tab2,tab3, tab4
where tab1.id=tab2.id and
tab4.pkey=tab3. pkey
and tab2.fkey=tab3. pkey
group by ano,sno;
Now the problem is the refresh interval...Is there any way I can
specify a fixed refresh interval...What happens is after the first
refresh let us say at 10.00.00 am ..next refresh should be at 11.00
am..instead of that, the interval slips by 30-60 seconds..so the next
refresh would be at 11.00.30 am..
I have a dependent job which runs after the view is refreshed....
Any help is greatly appreciated..
Thanks
Arpit 2 12331
AJ wrote: Hi,
I have a materialized view in oracle which is a complex view of 4 tables which belongs to different schemas..
create materialized view materialized_su m refresh complete start with sysdate next sysdate+1/24 as select ano,sno,count(i d) assigned, count(decode(ss tno,70,1))compl etes,count(deco de(sstno,75,1)) ftq, (count(start_da te)-count(complete_ date))breakoffs from tab1,tab2,tab3, tab4 where tab1.id=tab2.id and tab4.pkey=tab3. pkey and tab2.fkey=tab3. pkey group by ano,sno;
Now the problem is the refresh interval...Is there any way I can specify a fixed refresh interval...What happens is after the first refresh let us say at 10.00.00 am ..next refresh should be at 11.00 am..instead of that, the interval slips by 30-60 seconds..so the next refresh would be at 11.00.30 am..
I have a dependent job which runs after the view is refreshed....
Any help is greatly appreciated..
Thanks Arpit
....and you reschedule it every hour... The point is,
jobs get reschedyled AFTER they complete; looks asif
your job runs for about 30 secs.
You better reschedule using trunc(sysdate) plus a fixed
interval - you may round down to an hour, a minute, whatever.
--
Regards,
Frank van Bortel aj*****@hotmail .com (AJ) wrote in message news:<60******* *************** ****@posting.go ogle.com>...
It looks like the next interval is being calculated after the refresh
(perhaps for transactional reasons.)
Just a guess, but how about trying this ....
create materialized view materialized_su m
refresh complete
start with sysdate
next to_date(to_char (sysdate, 'YYYYMMDDHH24') , 'YYYYMMDDHH24') +1/24 Hi,
I have a materialized view in oracle which is a complex view of 4 tables which belongs to different schemas..
create materialized view materialized_su m refresh complete start with sysdate next sysdate+1/24 as select ano,sno,count(i d) assigned, count(decode(ss tno,70,1))compl etes,count(deco de(sstno,75,1)) ftq, (count(start_da te)-count(complete_ date))breakoffs from tab1,tab2,tab3, tab4 where tab1.id=tab2.id and tab4.pkey=tab3. pkey and tab2.fkey=tab3. pkey group by ano,sno;
Now the problem is the refresh interval...Is there any way I can specify a fixed refresh interval...What happens is after the first refresh let us say at 10.00.00 am ..next refresh should be at 11.00 am..instead of that, the interval slips by 30-60 seconds..so the next refresh would be at 11.00.30 am..
I have a dependent job which runs after the view is refreshed....
Any help is greatly appreciated..
Thanks Arpit This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Bernard André |
last post by:
Hi All,
I am getting crazy....
This code work fine in step by step but at execution time, it looks like a
delay to refresh the A2K table from VB is resulting in some records being
treated more than once.
What is wrong ?
How can I "flush" data in the A2K tables?
Thanks for helping,
|
by: Conax |
last post by:
Hi,
It's me again asking about IFRAME.
With UncleWobby, Steven Burn and Roland Hall's help, I was able to create a
proper IFRAME section on my page.
Now I come to the next problem.
I'd like to be able to:
|
by: M. Mehta |
last post by:
It seems that you can not create a materialized view if you are using
outer joins...can someone please verify this?
Thanks
M. Mehta
Please follow my example below:
created 2 tables:
|
by: Willem |
last post by:
Can someone tell me how I can get a page(any page) on the Internet to
refresh automatically every 5 minutes. I was thinking along the lines of
having a HTML file on my C-drive with JavaScript to do so. It should be
possible, Right?
I don't know much about JavaScript.
Thanks for the help.
|
by: dan baker |
last post by:
I have a page that gets loaded with a meta-refresh hardcoded so that a
few things on the page get updated. its kind of a fake chat board.
anyway, what I need to do is turn off the meta-refresh once someone
clicks in a <textarea> to enter their input; otherwise the refresh
catches them in the middle and messes up the focus.
I need a way to turn off the meta-refresh, or to force the
cursor/focus to stay in the message input box once they...
| |
by: martin1 |
last post by:
All,
is there window form refresh property? I try to set up window form refresh
per minute. Thanks
|
by: marik |
last post by:
Hi, people.
I have a question:
Can somebody link me to a simple javascript piece of code, that allows
me to get input from a combo box and set the refresh interval of the
page to be that number?
Thank you,
marik
|
by: AJ |
last post by:
Hi,
I have a materialized view in oracle which is a complex view of 4
tables which
belongs to different schemas..
create materialized view materialized_sum
refresh complete
start with sysdate
next sysdate+1/24
|
by: sainiamit25 |
last post by:
Hi,
I want to create a materlised view log in my database A and materlised view in some other database B. I was successful in creating materlised view in database B (after creating a dblink with A, as create materlised view statment should refer to some table and i used create materlised view on xyz@dblink) BUT when i chekced closely i found that dblink was able to access all the tables in database A. As a start, i revoked all rights from...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |