Success! I've now learnt, from our network security admin guy, that the
Firewall Manager on the new network is configured by default to timeout
inactive connections after 60 minutes. Even though all the user clients
are inside the firewall, the server is specially ringfenced because the
Rachel,
Thanks for the idea but the system is running 8i. I'll remember it for the
future.
Chris
Quoting Rachel Carmichael [EMAIL PROTECTED]:
Chris,
Have you considered using dbms_redefinition for your second case? That
would allow you to reorg and swap the tables without locking for any
Tom,
In my first example you are right that new inserts would use the space freed by
the deletes but the purge program is run every quarter (sorry for not stating
that explictly earlier). Therefore there is at most 2.25 years worth of data in
the tables when before the first purge there was 4
Niall,
In the first case disk space was the primary reason, performance improvement
being a positive side-affect, so as to avoid a major disk array upgrade. I know
that new inserts would use the deleted space in the pruged tables. However that
free-space within the table block isn't very
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tony Miller
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
Jonathan,
Thanks for your answer this clarifies a bit more
But it still bothers me that this program can swallow
4Gb of physical memory and 4 Gb of swap and it is still not
enough. You explain that the memory of pl/sql tables is not in
the sga so that's clear now.
What still bothers me is that
And all the +RULE queries you listed, where data dictionary queries anyway
(which is designed for RBO).
Tanel.
[TG]: I can't even spell 10g, so I'll take your word for it...
The OraApps 11i assertion did not sound right, so to verify I queried both
the V$SQLAREA view as well as the
Don,
Comments inline...
Yes! IME, there ARE still problems in the CBO, especially with complex
subqueries.
I have more than a dozen systems where management insists on staying
with
the RBO!
[TG]: With all due respect, what does management know about this stuff
anyway? They do not
Thank you for your reply,
Yes, you're quite right, I think the archive next to the cold backup is
corrupted. The hot backup is always succeeded. But I wonder why is my
cold backup is largely end up with internal error or corrupted archive
log files.
All I do for closed backup is shutdown
Are you certain that SHUTDOWN IMMEDIATE succeeded? There are lots of bugs
in MetaLink where it hangs or fails with ORA-00600...
on 1/12/04 7:04 AM, Wendry at [EMAIL PROTECTED] wrote:
Thank you for your reply,
Yes, you're quite right, I think the archive next to the cold backup is
Have you considered enabling DCD? This causes oracle to send pseudo-keepalive packets
periodically, which should keep your sessions active from the firewall's perspective.
You enable this by adding
sqlnet.expire_time = ??
to sqlnet.ora on the DB server, where ?? is the frequency (in
I've set it before to prevent IP trips to the router for programs that use
IP to talk to itself (like some backup programs that work over a network).
But like I said, it's probably my lack of understanding of how proper
networking is to be setup... :)
Rich
Rich Jesse
Two custom views [DDFS_TOTAL on DBA_DATA_FILES,
and FSH_TOTAL on DBA_FREE_SPACE]
which I create in the DBSNMP schema are now failing with
ORA-00942 after having set O7_DICTIONARY_ACCESSIBILITY=FALSE.
The database is 8.1.7.4 32-bit on Solaris8.
These views used to work with
--- Norris, Gregory T [ITS]
[EMAIL PROTECTED] wrote:
Have you considered enabling DCD?
Greg,
short of migrating to *nix, dead connection detection
does not work on win32. not in 8.1.7.4, not in
9.2.0.4.
possibly in 10g? ;)
Pd
This causes
oracle to send pseudo-keepalive packets
Have you checked that it doesn't go to the router when you
set localhost to the address of your eth0 adapter and that
it does when you set it to 127.0.0.1? I would be very surprised
if the default route was used to resolve route from lo0-eth0.
When you do netstat -r, your LAN network address
Title: Yep.it's a Monday..
While doing some SAN work, one of our intrepid Sys Admins unplugged the wrong cable, crashing 20+ production databases at the same time..Yeah, it's a Monday..
So, here I sit, waiting, while they scramble around, re-connecting cables and re-booting
almost as good as the SAN CE coming in and instead of formatting the new
SAN, format the existing one, wiping out OS/databases/redo logs, etc.
joe
Bobak, Mark wrote:
While doing some SAN work, one of our intrepid Sys Admins unplugged
the wrong cable, crashing 20+ production databases at the
Ew! Don't say that! The UPS guy is here replacing all the batteries (on
bypass) and adding another bank, so we're un-UPS'd for a bit.
Hopefully my unanswered Packer prayers transfer to today...
Happy Monday!
R2
Rich Jesse System/Database Administrator
[EMAIL
I had an SA do that to my 500G DW once, in the middle of the day.
Took a few minutes to figure out why tablespaces were successively
going offline...
Jared
Joe Testa [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/12/2004 08:54 AM
Please respond to ORACLE-L
To:Multiple
Mladen/Hemant,
I should have expressed myself more clearly. Suspend is not necessary,
it's only fast. Basically, with suspend, you don't put tablespaces into
backup mode. You
suspend, resync, split and start aonther instance as if it crashed. As no
I/O is
going to disk, datafiles aren't
FYI - I'm forwarding this on Lisa's behalf.
Please reply to [EMAIL PROTECTED] -
Please do not reply to m
Please do not reply to the list.
-
My employer, Fairfield Resorts (www.fairfieldresorts.com) is looking to hire a SQL Server DBA with several years' worth of
Title: Yep.it's a Monday..
My
damager just DTS'ed a bunch of tables that are critical for ourweb apps to
work back on themselves. When he set up the DTS he thought he was going
from our production box to our test box but did the DTS from production to
production. The problem was
I have to confess that I was the one who did it once. I was supposed
to test a new UPS for a VAX 4200, but I forgot to turn the UPS on.
UPS was supposed to send a shutdown command with 15 min. grace time, but
when I flipped the switch, everything just died. I did that after 18:00 but
I forgot that
I see that I never replied to the list for the answer, as given by The
Goddess herself. Rachel had me create a view of a view, putting the
function in the outer view while retaining the fields from the DECODE in
the inner view. The explain plan still isn't optimal, but now at least
the view can
Title: Yep.it's a Monday..
What
the heck... Monday story from last week..
Low
voltage guys were working under the raised floor in the datacenter to pull SAN
cable and network cables. Upon getting to the patch panel (wrong one), they
found no open ports on the Brocade Switch. so
Hi List,
I have following sql that runs in 1 sec:
SELECT b.* FROM RF_BALANCE_T b, rf_security_by_dceid s
WHERE
(s.award_number = 'ALL')
OR (b.award_number = s.award_number AND s.project_number = 'ALL')
OR (b.award_number = s.award_number AND b.project_number=
s.project_number AND s.task_number =
John, I know that fro RMAN tablespaces need not be in hot backup
mode. The trick with susspend is quick dirty way of achieving
the same effect as with the cold backup, without bringing the
database down. No RMAN involved.
On 01/12/2004 12:44:36 PM, John Kanagaraj wrote:
Mladen/Hemant,
I
David - Can you post the EXPLAIN PLAN for both?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, January 12, 2004 1:14 PM
To: Multiple recipients of list ORACLE-L
Hi List,
I have following sql that runs in 1 sec:
SELECT b.* FROM RF_BALANCE_T b,
Can you change it to this query:
SELECT count(1) FROM RF_BALANCE_T b, rf_security_by_dceid s
WHERE
(s.award_number = 'ALL')
OR (b.award_number = s.award_number AND s.project_number = 'ALL')
OR (b.award_number = s.award_number AND b.project_number=
s.project_number AND s.task_number = 'ALL')
That's fairly typical behavior. Try the following
SELECT /*+ NO_MERGE(x) */ COUNT(*)
FROM (your 1 second query) x
Kevin
-Original Message-
Sent: Monday, January 12, 2004 2:14 PM
To: Multiple recipients of list ORACLE-L
Hi List,
I have following sql that runs in 1 sec:
SELECT b.*
Title: Yep.it's a Monday..
Yeah,
it is a Monday. Vendor shows up to "fix" a minor problem my day gets
trashed. Oh well, job justification!!
Dick GouletSenior Oracle DBAOracle Certified 8i
DBA
-Original Message-From: Bobak, Mark
[mailto:[EMAIL PROTECTED]Sent: Monday,
Dear List,
I have a very strange query:
The table, data, indexes, constraints are set up exactly same
The query was running ok in the test database but paused the production
system.
It is also running ok in production if the primary key disabled.
Any ideas? Any input will be greatly
Title: Yep.it's a Monday..
Developer is saying functions are good - all functions referencing
dbms_sql bomb???
Help???
problem with dbms_sql
Compiling function FUN_CHANGE_PASSWORD...
Compilation error on function FUN_CHANGE_PASSWORD:
PL/SQL ERROR 801 at line 1, column 1
Hi Richard
Strangely, I've also never been to a management meeting where the reason for
my attendance was to enquire as to how the instance efficiency statistics
were this month. On the other hand when management reports take 3 days not 3
hours they're the first to complain. I wonder since we
Privileged/Confidential information may be contained in this message.
If you are not the addressee indicated in this message (or responsible for delivery of
the message to such person), you may not copy or deliver this message to anyone.
In such a case, you should destroy this message and
Developer is saying that applying patchset 9.2.0.4 broke dbms_sql or changed it so
that they cannot compile their procs referencing dbms_sql. Help?
-Original Message-
Sent: Monday, January 12, 2004 4:27 PM
To: '[EMAIL PROTECTED]'
to developer mailgroup?
1) Please tell me how to
My explanation for that would be that it is all driven by beans. If manager
learns that a resource is underutilized he/she immediately starts to plan
to switch it for a smaller (i.e. cheaper) resource. Unless you can express
performance in terms of beans it doesn't mean beans (so to speak) to
I'm sure that buffer cache hit ratio is still a big hit with the damagement.
You should also compile dictionary cache hit ratio (v$rowcache) and library
cache hit ratio. Damagement usually loves statistics, the more meaningless
it is, the more they love it.
On 01/12/2004 04:19:34 PM, Niall
Even stranger is, that you expect us to solve your problem without knowing
what exactly the problem is!
Does your query consist of a SQL statement? Does it have an execution plan?
Very strange, indeed.
Tanel.
Dear List,
I have a very strange query:
The table, data, indexes, constraints
Dear system mamager,
You have given very little to work from. Is the query a SELECT, UPDATE,
INSERT or DELETE? Can you produce explain plans for the query on both
systems? What made you consider disabling the primary key on production
(this sounds like a bold / crazy move, but I wonder why
Paula, did you try re-running catproc? Did your duhveloper follow the
installation instructions to the letter, or creatively, skipping the parts
he didn't like?
On 01/12/2004 04:34:25 PM, [EMAIL PROTECTED] wrote:
Developer is saying that applying patchset 9.2.0.4 broke dbms_sql or changed it so
On 01/12/2004 03:54:27 PM, system manager wrote:
Dear List,
I have a very strange query:
The table, data, indexes, constraints are set up exactly same
The query was running ok in the test database but paused the production
system.
It is also running ok in production if the primary key
I am only an egg, so I hope someone else can explain this to me.
Oracle Enterprise Edition 8.1.7.4.1 on Windows 2000
I was experimenting to see if an alter table enable validate constraint would cause
DML statements to wait. I thought it wouldn't. But in real life I see something
different.
I
Did you loon into v$lock? V$LOCK has columns REQUEST and LMODE and it would tell you
the mode
of the lock imposed by alter table. I would guess that enable validate would briefly
impose a shared lock on the whole table.
On 01/12/2004 05:29:25 PM, Jacques Kilchoer wrote:
I am only an egg, so I
It is not an expensive query.It runs really fast without the primary
key in production but
we dont have this problem in the test instance.
--
Original Message
Date: Mon, 12 Jan 2004 14:04:42 -0800
Even stranger is, that you expect us to solve your
You should first enable novalidate the constraint and then run enable
validate.
This way Oracle knows that any *new* DML can't invalidate data and can
calmly scan through the table without locking it, to see whether the rest of
the data is valid as well.
Another reason for blocking locks that I
Hi,
For taking Oracle9i OCP exam is it necessary to have attended a Oracle course by Oracle University.What is the minimum? Is any small course good enough?Can someone who has gone through this provide details? Thank you
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
Mladen,
I apologize - I didn't want to imply that you were not aware of the way RMAN
works. However, I am not sure I got my point across on the Hot backup issue,
so here goes...
You should not take a backup of a BCV mirror _without_ putting the whole
database in Hot backup, even if you suspend
www.oracle.com
do a search for certification. Its all explained
there. You can take an online course for $300. If your company is an oracle
partner the course is free.
- Original Message -
From:
A Joshi
To: Multiple recipients of list ORACLE-L
Sent: Monday,
Privileged/Confidential information may be contained in this message.
If you are not the addressee indicated in this message (or responsible for delivery of
the message to such person), you may not copy or deliver this message to anyone.
In such a case, you should destroy this message and
Dear List,
We have a developer here that is pretty good with the web stuff, but his strong
suit is not databases, or at least not Oracle.
He develops primarily in Cold Fusion, which I know little about.
I'm trying to teach him the difference between literal and bind variables, and the
test... We have been having mail problems.
Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional
Transit Authority1240 W. 6th StreetCleveland, Ohio
44113
--- Jeffrey Beckstrom [EMAIL PROTECTED] wrote:
test... We have been having mail problems.
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
yeah, I had 2 posts not go through today ... unless
I'm blocking my
Hi everyone!
Can anybody point me to any good documentation regarding disk capacity planning? Sharing your experience or approach will also give me so much help. I'd like to know other people's approach on forecasting the growth of their databases particularly on determining the (growth) rate of
54 matches
Mail list logo