If ur upgrading from nt 5 to 2000 then he first opt should work. Just
install oracle on w2000 and start up the db coz the services are n nt. but
if ur goin in for a fresh install of w2000, it is better to create a fresh
db and import.
Alternatively u can create a db with the same config of existig
Seems to me you should just have your program try to lock tables in
exclusive mode. If it succeeds, then rollback. If it fails
(timeout), it opens another session while the 'lock table' is waiting,
and finds the blocker.
Otherwise, if you are only interested in sessions that are actually
blockin
Hi,
I would like to send an alert message to a client when a data row is locked for more than a certain period of time. For this can I write triggers on the system tables. If so on which table should I write a trigger to retrieve the table lock information. Are there any implications on writing
Richard,
if pctincrease is zero, and there are a large number of contiguous
smaller extents, SMON will not automatically coalesce the tablespace.
However, whether or not SMON does an automatic coalesce, if you need an
extent that is larger than any of the small ones, Oracle will coalesce
those sma
Madhu
To be perfectly honest, I had an unfair advantge as I worked in Siebel
Expert Services for 2.5 years, flying all over the world, with a broom in
one hand and a mop in the other, cleaning mess after mess at customer
sites,where usually the integrator stuffed things up mainly due to
ignora
Veronica,
Ah, rumors are a wonderful thing, especially if they turn out to be true
in our favor. :-)
Not unless it happens to be the only segment in a given tablespace. A
tablespace is as granular as an RMAN restore/backup can be set. Even
then, if you were to restore the tablespace to a previo
Jared,
You're right. There's a cool diagram in the Server Concepts
manual. So back to the original issue, scalabilty could be
affected in a dedicated server configuration depending on how
many files needed to be opened. I guess the problem could be
mitigated by fewer/larger datafiles and/or MTS
Rachel,
What I mean to say is when there are a lot of contiguous smaller free
extents.
Then coalesce will produce a larger free extent so Jay wouldn't have to
add a datafile for his table to grow.
On the automatically coalescing part, I believe SMON will only coalesce
when pctincrease != 0, or ha
Nothing can prevent an SA from wreaking havoc. The best we can do is narrow
the number of people who can and DBAs can be removed from that group, if
desired...
> - Original Message -
> From: "Jared Still" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>; "Tim Gorman" <[EMAIL PROTECTED]>
> Se
Rich,
The PGA is never contained within the SGA. In all architectures and on all
platforms, it resides separate. The PGA holds process-specific data
structures such as the "sort area", the "hash area", and some work areas
used during bitmap-index operations.
In "shared-server" (formerly "multi-
Veronica - No RMAN uses its own format, so only RMAN can do anything with
the files it creates.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, November 29, 2002 4:39 PM
To: Multiple recipients of list ORACLE-L
Hi Listers,
Is it true th
Hi Sean,
Me too I'm interested into your evaluation
methodology.
Thanks,
Kader
--- [EMAIL PROTECTED] wrote:
>
>
> Hello Sean,
>
> Would you mind sending me your evaluation? I'm in
> the process of performing
> a tool evaluation also, and this material would be
> invaluable.
>
>
> Thank
To be more precise, the real problems in application-partitioning for
OPS/RAC are UPDATE, SELECT ... FOR UPDATE, and DELETE statements due to
their WHERE clauses...
A SELECT statement does not force exclusive access to a database block and
so does not directly cause contention for a block in OPS/R
Hi Listers,
Is it true that I can do an import of a table from a full backup that was
done with RMAN?
That was a comment I heard today and doesn't make sense to me,
any comments?
Saludos,
Veronica Levin Enriquez
Compañía Cervecera de Nicaragua
--
Please see the official ORACLE-L FAQ: http://ww
On Friday 29 November 2002 08:43, Jeff Herrick wrote:
> My understanding
> from the question was that he was wondering whether each
> user's process in a dedicated-server configuration opened
> all of the datafiles too
Maybe not all of the data files, but the users dedicated server
process will op
how would coalescing help even if there were a lot of smaller free
extents? Oracle would do the coalesce automatically, there would be no
difference between manually coalescing or allowing Oracle to do it when
a new extent was needed.
--- Richard Ji <[EMAIL PROTECTED]> wrote:
> Coalescing might
Martin - Since I don't see any reply to your question (U.S. holiday), I
would start with the Oracle National Language Support Guide.
>From past postings on this list, I believe that you can export the data from
your American (8-bit characters) language database and import it into your
Chinese (16-
Jackson - It is a holiday for most of the U.S. folks, but hopefully someone
will get back to you. I am on Unix myself, so of no help to you. My laptop
was recently upgraded from NT to 2000 Professional, and the PC
administrators said that their experience was to not upgrade the system, but
to refor
Hemant,
After having rolled out ONAMES twice in two large organizationations, it was
apparent that the technicalities of ONAMES in itself is simple. It is in the
compilation and reconciliation of the various entries, their variations and
having to deal with the different default_domain/zone names
John - How many tables are we talking about here? In Oracle, you normally
use separate schemas (usernames) to separate unrelated objects. I was just
discussing this issue with developers recently. In past projects, sometimes
we've ended up with many tables, but no dividing principle. Other times,
w
Coalescing might help if there are many smaller free extents
that can be coalesced. But that still doesn't solve Jay's problem.
Because he doesn't want the table to extent at all since he just deleted
2 million rows so there are plenty of space within the segment itself.
Those free blocks should b
Madhu - Here is what I understand you to be asking: "How do I understand how
my 3rd-party application works with Oracle". Here would be my tips:
1. Search for any books besides the vendor documentation.
2. Read the vendor documentation VERY carefully. Often the vendor explains
very clearly how the
How are the inserts being done? Are you doing an insert with append hint?
-Original Message-
Sent: Friday, November 29, 2002 12:59 PM
To: Multiple recipients of list ORACLE-L
Okay, I can't figure this one out. Earlier this week I got an ORA-1653:
unable to extend table on a really big
did u coalesced the tablespaces?
-Original Message-
Sent: sexta-feira, 29 de Novembro de 2002 17:59
To: Multiple recipients of list ORACLE-L
Okay, I can't figure this one out. Earlier this week I got an ORA-1653:
unable to extend table on a really big table. However this was just after
Did you insert using direct path ?
If so the insert inserts after the highwater mark.
The highwater mark is not reinitialized after deletes.
So maybe that's why the insert failed.
--- "Miller, Jay" <[EMAIL PROTECTED]> a
écrit : > Okay, I can't figure this one out. Earlier
this
> week I got a
If you're thinking of going ONAMES, consider OID. There are downsides to
each, however, that you'll need to consider.
1) There is no mechanism in ONAMES to modify an alias. As per Oracle
Support, you'll need to drop and recreate the alias instead. (Or you can
modify the repository directly, bu
Okay, I can't figure this one out. Earlier this week I got an ORA-1653:
unable to extend table on a really big table. However this was just after I
had deleted over 2 million rows in the table and we were only inserting
30,000.
After reanalyzing the table I saw the following stats in DBA_TABLES:
Jeremiah
I _did_ say the background oracle 'processes' meaning
lgwr,dbwr,ckpt threads on Win32 specifically. My understanding
from the question was that he was wondering whether each
user's process in a dedicated-server configuration opened
all of the datafiles too
but I might have mis-under
Hello Sean,
Would you mind sending me your evaluation? I'm in the process of performing
a tool evaluation also, and this material would be invaluable.
Thanks,
Todd
"O'Neill, Sean" <[EMAIL PROTECTED]> on 11/29/2002 05:34:00 AM
Please respond to [EMAIL PROTECTED]
To: Multiple recipient
You'd hit "nfile" limits on HPUX [or at least HPUX 10.xx] pretty quickly.
Hemant
At 06:43 AM 29-11-02 -0800, you wrote:
None...only the oracle background processes (threads in Winblows)
access the datafiles/logfiles etc. All other communication is
done through the SGA. On some Unix variants you
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, Jere
No.
Multiple application servers are for redundancy and load balancing at the
ApplicationServer level.
Thus, all 4 application servers do the same job and transactions coming
in to them
are "load balanced' by the application. However, all 4 come in
to the one database.
The idea is to use both no
Hi,
I think you could use different schema's to distinguish between different
companies.
Jack
-Original Message-
Sent: vrijdag 29 november 2002 2:44
To: Multiple recipients of list ORACLE-L
can we arrange tables in a heirarchy form, just like we have
folders and under folders we have
No one here [including me !] knows Oracle Names or OID.
There's a profusion of TNSNAMES.ORA files for various databases
and applications but not Oracle Names.
I've been thinking and thinking of Oracle Names for a year and
haven't got around to it . [I guess you'll think twice before hiring
me as
On Fri, 29 Nov 2002, Jeff Herrick wrote:
> None...only the oracle background processes (threads in Winblows)
> access the datafiles/logfiles etc. All other communication is
> done through the SGA. On some Unix variants you _can_ reach
> a file_open max kernel parameter because each process (in a
>
I am that specific customer for whom that bug was opened. If you need more
information on this then let me know. This issue is still being worked on by
the group which wrote 9idataguard and the problem is not diagnosed yet.
What we noticed was that some archiver-rfs transfer processes become
extre
Thanks Jeff. The more I thought of it, the more I thought this had to be
the case (e.g. only SMON, PMON, ARCH, etc. actually handled file access),
but the topic raised just enough curiosity in my mind to seek another
opinion.
Ciao
Fuzzy
:-)
> None...only the oracle background processes (threads
I would not advise anybody to create objects using a
graphical tools, rely on scripts instead.
You can separate tables in a physical way and in a
logical way.
Physically you can use schemas and tablespaces to
separate tables. Logically , use a good naming
convention and then organise your stuff.
Jay,
My column counting skills might be off, but it looks
like the 'sr' stat is 0 most of the time, and scan
rate is the stat that I use to see if a machine is
memory starved.
Priority paging is a very good idea, but you'll
probably see even more benefit if you can mount your
oracle file systems
None...only the oracle background processes (threads in Winblows)
access the datafiles/logfiles etc. All other communication is
done through the SGA. On some Unix variants you _can_ reach
a file_open max kernel parameter because each process (in a
dedicated server scenario) opens it's own stdin/st
Jay,
My understanding is that the PGA is contained within the SGA, and that
shmmax is the "maximum size of a single shared memory segment". If you
set shmmax to 256MB and configure 1GB SGA, you should see it allocate 4
shared memory segments for that purpose. Some Unix variants have
limitations
Hi
We are currently running Oracle 817 database on a Windows NT, version
5, service pack 6. We need to upgrade O/S to Windows 2000. What should
we do on the database side, do we need to do a new Oracle 817 software
installation after upgrading O/S and try to startup the database or do
we need to d
Similarly, if you only want the procedure to be run IF
the base transaction does a commit then you can use
dbms_job (because the job submission process is part
of the same txn)
hth
connor
--- Stephane Faroult <[EMAIL PROTECTED]> wrote: >
Andrey Bronfin wrote:
> > Dear gurus!
> > I'm looking for
Saw an interesting post in comp.databases.oracle.server postulating that if
a shadow thread needed an open file handle on all files in a instance (or
even some of them), the process handle limit in windows could constrain user
scalability (e.g. too many users would result in ora-12500 unable to spa
Dennis & Ferenc,
Your discussion is a good read ...
You guys are able to understand how your applications are working WITH
Oracle, like using RULE/COST optimizer , Table Scans and also how it is
using the Oracle capabilities. I also wanted to know more about the
application running on top of Oracl
Hi there,
If you are interested I can send you a word document which I used to select
and evaluate an Oracle monitoring tool solution which might be useful for
adapting to your needs. We're an NT/W2K site.
BTW, we choose Quest I/Watch as our solution. Did not come across eHurkha
product during
Interesting. Thanks.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, November 27, 2002 5:54 PM
> SQL Injection and Oracle - By Pete Finnigan
>
> This is the first article in a two-part series that will examine SQL
> i
Building replication is usually somewhat lengthy process.
I spent sometime with an Oracle expert and built a skeleton script
to build my replication via sqlplus.
However, I use the replication manager to track the progress of
the build process and to check the results.
Yechiel Adar
Mehish
- O
Hello Guang
>From your note about weekly one day long import I think that you are dealing
with DW.
1) Am I correct?
2) Are there other updates to the database while the import is in progress?
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECT
Hi Guys,
We are in the process of configuring Oracle 9i Release 2 on
TRU64 Cluster (2 ES40s with RA3000, with SCSI cluster N/W no FC Channel
). So far we have done just the installation( No database creation). The
problem is that System looks very slow. Perform is perfectly OK when you
pe
On windows you can use the DBA console/OEM console (on 9i):
select the database then go to space->tablespaces.
Right click on tablespaces you get: Create.
Or - read about the create tablespace command in the manual.
(which you need to do anyway to understand what the GUI is doing).
Yechiel Adar
Title: Pro*C for Oracle 817 on Win2000?
We only apply patches as needed and where
needed.
For example: I had a problem with export taking a long
time on one system.
I installed a patch for this problem (after testing in
test environment of course) only on that database.
My motto is: If it a
52 matches
Mail list logo
