 | | | Oracle List | | I copied and pasted it from the source site into a ms-windows sqlplus
executed it and came up with
DECLARE
begin_time TIMESTAMP 3D
TO_TIMESTAMP( '18-Sep-2002 07 35 00PM ' 'dd-Mon-yyyy perldoc DBD Oracle
Search for ora_module_name
Hi
There are nearly 15 databases(Oracle 9.2.0.1 to 9.2.0.6) on different machines but with the same SID say mysid. I have installed 10G Grid Control on one machine say host1. Also I have installed 1If I set the blackout in AI and then shutdown AI will AI knows how long it
was shutdown? example I set blackout for 5 hours then shutdown AI for 4
hours. When I start AI 4 hours later will the bI think the idea is to skip unusable indexes do the load then rebuild
the indexes w/ NOLOGGING. If you rebuild the index before the load the
index maintenance will cause significant logging. ItI am trying to understand why I get this error when using direct path
sqlldr.
There are no constraints on the table just this index which is one field in
the table.
Why do I get this error?.
9.2.0.4 on HP-UX has some compiler related issues and Oracle suggested to
upgrade to 9.2.0.5 (9.2.0.6 wasn 't released that time). We were getting
ORA-7445 due to shared_pool memory allocation issue.John
Direct load takes a TM enqueue on the table in e 'X 'clusive mode. This
effectively blocks all other DML (and DDL for that matter) against this
table. Non-direct DML takes a TM enqueue in 'S
in 10g Oracle data files are made "platform aware " -- that is the file headers store detailed platform information. the new v$transportable_platform view will show you the full list of supported
I personal don 't have first hand experience wih this but...
a while back on another list there was a long thread on the very
subject.
Seems it all has mostly to do with "Little Endian " vs. "BSorry for the previous mail the database version is 9205 not 9204.
Previous mail as below.
Hi all
My test env is oracle9204 on Solaris 8 for sparc.
I unplugged standby network and checkeHi all
My test env is oracle9204 on Solaris 8 for sparc.
I unplugged standby network and checked primary 's alertlog I found even
I set MAX_FAILURE 3D2 REOPEN 3D10 primary still keep checkinThey posted the quarterly patches check out the alerts page at
http //www.oracle.com/technology/deploy/security/alerts.htm
Patrice.
-----Original Message-----
From Pete Finnigan [mailto orahi all
we find a very interesting thing
we copy the WINDOWS2000 datafile to linux (they have the same byte order)
and dd a linux datafile header to cover the windows datafihi all
we find a very interesting thing
we copy the WINDOWS2000 datafile to linux (they have the same byte order)
and dd a linux datafile header to cover the windows datafiHi all
Example of insert string
Insert into saud_log (sysdate() 'some text ')
Commit
I now want to retrieve the text in date/time order.
Since multiple insert can occur from the same paHi Rac gurus
When i run srvctl status nodeapps on a 10g rac
I am getting
PRKO-2016 Error in checking condition of listener on
node linuxtest1
the listener name actually is listener_orcl but
Note 293737.1
Subject Oracle Critical Patch Update January 2005 Pre-Installation Note
for Oracle Database Server
Hi Cary Any upcoming events in NewYork City?
Raja.
-----Original Message-----
From Cary Millsap [mailto cary.millsap@(protected)]
Sent Thursday January 20 2005 4 34 PM
To oracle-l@(protected)Hi
Given your server I assume that your IO is fast enough for these parallel
loads as well?
If you have logging on and lousy IO for redologs then this might be a
reason why parallel jobs geHi All
I need some clues from all on this list.
Our office plan to make capacity planner for our database server. Oracle 8i on AIX.
What 's powerfull tool that we can use? And please give me a littleThe takeover was recursive and now PeopleSoft owns Oracle. They are in
the process of a major application change from Oracle FinApps to the
whole PeopleSoft suite. Needless to say there are Hello everyone
I have a table where I have a date column with historic information in
the same table if date '31-dec-2999 ' then is actual record if the
date is different of 31-dec-2999 the isWe are using oracle 9.2.0.5 on HP 11.11. The v$sgastat monitoring shows that
the 'shared pool miscellaneous ' is keep growing and ORA-4031 occurs in few
days. The session_cached_cursors value is 12In addition to Hotsos classes depending on budget and timing look at
the Hotsos Symposium coming up in March. Excellent event!
-Mark
On Wed 2005-01-19 at 11 02 rachel carmichael wrote
>Isn 't it "maxuprc " on HP-UX that determines max number of processes
per unix user?
> On HP-UX there is a kernel parameter called NPROC. Like
> PROCESSES and SESSIONS it should have a reasonable
First of all test is the truth!
Second maybe you can use 'maxvalue ' to contain other records.
On Wed 19 Jan 2005 13 31 57 -0000
"John Dunn " <jdunn@(protected) > wrote
> I have a table which hYou received this from your SA Clause? Santa Claus?????
-----Original Message-----
From Ruth Gramolini [mailto rgramolini@(protected)]
Sent Tuesday January 18 2005 2 53 PM
To oracle-lIf daily deletes are must I would build a daily partition.
Otherwise I would do it with monthly partition as there is no need to keep
month 5 and 6 in the database.
Yechiel Adar
Mehish ComputeDid your standby use standby redologs? did it run in archivelog mode?
On Tue 18 Jan 2005 10 39 32 -0800 (PST)
steve noyle <stevenoyle1@(protected) > wrote
> hi
> I 've just set up a 9.2.0.4 sta |
|
|
