what is the cpu utilization on your box?
Waleed
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 4/17/02 12:43 AM
Qs Why is elapsed Time so HIGH in the following SELECT ?
NOTE -
1) TBA_GENERAL_ACCT_MAST_TBL is a SYNONYM for GENERAL_ACCT_MAST_TABLE
Table
2) The
We R running some querry against partitioned tables and we get the above
oracle error.
Metalink says something like:
Bug:785518
The hint given in there does not seem to get us off the hook!
Any idea welcome.
'll post the querry excerpt on request.
Thanking you,
---
CSW
--
Please see the
Dear DBAs,
Yes I am referring to the iSQL*Plus tool available in Oracle9i. This is
also a topic of OCP 9i Exam-1. Would you please suggest some links where I
can get material in detail.
Thanks
mks
Hi Unal,
Here is a part of SQLNET.LOG file.
Thank You
Best Regards
Kamel Benlatreche
-
***
Fatal NI connect error 12560,
I wonder how many people have rushed out to do this on their production
instances now? ;P
-Original Message-
McDonald
Sent: 16 April 2002 23:23
To: Multiple recipients of list ORACLE-L
The problem can be worked around by issuing:
grant dba, select any table, select any dictionary to
Oracle Database is Portable means that it can be ported to any OS
platform. Take a full Export of the database and then use the imp utility of
Oracle to build the exact database what was there on the previous one.
If you want to import certain objects then you need to create the tablespace
Anybody know the answer to this question? This is on HP-UX.
I am managing a database that has symbolic links for data files. On this instance, I
am using STATSPACK to track performance. I need to tie IO rates back to real mount
points so that I can work on balancing IO.
How do I tie the
Rao,
This following is the one I am seeing on my m/c
ORACLE BBED1 !df -g .
/db01 (/dev/vx/dsk/root2dg/db01): 8192 block size
1024 frag size
12582912 total blocks8284512 free blocks 7766758 available
1089844 total files
1035561 free files 53554381 filesys id
No, it is of the most gentle substrate of the shaft of moon light.
[EMAIL PROTECTED] wrote:
I believe its C++ now but it was C.
-Original Message-
Xing
Sent: Tuesday, April 16, 2002 11:48 PM
To: Multiple recipients of list ORACLE-L
Hi all,
Just for my own info,
Is Oracle
There is a world of difference between'em.
We use both here, Oracle for our large, active customers, and MySQL for our
smaller customers, to avoid as much as possible having to pay Oracle's
ridiculous licensing fees. Our smaller customers don't need Oracle's
scalability and reliability, and
David,
Yes and No in the same breath just like apples and oranges are both fruits.
Yes they are both databases and yes they both talk SQL, but that's about where
the similarities end. And before I go any further, let me say I like both of
them, for particular purposes. MySQL is nicer to
Check google. Anyway they are completely different. MySQL is more like
Access than Oracle.
On Wed, 17 Apr 2002, Nguyen, David M wrote:
What is different between MySQL and Oracle database? Someone says they are
the same as they are just database. From DBA or developer point of view,
what do
And all this time I had thought it was made from widgets and gizmos. ;o)
-Original Message-
Sent: Wednesday, April 17, 2002 11:03 AM
To: Multiple recipients of list ORACLE-L
Nope just C
Anjo.
Kimberly Smith wrote:
I believe its C++ now but it was C.
-Original Message-
Well, MySQL and Oracle are very different, but there's a world of difference
between MySQL and Access too. It's quite possible to use MySQL as a backend
database for web hosting and get good performance and decent reliability. I
haven't heard of Access being used for that sort of thing.
--Walt
On Wed 17. April 2002 18:28, you wrote:
[EMAIL PROTECTED] wrote:
What is different between MySQL and Oracle database? Someone says they
are the same as they are just database. From DBA or developer point of
view, what do you say?
Thanks,
David
OK, so is everybody out to start
To simplify my question, if I am creating a STATE table to hold all the
states of the US, should I create it like this...
Name Null?Type
-
STATE_CODE
Nope - there's a lot of PL/SQL and Java as well, but I know that is neither
what you meant nor what the original question was about
Rgds, Bjørn.
On Wednesday 17 April 2002 18:03, Anjo Kolk wrote:
Nope just C
Anjo.
Kimberly Smith wrote:
I believe its C++ now but it was C.
Alex,
Just wondering why do you think MySQL is closer to
Access than to Oracle. I have played with MySQL a
little and it is a relational database like Oracle
(not sure if access is one), uses a SQL, can have
logging and archiving just like Oracle. Again I'm not
sure whether access have all
On the same server running 8.1.6.1.5 and 8.1.7.3.2.
Now ready to upgrade the 8.1.6 database to 8.1.7.
Our 8.1.7 is 8.1.7.3.2, in the 8.1.7.3.0 readme it stated: Database
Migration When migrating a database from an earlier release, for instance
8.0 to 8.1, you must complete the database
Lisa,
What version you are talking about? I am using locally managed tablesspace
with uniform extents for temporary tablespace with tempfile for last one
year with oracle version 8.1.6.2 on HP-UX 11 for datawarehouse database
without any issue/problem. Now we have migrated it to 8.1.7.2 and
just to one
-Please suggest if changed will be on both database what option would be
good?
--Please suggest if changed will be on one database what option would be
good?
Thx
-Seema
From: Joe Raube [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL
Madhu,
Oracle has a fixed (at compile time) (OS) physical blocksize to work with.
That blocksize is basically the minimum blocksize the control file and the
redo log file get accessed in. So by doing 'dbfsize controlfile' you can see
what the physical blocksize is. Or check from x$kccle. Now
Title: RE: Upgrade 8.0.5 to 8.1.7.3
Matt:
I
don't have the bug#s. When I opened a TAR on this (now unpublished) the support
person called me and told me that I had to downgrade the database to workaround
the bug. (All the TAR saysis thatthey called me.)The analyst
said thatbug is one that
Obviously, the reality is that it is made of Powerpoint slides
On Wednesday 17 April 2002 19:28, Farnsworth, Dave wrote:
And all this time I had thought it was made from widgets and gizmos. ;o)
-Original Message-
Sent: Wednesday, April 17, 2002 11:03 AM
To: Multiple recipients
There is hardly any difference, except the waste of space for the state_id.
But purists will tell you, that you should not put business information into
primary key columns, and therefore state_code should not be a primary key.
And if a state is gets a new code, it is much easier to change
My fellow Databasers,
I just found out my employer has an unlimited license for DB2/UDB. I am
kind of excited at the prospect of learning a new dbms that isn't SQL
Server.
I am also feeling the need to expand my skills. Glancing at the job market
under just Oracle isn't promising right
H
from a pure relational standpoint (something like 4th or 5th normal form),
keys shouldn't have any inherent meaning so you should go with STATE_ID as
the PK.
From a real-world perspective, I would use STATE_CD as the PK. Its not going
to change very often (how often do state
Chris,
I would prefer the first method. As far as I am concerned, the only reason
to use a sequence number as a primary key is if the value for the natural
primary could could possibly change.
In this case, the two char state codes have been around for a very long time
and would probably not
Hi Rafiq,
Sorry. I'm 8.1.7.3 on W2K. It's very possible that things have changed
drastically since last year when I created this database.
If I remember right there was an issue with export. I may be off my rocker,
because nothing is exported out of a temporary tablespace.
LK
On Wed, 2002-04-17 at 10:18, Grabowy, Chris wrote:
To simplify my question, if I am creating a STATE table to hold all the
states of the US, should I create it like this...
Chris,
We use a state_id field which is a number.Usually you want to use
numbers or integers as primary keys, but since
Older link but still some food for thought -
http://openacs.org/philosophy/why-not-mysql.html
Brian P. MacLean
Oracle DBA, OCP8i
Weaver, Walt
From clowns to a database monkey...
Lisa! you got dissed!
-Original Message-
Sent: Wednesday, April 17, 2002 1:34 PM
To: Multiple recipients of list ORACLE-L
-They don't believe in spending a lot of money on IT because
-it hasn't paid off for them in the past and they've had
Well Chris, as you are probably aware, there is a theoretical train of
thought that says that every table should have a primary key that is an
arbitrary ID, not related to the data in any way shape or form. The benefit
is that data that is SUPPOSSED to be unique (like ssn's) can break and your
Several people have replied back to me about the design rule to not use
business data in the primary key, which I agree with. Although I don't plan
on creating a permanent STATE_SEQ sequence, since it will only be used once
to populate the table.
Any other thoughts or arguments?? TIA!!
The previous DBA, also used the export/import method, and is the method
I am most likely going to use.
Create the new ORACLE_HOME (8.1.7)
Patch to rev desired (8.1.7.2 or 8.1.7.3)
Export from 8.0.5
Import to 8.1.7.x
Upgrade application.
Test like crazy.
Darren
-Original Message-
Sent:
All,
Does anyone have any specific metrics demonstrating that a PK that is based
on a number field is faster than a PK based on a character field?
I've seen it mentioned a couple of times today under the Design Question
topic.
It doesn't make any sense to me that one or the other would be
DB2 usually means RPG which IMHO totally sucks. What OS is this for?? DB2 pretty
much runs on its own. You might get to learn all about an AS400. I agree with you
that you will be more marketable knowing more than one database. There are all types
of apps made for DB2. I don't do the
That's Monkey Mama to you!!
-Original Message-
From: Mercadante, Thomas F [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 2:21 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: MySQL vs. Oracle database
From clowns to a database monkey...
Lisa! you
Lisa,
Thanks. I saw couple of messages today about problems with 8.1.7.3 on
Solaris. We are also thinking to move to 8.1.7.3 on HP-UX 11 in near future
but now we have to wait and see for a while.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL
One thing to consider is country codes. I have seen many applications
where two character country codes have been crammed into the STATE_CDS
table. Usually the two character state abbreviation is the primary key,
but that means that some smaller countries end up with abbreviations that
have no
I don't think you're wrong. MySQL gets dissed frequently on this list, but
it's really a nice little product. IMHO it's much closer to Oracle than
Access.
It works well for us. Doesn't scale like Oracle, but works well.
--Walt Weaver
Bozeman, Montana
-Original Message-
Sent:
I did not say MySQL was like Access. I said it is
more like Access than it is like Oracle.
On Wed, 17 Apr 2002, Gurelei wrote:
Alex,
Just wondering why do you think MySQL is closer to
Access than to Oracle. I have played with MySQL a
little and it is a relational database like Oracle
Sounds like a documentation bug in the readme. I have always patched
the software to the highest available patchset plus one-off patches,
then switched the instance to the new ORACLE_HOME and ran the upgrade
scripts.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Wed, 17 Apr 2002,
-- Weaver, Walt [EMAIL PROTECTED]
I don't think you're wrong. MySQL gets dissed frequently on this list, but
it's really a nice little product. IMHO it's much closer to Oracle than
Access.
It works well for us. Doesn't scale like Oracle, but works well.
In some ways it scales better than
On Wed, 17 Apr 2002, Browett, Darren wrote:
The previous DBA, also used the export/import method, and is the method
I am most likely going to use.
Can someone explain why anyone would opt for export/import as a path
to do an 8.0 to 8.1 upgrade? Doesn't the basic upgrade just consist
of
We have a country_code table to represent countries, but the first version
of the app is supposed to be the U.S. only version. Obviously, any
flexibility that we can design in right now can only help in the next phase.
It's the client's left hand that keeps saying this will only be used in the
Gene,
Nope, dead on!
Dick Goulet
Reply Separator
Author: Gurelei [EMAIL PROTECTED]
Date: 4/17/2002 9:49 AM
Alex,
Just wondering why do you think MySQL is closer to
Access than to Oracle. I have played with MySQL a
little and it is a
Add in some wishful thinking and dreams of HUGE profits and you've got it.
Dick Goulet
Reply Separator
Author: =?iso-8859-1?q?Bj=F8rn=20Engsig?= [EMAIL PROTECTED]
Date: 4/17/2002 9:28 AM
Nope - there's a lot of PL/SQL and Java as well, but I know
Fear.
I agree with you. Migrate is the preferred method in my tool-box.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, April 17, 2002 3:32 PM
To: Multiple recipients of list ORACLE-L
On Wed, 17 Apr 2002, Browett, Darren wrote:
The previous DBA,
I have ran this on a test database
bbuxdv01:/db02/oradata/tstd1 dbfsize tstd1_1.ctl
Database file: tstd1_1.ctl
Database file type: file system
Database file size: 232 8192 byte blocks
bbuxdv01:/db02/oradata/tstd1 dbfsize tstd1_0101.rlg
Database file: tstd1_0101.rlg
Database file type: file
Clean up fragmentation/chaining, change block size at the same time, in my
current
case, chage hardware platform...
All sorts of reasons. :)
-Original Message-
Sent: Wednesday, April 17, 2002 3:32 PM
To: Multiple recipients of list ORACLE-L
On Wed, 17 Apr 2002, Browett, Darren wrote:
Rafiq,
I upgraded an HP-UX 11.0 64-bit machine in early April. (8.1.6.3.0 to
8.1.7.3.0) It was the worst upgrade I've ever gone through, but everthing
appears to be running normally. (I'm not using locally managed tablespaces
yet though.) I was missing a couple of operating system patches and
FYI for anyone running Oracle 8.1.7.1, HPUX 11. Seems we are getting some
new ORA_600's at a remote site:
ORA-00600: internal error code, arguments: [kolseget623], [kolseget: index
= max index ptr per page], [101192], [], [], [], [], []
ORA-00600: internal error code, arguments: [kolseget623],
I also remember (hopefully correctly) reading somewhere, either in metalink
or from
this list that there is a low-level corruption problem in
8.0.x that may causes problems when migrating to 8.1.x, by
doing the imp/exp method, you don't have to fix the 8.0.x database
before you upgrade.
There
512 bytes
Reddy, Madhusudana wrote:
I have ran this on a test database
bbuxdv01:/db02/oradata/tstd1 dbfsize tstd1_1.ctl
Database file: tstd1_1.ctl
Database file type: file system
Database file size: 232 8192 byte blocks
bbuxdv01:/db02/oradata/tstd1 dbfsize tstd1_0101.rlg
Database
My TEMP tablespace is a locally managed temporary tablespace using a tempfile (not
datafile). See results below;
SQL alter tablespace TEMP begin backup;
alter tablespace TEMP begin backup
*
ERROR at line 1:
ORA-03217: invalid option for alter of TEMPORARY TABLESPACE
which makes perfect sense,
Julie,
We are also going through same exercise now a days as we are moving to new
HP hardware with HP-UX 11 64 bits with Hitachi Storage. These machines do
not run on 32 bit Unix. However we are still using 32 bit Oracle and Oracle
Financials 10.7 char software.
In our situation we have to
Does anyone have the scripts (or URL) for identifying objects having
freelists contention?
Thanks.
Anand Prakash
I am currently building a new 8i database, and have the oppurtunity to
consolidate
some of my datafiles. In the current configuration I have 4 500Mb datafiles
that make up
a tablespace.
Is it okay to create a 2Gb datafile, or am I better off to create 2 1Gb
datafile's, or
stay with 4 500Mb
You better check metalink for this one.
Cleanly removing java from a database is a rather involved
job. I've done it once, don't care to do it again.
Sorry, no pointers. It was a trial and error process with me.
There are several metalink references to it.
Jared
[EMAIL PROTECTED]
Sent
On Wed, 17 Apr 2002, John Weatherman wrote:
Clean up fragmentation/chaining, change block size at the same time,
in my current case, chage hardware platform...
All sorts of reasons. :)
What do those things have to do with an upgrade?
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
I have downloaded a trail version of Quest's Data Factory, and started
playing around with it. So I am wondering if other people have used this
product and their impressions.
TIA!!!
Chris
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Grabowy, Chris
INET:
Chris,
I'm rather anal about using generated keys, and *I* wouldn't
even use them here. ;)
Lookup tables with information that is likely to remain static
and have an obvious key should be fine without a generated
key. ( States are a good candidate )
Jared
Grabowy, Chris [EMAIL
I have upgraded 8.1.6 to 8.1.7.2(32-bit) on HP-UX 11.0 64-bit machine and
use LMT on all my databases. They run fine and one of the database has been
running over 1 year now.
-Original Message-
Sent: Wednesday, April 17, 2002 12:59 PM
To: Multiple recipients of list ORACLE-L
Hi
WHat is best practices for PCTFREE,PCTUSED AND PCT_INCREASE value at object
level?
Thx
-seema
_
Chat with friends online, try MSN Messenger: http://messenger.msn.com
--
Please see the official ORACLE-L FAQ:
From a performance benchmark prespective take a look at this:
http://www.eweek.com/article/0,3658,s=708a=23115,00.asp
Well, MySQL and Oracle are very different, but there's a world of
difference
between MySQL and Access too. It's quite possible to use MySQL as a backend
database for web
Tom,
Well you got me sort of. I ran a few quick tests on a table with 500K
rows. The return times were almost always identical. The main difference
between a Pk with a number and a char/varchar is storage. a 40 digit
number takes 4bytes of space. A 40 character string takes 10 bytes.
This
I am not clear on what will make a fast refresh materialized view too
complex. What functions cannot be used in a FRMV that is a single table
aggregation? The following example won't work if I try to add the decode:
create materialized view log on emp
tablespace tbsname
with sequence, primary
An upgrade can be seen as a rare chance to do all these things, if you
choose exp/imp method. That's what John is referring to.
LK
-Original Message-
From: Jeremiah Wilton [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 5:12 PM
To: Multiple recipients of list ORACLE-L
Because it has executed nearly 7000 times at 0.145 seconds per execution.
I would wonder why a query was executed 7000 that didn't return a result
set.
Jared
VIVEK_SHARMA [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
04/16/02 09:43 PM
Please respond to ORACLE-L
To:
How does one destroy cookies created by an Oracle applications server without exiting
the browser? It's been a while since I tried, but several months ago, I found I could
destroy cookies that I had created, but not those created at log in. I don't want to
query these cookies just pulverize
Yes, exp/imp cleans up a lot of garbage. I always use this method.
-Original Message-
Sent: Wednesday, April 17, 2002 3:38 PM
To: Multiple recipients of list ORACLE-L
An upgrade can be seen as a rare chance to do all these things, if you
choose exp/imp method. That's what John is
If you use Veritas quick IO, you must use soft links.
Jared
Koivu, Lisa [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
04/17/02 09:43 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Symbolic links
I hope it works for
you.
set Trimspool onset Line 132set Pages
57set Newpage0set FeedBack offset Verify offset Term
offTTitle offBtime offcolumn Pct Format 990.99 Heading "%
Of |Free List Waits"column Instance New_Value
_Instance NoPrintcolumn Today New_Value _Date No
Printselect
The poster implied he was going to change the
temporary tablespace to locally managed.
to some of the other org's, so maybe staying
with
dictionary-managed would
be
best, except for the temporary tablespace.
Darren.
All of my production databases are still
Do you have mainframe programs that will be brought over to use this
mainframe data? If so, they will likely have problems with nulls. If there
will only be new programs accessing this data, then it sounds fine.
Will there by any statistical work on these columns? Averages, for example,
will
When you backup, temporary tablespace does not need to be backed up and it
is not a required tablespace for creating/bringing up database. My hot
backup does not include temporary tablespace and I was many times able to
restore/recovery the database without any problem.
-Original
Darren, discuss this with your SA. There may be a limit on the os side you
need to be aware of.
Also, consider MTTR. Seems to me that MTTR won't be that different between
a 500MB file and a 2GB file.
Beyond that, it's your comfort level. Personally I like having larger files
for ease of
Hi Marc,
No and no, as far as I know. I should double check on the user
requirements, you are right. (It would be helpful if THEY knew)
Thanks, you bring up a good point.
LK
-Original Message-
From: Marc Perkowitz [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 8:04
Hi Barbara,
I have just completed an upgrade of our production dbs from 8.0.5 to
8.1.7.3. Due to problems with our application, I actually had to migrate
from 8.0.5 to 8.0.6 first. Then as in your case, Oracle said they didn't
support migrating to 8.1.7.3 directly. So I migrated to 8.1.7.0.0
Darren,
Some operating systems have file limit sizes of around 2GB so you should
check if that applies to your system.
Regards,
Sujatha
-Original Message-
Sent: Thursday, 18 April 2002 7:48 AM
To: Multiple recipients of list ORACLE-L
I am currently building a new 8i database, and
I was talking w/someone today, and we realized that neither
of us knows of anyone actually using RAC in production. So
now I'm curious. Is anyone?
Jonathan Gennick --- Brighten the corner where you are
mailto:[EMAIL PROTECTED]
http://Gennick.com * http://MichiganWaterfalls.com *
Apparently folks are bored today.
-Original Message-
Engsig
Sent: Wednesday, April 17, 2002 11:04 AM
To: Multiple recipients of list ORACLE-L
Obviously, the reality is that it is made of Powerpoint slides
On Wednesday 17 April 2002 19:28, Farnsworth, Dave wrote:
And all this time
How many extents for the table?
- Original Message -
From:
Richard Eastham
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, April 16, 2002 11:58
PM
Subject: HIGH CPU WITH MULTIPLE
CONCURRENT USERS (long)
A co-worker is having a fairly serious
Never mind. I just saw that oracle was able to
reproduce it internally.
- Original Message -
From:
Richard Eastham
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, April 16, 2002 11:58
PM
Subject: HIGH CPU WITH MULTIPLE
CONCURRENT USERS (long)
I
think you are running into the stampeding herd phenomenon. I'm
suspicousof the low value for the spin count. It seems timid.
Could you truss one of the shadow processes with the timing option and post the
output? Just enough to identify the repeating pattern. Also, please
run the trussin
Can you post what requiremment is driving this? I.E. Is it to be able to query for a
mixed-case input value? Maybe to sort mixed case as if it were all upper or lower?
Tony Aponte
-Original Message-
Sent: Tuesday, April 16, 2002 12:34 PM
To: Multiple recipients of list ORACLE-L
Steve Adams' site is a good
start. http://www.ixora.com.au/
Tony Aponte
-Original Message-From: Anand Prakash
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, April 17,
2002 5:29 PMTo: Multiple recipients of list
ORACLE-LSubject: Script for identifying objects having freelists
Dear Guru:
I have a number of staff needs to upgrade their skills from Oracle 7.3.4 to
Oracle 8.1.7. Going to Oracle Education Center will be too expensive given
that I am looking at 7 person. Anyone have experience with electronic
training using the Oracle CD-ROM training package, NETg
Hi,
I tried to create a public synonym for a table in schema inventory, but it
does not seem to be working, i.e., when I connect as another user, and try
to select from the synonym it says table or view does not exist.
I would appreciate any help.
Aleem
Following are the commands from
I don't think so,
I think they just don't know
Aleem
-Original Message-
Sent: Thursday, April 18, 2002 7:53 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: What is Oracle made from ?
Apparently folks are bored today.
-Original Message-
Engsig
Sent:
91 matches
Mail list logo