Can you please guide me how to do all these steps?
Roland
MacGregor, Ian A. [EMAIL PROTECTED]@fatcity.com den 2002-01-24 08:15 PST
Sänd svar till [EMAIL PROTECTED]
Sänt av: [EMAIL PROTECTED]
Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Kopia:
Whose ODBC DRIVER are you
Greetings All !!!
Could anyone tell me which book is best for the oracle developer which is compatible
with Oracle 8i.
Regards,
Gagandeep
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gagandeep Singh
INET: [EMAIL PROTECTED]
Fat City Network Services--
Hi,
Am I misreading all this, but should the auxiliary database be in existence
before I can Clone to it?
I created the init.ora and all directories and started TEST3 in nomount. I
created the password file and can connect to it with a connect string no
problem.
Another point is. Did you mean
Hi,
I would suggest you should take a look at
Osborne Oracle Press !!! They are very good !!
www.osborne.com
i.e. ISBN.: 0-07-212048-7 Oracle Developer Advanced Forms Reports
very powerful knowledge !!
Frank
Von: Gagandeep Singh [mailto:[EMAIL PROTECTED]]
Greetings All !!!
Could
Having a small problem I need some help with...
The problem is trying to lock a row on a parameter table for an application.
The thing we need to do is following:
Read the value in one row. LOCK that row for other users, increase the value
with one
update the row with the new value and release
Jay,
I'm, not sure I understand what you mean by the instance reference to
the parameter file
do you mean the init.ora file that's used when the database starts up?
You can override that by
startup state pfile=full file specification of the parameter file
--- Jay Wade [EMAIL PROTECTED]
Does anyone know if the book is any good? I'm thinking about getting it,
Thanks,
Jim
-Original Message-
[EMAIL PROTECTED]
Sent: 24 January 2002 23:25
To: Multiple recipients of list ORACLE-L
That could have something to do with the questions not being pointed
enough.
Could be
Hi,
We are evaluating databases to our web site and the candidates are Oracle
and MS. We already have Oracle running on our production environments , but
, mainly a cost-based decision , management don´t want to buy Oracle to the
web site. So , we want to know how big are the MS databases out
Hi All,
I know it has been asked many times but I have changed jobs and no longer
have old e-mail. Anyway I need to know
how to send e-mail using pl/sql with attachments. Any real
examples,links,references would be very helpful.
My environment is Oracle NT 8.1.6 SE, NT 4.0, client is Win 2000
Thank you very much, Henry, I really appreciate the help. I'll post the
results later.
Best,
Sergey
-Original Message-
Sent: Thursday, January 24, 2002 4:25 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Session_wait
Let me try again (using expand -t 3 as
Hi Raj,
Interesting that you first agree with Jeremy and then argue with him. It
is precisely because
export does not generate rollback that the "gymnastics" of taking all of
the other rbs's offline
will not help anything. It might make you feel better, however :-).
John
[EMAIL PROTECTED]
Ooops..
Jared,
You are right.
I didn't notice the order of the dates in 'between' condition.
That's why I prefer to use:
where Time_Stamp ...
and Time_Stamp ...
in this case don't have to bother about the order.
Still, 'group by' attracted my attention, because even with correct
U can e-mail me @ [EMAIL PROTECTED] to remind me:
I have real life examples I can send u: Today is holiday in middle east
where I work: I will be at work tomorrow and I will send them
Sam
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday,
is there only one row in that table? if so, you can lock the table
itself.
try it without the nowait...
--- Stefan Jakobsson [EMAIL PROTECTED] wrote:
Having a small problem I need some help with...
The problem is trying to lock a row on a parameter table for an
application.
The
Title: RE: More Rman q's
Jack,
TEST3 instance should be exactly as you stated, an Oracle instance with no datafiles as yet.
What I think I was meaning regarding the names of the objects is that the format is
Rman catalogue = catalogue
Source database = target
new database = auxilliary.
I have JRE Installed here is what I
get
$: java -versionjava version
"1.3.0_02"Java(TM) 2 Runtime Environment, Standard Edition (build
1.3.0_02)Java HotSpot(TM) Client VM (build 1.3.0_02, mixed
mode)
There fore Java is
installed.
I think this might have
I know that this is not the forum to ask perl questions. But is there some
one who can help me on how to read two lines at a time using
a Perl script
My script looks like this :
open(FILE_IN, $datafile) or die Cannot open $datafile...\n;
while(FILE_IN)
{ chomp;
@fields =
We have a client requirement for several Oracle DBAs in Baton Rouge, Louisana.
*This company will provide relocation assistance, as long as there is a viable
reason besides money for the candidate's desire to move there.
These are full time staff positions so no sub-contractors or third parties
The topic of Oracle on NT vs. Oracle on UNIX has been addressed many
times before, but in my searches I have not found hard statistics to
support either choice. I have been running Oracle on Tru64 UNIX for six
years, and it has been rock solid. I have no experience with NT other than
my desktop
Hi ,
I must have made a really big mess of the catalog or something.
I reinstalled the catalog, recreated TEST2 and ran the clone script again.
Guess what.?
Thx JJ
Jack
[EMAIL PROTECTED]@fatcity.com on 25-01-2002 11:10:19
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL
I know that at one time, Oracle recommended that you do not put files onto an NFS file
system. I think the OS needs to guarantee that the data was actually written to disk,
and when you use NFS the OS thinks the data was written, when in reality it may
still be transferring across the
Hi All,
I have a package pkg1 that has a variable var 1 declared
Inside of pkg2 I want to use pkg1.var1. I always get PLS201 identifier
pkg1.var1 must be declared.
What do I need to do to correct.
Pkg1 compiles fine.
Thanks
Rick
--
Please see the official ORACLE-L FAQ:
In the past, I was running Oracle 8.1.5 and the clients were running
Oracle Forms 4.5. When I queried v$session and looked at the program
field I could see what clients where running f45run32.exe.
Now we are on Oracle 8.1.6 and the clients are running Forms60. When I
now query v$session the
Jack,
The auxiliary database is the clone of the target database (Oracle really should
have called this parameter SOURCE instead of TARGET). It (the auxiliary) is the one
you are creating.
The auxiliary database should be started nomount. The only files needed for the
auxiliary are
There are more rows in that table.
It's one that we use for storing sequential numbers we use... like invoice
numbers, membership numbers etcetc
So we have to lock row when using it, so noone else uses the same number
when we add a new member or
create a new invoice...
But good advice tho, and
Hi All,
I have a mixed environment 8.0.5 8.1.7 databases. I can not use the same
catalog for both versions. I tried creating a new catalog for my 8.0.5
databases (different owner) in the same 8.1.7. database that my other
catalog is in using the rman 805 executable. This also results in
We have both. NT is MUCH easier to manage and set up. But unless you put
some money in the hardware it is not as stable. Our applications have lots
of interfaces to other servers. Lots of scheduled batch jobs. This seems
to cause a lot of processes to get started that never stop. They tie
Three methods: read newline delimeted two at a time, read the whole thing
and process it in pairs of lines or read twice the size of a fixed-length
line from columnar data:
while()
{
my $line = $_ . ;
...
}
or
my @linz = ;
for( my $i = 0 ; $i @linz ; $i += 2 )
{
my @twolinz = (
Jay Hostetter wrote:
I know that at one time, Oracle recommended that you do not put files onto an NFS file
system. I think the OS needs to guarantee that the data was actually written to disk,
and when you use NFS the OS thinks the data was written, when in reality it may
still be
You have to declare this variable in package1 specification
create or replace package pkg1 is
v_var VARCHAR2(10) := 'Blahblah';
end;
/
create or replace package pkg2 is
procedure showvar;
end;
/
create or replace package pkg2 body is
procedure showvar
begin
Getting:
ORA-04031: unable to allocate 4256 bytes of shared memory (shared pool,
unknown object, sga heap, library cache)
and
ORA-00604: error occurred at recursive SQL level 1
over and over in the alert log.
This is a suddenly event on a production database that had been
operational at 8.1.6
Hi,
Try module in v$session (just a guess)
Jack
Joe LaCascio [EMAIL PROTECTED]@fatcity.com on 25-01-2002 15:35:24
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Jack van
Interesting. Are you sure?
I have actually started reading Tom Kyte's book, Expert One-on-One, and he
mentions this problem and the solution(specifically, page 32). Basically,
you code..
SELECT * FROM table WHERE field = something FOR UPDATE NOWAIT;
UPDATE table set field = blah WHERE field
[EMAIL PROTECTED] wrote:
thing, but I also worry about the stability and availability of my database
that I would be presenting to my customers. If anyone has any insights,
statistics, facts or links to documentation presenting such, I'd sure
appreciate the help.
i can only relate my
you need a where clause on that select statement, so that you get the
ONE row in that table that you want.
and remove the nowait. Nowait tells Oracle to continue processing the
next statement even if you didn't get the lock you wanted... Of course
removing it has it's own drawbacks, you could be
Hey, just to confirm what I think is obvious...
For an oracle database to be backed up on NT with Legato: you need to
either;
shutdown, cold backup via legato, startup, or
online backup mode and legato's Oracle database extension,
[or some sort of strategy involving oracle export].
And to
It is my understanding that you can backup all lower versione databases with
the highest version of Oracle you are using. Thus, you can use you 8.1.7
rman and catalog to backup all of you databases.
Ruth
(I have only tried it with different versionof O8, not O8i, but it worked.)
- Original
Title: RE: Hm
I just had another idea. Maybe you can use UPDATE table SET column=column+1 RETURNING column INTO somevariable instead of the SELECT FOR UPDATE. This will add 1 to the current value and return the result to the caller.
Tony Aponte
-Original Message-
From:
Hi,
A user in our data warehousing group is running into
the old ORA-01555 (snapshot too old) error every time
she runs a massive (20 million rows) select against
one table via a view. I confirmed that the view only
translates to the one table.
The user swears that no one would be making any
Title: RE: Hm
What you are observing is the concurrency mechanism as implemented in the Oracle rdbms. I couldn't explain it better in an email so I suggest you get a hold of Expert One-on-one Oracle by Thomas Kyte, chapter 3 on Locking and Concurrency. Another thought I have is that it
I tried a different way once - with the PL/SQL extensions to export
package. It isn't described in the docs, but there is a file (dbmsexp.sql)
in rdbms/admin directory. Basically for each table that needs special
treatment, you insert a row in sys.expact$ and identify the PL/SQL code you
want
Ok, I guess, I owe some explanation here, since I've got a lot of spanking
(replies, some rather sarcastic) regarding this issue.
My original note comes from my real life experience, so I'm still standing
behind it.
Sorry, it'll be kind of long, but if you are really interested...
Couple years
John,
I DISAGREE. The gymnastics of assigning a large rollback segment to an
export could avoid the snapshot too old error.
I agree with Jeremy when he says export does not generate rollback. But I
was trying to impress upon him that still an export could end up with the
snapshot too old
This well known and highly respected client in Boston, Mass. needs an
Oracle DBA to join its' I.T.staff.
A great opportunity for the right candidate with ALL the required skills
listed below.
* Duties and Responsibilities
Work with technical and application analysts to integrate project
RMAN will interface nicely with Legato.
-Joe
--- Jenner Mike [EMAIL PROTECTED] wrote:
Hey, just to confirm what I think is obvious...
For an oracle database to be backed up on NT with Legato: you need
to
either;
shutdown, cold backup via legato, startup, or
online backup mode and
In Tom Kyte's book Expert 1-on-1
he says to ANALYZE the table BEFORE starting a big query.
Read Chapter 5, starting on page 185 for a complete explanation.
Walter K wrote:
Hi,
A user in our data warehousing group is running into
the old ORA-01555 (snapshot too old) error every time
she
Don't believe your users. Somebody is causing
oracle to read blocks in consistent mode, ie. reading them
from rollback segments. If the user is right, then try
locking the participating tables in the exclusive mode and see
who will complain. Alternatively, go to V$ACCESS table, see who is
Yes, this sounds like you need to use a sequence. And you should seriously
consider using a sequence, since you might continue to run into
locking/performance issues trying to use a table.
Chris
-Original Message-
Sent: Friday, January 25, 2002 10:00 AM
To: Multiple recipients of list
DBA's
Does anyone have instructions for re-compiling apache to include
mod_ldap? We need to integrate our existing iplanet ldap into 9iAS for
reports and portal. Metalink states re-compiling apache is not supported
and the only manuals I've found so far only address OID.
TIA
...JIM...
--
I have a batch job that does this consistently. It's the only job in the
database; it sets the transaction to a hugh rollback segment. And it eats
its own tail.
Depending on how the job is written, it may need a read consistent view
itself (as opposed to some other query in the database
You're right - you're picky..
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, January 25, 2002 11:55 AM
To: Multiple recipients of list ORACLE-L
I am picky perhaps, but why is there an apostrophe between its and I.T.
staff?
This is like store fronts
Jack,
Generally, you can backup any database to a higher-level Rman repository by
using the Rman version of the database you are backing up.
So, in your case, use the 8.0.5 version of Rman, connecting to the 8.1.7
repository.
Optionally, you could create an Rman 805 catalog in an additional
I am picky perhaps, but why is there an apostrophe between its and I.T.
staff?
This is like store fronts that don't put apostrophes anywhere.
: )
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
Sent: Friday, January 25, 2002 12:40 PM
To:
Is it a simple select statement, or is it a cursor select in an PL/SQL
block? Does her transaction itself perform any DML on those tables?
Raj
Walter K [EMAIL PROTECTED]@fatcity.com on 01/25/2002 11:15:26 AM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To:
Claim,Jared,Peter,Rajesh:
Thanks for the reply. I just try a different
method.
exp the two tables to a dump, truncate the tables, exp
the rest to another dump. imp the two tables back to
the database, ship the secpdn dump to the customer.
The customer does not like that two tables, because
I'm not sure why you want to do this. Why not have the package that you
call return the value back to the calling package. I would not guarantee
that the value you expect to be stored in the variable would exist when you
think it will be there.
Tom Mercadante
Oracle Certified Professional
So, the client will only relocate people who have already decided to
move to Louisiana?
--- OraStaff [EMAIL PROTECTED] wrote:
We have a client requirement for several Oracle DBAs in Baton Rouge,
Louisana.
*This company will provide relocation assistance, as long as there is
a viable
HI Raj,
I hope you feel better :-).
John
[EMAIL PROTECTED] wrote:
John,
I DISAGREE. The gymnastics of assigning a large rollback segment to an
export could avoid the snapshot too old error.
I agree with Jeremy when he says export does not generate rollback. But I
was trying to impress upon
Precisely the point I was trying to make, when I put the question if it was
a normal select, or if it was within a PL/SQL block? The myth is that
snapshot too old happens only when some other transaction was in the
process of performing an DML on a table, when you did a select on it. It
can
Not only shouldn't there be an apostophe, but it's in the wrong place.
Geeze. ;-)
--- Boivin, Patrice J [EMAIL PROTECTED] wrote:
I am picky perhaps, but why is there an apostrophe between its and
I.T.
staff?
This is like store fronts that don't put apostrophes anywhere.
: )
Hi Igor...
I have a couple questions to you... What do you think will happen the
first time you have ANY problem recovering a backup that was taken with the
COPY utility and you contact Oracle support... Will Oracle support you or
immediately blame it on you backup method since it is
Eventually...
real: 0
SQL select
2 name, value
3 from
4 v$sesstat vs, v$statname sn
5 where
6 vs.statistic#=sn.statistic# and
7 value is NOT NULL and
8 value0 and
9 sid=11;
NAME VALUE
Sure, but the original post concerns a *query*, not a transaction, and
before running the query, the user locked the queried table in
exclusive mode, to ensure that no other session could write to the
queried table. How do we account for the query's need to read from
rollback?
--- Baker,
Igor,
That sounds good, but what is Oracle Support going to say when you call them
for support on a database recovery and you mention that you used NT COPY??
Your hosed, if there attitude is you should have used OCOPY so we can't help
you.
Chris
-Original Message-
Sent: Friday, January
Here's some places to start:
http://httpd.apache.org/docs/sitemap.html
http://www.kie.berkeley.edu/people/jmorrow/mod_ldap/
Jared
James Howerton [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/25/02 08:55 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
Guys, in the next round, please correct Mr. Wilton's first name to -
Jeremiah.
Cut paste is a wonderful thing ;-)
- Kirti
-Original Message-
Sent: Friday, January 25, 2002 10:35 AM
To: Multiple recipients of list ORACLE-L
John,
I DISAGREE. The gymnastics of assigning a large
Becauses, he needs ... HELP ;-)
-Original Message-
Sent: Friday, January 25, 2002 10:55 AM
To: Multiple recipients of list ORACLE-L
I am picky perhaps, but why is there an apostrophe between its and I.T.
staff?
This is like store fronts that don't put apostrophes anywhere.
: )
This is a busy little beaver...how long you say this runs?
opened cursors cumulative 1072
session logical reads 77233609
db block gets 2642119
What platform?
On HP-UX 11.0 and Oracle 8.1.6.2.0 and w/ Clients on Win/NT 4 Workstations,
here is what I get: (last few lines)
SQL select username, program from v$session;
USERNAMEPROGRAM
--- ---
X468Y02 C:\orant\bin\ifrun60.exe
X0C0AJF
Hallo,
How can I select the name of the procedure, which is running.?
I mean I am running a procedure and I want the name of the pocedure to be inserted in
a table.
Please help me with a simple pl/sql script on this.
Thanks in advance
Roland S
--
Please see the official ORACLE-L FAQ:
I already did that, about a year ago.
btw, there is a (very low-traffic) oracle-nt list:
http://groups.yahoo.com
-
http://groups.yahoo.com/group/oracle-on-nt
a collection links to this kind of stuff could be put
there?
regards,
ep
ORACLE-L Digest -- Volume 2002, Number 025
Sorry Jeremiah!
John
[EMAIL PROTECTED] wrote:
Guys, in the next round, please correct Mr. Wilton's first name to -
Jeremiah.
Cut paste is a wonderful thing ;-)
- Kirti
-Original Message-
Sent: Friday, January 25, 2002 10:35 AM
To: Multiple recipients of list ORACLE-L
John,
Hallo all you gurus,
How can I write in the pl/sql code if I want to insert in a table the number of rows
that are inserted in the select statement in the procedure?
Give me a good example, please.
Thanks in advance
Roland S
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
Hi, Ross,
This has been running for about 4 hours now. I got an SQL trace file, and
looked at the execution plans. So here's the deal. There's an interesting
join condition ...where A.col1=B.col1.. However, A has a few hundred
distinct values in that column, none of them being NULL, and B,
I have experienced problems in the past when using NFS drives to dump
large amounts of data. No sure if having the redo logs there will cause the
same problem.
I am running a tru64 4.0f environment, and what I was doing ( needed the
disk
space at the time) was export my production databases to
Jeremiah, it is.
Thanks, Kirit ;-)
Raj
Deshpande, Kirti [EMAIL PROTECTED]@fatcity.com on 01/25/2002
12:55:27 PM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Guys, in the next round, please correct
There have been turf wars between central
(mainframe/unix oriented) and departmental (NT
oriented) SysAdmns here for 5+ years (administration
promulgated a decentralization policy, and changed
IT funding to support it).
Now, some of the departmental SysAdmns are finally
getting sick of
I was almost ready to subscribe to the idea of delayed cleanout, but I
cannot understand why really. The necessity for reading a block from the
rollback segments comes from encountering during the course of the
SELECT a block the SCN of which is higher than the SCN when the query
started. I have
Use SQL%ROWCOUNT.
BEGIN
insert into table1
select * from table2;
dbms_output.put_line(SQL%ROWCOUNT);
END;
/
Executing this PL/SQL block should display you the number of rows that were
inserted into table1.
Raj
[EMAIL PROTECTED]@fatcity.com on 01/25/2002 01:20:40 PM
Please
Dick:
This makes the assumption that Walter can get to the code, find out what
it's doing, and make modifications. (In our case, we can't. The code is
vendor-supplied, unchangeable, and is written in Cobol).
It also sounds like this might be happening in the middle of the night.
I'd
RTFM on SQL%ROWCOUNT and %ROWCOUNT
Jared
Sorry, all exampled out today.
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/25/02 10:20 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Number_of_rows
Delayed block cleanouts can still cause the ORA-1555, even
after locking the table in exlusive mode.
That's the purpose of the analyze, to force the block cleanouts.
Jared
Paul Baumgartel [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/25/02 09:30 AM
Please respond to ORACLE-L
Yes, and if one buys enterprise version with a special
support plan, there is an option for an onsite
proctologist.
ORACLE-L Digest -- Volume 2002, Number 025
--
From: Loughmiller, Greg [EMAIL PROTECTED]
Date: Thu, 24 Jan 2002 14:55:44 -0500
Subject: RE:
Yes But I want thatthat number is inserted into the table.
[EMAIL PROTECTED]@fatcity.com den 2002-01-25 10:39 PST
Sänd svar till [EMAIL PROTECTED]
Sänt av: [EMAIL PROTECTED]
Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Kopia:
Use SQL%ROWCOUNT.
BEGIN
insert
Hi DBAs,
One of the co-workers has a hot standby database. Logs are applied at some
interval. He has to add
a tablespace. What is necessay to make standby database aware of this?
Thanks
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL
So, there I am. 8.1.7.2 with JVM loaded in Oracle. I need to be able to
access the Unix shell from within a procedure, so naturally, I plagiarize
and modify a very simple Java class from somewhere in Metalink:
--- Java code start
import java.lang.Runtime;
import java.lang.Process;
import
Jared, would you elaborate more on this? Does this
need to be a 'compute' or can it be an 'estimate' on
the analyze?
I read the info on Steve's site as suggested by Barb
and it sounds like block cleanout may be the issue but
I'm still trying to digest the concept/issue as it
relates to my
Well, I know what you mean.
But, I'll take my chances, because as I said before, MetaLink Note:139327.1
didn't convince me at all that OCOPY is any better than regular NT Copy
command.
Besides, I am keeping two generations of backup (the latest and the one
prior to that), so if anything goes
How about doing a set transaction to a large rollback before running this query if the
analyze doesn't resolve the problem.
Kathy
-Original Message-
Sent: Friday, January 25, 2002 10:40 AM
To: Multiple recipients of list ORACLE-L
Dick:
This makes the assumption that Walter can
(fwding in case TBC's cc: doesn't make it to the list.)
--- Forwarded message follows ---
Date sent: Fri, 25 Jan 2002 11:12:11 -0800 (PST)
025
To: [EMAIL PROTECTED]
Copies to: [EMAIL PROTECTED]
I gave the right advice for the wrong reasons.
Igor,
I think your missing the point... You state...
But, I'll take my chances, because as I said before, MetaLink Note:139327.1
didn't convince me at all that OCOPY is any better than regular NT Copy
command.
But, I assume that the opposite is also true? NT Copy isn't any better
then OCOPY?
On Fri, 25 Jan 2002, Kathy Duret wrote:
How about doing a set transaction to a large rollback before running
this query if the analyze doesn't resolve the problem.
That will have no effect.
http://www.speakeasy.org/~jwilton/oracle/snapshot-too-old.html
--
Jeremiah Wilton
Another fact, that should be mentioned, is that the
table in question was built (loaded) two days ago. The
nightly ETL processes for the warehouse are pretty
substantial and the likelyhood of a block not getting
cleaned/flushed out for a couple days should be nil.
To summarize:
1. Tuesday
I use this techinique when I build PL/SQL applications that span packages.
I almost always create a global package with nothing but the specification
filled with variables. Usually these variables are established upon entry
to the app, and are applicable for the length of the run. As for
I was going to write this myself, but this explanation fron
MetaLink Note 45895.1 means I can just cut and paste, and
Rachel won't get after me for typos. :)
Jared
Delayed block cleanout on old committed updates. An update operation
completes and commits; the updated blocks are not
Strange, I'd expect, that dropping 12 partitions should speed up the query.
Still partitioning helps only if column, used for partitioning, is specified
as one your search criteria, or if you do full table scan in parallel, or in
maintenance when you can quickly drop a partition instead of
Thomas:
Here is the person to credit:
Igor Neyman [EMAIL PROTECTED]
btw, any advice on libertarians to support in the
election for california governor?
thanks,
ep
On 25 Jan 2002 at 11:12, Thomas B. Cox
[EMAIL PROTECTED] wrote:
Date sent: Fri, 25 Jan 2002 11:12:11 -0800
Sergey,
Have you considered adding an index to that queried column in table B?
Many third-party vendors allow the DBA to add indexes even when they
won't allow them to alter the code.
Something to consider.
Cherie Machler
Oracle DBA
Gelco Information Network
On Fri, 25 Jan 2002, [EMAIL PROTECTED] wrote:
One of the co-workers has a hot standby database. Logs are applied
at some interval. He has to add a tablespace. What is necessay to
make standby database aware of this?
This is clearly documented in the Oracle8i Standby Database Concepts
and
Ditto.
Tim,
I think we should save all these emails, so when Igor posts a message asking
for help on recovering a database that won't recover for some reason then...
Sorry, Igor I couldn't resist.
Chris
-Original Message-
Sent: Friday, January 25, 2002 2:39 PM
To: Multiple recipients
1 - 100 of 133 matches
Mail list logo
