NJ,
For each SQL statement in each instance, run a trace, then run tkprof
against it with the explain option. When you compare the two, it should
tell you what they are doing differently and what you're biggest time
waster is.
Regards,
David A. Barbour
Oracle DBA, OCP
N J Neog wrote:
Hi
Hi David,
Thanks for your suggestion.
I thought TRACE,TKPROF, EXPAIN PLAN
will be the last thing thing I will do.
Because There may be lot of SQL Statement I have to select from these two
Package for probable degradation. Moreover in both user same two package was
recompiled.
If inefficient
Yes it is,
Managers are told not to hire anyone in that quarter,
they must all make their numbers.
--- Tom Schruefer [EMAIL PROTECTED] a
écrit :
I have heard, but have not been able to confirm that
May is Oracle's
fiscal year-end. Does anyone have any information
regarding this?
I
Well, we run lots (70 odd) of smallish (4-16Gb) databases that usually don't
need a lot of tuning. Hence, if we do have to tune something, its a real
pain because we don't have the experience of doing it every day. So, as far
as I'm concerned, roll on autotuning. There's plenty to keep us
FOR YOUR INFORMATION
ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has
changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails
using the old format will continue to be delivered until 30th June 2001.
Larry, you are quite correct. As the
FOR YOUR INFORMATION
ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has
changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails
using the old format will continue to be delivered until 30th June 2001.
Naba,
Whilst you state that both schemas
Can I use the same column name in the same database and in the same schema? Could this
cause me lots of trouble?
Roland Sköldblom
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
The only thing I could think of would be if the KEEP buffer pool was not
sized correctly. If the pool were too small to hold all pinned objects then
I should think the LRU algorithim would come in to play.
What you have to look at is the size of all objects pinned against the size
of the KEEP
The buffer pools (keep, recycle and default) are for
data blocks (tables, indexes, rollback) not for the
sql code. Pinned packages, procedures, functions are
kept in the shared pool.
Pinning a package will prevent it to be aged out of
the shared pool.
--- Mark Leith [EMAIL PROTECTED] a écrit
Title: monitoring listener.log
hey can u elaborate how do u scan each log file,
and convert it in email msg.
how do u do this..
saurabh sharma
dba
- Original Message -
From:
NGUYEN Philippe (Cetelem)
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, April 25,
FOR YOUR INFORMATION
ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has
changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails
using the old format will continue to be delivered until 30th June 2001.
Roland
It is quite normal to use the
Hi
It was because of a missing / at the end of Oracle Home entry in the
listener.ora file.
Thanks for your replies..
Manivannan.M
___
On Thu, 26 Apr 2001, Martin Kendall wrote:
Have you got a Listener running
Hi Earl,
1) Sun Solaris 2.7
2) 8.1.6.0.0
3) The Standby is required for Reporting use during Normal Business Hours.
So during that time frame day it is setup as READ ONLY. This requires a
TEMPFILE Temporary Tablespace to allow things like Sorting in any queries
as the SYSTEM Tablespace
I am still sorting out that TN visa business - I am not sure but I think one
has to go back to their country of origin at least once a year, to update
the visa. I was told that all I need is US$55 at the border, with a letter
of offer from an American employer.
I have no idea how that would
hi everyone,
can anyone help me in understanding the contents
iof the above file...
i.e. oraCore.log in
orahome\rdbms##\trace\
what does this file contains and when it is
created, which process controls it.
thanks in advance.
saurabh sharma
I'm getting slower loads using parallel than a serial load. I set up
a test case and am pasting it for you to see what I am doing wrong.
I'm on a Sun 220R, 2 CPUs, 2 GB Ram, 50GB Raid 5 with Veritas,
and Oracle 8.1.7 Standard Edition.
Here's my parallel parms
parallel_server FALSE
I liked the O'Reilly book, but don't know if they updated it for 8i - time
to do it soon, if it hasn't been done! 9i is coming this summer...
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services| Services
Yes you can use the same column name in a database and
in a schema. The only thing is that you have to
precede the field with the table name when you're
joining 2 tables containing columns with the same
name.
Let's open a can of worm.
There are 2 stands on this :
1. Something should have the
I got SQL*Loader to run faster in parallel. I was loading a 8 million record
file that was about 800-bytes wide. What I wound up doing was splitting the
file into n separate files.
My control file looked similar to yours, except it didn't have the INFILE
parameter... I called sqlldr with the
Hi,
Typical errors in sql*net traces are like this:
nserror: nsres: id=0, op=67, ns=12571, ns2=12560;
nt[0]=533, nt[1]=57, nt[2]=0
Means:
You get protocol error 57. If you are using TCP/IP, check winsock errors,
if I'm not wrong it should be 20057 or 10057.
This error causes sql*net 533 error.
Hi,
I'm not sure if the name is oraCore.log. But, core log is generated
if an exeception is occured. It includes stack traces, registers etc. You
can understand where error is occured by register values, especially CodeSegment/InstructionPointer
registers.
Saurabh Sharma wrote:
hi
Thanks to all who replied.
An aging out mechanism for pinned packages didn't sound right. But, it seems
like there are exceptions to almost everything, and many times
contradictions, in Oracle docs. Just wanted to make sure I wasn't missing
something obvious, or obscure. The 2 DBA's in the
Hi Tom,
You can have multiple destinations, but each log file is copied to all the
destinations. You can also have multiple ARCn processes, but each log file is
handled by a single ARCn process. So, you cannot do exactly as you wanted.
However, there are two tips on the Ixora web site that be
Yes we did.
It's on windows NT. We have implemented manually managed standby database,
with a db job on the primary database archiving online redo log files every
five minutes to minimize data loss in case of a crash of the primary
database. The standby database server ftps *iwth a windows nt
Any one whom can give me a good advice, on a pl/sql procedure, that delete data from
table a, then runs a query from table b and and that insert this query into table a.
Pleas help me with a good example.
Thanks
Roland Sköldblom
--
Please see the official ORACLE-L FAQ:
Try putting the select in an enclosing block, ie: -
begin
SELECT my_id INTO v_temp
FROM my_tablee
WHERE my_id = v_number;
exception
when NO_DATA_FOUND then
do_something;
end;
use_v_temp;
HTH
David Lord
-Original Message-
Sent: 27 April 2001 15:41
To:
I heard the same from many consultants at the Oracle Application Users Group show in
Atlanta this week. May is the best time to purchase software.
ROR mª¿ªm
[EMAIL PROTECTED] 04/26/01 11:41AM
I have heard, but have not been able to confirm that May is Oracle's
fiscal year-end. Does anyone
Hi List ,
I am in the middle of Major configuration of JFS
filesystem on HP-UX 11.0 . I came across the follwing
info . Could someone validate this please ?
The options you want are mount options available only
with Online JFS (not
a free product, unfortunately.) The options you want
are:
the only concern is column ambiguity.
Precede the field with the table name when you're joining
tables.
Sunil Nookala
Dell Corp
Austin, TX
-Original Message-
Sent: Friday, April 27, 2001 5:00 AM
To: Multiple recipients of list ORACLE-L
Can I use the same column name in the same
Have you connected as internal and issued the start command??
The error says Oracle not available.
ROR mª¿ªm
[EMAIL PROTECTED] 04/26/01 02:16PM
Hi
I have a problem. I've installed Oracle 8.0.5 on HPUX.
I've created the database. But I can't connect thro tns. Its giving me
Oracle not
CREATE MY_TABLE(TEST1 NUMBER,TEST2 VARCHAR2(10));
DELETE FROM MY_TABLE;
INSERT INTO MY_TABLE SELECT VALUE1,STRING2 FROM MY_OTHER_TABLE WHERE VALUE3 = 7;
This insert would insert into MY_TABLE the columns value1 and string2 from the table
my_other_table where the column value3 is equal to 7
Try This. In this example you can handle the exception without exiting from
the procedure. The exception interrupts the process between the inner
begin-end block. The execution is continued after the inner begin-end block.
Procedure Something as
Begin
.
.
.
.
Begin
Title: RE: OT: Reading the Oracle Tea Leaves
David,
Your work environment sounds interesting. How would you feel about
answering some questions about itlike...how many DBAs and SAs
support the 70-odd databases?how many physical boxes are they
on?...what are som higher tasks, to
Sounds like time to find a new consultant.
Reply Separator
Author: [EMAIL PROTECTED]
Date: 4/26/2001 4:40 PM
Listers,
I was involved in a meeting today, strictly as a listener (no pun intended).
A consultant made the statement that pinned packages
NJ,
From what you've outlined here, everything should be the same except in
creating the new user, did you use import/export on the tables? If you
did, then I'd check to see if row chaining might not be a problem.
Have you tried forcing the application to use rule-based optimizer and
seeing if
At 04:30 PM 4/26/01 -0800, you wrote:
Jared ( I am *not* a hypocrite :)
A Traveling salesman walks into a bar. The bartender looks at him and says
You're in the wrong joke.
Dennis (I am not a Pig's Fundament)
Dennis Taylor
I shall be telling this with a
You do not have to leave the country to get your TN renewed. EDS simply put
the paper work in for me and later I get the new copy. However, you cannot
just show up at a border and get to work in the country. You have to meet
certain minimum requirements and have proof that you do, you have to
I have recently implemented it at Cox, San Diego.
I faced lot of problems in switching between Read Only and sunstained
recovery modes with 8.1.6.
I could not conclude anything about this, may be bug in 8.1.6.
I am observing everyone mentioning about scheduling a job to transfer arch
files
to
You forgot the most likely option (considering politicians) BOTH??
Rodd Holman
Oracle DBA
(605) 988-1373
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
Comments made are my own opinions and views. They do not represent views,
policies, or procedures of LodgeNet Entertainment Corporation
The only duplication of column names that is not allowed in the same column name in
the same table in the same schema. The column name ename can be in any table you
create.
ROR mª¿ªm
[EMAIL PROTECTED] 04/27/01 06:00AM
Can I use the same column name in the same database and in the same
I read the tips. They are helpful. Thank you.
..tom
-Original Message-
From: Steve Adams [SMTP:[EMAIL PROTECTED]]
Sent: Friday, April 27, 2001 8:36 AM
To: [EMAIL PROTECTED]; Multiple recipients of list ORACLE-L
Subject: RE: multiple archive destinations
Hi Tom,
You
Hi,
Please let me know the OTN discount code used for taking OCP.
Thanks
Prakash
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bala, Prakash
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
That auto fail over feature is called Data Guard, and its out now (at least
the docs are). It will work with 8.1.5 or higher on UNIX OS in a non
parallel server environment. Basically as far as I can tell, it runs agents
on both primary and standby servers, and will auto fail over to the standby
Naba,
Performance tuning is an 80/20 ruled operation. Regrettably it sounds like
you went to the 20% payback side first. In all of the years I've been a DBA I
have always gone into the SQL statements before touching the database. In our
case our PeopleSoft payroll application was running
Trace each process with timed statistics = true and run tkprof on the trace files,
then compare.
[EMAIL PROTECTED] 04/27/01 01:25AM
Hi all,
We have got a Payroll Application develeoped in-house.
It takes 30-34 Minutes to Run this Batch Application.
General feeling is - it should be able to
Michael,
Thanks for the great info, it was quite helpful.
I've got my hands full learning NT server admin, upgrading from v7 to
v8i dba, upgrading my Forms5/etc skills to Developer6i and learning
the middle tier apps/web server architecture, so I'm wondering if I
can just use Developer to
Gurus,
In my Oracle 8.1.7 stored procedure, I'm selecting into a variable and need
to check to see if anything was found but I get an exception when there are
no records. I guess I could select count() and check the returned count
number but I thought there might be a better way. Any ideas?
Catherine,
Just a WAG, but could the udump directory be a link to the
nieora/8.1.6/rdbms/log directory?
David A. Barbour
Oracle DBA, OCP
CHAN Chor Ling Catherine (CSC) wrote:
Hi Ed,
SQL select name, value
2 from v$parameter
3 where name like '%user_dump%';
NAME
Hello List,
I'm planning an upgrade of four databases on one server from 7.3.4 to 8.1.7
on Solaris. We are in the initial stages of implementing a Storage Area
Network (SAN) project, initially 10TB on EMC hardware. The database server
will use the SAN for its storage so I will have no decision
Title: RE: Real-life Stand-by DB implementation stories?
How easy or difficult is failing back to your production instance once you have failed over to your standby? It sounds horrific, but I am sure that I don't know the full story.
TIA,
Barb
-Original Message-
From: Szecsy Tamas
Would someone know what the type# values correspond to, in sys.obj$ on
Oracle 8.1.6.?
There are a number of new values in there.
Oracle also tagged a # character at the end of the column name, I guess they
always warned us that these x$ and xxx$ tables are not written in stone.
TIA
Patrice
You can do a simple insert/select statement within
pl/sql
declare
begin
insert into table_a
(select * from table_b);
end;
/
if all the columns are in the same order in both
tables. If not list the columns out.
James
--- [EMAIL PROTECTED] wrote:
Any one whom can give me a good advice, on a
spool
currently spooling to C:\WINDOWS\Desktop\huh.LST
SQL create table test1 (f1 char(1))
2
SQL /
Table created.
SQL ed
Wrote file afiedt.buf
1* create table test2 (f1 char(1))
SQL /
Table created.
SQL ed
Wrote file afiedt.buf
1* insert into test2 values ('2')
SQL /
1 row created.
We have a new database cluster here that we are testing and are getting
ready to move into production. At the same time I am training a new DBA.
The lead Sys. Admin. figures I should have to pay to come to work because I
am enjoying my job to much. Every now and then I will remove a datafile,
Woody,
That would be one way to handle it, but you can also try:
declare
cursor my_cur is
select my_id
from my_tablee
where my_id = v_number;
v_temp mu_cur%rowtype;
begin
open my_cur;
fetch my_cur into v_temp;
if(my_cur%found) then
whatever
My goal is to have Oracle user JOHNQPUBLIC bounce a database from the
local host or remotely. Any UNIX account for that user would NOT be part
of the DBA group.
I performed the following steps:
orapwd file=$ORACLE_HOME/dbs/orapwXXX password=YYY
$ ls -l
-rwSr- 1 oracle dba
Morning all,
I've got a problem with the UTL_FILE package on a 7.3.4 database. The
UTL_FILE_DIR initialization parameter is set to *. I define my
filespecs as follows:
file_one UTL_FILE.FILE_TYPE;
BEGIN
file_one:=
Title: RE: type# values in sys.obj$ on 8.1.6.
-Original Message-
From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]]
Would someone know what the type# values correspond to, in sys.obj$ on
Oracle 8.1.6.?
There are a number of new values in there.
Oracle also tagged a #
Hello:
I'm new to SQL Loader. Is there a way to code incontrol filethatcan separate 'a tab' and 'a blank space' ?
I use "FIELDS TERMINATED BY WHITESPACE", but it will TERMINATE a field when there isa space or a tab. However, the data fields were separated only by the "tab", not 'a space'. Is it
Dear list,
Does anyone have a copy of the performance tuning document, I think it is
called the 10-90 rule document. This document focuses on the main init.ora
parameters (10 of them) that are responsible for about 90% of all of the
improvements that are possible from tuning your init.ora file.
HI all
I am using a 8i database. In our application we are
using a lot of database packages. Some of them are
slow and need to be tuned. How can I easily find out
which ones are slow ? (without using sysdate etc. How
can I TRACE this)
Thanks
Alroy
hm, my kind of senior DBA :)
I will hand off things to my assistant with the words if you have a problem
or a question, ask me.
He's got the DBA Handbook on his desk, and the Oracle docs online. He sits
directly opposite me so I can tell from his face when he really needs help.
He's doing
You have to specify entries-xxx in the orapwsid file where xxx is the
number of users with sys privs you want to be able to log on at once. Your
line for orapwd should be:
orapwd file=$ORACLE_HOME/dbs/orapwXXX password=YYY entries=xxx
HTH,
Ruth
- Original Message -
To: Multiple
Does anyone out there know why I got this error
and how do I fix it?
1 insert into d_rule
2 select
3 4955,
4 x_NAME,
5 x_RULESETID,
6 x_RULESETORDER,
7 x_EXPRESSIONSETID,
8 x_TARGETMAPID
9 from d_rule
10* where x_id = 3
SQL /
insert into
You need to handle the exception, for example
Exception
When no_data_found then
dbms_output.put_line ('no data found');
When utl_file.internal_error then
dbms_output.put_line('internal error');
When utl_file.invalid_filehandle then
Was there a cake and I missed it?
-Original Message-
Sent: Thursday, April 26, 2001 4:46 PM
To: Multiple recipients of list ORACLE-L
On Thursday 26 April 2001 12:37, Jenny Jacobson wrote:
Jared sent out his notice of the new mailing list on May 26, 1998.
And I would still have the
List,
Oracle 8.0.4.3.0
AIX 4.3.3
EMC Symmetrix
SAPR/3 4.0B
200,000+ transactions/day; 300GB database.
Here's what we do:
1. Put all tablespaces in hot backup mode.
2. Split/Sync mirror.
3. Take tablespaces out of hot backup mode (usually after only 3-5
minutes).
4. Take BCV backup of this
Helen,
You can use the optionally parameter to specify multiple enclosed
by/terminated by parameters. NULLIF is also available to assist in
loading blanks.
Regards,
David A. Barbour
Oracle DBA, OCP
Helen Zhung wrote:
Hello:
I'm new to SQL Loader. Is there a way to code in control
Hi Listeners,
I'm looking at several Oracle products and have several issues I'm
trying to resolve:
Oracle 9iAS
- IFS web interface configuration
JDeveloper
- Configuring Application Server for deployment
Oracle Forms Reports
Here are three slightly different versions of what you might be looking for.
CREATE OR REPLACE FUNCTION isnum (thestring IN VARCHAR2)
RETURN BOOLEAN
IS
holder NUMBER;
BEGIN
holder := TO_NUMBER(thestring);
RETURN TRUE;
EXCEPTION
WHEN OTHERS
THEN
RETURN FALSE;
END;
/
That
Steve, thank you very much for your help.
- Original Message -
To: Diego Cutrone [EMAIL PROTECTED]; Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, April 26, 2001 8:32 AM
Hi Diego,
There is a subtle distinction between reason codes 1012 and 1016, but the
a short one
On 27 Apr 2001, at 11:54, Nancy McCormick wrote:
Date sent: Fri, 27 Apr 2001 11:54:35 -0800
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Was there a cake and I missed it?
...
--
Please see the official ORACLE-L FAQ:
Under this situation try to offline temp tablespace and online it
immediately.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Thu, 26 Apr 2001 13:05:26 -0800
I've got a 8.05(2.6 patch on NT) db that the temp tablespace is constantly
Hi gurus,
I developed a web based tool which formats SQL and Event10046 traces.
This tool is superior to tkprof but It works on WEB and formats Binds variables
and Waits for SQLs in trace files. and gives tuning advises and costs of
SQLs. You can compare these costs with other SQLs (unlike in
http://www.odtug.com
On 27 Apr 2001, at 12:25, Charles Yuan wrote:
...
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Eric D. Pierce
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California--
Jared,
This should not offend anyone, but:
CAUTION: Fasten seat belt before reading. I would want you hurting yourself
when you fall out!!
--
Brian is a commercial saturation diver for Global
Divers out of
While we are on the subject, is there a 9iAS listserv?
...JIM...
[EMAIL PROTECTED] 4/27/01 3:25:23 PM
Hi Listeners,
I'm looking at several Oracle products and have several issues I'm
trying to resolve:
Oracle 9iAS
- IFS web interface configuration
JDeveloper
Kimberly, when your guy goes bald, gains 35 lbs. and starts suffering from
heart problems,
you'll know that he has learned the forbidden art of being an Oracle DBA.
When he starts
smoking, he's ready for a promotion. By the way, why do good DBAs live only
around 45 years
on average (some are
Thanks IAN,
It confirmed what I already expected - it's a write error. I can't
figure out why though. This directory is owned by the oracle user. It
creates the file, but the refuses to write to it! I've changed the
specification to 'A and given /oracle and /P01 full permissions.
Touched the
Normally aging does not kick out pinned objects provided shared pool is
rightly sized but there are situations when application because of dropping
some objects makes pinned objects invalid and hence they are reloaded as
kept=YES again.
for example in following list this objects are pinned
Does the temp tablespace has it's autoextend turned off?
[EMAIL PROTECTED] 04/27/01 04:55PM
Under this situation try to offline temp tablespace and online it
immediately.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Thu, 26 Apr
Jim,
Don't know if this applies in your case, but a couple of years ago I had
similar problems with hot backups on AIX. It seems that if the
initialization parameter log_archive_buffers was set to anything higher
than 1, I had the possibility of getting Fuzzy SCNs (they didn't call
it that,
I'd side with Stephan on this. Many folks think it necessary
to preface foreign key columns with the short name of the
parent table.column.
Most of the time this is redundant. There are situations
where it is necessary though:
1. inheriting 2 columns of the same name from different
that would be extremely similar to what is typically experienced at
most of our staff meetings...
On 27 Apr 2001, at 13:25, ([EMAIL PROTECTED] [EMAIL PROTECTED]) scribbled with
alacrity and cogency:
...
--
...
...
Oracle appears to be selective about where it uses this.
From the docs:
CURSOR_SHARING determines what kind of SQL statements can share the same
cursors. EXACT causes only identical SQL statements to share a cursor.
FORCE forces
At 01:25 PM 4/27/2001 -0800, you wrote:
Kimberly, when your guy goes bald, gains 35 lbs. and starts suffering from
heart problems,
you'll know that he has learned the forbidden art of being an Oracle DBA.
When he starts
smoking, he's ready for a promotion. By the way, why do good DBAs live only
At 02:19 PM 4/27/01 -0800, you wrote:
OH NO, i'm dead, well at least i should be :-)...
So is Keith Richards. Hasn't slowed him down.
Dennis Taylor
I shall be telling this with a sigh
Somewhere ages and ages hence:
Two roads diverged and I --
I took the one
Are you out of space or quota? I assume this UFS filesystem. We use AFS here for
quite a bit of stuff. AFS permissions are more granular; a person could have
permissions to create a file but not write to it. The chmod command is still
available, it just doesn't do anything on AFS files.
Title: RE: Urgent - tnsnames problem..
May be
your ORACLE_SID is inlower case(vuntest) and yourSID in the
listener.ora is in upper case (SID = VUNTEST)..
Check'em..
-Original Message-From: Adams, Matthew (GEA, 088130)
[mailto:[EMAIL PROTECTED]]Sent: Thursday, April 26, 2001
I came to know today THE TRUTH. i didnt knew it bfore :-)
Oracle APPS do not use Primary Key and Foreign Key constraints.
They use not null and unique indexes for primary key type columns.
Also they do not keep database triggers.
All the integrity is maintained thru application.
The PK,FK and
Thanks for the input Ian, I figured out the problem which really
involved how I was logging into the database. There was a note on
Metalink where somebody was having the same problem I was experiencing -
the file would be created, but either nothing would be written, or you'd
get a write error.
---
Harley Davidson Barbie #5
http://images.amazon.com/images/P/B56VNP.01.PT02.LZZZ.jpg
From Toysrus.com Amazon.com
Amazon.com
With her long coppery hair and the colorful flames on her sleek
riding outfit, this Harley-Davidson Barbie makes motorcycle
cruising
yes, but the good news is that it is compatible with
forms 1.0!
On 27 Apr 2001, at 16:15, Mandar Ghosalkar wrote
I came to know today THE TRUTH. i didnt knew it bfore :-)
Oracle APPS do not use Primary Key and Foreign Key constraints.
They use not null and unique indexes for primary key
Rafiq,
Thanks for taking the time to address this aspect. Those are the type of
details that help me in some of the areas I am trying to get my arms around
and better understand. I was aware of how the objects could become
invalidated, but, I didn't know it would be re-pinned. It's something I
Hi David,
How do I know whether the udump directory is a link to the
nieora/8.1.6/rdbms/log directory? My OS is Unix I am pretty new to Unix.
Any advice ? TIA
Regds,
Chorling
-Original Message-
From: David A. Barbour [mailto:[EMAIL PROTECTED]]
If you want to tune SQL, get Guy Harrisons book on tuning Oracle SQL.
It is the best document available for that.
Some books I've heard are very good, but can't recomment cuz I haven't
read em yet are Jonathan Lewis book, 'Oracle 24x7', and 'Unix Oracle
Tuning'
Sorry don't have exact names,
What's the load like on this machine when you're loading?
Are other users on the box?
Don't expect to get much help from parallel loads with
only 2 processors. Personally, I wouldn't set parallel_max_servers
above 4 on this box.
Also, is the 50GB all on one mount point? Going through one
You can no doubt do this with Sql*loader.
Personally, I like to clean up the data first instead. I find
it easier to work with that way.
These task are easy on unix, and not too bad on windoze if
you get some decent text tools.
The following line for instance will change all tab characters
Hi all,
We 3 Oracle server as follows.
A. Oracle8 Enterprise Edition 8.0.5
B. Oracle8i Enterprise Edition 8.1.5
C. Oracle8i Enterprise Edition 8.1.6 was
Installed Recently.
All are in Digital Unix
The problem is
Froma Unix user ifmy ORACLE_HOME is
pointing to database A(8.0.5) or
Hi all,
Our trainer needs to build training database/s, she is
asking the following questions:
1. use Sybase or Oracle as the database server?
We have some projects using Sybase databases, and
old training database is on Sybase.
2. build the database on Unix vs NT platform?
3. She
1 - 100 of 102 matches
Mail list logo