Jump to content

Larry Siemer

Member Since 07 Apr 2000
Offline Last Active Sep 16 2016 08:39 PM

Posts I've Made

In Topic: SQL in PROIV SL

30 September 2004 - 12:14 PM

besides EXIST, any other command can be used at that particular point?

The following can also be used in place of EXIST:


In Topic: SQL in PROIV SL

29 September 2004 - 11:11 AM

:D by the way, what happend if my nested IF block returns no data?

Then nothing 'EXISTS'.

In Topic: Waitng for database - file - full function

26 July 2004 - 01:01 PM


I followed this up and I found some of my old reference materials that say "the database can freeze [...] whenever LGWR is forced to wait for an inactive redo log group to become available for reuse".

I also found some recommendations I once collated for 24x7 Oracle systems that strongly suggest such systems should have "extra" monitoring in place to detect failures in the redo log archiving process - precisely because of its impact on database availability.

Is there any way you can find out if the automated redo log archiving had likely failed when you had your problem? Maybe from timestamps on the archived copies at the archive destination?

Incidentally, for very-high-throughput systems, archiving via a network or comms link can be an issue because the database may be able to create online logs (at local-disk bandwidth) faster than they can be archived. That's very unlikely to be the case with 'normal' applications though.

Also, FWIW, I never used to set production systems up with less than five online log groups.

Regs, Richard


When all of the redo log groups are currently being archived, you should see a message similar to the following in the alert log:

Thread 1 cannot allocate new log, sequence 23611

Once the archiving process is done with one of the log groups the database should resume normal operations.


In Topic: copy and paste

21 April 2004 - 01:43 PM

You can press the Windows Print Screen key to copy a bitmap of the screen to the Windows Clipboard and from there paste it to any windows application that accepts bitmaps. We typically use this in along with a Print Screen utility to only capture the current applicaiton. Print Screen utility

In Topic: Report functions in Proiv 5

25 June 2003 - 04:50 PM

Try changing: