you mean niemic didnt actually have to take the test? It was just handed
to
him? who is jeremiah wilton?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 4:09 PM
IIRC, Tanel did the OCM as well, but I suspect most
around all the statistic#s with every
major release. So if you write (or memorize) something that relies on
the statistic# being permanently associated with a particular
statistic, it will break (give results for the wrong statistic) as
soon as you upgrade.
--
Jeremiah Wilton
http://www.speakeasy.net
= atttribute
to the mts_dispatchers parameter.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Mon, 17 Nov 2003, Schauss, Peter wrote:
Oracle version 8.1.7
AIX 4.3.3
I am trying to configure mult-threaded server on one of my development
databases. In my init.ora file, I set
How about just committing every n rows, instead of trying to fit the
whole thing into one transaction? This is why they have the ROWS=
option on the command line and in the parameter file.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Sat, 15 Nov 2003, Stephane Faroult wrote:
[EMAIL
by grouping sql_text in v$sqlarea by the first 30
characters or so. This assumes your problem is shared pool sqlarea
bloat. You could just be runnning out of space for MTS session heaps
in the large pool. You have to look at v$sgastat first.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
not just try a 10046 level 12 in your SYSDBA
session when you are trying to shut down. Then you can tail the trace
file in another window and see what wait events it is waiting on.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Wed, 22 Oct 2003, Tortorelli, Mary Jo wrote:
We do shutdown
. Dictionary management doesn't account
for much redo at all, even in masively misconfigured environments.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
-Original Message-
Sent: Monday, August 04, 2003 11:59 AM
To: Multiple recipients of list ORACLE-L
How come changing the TS
this. Bug 2186174 is triggered
under certain circumstances under 9.x if fast_start_parallel_rollback
is set to TRUE. It causes instances to SPEW redo in a big way.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Fri, 1 Aug 2003, Whittle Jerome Contr NCI wrote:
This has suddenly started
needs to be done. This is pretty easy in perl
on in a spreadsheet even.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Fri, 1 Aug 2003, Tanel Poder wrote:
Hi!
Statistic#'s vary between versions (and possibly platforms), so one should
use statistic names instead of numbers
like emacs than vi.
There is an emacs OracleSQL mode, but I don't use it. I just start
emacs, META-X shell, then sqlplus...
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Fri, 25 Jul 2003, Orr, Steve wrote:
I agree with the developer vs. sysadmin generalization
: http://www.orafaq.net
--
Author: Jeremiah Wilton
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
On Tue, 24 Jun 2003, Wolfe Stephen S GS-11 6 MDSS/SGSI wrote:
What's a DAB?
Among the Hmong, a dab is an evil spirit thet makes mad things happen.
For instance, a dab might hang out at a particular intersection and
make fender-benders happen.
--
Jeremiah Wilton
http://www.speakeasy.net
Not sure if this was already mentioned. You can hack up the result of
this:
alter database backup controlfile to trace;
into an exact replica of the create database statement.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Tue, 17 Jun 2003, Jack van Zanen wrote:
Maybe not exactly
ways.
There's a lot involved in a migration. Lots of dependencies and
details to think about. I recommend repeated practice runs on test
equipment before trying the real thing. There's a lot of blood to be
squeezed out of this stone to get the time down and reliability up.
--
Jeremiah Wilton
http
a variety of v.5 administration syntax
(IOR WARM, etc.), and a wall-mountable full color picture of the
author on the back looking very spiffy with the exception of needing a
neck shave.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Wed, 4 Jun 2003, Jamadagni, Rajendra wrote:
Dang
What are the wait events of the slowed sessions?
What is the correspondence with v$session_longops phases for the
rebuild?
Really, the answer to 75% of the questions in this group is look at
v$session_wait.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Thu, 29 May 2003, Stephen Lee
it fixed for good.
Or you can try to get it to happen under load on a test system.
Hope this helps!
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Thu, 29 May 2003, Stephen Lee wrote:
I appreciate the response. The questions here are not Are there waits?
Most obviously
out, or background thread IPC will time out,
bringing the instance down.
This seems like a silly exercise. Whose idea is it?
Good luck with all that
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Thu, 29 May 2003, Munish Bajaj wrote:
Hi Gurus,
I am facing a problem. I need to log
to
do something that you need to do, then booting is reasonable. I think
the author must have been referring to routine reboots when nothing is
actually wrong, or when the solution to the problem can be achieven by
other means than shutting everything down.
--
Jeremiah Wilton
http://www.speakeasy.net
bruised anyway.
I guess the bruising my equate to overtime spent recovering the database...
Oh, I hate trying to make really good analogies.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jeremiah Wilton
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858
On Wed, 2 Apr 2003, [EMAIL PROTECTED] wrote:
Then, while bringing up, we do
startup restrict;
shutdown immediate;
startup
Why? Doesn't it start up fine the first time?
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
--
Please see the official ORACLE-L FAQ: http
What does this have to do with archivelog mode? In the bizarre
scenario in which you lose a log between the time you shut down and
started up, you are screwed with or without archivelog mode.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Wed, 2 Apr 2003, GovindanK wrote:
This topic
logfile? If so, you should know that this combination of commands
will not accomplish that. Any user with DBA priv can be in the
database doing stuff and making transactions after your switch logfile
and your shutdown immediate.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
--
Please see
On Wed, 2 Apr 2003, Chris Berry wrote:
Shutdown abort is pretty drastic, are you sure shutdown immediate
didn't work?
What is drastic about shutdown abort?
Never one to opt out of a shutdown abort thread,
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
- Uses shutdown abort exclusively
there is no reason to be more
careful about using abort if you are in noarchivelog mode. Crash
recovery will not need any archived redologs, since it only needs
those logs since the last checkpoint.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
--
Please see the official ORACLE-L FAQ: http
, restarting the
instance is unnecessary and only reduces availability.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
-Original Message-
Sent: Friday, March 28, 2003 6:24 AM
To: Multiple recipients of list ORACLE-L
I wonder where I should set TIMED STATISTICS = TRUE, if any
Why do you have to suspend?
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Wed, 26 Mar 2003, Hemant K Chitale wrote:
We want true server-less backups. I know that RMAN's overhead is [much] lower
than that of the ALTER TABLESPACE BEGIN/END BACKUP but the
Snapshot method in a SAN
the
thing out of service unnecessarily!
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Wed, 26 Mar 2003, Hand, Michael T wrote:
Jeremiah,
The only reason I could forsee is if the split is not atomic. This is the
case
in our (Non-SAN) environment. The split takes several minutes
/rollback prior to
shutdown
4. Look for which processes are still alive during the shutdown, use
lsof to trace them back to the client app OR select a list of sessions
and their respective processes prior to shutdown
5. Forget about shutdown immediate, use shutdown abort.
--
Jeremiah Wilton
http
commence and finish before archival is complete.
The correct command to use is 'alter system archive log current'.
This command will not return until the current log is fully archived.
Than your copy can proceed safely.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Fri, 14 Mar 2003, Ball
I think it is looking for the Taiwan Chinese (BIG5) error file, which
you don't have. If you change your NLS_LANG environment variable to
something that is available in that directory, it will probably work.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Thu, 6 Mar 2003, [big5
So the obvious question:
What is the db_block_size and what is the size in bytes of
/oradba/oradata/HTK443M8/audit_sis01.dbf as it was restored from
backup?
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Wed, 5 Mar 2003, BanarasiBabu Tippa wrote:
I am recreating the database from
Ofer,
Are you suggesting that it is OK to copy an open database without
using hot backup mode, as long as there isn't a log switch during
copy?
Do you use this method at your place of employment?
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Tue, 4 Mar 2003, Ofer Harel wrote
before the database opens.
Otherwise, you will have to wait for instance registration with the
listener, or force it with 'alter system register'.
For dedicated connections, this problem can be avoided with a sid_desc
in the listener.ora
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Mon
stolen away by a needlessly
spinning listener(s) that is just rejecting connections, one after
another.
So, in such a case, listener first, then database.
But shutdown immediate is for wimps. Just shoot DBW0 in the head with
a SIGKILL. ;-)
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Mon
The wait events.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Fri, 28 Feb 2003, Nguyen, David M wrote:
Someone writes a SQL script to dump a table on three different database on
three different Solaris8 machines, he complaines one of machines took 6
hours to dump a table while
In Unix, maybe something like this?
for X in *.dbf
do
dbv file=$X
done
Add logfiles, paths, etc. as you wish. I suppose something similar
must be possible in batch scripting for windows. Then again maybe
not!
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Thu, 27 Feb 2003
On Wed, 26 Feb 2003, Yechiel Adar wrote:
We had a session with an expert on Monday and he recommended export
to \dev\nul to detect errors in the database.
Well the expert isn't going to find any corruptions in indexes that
way.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
--
Please
Seems like 1999 around OOW.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Wed, 26 Feb 2003, Jonathan Lewis wrote:
Does anyone happen to remember when
Juan Loaiza and Bhaskar Himatsingka first
published their paper called:
How to stop defragmenting and start living
encountered data corruption problems.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Wed, 26 Feb 2003, Daniel W. Fink wrote:
I had a scheduled job that ran dbv on Solaris 8.0.4 databases once a
week. Never a problem. It has been awhile since I used it on Windows,
and I don't recall using
in 10i, with some backports and patch
releases for 9.2.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Tue, 18 Feb 2003, Jacques Kilchoer wrote:
I was looking this up on Metalink just the other day, and here is one of the
items of interest I found:
Doc ID: 408286.999
In my case I
://www.orafaq.net
--
Author: Jeremiah Wilton
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
John,
In 7.3.4, wasn't background TX recovery already a feature? In other
words, weren't large rollbacks delayed until after the database was
already open and available?
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Fri, 7 Feb 2003, John Kanagaraj wrote:
Just to add another aspect
Kirti
In v.7 the archiver is called ARCH. If 'archive log start to xxx'
starts another, what is it called?
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Wed, 5 Feb 2003, Peter Gram wrote:
Kirti
From version 7.x you can manually start multiple archive processes by
using
Sorry Kirti, that was meant for Peter.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Thu, 6 Feb 2003, Jeremiah Wilton wrote:
Kirti
In v.7 the archiver is called ARCH. If 'archive log start to xxx'
starts another, what is it called?
--
Jeremiah Wilton
http
What was the first version of Oracle with the ability to start
multiple archiver processes?
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jeremiah Wilton
INET: [EMAIL PROTECTED]
Fat City Network Services
recoverable as soon as they are
considered successful by the app.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Mon, 3 Feb 2003, Rajesh Dayal wrote:
I totally agree
I am witness of one of these untested combination resulting in true
disaster
to make Oracle unrecoverable after ABORT?
I'm still mulling over that 'alter system checkpoint.' Sounds
familiar.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Sat, 1 Feb 2003, [iso-8859-1] Connor McDonald wrote:
Agreed. All that matters is the redo logs. If Oracle
had named
Wilton
http://www.speakeasy.net/~jwilton
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jeremiah Wilton
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
to that Rubik's cube.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
-Original Message-
From: Jeremiah Wilton [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 30, 2003 7:49 AM
To: Multiple recipients of list ORACLE-L
Subject: Making dispatchers re-read tnsnames.ora
connecting
to my databases (especialy if I have to set up a separate service name
for every little special situation)?
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Thu, 30 Jan 2003, Jesse, Rich wrote:
Not that ONames doesn't have it's shortcomings, but I'm not sure how ONames
is using the
most CPU BETWEEN QUERIES. Alternately, you can get this info from the
same table since instance startup by dividing the statistics value by
the total lifetime of the session taken from from v$session.
I'll let you make the SQL.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
.
If you have any such materials that you would be willng to share,
please contact me off the list.
[EMAIL PROTECTED]
Thanks,
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jeremiah Wilton
INET: [EMAIL PROTECTED
the max file size.
Is there a way to recognize, which trace file belongs to which session?
Unless you are running MTS/Shared Server, the trace output begins with
something like:
*** SESSION ID:(134.58553) 2003-01-13 09:11:02.501
That's SID.SERIAL# inside the parentheses.
--
Jeremiah Wilton
I believe 1998 was the last year they provided CDs with papers and
presentations. Does anyone still have the 1998 CD and is willing to
share it?
Please mail me directly off list: [EMAIL PROTECTED]
Thanks,
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
--
Please see the official ORACLE-L
If anyone has a conference program or other documentation with session
listings from 1998, could you please contact me off the list.
Really interested in the who's who of Oracle 7.3 tuning!
Thanks!
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
--
Please see the official ORACLE-L FAQ
and recreated (unless you
get the patch). Let one segment extend into there and watch the
ORA-600s.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, December 11, 2002 2:46 AM
waiting.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Wed, 11 Dec 2002, Naveen Nahata wrote:
Won't 'seconds_in_wait' show the total time waited for the session rather
than the current wait time?
-Original Message-
Denham - I'm going to make a guess here and someone
resizing.
:-)
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jeremiah Wilton
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list
64,0x1006f 0x77b6a000 2179 /dev/data1/rorclts3-01
oracleorc 29290 oracle 22u VCHR 64,0x10079 0x75c94000 2199 /dev/data1/rorclts3-02
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Fri, 29 Nov 2002, Grant Allen wrote:
Saw an interesting post in comp.databases.oracle.server
Yes, I meant files they need for read.
No matter how many times you proofread before sending...
A shadow server process would only write if it were using direct path
insert /*+append*/ or sqlldr or sorting to TEMP.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Fri, 29 Nov 2002
blocking other sessions, just look in v$lock where block = 1.
As interesting as it seems, I think you won't succeed in trying to put
triggers on x$kgllk or anything like that. They're not real tables -
just table-like accessors for memory structures in the SGA.
--
Jeremiah Wilton
http
work on lower version databases, but I am not sure.
Check out the docs.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Mon, 25 Nov 2002, Koivu, Lisa wrote:
I can't answer the question about rman... but if you recreate the
controlfile you will have a new incarnation number
v$sysstat where name = 'CPU used by this session';
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Mon, 25 Nov 2002, Gurelei wrote:
I'm trying to figure out how much of the srever's resources
(CPU-wise) a database and the application running against it is
taking. There are several
and ss.statistic# =
sn.statistic# and sn.name = 'CPU used by this session';
To get the total for everyone ever logged in up to now, just query
v$sysstat.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Mon, 25 Nov 2002, Gurelei wrote:
Wouldn't this only give me the statistics for
MY current
them back.
Also, you might want to have a look at the Oracle Concepts Manual. It
explains all about creating a database and controlfiles.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Sun, 24 Nov 2002, john wrote:
the location mentioned in the init.ora for control files does not
have
?
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Sat, 23 Nov 2002, Arup Nanda wrote:
Well, system does not do a shutdown abort. Oracle finds a problem and then
instance aborts.
A few things you can do here.
(1) See if a trace file is generated around that time in user_dump_dest
Anyone going to he UKOUG conference and exhibition Dec. 9 - 11?
Anyone been to previous ones who can vouch for the value of the
conference?
Anyone know if they are looking for more speakers?
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
--
Please see the official ORACLE-L FAQ: http
roundtrips
to/from dblink';
VALUE
--
1925
(Oracle8i Enterprise Edition Release 8.1.7.3.0 - 64bit Production)
However, using DB links can never be as efficient as a parallel
datafile copy followed by a near-zero downtime switchover.
--
Jeremiah Wilton
http://www.speakeasy.net
kicking the users off
the old database and letting them into the new one.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Wed, 13 Nov 2002, [EMAIL PROTECTED] wrote:
What about foreign keys, functions, procedures, synonyms, roles, grants
and
triggers (if any)? I've used the db link
presentations. These guys do not tow the
line.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Tue, 22 Oct 2002, Deshpande, Kirti wrote:
Gaja is an Oracle employee now..
... but will not be presenting this year...
- Kirti
-Original Message-
Sent: Tuesday, October 22
, that presenters are predominantly Oracle employees, and
major Oracle customers and partners. This limits the number of
presentations having technical merit. I only attend OOW to present
papers, to meet you all, and then only if admission is free.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
?
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
- Original Message -
I'd like to pose a question to you all and get your response. If you are
running a database that is larger than 250GB, what place in your backup
strategy does a logical export have? Do you do logical exports at all
On Wed, 5 Jun 2002, VIVEK_SHARMA wrote:
Did a Database Recovery was Able to Successfully Recover ALL Data
of a Table Created with the CTAS NOLOGGING Option
Did you recover from a backup taken before or after the CTAS?
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
--
Please see
attribution.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Wed, 29 May 2002, John Dunn wrote:
Can anyone please clarify what archived logs should be backed up when doing
a online backup?
I have seen various online backup scripts that seem to take different
approaches.
I have
-- -- ---
1 54284 YES INACTIVE 2002-05-29:17:15
2 54285 NO ACTIVE 2002-05-29:17:17
3 54286 NO CURRENT 2002-05-29:17:26
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
--
Please see the official ORACLE-L FAQ
cheaper than a whone second server for a standby.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Wed, May 29, 2002 at 03:53:32PM -0800, Li Zhang wrote:
The company I am working for is planning to move the whole production server
to a new faster box. As DBA, I will move the database
misconceptions I wrote about:
http://www.speakeasy.org/~jwilton/oracle/switch-logfile-backups.html
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
John Dunn [EMAIL PROTECTED]
I have a online backup script which issues the command
ALTER SYSTEM SWITCH LOGFILE;
immediately before
article for more
information:
http://home.clara.net/dwotton/dba/snapshot2.htm
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
-Original Message-
From: Andrey Bronfin [SMTP:[EMAIL PROTECTED]]
There is something strange going on in my production DB.
There is a program
). And you have
to use server-managed undo to use query flashback.
Personally, there are a lot of queries the developers here have come
up with that I have flashbacks of anyway, usually around 3 or 4 in the
morning.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Tue, 28 May 2002, Rachel
in an export?
If I were the original poster, I'd just look at v$session_event for
the export session after several minutes of slowness.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
-Original Message-
Sent: Monday, May 20, 2002 3:43 AM
To: Multiple recipients of list ORACLE-L
to accomplish with the big rollback segment?
What do you think the rollback segments are being used for by an
export?
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
-Original Message-
Sent: Monday, May 20, 2002 1:04 PM
To: Multiple recipients of list ORACLE-L
On Mon, 20 May 2002
You can connect directly to a dispatcher you have started on a
different port. No listener required.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Fri, 17 May 2002, Keith Peterson wrote:
if your real question is can I circumvent the
listener, the answer is no.
Keith
Date
give you this: It isn't the flavor of browser.
Also, remember when posting that you can specify Amazon detail page
URLs as shorter strings by cutting off everything after the ISBN, like
so:
http://www.amazon.com/exec/obidos/ASIN/0201715848
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
RTFM.
http://www.bcpl.net/~rgarriqu/babyman.html
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Mon, 29 Apr 2002, [EMAIL PROTECTED] wrote:
EPIDURAL..
advice from the recently hatched (eight month old little girl:)
-Original Message-
From: [EMAIL
Why don't you verify that the corrupted block belongs to the segment
you think it does, or belongs to a segment at all?
select owner||'.'||segment_name, segment_type from dba_extents where
file_id = file# and 67108870 between block_id and (block_id + blocks
- 1);
--
Jeremiah Wilton
http
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
of starting the instance on the new ORACLE_HOME and running an upgrade
script? Why would someone undergo the disruption and complexity of a
full export/import when you can just leave the data where it is?
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
Create the new ORACLE_HOME (8.1.7)
Patch
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
Which filesystem/volume manager are you using, if any?
That is potentially where you would want to look if the async write
queue is getting backed up. Just shutting off async is a terrible
suggestion from EMC. I am suprised at them.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Mon
If you trace the listener you will see that it is looking for
.protocol.ora with a leading period. This is a documented bug. Just
copy protocol.ora to .protocol.ora.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Fri, 12 Apr 2002, Sajid Iqbal wrote:
We used to use the protocol.ora
extent_management from dba_data_files df, dba_tablespaces
ts where df.tablespace_name = ts.tablespace_name and file_id = 2;
EXTENT_MAN
--
LOCAL
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jeremiah Wilton
INET: [EMAIL
Here's a way on unix:
strings $ORACLE_HOME/lib/libclntsh.so | grep ^Version [7-9]
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Thu, 28 Mar 2002, Harvinder Singh wrote:
In batch script If we need to verify the version of oracle software on
server we issue:
select * from v$version
Does anyone have information on the location and format of the
whitepapers and presentations from OpenWorld 1999? Was it produced on
CD that year? If so does anyone have a copy?
If it was published on the web, does anyone know where and if it is
still there?
--
Jeremiah Wilton
http
of the application
software, not the database.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Wed, 20 Mar 2002, Jeroen van Sluisdam wrote:
The only way to limit your connections is through the
max_sessions parameter. As far as I know there is no
queuing mechanism for this available
is hanging. This information can
be forwarded to Oracle Support.
BTW, Oracle Support should have already suggested all these things to
you. They are standard hang diagnosis steps.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Tue, 19 Mar 2002, Grabowy, Chris wrote:
Here
The procedure in the 9i docs is limited, and does not include recovery
of a whole database, or any read/write datafiles up to and past
resetlogs.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Tue, 19 Mar 2002, [iso-8859-1] Connor McDonald wrote:
The 9i doco contains a section called
Gopal,
Would you mind posting the procedure for recovering past resetlogs?
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Mon, 18 Mar 2002, K Gopalakrishnan wrote:
I have once recovered a 8.0.5 database on Solaris using the backup (pre
RESETLOGS) and the archive logs of pre
Seattle listers,
Rachel Carmichael will be in town this weekend. If anyone wants to
get together Sunday evening with us and possibly some of the
Amazon.com DBAs, let me know.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
sizes are fine.
Robert F., Here's one for ya.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
-Original Message-
Sent: Thursday, March 14, 2002 8:19 AM
To: Multiple recipients of list ORACLE-L
An Oracle Support technician recommended that I try to aim for three log
switches
1 - 100 of 183 matches
Mail list logo