Bull's eye .
Will Check out the Steve Adams' Book revert
Thanks
-Original Message-
From: yong huang [SMTP:[EMAIL PROTECTED]]
Sent: Monday, February 05, 2001 10:30 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Waits on latch free for shared_pool library
select empid, empname, dept
from employees
where rownum = 3546;
When you are looking for scott..
That is pretty unreliable, and I think that is what Bunyamin(?) was getting
at..
Regards
Mark
-Original Message-
Sent: Sunday, February 04, 2001 02:40
To: Multiple recipients of list
I have a public database link defined with userid-1.
Userid-1 has update permissions on table-a in database-b.
Userid-2 has no permissions on table-a in database-b.
Userid-2, in database-a, calls a package that contains the database link and
tries to update table-a in database-b.
The result is an
Title: OT:Thunderstone.com: Texis
Yes I
have somewhat, context searches are fast.
You
need to keep three copies of the data and indexes (things get corrupted
easily). If you do alot of updates, you will have the rebuild the
tables and/or redo the indexes all of the time.
But it
is
Surjit,
I think your "hardcore Tera Data" fans are also bigots. I've a friend at
Fidelity Investments where they swear by SUN Oracle. The last time I talked
to him their datawarehouse was fast approaching 2PB without any problems. They
use all of 8i's datawarehousing stuff like
On Mon, 5 Feb 2001,[EMAIL PROTECTED] scribbled on the wall in glitter crayon:
-There are two basic problems with data warehouses that I've seen it should
-be noted that I'm in the middle of specing a re-wtite of ours. 1) people create
-then in a normalized manner, not in the idea of a
I'm sorry. The error is not that the user cannot use the database link.
The error is that Oracle does not want the user to update table-a in
database-b even though the user has update permissions.
Ron
-Original Message-
Sent: Monday, February 05, 2001 8:30 AM
To: Multiple recipients of
Hi,
Why not to use otrace? Of cource, you may need some space to save
trace results, but you'll definitely get complete statistics.
Vadim Gorbounov
Oracle DBA
-Original Message-
Sent: Tuesday, January 30, 2001 3:57 PM
To: Multiple recipients of list
Hi,
I have a situation where in all the user related
objects (tables) have been created in System tablespace.
I believe there is no convention followed while
creating these tables.
Now, how do I separate these user related objects
and put them in Users tablespace?
Vinay
Hi all,
I have been trying to find some reference on pinning tables in the SGA. I
haven't found anything, all that I am finding is table caching and the keep
buffer pool. Is this all that there is, can I "pin" a table in the memory?
Thanks in advance.
Sincerely,
Kevin Kostyszyn
DBA
Did you try re-running catalog and catproc and then recompiling invalid
objects? We were getting ora-7445 errors on one of our databases last week,
and this fixed it.
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject:
So, there I am, with an HP/UX server hosting 3 production Oracle DBs. The
node is also running Oracle Intelligent Agent, and I have OEM events to
e-mail/page me if there's problems with productions DBs and servers.
Anyone else running something similar? How do you shutdown a single
production
Title: RE: Async I/O on Windows
WHOOO a SQLServer vs. Oracle debate
again!!
Come
on guys in the field, lets hear you comments from all those using both in the
field. I personally have been trained in administration on both, and - like you
Ross - have to agree that Oracle is my
Title: RE: Async I/O on Windows
"NT
still pants"...LOL!!!
It must be panting alot, It has BLOWN THE DOORS
OFF of "Oracle on Unix" in running
SQLServer on NT, as has DB2.
The
general public ( and anyone else ) can wake up and smell the coffee at www.tpc.org.
Check
out the Top Ten TPC-C
Here is what I get in the alert log:
Errors in file /oracle02/app/oracle/admin/ORTE/udump/orte_ora_15115.trc:
ORA-07445: exception encountered: core dump [lxdgetobj()+60] [SIGSEGV]
[Address not mapped to object] [1651271016] [] []
Mon Feb 5 12:55:20 2001
Errors in file
Yeah, but Rachel, think of the FAME! Didn't I hear you were
opening for Billy Joel and Elton John in LA on Feb 6?
:-)
Yosi
-Original Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: Sunday, February 04, 2001 1:00 PM
To: Multiple recipients of list ORACLE-L
I run about 20+ databases from one OEM session, albeit on NT, and I never
shutdown the agent when I shutdown a database. You must have OEM sending
email for all events. Just use email for selected events that you want to
know about.
OEM won't freak if you don't shutdown the repository
My problem is that the timestamp, which is just that--no date, is only on
the
first record of each sample rather than every record and I don't want the
blank
lines in between the samples. Perhaps this is a simple awk routine but
I don't know awk well enough to do this.
awk '{ if (NF7)
Hi
I am wondering about some results I am getting back when I am querying based
on date fields. I have a large table partitioned on source year. When I run
the following query the results are not correct results, it seems to be
grouping the year incorrectly.
select to_char(landed_dt,''),
Title: RE: Async I/O on Windows
LOL!!! Amen!
-Original Message-From: Mark Leith
[mailto:[EMAIL PROTECTED]]Sent: Monday, February 05, 2001 12:25
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
OT RE: Async I/O on Windows
WHOOO a SQLServer vs. Oracle debate
Title: RE: Oracle Vs Tera Data
Surjit,
In my experience, Sun storage ( the A5000 stuff, etc. )
does not do the best possible job.
But, then again, you may be on Fujitsu, EMC, or some
other good storage vendor.
(Dick, liked your comments about normalization and adjustment
I have taken the stance with one junior that he now
has to prove me wrong in anything I tell him. Loser buys
the beer. He owes me quite a bit right now:-)
-Original Message-
Sent: Friday, February 02, 2001 9:16 AM
To: Multiple recipients of list ORACLE-L
Kimberly,
I could say the
By chance, does
anyone have a script that will reparse a collection of sar statistics, that came
from "sar -d", into a file that can be used by SQL*Loader?My problem is
that the timestamp, which is just that--no date, is only on the first record of
each sample rather than every record and I
Hi Dick,
A couple of campanies I consult for are using
Linux and Oracle (8.0.5, 8.1.6) as production
databases. Neither is really high transaction volume
but one is holding about 1.5 GB of data.
One install occured because Oracle on NT was choking
No, pinning is for the code: sql, procedures/functions/packages and
sequences. Take a look of the package dbms_shared_pool.
Regards.
-Mensaje original-
De: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]]
Enviado el: lunes 5 de febrero de 2001 16:36
Para: Multiple recipients of list
I am running ORacle8i on Windows2000 and for what I use
it for I see no difference from NT.
-Original Message-
Sent: Monday, February 05, 2001 11:06 AM
To: Multiple recipients of list ORACLE-L
Ross Mark,
There are no major performance concerns here (and we get
Oracle "free" {system
I believe chr(9).
--
Chris J. Guidry P.Eng.
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: [EMAIL PROTECTED]
-Original Message-
From: Viktor [SMTP:[EMAIL PROTECTED]]
Sent: Monday, February 05, 2001 11:57 AM
To: Multiple recipients of list
Title: RE: Async I/O on Windows
Does
anyone know what this error means? What caused this
error?
TIA
SVRMGR alter database
open;
alter database open
*
ORA-01187: cannot read from file 1 because it
failed verification tests
ORA-01110: data file 1: '/opt/oracle/oradata/system01.dbf'
Let me rephrase it. The user defined in the database link has insert
permissions on table-a. The user calling the database link does not have
any permissions on any table in database-b.
Ron
-Original Message-
Sent: Monday, February 05, 2001 10:11 AM
To: Multiple recipients of list
Hi DBAs,
Oracle 8.1.6 on Sun; DW environment:
Have a table that gets populated by SQL*Loader and thereafter lots of
queries go against this table using different combinations of 4 columns
(date, varchar2(6), varchar2(5), char(1)). Once a row is processed, the
char(1) column gets updated from
What is ascii code of TAB?
Thanks
__
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Viktor
INET: [EMAIL
It is CHR(9):
SELECT column_1||chr(9)||column_2 FROM table_name;
Best regards,
-Ari Kaplan
Independent Oracle DBA Consultant
Founder/CEO, PocketDBA Systems -- Wireless Database Management Now
www.pocketdba.com
--
- For 400+ Oracle tips, visit: -
-
-Original Message-
From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
Sent: Monday, February 05, 2001 9:56 AM
To: Multiple recipients of list ORACLE-L
Subject: OT RE: Async I/O on Windows
SNIP
Wanna drag?
(heh heh heh)
Well, I'd have to shave my legs, but for
^I Dec - 9 Oct - 011 Hex - 09
David A. Barbour
Oracle DBA - ConnectSouth
512-681-9438
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, February 05, 2001 12:57 PM
To: Multiple recipients of list ORACLE-L
What is ascii code of TAB?
Thanks
Rachel:
I miss a couple of my old jobs where I has other roles (developer/dba and network
admin/helpdesk/etc) where I got quite a few people trained real well :) I could count
on a snack from several people a week. Although I guess that could be seen from their
side as "We sure got this guy
Title: RE: OT RE: Async I/O on Windows
LOL!
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Monday, February 05, 2001 2:11 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: OT RE: Async I/O on Windows
-Original Message-
From: Mohan,
Title: RE: OT RE: Async I/O on Windows
TPC doesn't really matter
- You are correct: no single metric covers it all.
But, Oracle is sure all over the ad pages when
it FINALLY manages to get one near the top. Which
isn't often. And right now, hands down, SS2K is
about FOUR TIMES AS
Title: RE: Async I/O on Windows
H
- did you mount the database first?
David A. Barbour Oracle DBA - ConnectSouth 512-681-9438 [EMAIL PROTECTED]
-Original Message-From: Tony Guo
[mailto:[EMAIL PROTECTED]]Sent: Monday, February 05, 2001 2:12
PMTo: Multiple recipients of
Hello list,
Is there a possibility to know a specific session's NLS parameters querying
from another session ?
Regards, Radu Caulea
Senior Oracle Consultant
www.caulea.fr.st
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Radu Caulea
INET: [EMAIL PROTECTED]
Fat
Try: ALTER TABLE tablename CACHE;
The table will stay in the buffer cache and not get rolled out. This is
basically used for small lookup tables like security tables that are
accessed over and over.
Ron Smith
Database Administration
[EMAIL PROTECTED]
-Original Message-
Sent: Monday,
Title: RE: (Win2K vs NT4) / RE: OT RE: Async I/O on Windows
From what I know, Oracle8 is not yet
formally certified on Win2K, believe it
or not. But, I could be way wrong about this.
Anecdotally, I have colleagues running every
from clients through Net8 Names Servers to
database servers on
Title: RE: OT RE: Async I/O on Windows
You might want to check those results again. Oracle has the top three in the TP-C, nonclustered results.
|| I did. The results speak for themselves. You need to click ALL RESULTS. (Or, are you saying that,
in 2001, we should focus on NON_CLUSTERED
"Eric D. Pierce" wrote:
Ross Mark,
There are no major performance concerns here (and we get
Oracle "free" {system wide educational site license} -
unlike MS/SQL), so what I want to know is: does Oracle8
generally work well on Windows 2000 server (compared to
running it on NT4)?
Well, I
Title: RE: Async I/O on Windows
Yay,
someone is looking at the data!!!
On the
clustered side, did you notice that the leader, far and away, was SS2K on
Win2K.
Pure
Microsoft Play, and clustering 192 CPUs. WO-WAAA.
too
bad "Microsoft can't cluster" ( har de har har
)
Title: RE: (Win2K vs NT4) / RE: OT RE: Async I/O on Windows
Do you crash weekly?
-Original Message-
From: Kimberly Smith [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 05, 2001 3:21 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: (Win2K vs NT4) / RE: OT RE: Async I/O on
Rocky,
She lost the bet and got a raise - go figure !
well done lisa , we still wish you were back in Eden Prairie !
Q
Rocky Welch [EMAIL PROTECTED] on 02/05/2001 03:45:33 PM
Please respond to [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc:
Hi,
I am looking into installing a patchset with minimum downtime. Standard
Oracle procedure for installing a patchset is:
1. Shutdown the database
2. Install the patch binaries, relink.
3. Startup database (restrict ?), run the cat* scripts.
I wanted to change the procedure so that instead of
Title: RE: Pinning Tables
What is the difference between table caching and pinning, to your thinking?
-Original Message-
From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 05, 2001 10:36 AM
To: Multiple recipients of list ORACLE-L
Subject: Pinning Tables
Hi
There is a very helpful Microsoft help file available at
http://ourworld.compuserve.com/homepages/r_harvey
that contains references for everything from ascii to codepages, and the best part is
that it is free.
David Barbour [EMAIL PROTECTED] 02/05/01 04:25PM
^I Dec - 9 Oct - 011 Hex -
http://www.theregister.co.uk/content/30/12701.html
-
http://www.theregister.co.uk/content/archive/16057.html
(Prostitutes used to tempt IT staff into jobs)
On 5 Feb 2001, at 12:12, Rocky Welch wrote:
Date sent: Mon, 05 Feb 2001 12:12:17 -0800
To: Multiple
Title: RE: OT RE: Async I/O on Windows
Another way of looking at it:
So lets say the 12 computer configuration were to have a failure
in some *single* wintel box every 7 days .. who cares!! The shared
nothing architecture underlying the system load BALANCES users to
machines which are
Hi, Eveleen,
you a right, x$bh is the veiw, which contain important information
about database buffer. This means, you will find here references to only
those database blocks, which are currently in buffer, i.e., most recently
used. You even can identify "hot" (often updated)
Title: RE: (Win2K vs NT4) / RE: OT RE: Async I/O on Windows
:)...so, no Win2K Oracle8, but 8i is cool, all around.
Put that in yer pipe and smoke it!
(Love the haddock.ani .!)
-Original Message-
From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 05,
Title: RE: OT RE: Async I/O on Windows - Federated Database Foolishness
What's a federated database
|| I don't know. Where did you read it? shrug
We really need to understand this otherwise we'll be duped by Microsoft's
deceptive benchmark claims!!
|| wow! thanks for saving me,
Title: RE: OT RE: Async I/O on Windows - WHAT is a FEDERATED DATABASE
I have some answers, for the curious:
http://www.zdnet.com/eweek/stories/general/0,11011,2623013,00.html
It appears that SS can partition data storage among multiple
machines, giving it blow your doors off performance.
Yes, you do that in the SQLNET configuration files LISTENER.ORA and
TNSNAMES.ORA - use the IP address (instead of the hostname) of the NIC card
you want to use. It is not complicated at all!
Cheers,
Renato
Database Services
IBM Global Services A/NZ
To: Multiple recipients of list ORACLE-L
I'm used to Oracle7.3 command line DBA environment. Is
there anything in OEM that I "must have" to run the
Oracle8.1.7/Win2k?
I'm really not sure -- all I have needed to do with is startup, shutdown, and run SQL
PL/SQL scripts.
Good luck
Bill
--
If you are using OEM v2.1 or higher then you could define a paging / email
blackout before the shutdown
(either for the node / db in question or a total one).
Or you could remove the event and then reinstate it.
Regards,
Bruce
-Original Message-
Sent: Tuesday, 6 February 2001 5:06
I
Ross, glad to see you're starting to come up to speed here. :)
But for the clustering to work, businesses would have to change software
and segment the data
The CNet authors obviously got tangled up in their notes and didn't
understand what they were writing about. (Not a first.) You don't
Not a good idea. Oracle links some libs in with a direcory that is in
Oracle Home.
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Monday, February 05, 2001 3:42 PM
Hi,
I am looking into installing a patchset with minimum downtime. Standard
We have a 175 terabyte database in Objectivity. It houses event data from a physics
experiments looking at the decay of B-mesons and their antimatter counterparts, trying
to find out what's going on with CP violation.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
When I am installing the patchset I am giving oracle the new home. For
example:
1. My home is /u01/app/oracle/product/8.0.4
2. I copy all the tree under the home to the new home:
/u01/app/oracle/product/8.0.4.4
3. For the patch installation session I set:
We use a similar approach on Open VMS with some success where we
1) re-create a new oracle_root,
2) shutdown the database,
3) change the startup/login scripts. etc
4) start-up database.
I would not risk it if the patch modifies some catalogs. (ie a new cat*.sql
now exists).
Hi DBAs,
I would like to know the way for specifying a filename dynamically in
SQL PLUS.
Say, for example
The file name should be suffixed with a sequence number available from
a SEQUENCE object. ( like SPOOL filename>||seq1.nextval).
Any idea?
Thank You,
Arul.
64 matches
Mail list logo
