"Kirsh, Gary" [EMAIL PROTECTED] wrote:
Terry,I've seem LMT's used in standby db's without a problem. As a matter offact, if you ever want to use the standby in read-only mode, the temptablespace needs to be a LMT, otherwise any query resulting in a sort todisk will fail.Gary KirshNext Extent,
The script probably needs to set up the oracle environment variables before it will work. Try this.
1) In the oraenv script that's either in /opt/bin or /usr/local/bin depending on your platform, look for the comment that says "Install any custom code here" and insert right after itthefollowing
If you're going to split a table into multiple tables, then exchange them for partitions, why not just create the partitioned table and copy the original table right into that? I'd only use the "exchange" route when converting partitioned views into a partitioned table.
"Joseph S. Testa" [EMAIL
the entire index to be rebuilt. Local indexes still need to be rebuilt, but they reduce the impact of such operations to one partition.
HTH
Chuck Hamilton
Raghu Kota [EMAIL PROTECTED] wrote:
Hi GurusI have a big fat Indexes, I need to recalculate their storage clauses, What is best approach to calc
select parallelfrom v$instance;
The Oracle DBA [EMAIL PROTECTED] wrote:
Is there a query that will say if a DB is an Oracle Parallel Server instance?I have never, but if you install OPS during install, does that make a 'mark' for DBs re: OPS?Thanks.Get your small business started at Lycos Small
Actually a 12 year old could probably have done it better.
Kevin Kostyszyn [EMAIL PROTECTED] wrote:
I would agree with that as well. For such a large company I would have to say that they have one of the worst web pages in the history of web pages. I have seen second year students at The New
I'm considering the switch from Oracle Names to Oracle Internet Directory. One feature I liked about names was the dynamic discovery. Does dynamic discovery also work with OID? For example if one of my databases fails over to another machine in it's cluster, the names server is automatically
Thanks for all the information Greg. One more question. What's an oracle names proxy? I thought names was going away entirely in 9i.
Chuck Hamilton
"Nelson, Greg" [EMAIL PROTECTED] wrote:
Failover information in Oracle Internet Directory (OID) is entered like Net8configuration inform
Peroria? How's the skiing in Peoria?
OraStaff [EMAIL PROTECTED] wrote:
*Description:Peoria, IL company needs a Sr. level Oracle DBA with Unix experience to join its' I.T. team.This position will have typical DBA responsibilities i.e.: physicaldatabase design, installations,performance analysis,
A while back someone posted a method for determining which shared memory segments belonged to an instance. Can someone repost that and CC me? Thanks.Do You Yahoo!?
Yahoo! Mail Personal Address -
Get email at your own domain with Yahoo! Mail.
--
Author: Chuck Hamilton
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing
AKAIK tnsnames.ora will always be supported. Oracle Names is being dropped in 9i in favor of LDAP, and since 8i Oracle ships a new LDAP compliant directory server called Oracle Internet Directory with the database. You can also use any other LDAP directory server such as Microsoft Active
: http://www.orafaq.com
--
Author: Chuck Hamilton
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE
I ran into a situation this week where a session was waiting for results from a failed db link and holding a lock (library cache pin) on the sql it was executing. It never detected the failure and hung waiting for a reply on the link. This caused the pin to be help indefinitely too, which caused
For single character replacement (or removal) use "tr". For string to string replacement use sed.
echo $var | tr "e" "o"
-or-
echo $var | sed "s/e/o/g"# (the '/g' means globally)
Mandar Ghosalkar [EMAIL PROTECTED] wrote:
check this question from korn faq at
You use the orapwd utility to change the remote internal password on unix. The default file name is $ORACLE_HOME/dbs/orapw$ORACLE_SID. Also, when you log in as internal locally, you don't need a password as long as the id you log in with is part of the dba unix group.
Nihar [EMAIL PROTECTED]
A snail going uphill through jungle vegetation? Molasses in thenorthernmost region of the Siberian tundra?Do You Yahoo!?
Yahoo! Mail Personal Address -
Get email at your own domain with Yahoo! Mail.
We need to move a 700g Oracle DW from SGI IRIX64 (SGI's 64 bit unix) to AIX and upgrade it from 7.3.3 to 8.1.7 at the same time. Anyone got any suggestions on how to do this quickly? I'd rather only use exp/imp as a last resort because it'll be so slow.
One idea we've thought about is to:1. Backup
Is the hash area memory released back to the o/s when the hash join operation is finished or does it remain allocated as long as the session is still connected?Do You Yahoo!?
Yahoo! Mail Personal Address -
Get email at your own domain with Yahoo! Mail.
between unix systems, shouldn't I be able to open copies of 7.3.3 IRIX files on an 8.1.7 AIX instance?
"Thater, William" [EMAIL PROTECTED] wrote:
Chuck Hamilton wrote: We need to move a 700g Oracle DW from SGI IRIX64 (SGI's 64 bit unix) to AIX and upgrade it from 7.3.3 to 8.1.7 at the
Do You Yahoo!?
Yahoo! Mail Personal Address -
Get email at your own domain with Yahoo! Mail.
Looks like my first email got truncated so I'll try again. Is there a way to associate parallel query processes with the session that's running the query? Do You Yahoo!?
Yahoo! Mail Personal Address -
Get email at your own domain with Yahoo! Mail.
rom). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Chuck Hamilton
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
nd for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Chuck Hamilton
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public I
Hello everyone. I have just rejoined this list after a couple of years
hiatus. Quick question. Are HTML posts acceptable on this list or is
everything supposed to be done in plain text?
Thanks,
Chuck Hamilton
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chuck
What's the current recommendation for gathering statistics on system schema
objects like SYS, and OUTLN? Are they still saying not to do it? I am on
8.1.7.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chuck Hamilton
INET: [EMAIL PROTECTED]
Fat City Network
Title: RE: Purely for your amusement
Do not fear. Australia is catching up quickly. I've
gotten two "MS security patches" emailed to me in the last two days from a ISP
in AU. I wonder if anyone actually falls for this stuff.
- Original Message -
From:
Nick
Wagner
To:
).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chuck Hamilton
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chuck Hamilton
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego
.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chuck Hamilton
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
('1H92 Y
M,=S+B -@T*3W1H97(@26YT97)EW1S#0H]/3T]/3T]/3T]/3T]/3T-D-H
MFES=EA;FET0T*0FEB;4@W1U9'D-G-K:6EN9PT*8V%N;V5I;F-FMA
;6%K:6YG#0IH:6MI;F-F)O=VQI;F-@T*
`
end
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chuck Hamilton
INET: [EMAIL PROTECTED]
Fat City Network Services
://www.orafaq.net
--
Author: Chuck Hamilton
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from
Oops, Posted to the wrong address. Sorry folks.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, February 28, 2003 2:53 PM
bio oracle-l
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chuck Hamilton
INET
on Linux runs as multiple processes
, unlike Oracle on Windows which runs as one big process. Does this
mean each Oracle process on Linux can access 3GB of memory? So that in
the end the whole of Oracle can actually use greater than 3GB of memory?
--
Lyndon Tiu
Quoting Chuck Hamilton [EMAIL
--
Author: Chuck Hamilton
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing
SIGNATURE-
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chuck Hamilton
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
+ archivelogs = duplicate database??
Thanks
Edouard Dormidontov
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chuck Hamilton
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list
recommend backing up an open database and, if
that
were to happen, I would consider that backup to be a 'scratch' tape.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chuck Hamilton
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http
information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chuck Hamilton
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
It's possible. I've heard of this happening before
and the recommendation was to clear out the listener.log file. There are a
couple of ways to clear out that file. One is to stop the listener and delete
it. The other is to cat /dev/null to it (i.e. cat /dev/null listener.log).
The latter
). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chuck Hamilton
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chuck Hamilton
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting
BTW is 9i lite just a database engine for PDAs, or does it allow you to
administer databases over a network from a PDA?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chuck Hamilton
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http
Hmm, I'm not having any trouble getting to it.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, March 05, 2003 1:14 PM
Looks like the web site may be down.
Reply Separator
Author: Chuck Hamilton
be
monitored from OEM anymore. I'm sure others on this list are using this type
of failover for high availability. How did you get around it?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chuck Hamilton
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http
then. But of course
you can wait for EM in 10i which is browser based, so that should be
able to run in the pocket version of internet explorer
Regards,
Morten Egan
Chuck Hamilton wrote:
BTW is 9i lite just a database engine for PDAs, or does it allow you to
administer databases over a network
ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chuck Hamilton
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858
view.
Kevin
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chuck Hamilton
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
it
executes. Can this be done?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chuck Hamilton
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !!
-Original Message- From: Chuck
Hamilton [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 06, 2003 11:39 AM To: Multiple recipients of list ORACLE-L Subject
are
strictly personal. QOTD: Any clod
can have facts, having an opinion is an art !!
-Original Message-From: Chuck Hamilton
[mailto:[EMAIL PROTECTED]Sent: Thursday, March 06, 2003 1:24
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
Fudging outlines
command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chuck Hamilton
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting
want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chuck Hamilton
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego
ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chuck Hamilton
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
to be
rebuilt or not without setting a lock on the table? We are on Oracle 8.1.7.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chuck Hamilton
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing
://www.orafaq.net
--
Author: Chuck Hamilton
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself
the information needed to determine if an index needs to be
rebuilt or not without setting a lock on the table? We are on Oracle 8.1.7.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chuck Hamilton
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chuck Hamilton
INET: [EMAIL PROTECTED]
Fat City
containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chuck Hamilton
INET: [EMAIL PROTECTED]
Fat City Network
to a few in private.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, March 11, 2003 1:31 PM
Consider yourself lucky. We've got a 71:1 ratio here.
Chuck Hamilton
[EMAIL PROTECTED]T
Title: Message
Damn. Beat me to the punch. I was going to mention
being a "snow quality" inspector or Blue Mountain (PA). :-)
- Original Message -
From:
Weiss, Rick
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, March 12, 2003 3:19
PM
Subject: RE:
Title: RE: POLL: Database to DBA ratio
With such a large # of databases to support, how do
you divide up the work? Does everyone administer all of the databases, or are
databases assigned to a DBA? How do you handle on-call?
- Original Message -
From:
Adams,
Matthew (GECP,
://www.orafaq.net
--
Author: Chuck Hamilton
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself
for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chuck Hamilton
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
64 matches
Mail list logo