No, you can put a hint in inner sql and subselects. Some hints you NEED to
put on a subselect to make any sense.
Is that sql verbatim? The hint has a syntax error. There is a dot rather
than a comma after ps which - pooof - may turn the princely hint into an
ugly toad (no pun intended) comment.
I tried relinking all and rebooting server then relink again but no luck.
-Original Message-
Sent: Wednesday, August 06, 2003 10:10 AM
To: Multiple recipients of list ORACLE-L
left over memory segments/shared memory/semaphores?
ipcs is your friend, oh and its destructive brother ipcrm :
hi
can someone give me pointers on pros and cons of implementing rman with netapp filers.
any pointers,white papers,case study,implementation doc will be very helpful.
thanks
sai
Hi Jared
Yes I have read his article and also Dave Ensor's thoughts in it.
I personally am not convinced and am looking for reasons why I should
go with RAC other than fault tolerance given the risk involve in being
one of the 1st few genuine pigs.
I probably say, I would go with single instanc
Title: Message
Hi!
Mladen, does DG really have additional fee when
using EE? I tried to check from oraclestore, but got -> instead:
"The Oracle Store is
temporarily unavailable due to required maintenance. We apologize for the
inconvenience. For
further assistance, please contact an Ora
If you're on Oracle 9i sounds like a perfect example of the use of
hierarchical object types.
Cheers,
John
In message <[EMAIL PROTECTED]>, STEVE OLLIG
<[EMAIL PROTECTED]> writes
how about 2 tables w/ a 1:many relationship? document_types each with many
document_type_attributes. read up on da
You heard him.
Top men.
;)
Verifying backups is something we do in our spare time, one
of those skunk works projects we don't tell our bosses about. ;)
Jared
DENNIS WILLIAMS <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/05/2003 03:29 PM
Please respond to ORACLE-L
To:
The
Citrix ica calls a program called sams.exe and I don't know how it accesses the
db. I haven't tried the console from the remote machine, just the citrix
.ica file.
More
stuff for me to read...
Ken
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On
To overcome this in PL/SQL you can run sql,
which includes “case”, as “dynamic sql”:
EXECUTE IMMEDIATE ‘SELECT …’
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Guang
Mei
Sent: Thursday, A
I should have known to check Steve's site first (is he still lurking around
here?).
One thing I noticed is that one of the cursors listed in V$OPEN_CURSOR is an
INSERT into AUD$. This would account for the discrepancy and could match
the description you provided.
So, in summary, the true number
v$open_cursors is all open cursors in the instance
v$sesstat is just open cursors in the session.
what 3rd party product is that? is it cross platform? Ill make sure not to buy it.
really bad code to get too many open cursors.
>
> From: "Jesse, Rich" <[EMAIL PROTECTED]>
> Date: 2003/08/07 Thu
It’s because “flush” doesn’t
mean what you probably think. During a delayed block cleanout, Oracle updates a
block’s transaction table (ITL). Any time a block gets modified, there’s
redo.
See Jonathan Lewis’s Practical Oracle8i (pp43–44) for a
description.
Cary Millsap
Hotsos Ent
There was a similar problem under HP-UX systems (I believe it was on version
10.0) in which the file size was limited to 2Gb, then they released a patch so that
files could get bigger than 2 Gb after setting a parameter and recompiling the kernel.
Under version 11.0 this was fixes (yet
Right now I have 37 instances on an hp-ux
server,
a mix of 8.1.7.4 and 9.2.0.3
Matt Adams - GE Appliances - [EMAIL PROTECTED]We are pentium
of Intel. Division is futile.You will be approximated.
-Original
Message-From: Dilip Patel
[mailto:[EMAIL PROTECTED]Sent: Thursday, Aug
Jeff,
Don't mix missions. Consolidating to the same server is one thing.
Consolidating to the same version of software is another thing entirely.
Your boss's goal is to reduce the number of CPUs, not the number of
databases or ORACLE_HOMEs. Get his/her primary mission done first (i.e.
Reduce nu
Title: Message
I'll
add one to the list:
nnn)
How much downtime and DBA time is required when the Shareplex replication queues
get corrupted and you have to rebuild your entire replicated database? (I only
add that as I've got to do it tomorrow morning).
T¬
From: Nick Wagner
[mailto:[
I would consolidate and migrate at the same time. It makes your job a
little more complicated (you will want to test your applications on 9i
before you mograte your production instances at some point), but you will be
solving the migration to 9i sooner rather than later.
Tom Mercadante
Oracle Cer
Thanks everyone : Guang, Rajendra, Funny 2 , Daniel Fink, Deb, Jayadas, Igor, Rick, rgriffy for your prompt help.
Now I have better understanding.
Appreciated.
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
Title: Message
Robert? Dennis? Anyone?
-Original Message-From: Stefick Ronald S Contr
ESC/HRIDD Sent: Thursday, August 07, 2003 9:24 AMTo:
Multiple recipients of list ORACLE-LSubject: RMAN Backup piece being
placed in wrong directory
OS:
Win2K
DB:
8.1.7.4
All,
Here
is wh
Ok, since my original message still hasn't arrived (sent couple hours
ago), here it goes again (sorry, if you get duplicate).
First, sorry for asking this list before searching Metalink, but I don't
have access to it right now.
So, here it is:
I'm getting:
ORA-00600: internal error code, argume
"Learning Perl" from O'Reilly:
http://www.oreilly.com/catalog/lperl3/
US $21.50 from bookpool.com:
http://www.bookpool.com/.x/n6ardwv1ni/sm/0596001320
Got me going enough to start writing an OEM replacement in Perl/Tk. I
didn't say it was *good*...(or finished). :)
Rich
Rich Jesse
Thanks very much Arup for your suggestion.
Actually, Tables and indexes are already exist in the schema. I just have
to copy the data from one environment to other environment. So I thought I
will make the indexes unusable, load the data and rebuild the indexes with
nologging, parallel and comp
22 matches
Mail list logo