 | | | Oracle List | | Dear All
I would like to inform everybody on this list with the call for papers for Slovenian Oracle Users Group Conference (SIOUG) in September 23.-26. 2007 (www.sioug.si). About 500 to 700 (or Hi
We have a requirement where we need to find the Orphan session in DB.
Well it happened some time back when one of our job get killed after
reaching its max time but it 's thread processes Bill
are you sure of your test case?
the second query on testx
select * from t1 where not exists (select 'x ' from oracle.t2@(protected) a where
a.c1 t1.c1)
cannot return the result that you mention
1
ashi all
I have been asked by a manager to inquire if there is such a thing as a methodology or some software that automates script deployments (dml/ddl) coming out of PVCS or CVS... as it relates toHi.
We are trying to weigh pros and cons between using Oracle 's ODP.Net
provider and DataDirect 's 100% Managed equivilents. I 've read DD 's
spec sheet and have a pretty good understanding of how t
A late entry to this post but following up Stefan 's comment
about memory and buffering here 's a highlight from SQL*Plus
"Text_content " is a CLOB of about 120 000 bytes. I 've
deleted some of the liHi
HP-UX 11 Oracle 9205
Hi
We are getting these errors for users connecting via shared server
Tue May 22 11 05 42 2007
found dead shared server 'S049 ' pid (60 1)
found dead shared server 'S03Niall
When discussing OU courses IMO experience can be different based on where that course is taken as well. In my career (it 15 years time span) I attended Oracle DBA(performance tuning new fe
Jeremy
As promised by me
at http //hemantoracledba.blogspot.com/2007/05/recovery-in-cold-backup.html
to explain what I had hinted at about doing a RollForward in my
Oracle-L posting
(http //www.On 5/21/07 Shivaswamy Raghunath <shivaswamykr@(protected) > wrote
>
> Hello.
>
> I want to understand the major and minor numbers attached to the device on
> Linux. How can I identify the device type bHi Michael
You could use consumer group switching with DBMS_RESOURCE_MANAGER for this.
Here is an example just that it is for the opposite way switching to a
lower group if a statement runs longerHi Lutz
> Does anyone of you know about a way how to influence the threshold
> for optimizer statistics becoming stale with TABLE MONITORING?
>
> I guess that there is an underscore parameter for thiIs there a way to assign a profile to a user of large batch jobs and
maybe allow that to capture a higher priority to let a certain job or
jobs to "slam through " even if it hurts some other users(a liThere are a couple of job openings in the DC Downtown area. US citizenship
required.
The job titles are ETL tester and Data modler but the skills are much more a
hands-on development DBA.
Just cameDon
You can and should lock all of these accounts.
Secondly if you want to remove these options they should be
de-installed - not simply dropped. A lot of these things have objects
stored under The Shareplex guys from Quest do come on here occasionally.
Just post a question and see if you get any answers. Sorry I do not know
about a specific forum. It would probably be very low traffic anyHas anyone used SRDF without replicating TEMP tablespace? If yes during
failover was there any problem?
As far as I know there should not be any need of temp tablespace to be
replicated as there is
> > How to know whether a table column has been create using BYTE or CHAR
length
> > semantics?
Does this help
SQL > create table norman(a_byte varchar2(100 byte)
2 a_char varchar2(100 char))
No you do not need to upgrade (but you can).
The version of the repository is 10.2.0.2 (or later if you upgrade to
10.2.0.3) but the database hosting the repository is version 10.1.0.4 (or
later).
I have a 3 node 10gR2 RAC environment and am working on creating a
logical standby for use with dataguard.
One thing i 'm not certain of is how I should configure the standby to
connect to the RAWilliam
In brief this is all a part of the FAN framework where a listener
registers with ONS.
You shouldn 't have this problem if you set
SUBSCRIBE_FOR_NODE_DOWN_EVENT_ <listener > to OFF
which sOn 5/18/07 Karla Srini (HAS-SAT) <Srini_Karla@(protected) > wrote
>
> All
>
> Any one has apps financials and projects setup documents. I have
> installed Apps 10.5.10.2 from media every thinSorry
just read this
[...]
} double-dash is just a kind of terminator that says "don 't check for any more options after -p. Is that correct?
[...]
Yes )
Dimitre
<!DOCTYPE HTML PUBLIC "-//W3CIs this what you 're looking for?
Note 216205.1 - Database Initialization Parameters and Configuration for
Oracle Applications 11i
Bob Stauffer
DBA
D&E Communications
Ephrata PA USA
71
I know I 'm coming into this one rather late
but do you have table compression enabled
for the table suffering the problem ?
Regards
Jonathan Lewis
http //jonathanlewis.wordpress.com
Author Cos*From * oracle-l-bounce@(protected) <//oracle-l-bounce@(protected)/ >[mailto
oracle-l-bounce@(protected) <//oracle-l-bounce@(protected)/ >] *On Behalf
Of *rjamya
**
>
> Now now ... don 't be a s
Pull your Backup and Recovery manual.
Look at performing recovery using a backup control file.
-- Mark D Powell --
Phone (313) 592-5148
-----Original Message-----
From oracle-l-bounce@(protected)Hi all
I would like to know your backup policies concerning Archived redo logs
such as how long do you keep them on tape etc.
Thanks
Rich
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TransPaul
You said it best! Easier is not better.
The cardinal rule of database security
Only grant those privs exactly needed by the application. "Public "
should only be used by Oracle productshi all
I 'm trying to create a basic prototype for a problem updating a large target table based on another large source table and upon completion to update a flag on the source table that the ini |
|
|
