Hi
Thanks to all who help me.
We install Oracle 8.1.7 and the query tooks 50 seconds only !!!
(30 min. in 9.2)
I will post more...
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Tim Gorman
Enviado el: miércoles, 22 de enero de 2003 14:39
Para:
Title: Error extensions in the alrtXXX.log
Thanks
for your input.
-Original Message-From: Robert Freeman
[mailto:[EMAIL PROTECTED]]Sent: Friday, January 24, 2003
3:12 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: Error extensions in the alrtXXX.log
Look
in
It was actually released at Oracle World recently, and has a short paragraph
on page 11 of Oracle Magazine.
You can find the release here:
http://www.oracle.com/features/ow02/index.html?_ow_oem.html
And the new product page is already up here, with a few streaming demos:
Has anyone heard of or used a product called TimesTen ? It's a mid-tier
cache tool. Would it be a worthwhile thing to use with Oracle, or does
Oracle already have the same features built in?
Thanks,
Maria
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Maria Quinn
Title: RE: Producing .mdb output from sqlplus or SQL or PL/SQL
Thank
you.
Pat.
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]]Sent: Friday, January 24, 2003
5:34 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: Producing .mdb output from
Title: RE: Producing .mdb output from sqlplus or SQL or PL/SQL
I
would like the ability to create a file which, when double-clicked upon, will
open in Access or Excel automatically.
(I
know that Access can import other formats, I just want it to be automatic for
users who don't know /
Yes, RMAN is included with 9i and YES the OEM console uses rman.
John
[EMAIL PROTECTED] wrote:
It's already done, but error message isn't disappears. More question please,
Does back up via Oracle Management Console is equivalent with RMAN ? Is RMAN
include in Oracle 9i ?
Rgrds,
Sony
Hi List:
I have the below query which is taking 5 min. 20 sec. to fetch the
records. Can you please let me know as to how do I reduce the responste
time?I have created indexes on Fahrzeug.FZGBRIEF and
Historie.mytechobjekt and also the Oid column is uniquely indexed. I
Title: RE: Producing .mdb output from sqlplus or SQL or PL/SQL
Patrice,
You
can certainly spool a file that Excel will open automatically. Simply
create a tab-delimited output file, and make sure the extension is .xls .
Excel will open it and automatically have everything in the correct
Title: Checklist - Ken Janusz??
Lisa:
Here you go. It's located on Thomas Cox's web
site. The latest release is 1.5 generic.
http://www.geocities.com/tbcox23/
Ken Janusz, CPIM
- Original Message -
From:
Koivu, Lisa
To: Multiple recipients of list ORACLE-L
Sent:
Save flat file output with column delimiters \tab as file_name.csv
and Excel will it open by default.
JP
On Monday 27 January 2003 13:28, you wrote:
I would like the ability to create a file which, when double-clicked upon,
will open in Access or Excel automatically.
(I know that Access can
First thought,
Count(*) and FIRST_ROWS are self contradictory. If you want to count all the
records, how will first_rows help?
Regards
Naveen
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Monday, January 27, 2003 6:34 PM
To: Multiple recipients of list ORACLE-L
Hi List:
Access path would be helpfull. Alternatively, you can publish
password for the user SYSTEM, hostname, port and SID so that
we can help you over the internet.
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Monday, January 27, 2003 8:04 AM
To: Multiple recipients of list ORACLE-L
hi all
I just want to know ifOracle 9iAS can connect
to Oracle 7.3.4.
If yes, is it recommended ?
thanks in advance.
Amos K
Patrice,
Use the utility Tom Kyte has on his site called 'owa_sylk'. It will generate
SLK files that Excel opens automatically. We use it for lots of end user
reports.
See the following link:
http://asktom.oracle.com/pls/ask/f?p=4950:8:1962318::NO::F4950_P8_DISPLAYID,
Patch first then upgrade.
Dick Goulet
[EMAIL PROTECTED] wrote on 1/25/03 8:38 pm:
Im doing an upgrade from 8.1.6. to 8.1.7.4. Is there any benfit of doing the
upgrade from 8.1.6 to 8.1.7, using ODMA then patching to 8.1.7.4
or
installing 8.1.7, patch it to 8.1.7.4, then ODMA the database from
This is more of a
survey than a question about problems.
For those of you
using automatic undo management, what have been your experiences, both good and
bad. Are you also using flashback query and what are your
experiences?
Thank you for all
the responses,
Dan
Fink
hi, friends:
I hit some strange performance problem on my 9.2.0.2 on redhat linux.
I want to show developer/manager why delete data for archiving history data is
not a good idear, and I did a test:
There is some big table in our app, and currently we use cron to delete
Ranganath,
Is the OR NOT EXISTS
(SELECT /*+INDEX_FFS(HISTORIE, I_MYTECHOBJEKT) */ ZPAB.FAHRZEUG.OID
FROM ZPAB.FAHRZEUG,ZPAB.HISTORIE
WHERE ZPAB.FAHRZEUG.OID = ZPAB.HISTORIE.MYTECHOBJEKT and
ZPAB.FAHRZEUG.oid=F1.oid)
not just wishing to
As far as having the 32blt client, just create a new home for it. You can use
another SID for the /etc/oratab file so that oraenv/coraenv works as it should.
Now as far as this application owner having to shutdown restart the instance,
well that is just a pile of BULL. I haven't found the
Is F1.AMTLICHESKENNZEICHEN indexed as this seems to be the main filter?
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: 27 January 2003 13:04
To: Multiple recipients of list ORACLE-L
Hi List:
I have the below query which is taking 5 min. 20 sec. to fetch the
first thing to do, try to use count(a_column_name) instead of count(*)
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, January 27, 2003 2:29 PM
First thought,
Count(*) and FIRST_ROWS are self contradictory. If you want to count all
the
we plan to upgrade ORACLE 8.1.7 to 9.2 on SUN Solaris server. I plan to
upgade to 9.2 use oracle account and keep 8.1.7 on ora817 account. I
create user ora817 and assign it to dba group. I also setup ORACLE
environment similiar to oracle account. I tried to startup
sqlplus but failed.
We are using automatic undo management(version
9.2)- no problems so far.
Not using flashback query - so, no opinion on
that.
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From:
Fink, Dan
To: Multiple recipients of list ORACLE-L
Sent: Monday, January
dist cash
Do an ls -l on $ORACLE_HOME/bin/oracle.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, January 27, 2003 9:44 AM
To: Multiple recipients of list ORACLE-L
we plan to upgrade ORACLE 8.1.7 to 9.2 on SUN Solaris server. I plan
It's an in memory database. I have evaluated it a little bit.
Dependes on what you are trying to do, it might be useful in some
situations.
-Original Message-
Sent: Monday, January 27, 2003 5:54 AM
To: Multiple recipients of list ORACLE-L
Has anyone heard of or used a product called
Djordje,
Thanks for the information. I'll have to correct my statements about the
Oracle9i Epoch. If the values you listed below were microsecond times
that used 1/1/70 as the Epoch, then these numbers would represent times
in February 1970:
Your data:
21/01/2003 22:46:50 4655566135078
Getting slightly off-topic now, I never said ls's output wasn't
POSIX-compliant. I stated that the output itself is inconsistent, similar
to the output generated from grep'ing one file versus several files. And
this is highly undesirable in shells that rely on the output of one program
to be the
It works here for both 9iAS R1 R2!
Amos KABORE
it is their.
%ls -l $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 oracle oinstall 34260904 Dec 26 2001
/home/app/ora817/product/8.1.7/bin/oracle
From: DENNIS WILLIAMS [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: [Q]
Title: RE: OEM 4
And there will be one patch to match each of the original Mozart Symphonies too ...
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't
Dan,
We are using AUM on ALL our PROD/DEVL/TEST environments, no problems so
far. Haven't used much of flashback though ... Are you looking for anything
specific? The DB versions are 9012 and 9202 ...
Raj
__
Rajendra
Jamadagni
MIS, ESPN
I've never used it, but Oracle Reports server (part of 9iAS) is supposed to
have caching functionality, where you can defne a completed report to be
cached for a period of time. Such cached reports are identfiied by report
name and parameter values...
- Original Message -
To: Multiple
Repeat the tests, but take a snapshot of v$sesstat
for the session on each test. I would guess that you
will find that there is a more than balancing difference
in the statistic buffer is pinned count which also
records accesses to buffered block, but uses a
different buffer access mechanism.
Looks to me likethat hurts more than it
helps...
SQL declare
2
v_cnt
number; 3 begin
4 for i in 1..1
loop
5
select count(*) into v_cnt from x$dual;
6 end loop;
7 end; 8 /
PL/SQL procedure successfully
completed.
Elapsed: 00:00:02.60SQL SQL
Thanks. I notice you've got the sticky bit set, which is what you want.
However, you mentioned that you were using the dba group, yet I notice
your binary's group is oinstall. You might change that group, bounce your
instance and see if that fixes the problem.
Other than that, I couldn't follow
Aye, it is there, but look at the ownership...
You were able to operate under the oracle account because it owns the
executable, but now under ora817 you are neither owner nor part of the
oinstall group.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
We are using AUM on all databases(9014). Works
great and we manipulate retention time as needed.Had one encounter with
flashback query when got a call in lunch hour that someone updated wrong data in
production. Flashback worked like a charm and data was restored within 15
minutes.
Title: RE: OEM 4
As
long as it's not Bartok.
Pat.
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]]Sent: Monday, January 27, 2003
12:49 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: OEM 4
And there will be one patch to match each of the
Title: Message
In
many cases, if you create a CSV file (comma-delimited) Excel will execute and
read it properly. Excel generally sets itself as the default editor for .csv
files.
I
don't know of any way to do this for Access.
-Original Message-From: Boivin, Patrice
J
Tim,
As you
said, a count(column_name) has to query the table (if there is no index on the
column) to see if the column is populated. only non-null columns are
counted. if an index exists on that column, then all entries of the index
are counted.
a
count (*) will simply count the PK
When you bring up a database, a combination of the
ORACLE_SID and ORACLE_HOME environment variables are
hashed to a key and stored in memory. When you
attempt to connect to the database, this hash key is
verified.
Therefore your current environment for ORACLE_SID and
ORACLE_HOME must match
Title: Message
Nobody
can. As with just about anything, it will depend on what size the app will be,
what the access pattern will be, and how available it has to
be.
-Original Message-From: Amos KABORE
[mailto:[EMAIL PROTECTED]] Sent: Saturday, January 25, 2003 9:04
AMTo:
Ok, thanks for the test. you've right.
- Original Message -
From:
Tim Gorman
To: Multiple recipients of list ORACLE-L
Sent: Monday, January 27, 2003 5:13
PM
Subject: Re: Slow running query
Looks to me likethat hurts more than it
helps...
SQL declare
This guy gets around, doesn't he?
You would think someone would have something
better to do with their time
RF
Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (it's everywhere that I am!)
Author of several books you can find on
Tim - Good catch, and on a Monday yet!
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, January 27, 2003 11:19 AM
To: Multiple recipients of list ORACLE-L
Aye, it is there, but look at the ownership...
You were able to operate under the
Very possible to do. It's a bit involved but it is documented in my
Oracle9i RMAN Backup and Recovery book and it will work for 8i.
RF
Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (it's everywhere that I am!)
Author of several books
.. for Unix Services. :)
http://www.linuxworldexpo.com/linuxworldny03/V33/press.cvn?id=11p_id=12
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
There is no fixed cost for a logical I/O. The cost of a LIO will change
depending on many factors.
Anjo.
On Monday 27 January 2003 06:59, chao_ping wrote:
hi, friends:
I hit some strange performance problem on my 9.2.0.2 on redhat linux.
I want to show developer/manager why
The ora817 have goup oinstall setup.
From: Tim Gorman [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: [Q] create seperate DBA account on 8.1.7 but does NOT work?
Date: Mon, 27 Jan 2003 09:18:57 -0800
Aye, it is there,
Jonathan Lewis,
You are really oracle expert!Can you interpret more about this
statistics? And how did you think about this statistics that is seldom used?
The following is the test result:
--sql1:
Thanks,
Thanks for this information. I am more understanding of
the underlying causes for what was going on now.
I was the one that probably caused you to misinterpret
the what my real issue was. Sorry for that.
I am swamped here and have to brief. Thank You for
your time.
I enjoy
I have a java question so I figured I'd tap into some of the non-Oracle
expertise on this list. I'm doing a PeopleSoft install (basically setup.aix
calls a setup.jar file). This worked on one AIX (4.3.3) box, but is dying
(with no useful error messages or log files) on another box. Checking the
Any of you Oracle history buffs remember what version of Oracle that
advanced replication was first available in?
RF
Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (it's everywhere that I am!)
Author of several books you can find on
See
http://www.puschitz.com/OracleOnLinux.shtml
http://otn.oracle.com/tech/linux/pdf/installtips_final.pdf
Chris
-Original Message-
Sent: Monday, 27 January 2003 6:59 p.m.
To: Multiple recipients of list ORACLE-L
hi all,
I need your help, because I had try to install oracle 9.2.0 on
Jared,
I needed that, LOL!!!
Dick Goulet
Reply Separator
Author: [EMAIL PROTECTED]
Date: 1/27/2003 9:49 AM
.. for Unix Services. :)
http://www.linuxworldexpo.com/linuxworldny03/V33/press.cvn?id=11p_id=12
--
Please see the official
The stats output for your sql shows no physical reads.
This means either the whole table is cached or simply since you ran the test
many times you got all the blocks you're interested in cached.
Since all the needed blocks are cached, I do not think fetching the rows
using the rowid would be any
from metalink note: 28018.1
5.14 Symmetric Replication
---
It's basically a Microsoft version of Cygwin. I like
possibility of using NIS authentication. That would be
really helpful.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 27, 2003 12:50 PM
To: Multiple recipients of list ORACLE-L
Subject:
Thanks!
Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (it's everywhere that I am!)
Author of several books you can find on Amazon.com!
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Monday, January 27, 2003 2:12 PM
To:
Chaim - I agree with your note, but isn't that basic replication? Robert
asked about advanced (multimaster) replication.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Monday, January 27, 2003 2:12 PM
To: Multiple
Ive been reading the 9iR2 docs on partitioning, along with Tom Kytes
excellent chapter on the subject. It
seems that a Global index or unique, local indexes could be used effectively in
an OLTP system, but both have their caveats.
This is a hybrid system- its part OLTP but is also used
I just notice these ora_ixxx_sid processes on my server. Does anyone have
an idea what they are? They didn't used to be there.
oracle 18249 1 0 16:07:35 ?0:00 ora_i106_cdwprd
oracle 10664 1 0 15:36:38 ?0:00 ora_snp3_cdwprd
oracle 10650 1 0 15:36:37 ?
In case anyone cares--it looks like it is *not* possible to set a role in an
after logon trigger. Had I only looked at metalink:
AFTER LOGON Triggers Don't Allow DBMS_SESSION.SET_ROLE to Keep Roles Enabled
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab
Hi,
These are dbwr_io_slaves processes. Search in 'Metalink' (or Manuals) to learn more about these processes.Regards,
Quamrul
From: "Smith, Ron L." <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Strange processes showing up
Maybe I'm just a cynic but I view AUM as being akin
the SAME disk layout policy. That is, (and this is
subjective figures) it gives 90% optimal performance
in about 90% of databases out there.
Since going to aum on a significant (read:
reasonable number of users and workload) database I
used to
Title: Case of the Missing Rows
I have a recurring, repeatable problem I was wondering about its cause.
Oracle 9.2.0.1 on W2K Professional (SP2) Dell Optiplex workstation Pentium 4
Step 1 - I do an SQLLDR process that loads 88640 rows to a table
Step 2 - SQL*Plus session - SELEC COUNT(*)
Smith, Ron L.,
hi, did you set up db_io_slave process? check metalink note about
db_io_slaves:)
Regards
zhu chao
msn:[EMAIL PROTECTED]
www.happyit.net
www.cnoug.org(China Oracle User Group)
=== 2003-01-27 14:33:00 ,you wrote£º===
I just notice these ora_ixxx_sid
DBWR_IO_SLAVES 0. This is a bad thing. The IO slaves functionality
really stinks and the alternative of DB_WRITER_PROCESSES 1 is a much
better mechanism, especially from 8i onwards. Both mechanisms are Oracle's
own version of asynchronous I/O; is that enabled? If so, you might not
need
Hi,
DB: 8.1.5.0.0
O/S: Solaris 2.7
This database is the recovery catalog database. It is in noarchivelog mode
and is backed up cold.
Unfortunately, something happened on Thursday and the database does not
startup. I receive the following errors:
SQL startup
ORACLE instance started.
Total
Connor McDonald,
Hi, for IO balance , I think in most case, we put datafiles on raid so
it is not a problem? Or you can use multiple datafiles, which will give you solution
when no raid or multiple raid is used and you want to balance io?
I used AUM too in my rac
Title: Case of the Missing Rows
My guess is that SQL*Loader didn't really load
88,640 rows, but rejected or discarded about 1400 of them?
- Original Message -
From:
Weiss, Rick
To: Multiple recipients of list ORACLE-L
Sent: Monday, January 27, 2003 4:53
PM
Ok... I have the tapes now so I don't have to bother...but would this
scenario have been fixed by using the _allow_resetlogs_corruption parameter
and following the associated steps
Sorry for the bother
Sujatha
-Original Message-
Sent: Tuesday, 28 January 2003 11:14 AM
To: Multiple
If you use _allow_resetlogs_corruption, I believe that Oracle support
will require you to rebuild the entire database if you wish to have
support in the future. See MetaLink Doc 166181.1 for that.
They will not support your database for anything other than an export
used to rebuild the database.
The last time I went through the documentation from Oracle on doing an
upgrade. Planning for one of my 8.1.6.3 to be upgraded to 8.1.7 the
installation manual and Metalink's articles on upgrading specifically called
for the migration to be done (for all instances that were to be migrated)
first,
Hi,
shared memory realm does not exist
This must be your /etc/system semaphores setting incomplete.
Your oracle is not there yet
No such file or directory
This must be your environment not set properly
your
$ORACLE_HOME
library
may be also your system administrator don't like you.
Title: Case of the Missing Rows
I
think so too, perhpas you want to include the bad recordto capture those
bad records
make
the nesassary changes then load that bad file
repeat
until all loaded into your db
-Original Message-From: Tim Gorman
[mailto:[EMAIL PROTECTED]]Sent: 28
Sujatha,
There is never, ever, ever, ever, a perfect time to use
_allow_resetlogs_corruption.
Never ever. The results of such an operation may not be known for hours,
days or weeks.
Look which datafile it is that needs recovery, system01.dbf... which means
that if you
force open the database you
Yes, but you would be required to rebuild the entire database
via export. Oracle will not support a database opened with
_allow_resetlogs_corruption for anything other than export.
Jared
On Monday 27 January 2003 17:43, Sujatha Madan wrote:
Ok... I have the tapes now so I don't have to
If that were the case, he would not have seen 88640 rows
from sqlplus, as he reported.
Jared
On Monday 27 January 2003 16:43, Tim Gorman wrote:
Case of the Missing RowsMy guess is that SQL*Loader didn't really load
88,640 rows, but rejected or discarded about 1400 of them?
- Original
Even with W2k, I would still go talk to the network folks.
Look this up on MetaLink, that's where I found it.
Jared
On Sunday 26 January 2003 22:28, Walid Alkaakati wrote:
Hi Jared,
No the server is running on windows 2000,and this error is too annoying
every three days approximatlly i
81 matches
Mail list logo