Something like this would work.
SELECT GREATEST(FIRST_DATE,
NVL(SEC_DATE,THIRD_DATE),NVL(THIRD_DATE,SEC_DATE))
FROM your_table;
Just an idea, you can explore it further..
-Original Message-
Sent: Monday, May 20, 2002 3:48 PM
To: Multiple recipients of list ORACLE-L
Hello all,
This
Thanks,
We tried this syntax in our test environment and it worked very well but of
course had no way of knowing if it solved our problem since that didn't show
up in the test environment even in normal circumstances.
Have you actually had experience using this when Microsoft Transaction
Server
Thanks for all the replies. I was hoping to find a simple user-written
script that didn't require signing up for a fee-based service, though.
I guess there aren't any available.
--- K Gopalakrishnan [EMAIL PROTECTED] wrote:
Hi:
Check 'itprof' at http://www.ubtools.com
or
'Sparky' at
Thanks for the info. I have not but I will. Have you tried it?
Michele
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet
No, but I recommend you take a look at the book Oracle Backup Recovery
101 by Kenny Smith and Stephan Haisley (Oracle Press). About half the book
is devoted to RMAN. It has lots of hands-on exercises, and I have performed
most of them. DUPLICATE (Chapter 15) is on my to-do list.
Dennis Williams
good, now we don't have to worry quite so much about that the poo
thing.
On 18 May 2002 at 2:05, Oracle RDBMS Community Forum wrote:
Date sent: Sat, 18 May 2002 02:05:17 -0800
To: Multiple recipients of list ORACLE-L ORACLE-
[EMAIL PROTECTED]
Send reply to:
Yes, if it's different jobs.
If the same job was scheduled to run at 2:15 , 2:30 , 3:00, then oracle
will run only one job.
Igor Neyman
-Original Message-
Sent: Monday, May 20, 2002 3:48 PM
To: Multiple recipients of list ORACLE-L
What if I have jobs scheduled at 2:15 , 2:30 , 3:00 .
Sorry, I've never used MS-MTS...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, May 20, 2002 3:48 PM
Thanks,
We tried this syntax in our test environment and it worked very well but
of
course had no way of knowing if it solved our
Hello List,
I got the following error today(Oracle 8.1.7.0 Sun Solaris)
ORA-04031: unable to allocate 4200 bytes of shared memory (shared
pool,unknown object,sga heap,state objects)
At the moment my shared_pool size is 30M
Thanks for your help
Hamid Alavi
Office 818 737-0526
Cell818
Umm.. couple of things to verify...
First, yes, it is me again!
Second, the U-Turn was done on a yellow light (at least that
is what I see that
night!)
Third, that is just a LA street, not a highway! :P
Forth, this is not wild... just LA type of driving!
Hey Welcome back Winnie!
John
Title: RE: SHARED POOL SIZE
sorry
I goofed...I meant.. yes, it could be changed.
-Original Message-From: Adams, Matthew (GEA, MABG,
088130) [mailto:[EMAIL PROTECTED]]Sent: Monday, May 20, 2002
3:35 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: SHARED POOL SIZE
Ok i'm messing with dimensions.
dm_time to be exact:
create table dm_time
( calendar_date date not null,
calendar_month number(2) not null,
calendar_qtr number(1) not null,
calendar_year number(4) not null);
insert into dm_time values(to_date('20020101','MMDD'), 1,1,2002);
insert
I ran the query over again and here are the results.
It appears the anti join solution is the one.
suit yourself. I like Jareds / Larrys solution
note : Not Exists produced the same result as Not In
as the index remained suppressed !
Original Query
Execution Plan
Hi, guys.
I need to find current value of ORACLE_HOME on the client from VB program,
running on that client. I understand that it is in the registry somewhere. I
have 2 client installations - one is 8.1.7 and another is 9 on the same
client. Apparently EM from 9 installation knows that needed
Hi Greg,
Maybe not one, but what about two? At the same time v$system_event is
checked a couple of times, so you can see a time slice,
v$sysstat can be
checked, focusing on CPU used by this session, parse time cpu
and recursive
cpu usage. One view gives wait time, one gives CPU time.
check all the parameters that make up
your SGA not just the shared_pool,
eg. block size, block_buffers ,etc.
If you need more O/S allocated memory
, which is what it appears to be,
talk to the SA and then will adjust
otherwise you are going to have to reduce
some things.
Peace !
Mike
calendar_date calendar_month calendar_qtrcalendar_year
200201011 1 2002
200301011 1 2003
Mh...
The calendar_date(or changed to calendar_day) should be just the day of the
month since you already have
Ron,
We currently use 8.1.7.1.4 on NT and have been considering testing an upgrade to
8.1.7.4
However, to my knowledge, 8174 isn't yet out for Windows.
I can find it on Metalink for Solaris (ID:1697372 Patchset::2376472) but have not
found it for Windows.
Do you know where 8.1.7.4 for Windows
Joe,
Add a generated PK to the time dimension. The PK is stored
as an FK in the fact table.
That way you can select from the time dimension by year, day, qtr,
whatever,
and easily pick out the correct fact table rows.
The Data Warehouse Lifecycle Toolkit includes a spreadsheet to generate
looks like published aug of 98 for that book?, like $60?
joe
[EMAIL PROTECTED] wrote:
Joe,
Add a generated PK to the time dimension. The PK is stored
as an FK in the fact table.
That way you can select from the time dimension by year, day, qtr,
whatever,
and easily pick out the correct
There is not a single segment of memory large enough for you to grab. The
way I see it, you have two options, increase your shared pool or flush your
shared pool.
Regards,
Melanie Burns
-Original Message-
Sent: Monday, May 20, 2002 5:38 PM
To: Multiple recipients of list ORACLE-L
If an expert is done with consistent = 'N' it still must preserve some information.
In the beginning export runs some selects against the data dictionary and needs that
data to be consistent throughout the export. If that data changes then it needs to be
reconstructed from the undo
I am running 8.1.6 on a Win2000 SP2 machine.
When I try running 'statscre.sql' as SYS, the first script completes fine,
but when the second script tries to connect perfstat/perfstat , I get the
error, You are no longer connected to Oracle TNS:ORA-12154. Of course the
system then proceeds to
Download the YAPP paper ;-)
Anjo.
John Kanagaraj wrote:
Greg,
Can I assume a i/o bottleneck from the following
select * from v$system_event
order by TIME_WAITED;
No. Wait events may only make up a small amount of
processing that Oracle
is doing for you.
Hmm I
In short:
Oracle is either using CPU or is waiting on a resource.
If oracle is waiting on a resource, it could be an Oracle event
(v$system_event/v$session_event), BUT what about waits that are not registered there
. like
waiting for CPU, waiting for a memory page to be paged in ..
So
Have you connected via BEQ or Net8 initially?
Have you got oracle_sid set as an environment variable, as it looks like the connect
perfstat/perfstat uses a BEQ connection.
After connecting as sys, can you now do a connect perfstat/perfstat (though maybe
the scripts cleaned up on error and
You might like to take a look at the following 2 links and work through the
information contained within them.
diagnosing ora-4031_errors on Metalink at
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=146599.1
Also see
On Mon, 20 May 2002, Keith Carney wrote:
Have you ever used before PHP and done anything of this kind of application
that I want to accomplish? I need to dig out everything myself this summer.
If you know someone that has done somthing alike please let me know. Thanks
again.
Keith:
Keith,
Dennis, thanks for your answer
Have you ever used before PHP and done anything of this kind of application
that I want to accomplish? I need to dig out everything myself this summer.
If you know someone that has done somthing alike please let me know. Thanks
again.
Star wars, right?
Can you guess
On Mon, 20 May 2002 [EMAIL PROTECTED] wrote:
as wget no longer works with -http-user and -http-password from this site.
So, you get to do it from a browser. What fun.
Yeah, I just noticed that too. Gotta make sure you're not from Cuba,
Sudan, Iraq, Libya, NKorea, or Syria. Then again,
Thank you, I would contact again for other questions if you don't mind. (One
step at a time, right now I have to learn PHP, right?)
Aida (Keith is my husband)
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, May 20, 2002 1:18 AM
On Sat, 18
Sitescope is monitoring software produced by Freshwater software. It has
many different types of templates for monitors for OS, web servers,
databases, etc.
You're right that I could probably do what I want here with a function and
not a procedure. This is really a prototype for more
101 - 132 of 132 matches
Mail list logo