you did not send it, but...praps something
with your listener.ora?
-Original Message-
Sent: Monday, June 25, 2001 2:23 PM
To: Multiple recipients of list ORACLE-L
It is the same with mts_dispatchers=TCP,2
Ivo
-Original Message-
Sent: Monday, June 25, 2001 07:22 PM
To:
Title: RE: db_file_multiblock_read_count/max i/o
thanks Connor. Excellent info.
Lisa Koivu
Ft. Lauderdale, FL, USA
-Original Message-
From: Connor McDonald [SMTP:[EMAIL PROTECTED]]
Sent: Monday, June 25, 2001 2:18 PM
To: Multiple recipients of list ORACLE-L
Subject: RE:
Ask your SA to check unix level parameters for unix kernal are OK.
You may get those current parameters by using command 'sysdef' and
check with your platform specific oracle installation guide param suggested
in that.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of
offline normal is just fine :)
joe
[EMAIL PROTECTED] 06/25/01 02:51PM
Do I need to make the tablespace READONLY before cpying it to
another disklocation - ora can I simply - take the file offline - and copy
the fileacross-- Please see the official ORACLE-L FAQ: http://www.orafaq.com--
To properly move a tablespace you should put it in read only mode so the
header is not written to. Copy the data files, bring the tablespace
offline, rename the files, bring it online and make it read write. You can
do this all while the database is up and running.
Walking on water and
Hi Joe,
EMN0 is responsible for AQ. I assume
thatDave is on 8.1.7. If yes, then AFAIK that message related to EMN0 is
just 'normal' behavior
Regards,
Ed
License high water mark is exactly
that, the max number of connections to the database(if i remember correctly),
what lends you
Hello,
The upper limit for a server running NT is 2gb, because usually only 4gb of
memory can be installed. However, I believe that with the patch installed,
enabling NT to go above 4gb of ram, it will also increase the upper limit.
KK
-Original Message-
Kanagaraj
Sent: Monday,
Title: Does anyone have experience tuning wait event reliable message
I'm starting to see this event as we throttle up our Siebel application load tests. I was unable to find anything on Metalink and I'm getting vague responses from Support. We're using MTS on 8.1.6.3 running Solaris 8. All
yes it is. 9i removes that restriction.
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Monday, June 25, 2001 11:23 AM
To: Multiple recipients of list ORACLE-L
It may
Hi,
I currently have OWS 3.0.4 and RDBMS 8.0.5 running on the same NT 4.0
machine. I need to upgrade the DB to 8.1.6. Has anyone experienced any
problems running that version of OWS (we will upgrade that later) with RDBMS
8.1.6 (on the same machine)??
Thanks,
Mike
--
Please see the official
Does anyone have an idea of what percentage of total memory should be
reserved for NT? Say I had 600m of memory available. How big could my SGA
be and still have NT run properly?
Ron Smith
Database Administration
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, June 25, 2001 2:33
I would have a three table set up.
Your policy detail table, your vehicle table, and your vehicle_policy lookup
table.
I generally use this format to resolve many to many. Most of the time you
either know the vehicle or policy type. Which will keep you in the lookup
table and only go to the
While installing iAS 1.0.2.2. I get a
Could not initialize NLS Subsystem
Dialog box.
In Metalink there is a similar reference for this error, basically when
re-starting the forms service oracle cannot locate some .msb files.
How can I fix this for iAS 1.0.2.2.?
I logged a TAR, just curious
I have a treasury application that needs to be up 24 x 7 except for
scheduled downtime. Is there any way to guarantee an app will be available
24 x 7 on NT? Is anyone faced with this?
Ron Smith
Database Administration
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ:
The reason you were bounced is not something that can normally be
answered from the server end.
It requires some detective work, often a lot of it.
The problems that I have dealt with when helping list members
have *always* been unrelated to the list.
Usually the users local mail server,
b/c the DLM is intra-oracle now.
no need for OS level locks on shared filesystems.
it's all handled by Ozracle...
-Original Message-
Sent: Monday, June 25, 2001 3:41 PM
To: Multiple recipients of list ORACLE-L
Hi,
I currently have OWS 3.0.4 and RDBMS 8.0.5 running on the same NT
Title: RE: * Sr. Oracle DBA Needed in Kansas City, Kansas area..
Sorry Ken. I thought I finally figured out what employers want. What do I know. I work for a company who has different colored chairs depending on what 'level' your job is. Like I care. I said give me the color chair the janitor
Schoen Volker wrote:
Hi list,
I#m trying to install Oracle 8.1.7 on Redhat Linux 8.1.7.
First of all, I'm a newbie in Linux. So installed Redhat Linux. I have done
what Oracle docs says about pre-installation tasks on Linux. I've created a
user oracle, two groups oinstall, dba the
Kimberly,
We're on the same wavelength, as I was thinking the same thing.
Procrastinating on something that you know needs to be done
is not an ethical way of dealing with this, IMO.
Jared
Title: Multiple Oracle Instances on NT
Hi everyone -
I have worked exclusively with Oracle on Unix, but not at all with Oracle on NT. Our users have come to us with a requirement to run an application with their database on NT. They want to build both a test and production environment on
I'm pretty sure that this combination is not certified by Oracle.
-Original Message-
Sent: Monday, June 25, 2001 3:41 PM
To: Multiple recipients of list ORACLE-L
Hi,
I currently have OWS 3.0.4 and RDBMS 8.0.5 running on the same NT 4.0
machine. I need to upgrade the DB to 8.1.6. Has
Currently, we have Java based reports running against an OLTP database.
Connection pooling is being used via JDBC and threads are used to populate a
data holding table (built on the fly since the reports are custom with
different sorting options,different sections, etc)which is then used to
You suck up half of that memory easy for Oracle and NT would run just fine,
as long as there aren't a whole bunch of other applications running on the
server!
Kev
-Original Message-
L.
Sent: Monday, June 25, 2001 3:54 PM
To: Multiple recipients of list ORACLE-L
Does anyone have an idea
I don't know too much about their IS dept. I have my
resume in with them for a couple of Oracle related
positions, but haven't gotten any feedback yet.
Ken
Sorry Ken. I thought I finally figured out what employers want. What do I
know. I work for a company who has different colored
Wow what a can of worms that has just been opened!!!
KK:)
-Original Message-
L.
Sent: Monday, June 25, 2001 4:07 PM
To: Multiple recipients of list ORACLE-L
I have a treasury application that needs to be up 24 x 7 except for
scheduled downtime. Is there any way to guarantee an app
Ron,
my experience has been that it all depends.
If your NT server is being administered by a sane, conservative SA, who does
not treat it like a desktop machine (hey, lets downloaded the latest free
Java tool), then it might suffice.
It also depends on the load you will be asking it to
I just always figure that if I am doing my job properly, they will be
wondering why they pay me what they do (too little, but more than they think
they should, considering nothing ever goes wrong)
deliberately letting something fail so as to point out a problem is
definitely NOT the way to
I think I may have confused some, regarding my previous post. The coverage and
amount is specific to the vehicle. It is not a set amount. For example:
Method #1
Vehicle/Coverage Table
Seq Year Type Annual_Miles Comp_Ded Comp_Prem Towing_Ded
Towing_PremPip_Ded Pip_Limit
Title: Multiple Oracle Instances on NT
I
would say it depends on the size and amount of connections. Currently we
have two instances running on one NT server, but they are not very large, only a
couple of gigs. The machine is a dual 550 PIII with a gig of ram. It
seems to run fine, except
thx...for me, I would tying the IBM
SAs up and asking about everything they
see or touch. I'm like that.
Ross,
I agree. Alas, I jumped into this issue a little late
and everything has already been decided. So all I
can do is react.
You got me confusedthey are *raising*
BUFPCT
Title: Multiple Oracle Instances on NT
Lisa,
I am
not an Oracle expert, but I can tell you from my brief experience that you
should try to convince your users and management to NOT put test and production
on one NT box. If you have something go wrong on the test it may require a
bounce of
OK, after my vacation, I'll wade back into the fray!!
Ron,
To start with I do not believe it possible to guarantee that NT will be up
24x7, never mind Oracle. That is the main reason that we use Oracle ONLY on
Unix (in one flavor or another) here. All of our NT servers require a periodic
I think I may have confused some, regarding my previous post. The coverage and
amount is specific to the vehicle. It is not a set amount. For example:
Method #1
Vehicle/Coverage Table
Seq Year Type Annual_Miles Comp_Ded Comp_Prem Towing_Ded
Towing_PremPip_Ded Pip_Limit
Possible? Yes.
Likely? No.
Most NT system admins suck. Sorry guys, but it is true. It is a technology
that has been made available and easily accessable, many people (cooks,
waiters, wendy's employees) who are not truely System admins or even
computer geeks have found themselves working as
Title: RE: Griping about auditing (not the Oracle Kind)
In a perfect world or even a sucky world, yes. But the nightmare scenerio that was laid out wouldn't allow proactivity on their part. The inconvenient time thing was due to the fact that the proactive items they wanted to to do were
a design issue, correct? build a robust and resilient environment and you
can have the high-availability you seek. contingencies for x breaking and y
taking over, where x is any viable component; physical/logical components,
applications, memory/memory structures, processor(s)/processes, files,
Somebody should let Dell know. www.dell.com
They run on NT. When's the last time you heard
about their site being out?
A $40 Billion company can't be all wrong about NT, can it?
-Original Message-
Sent: Monday, June 25, 2001 4:58 PM
To: Multiple recipients of list ORACLE-L
OK, after
Hey Gene,
thanks for the response.
if OS cache hit is at good enough and BUFPCT is 25%
why on earth raise it?
-Original Message-
Sent: Monday, June 25, 2001 4:54 PM
To: Multiple recipients of list ORACLE-L
thx...for me, I would tying the IBM
snip, as per ThaterProtocol
--
...Dancing in Speedos to an Afro-Cuban drum beat.
Scott Shafer
San Antonio, TX
210-581-6217
Do not throw cigarette butts in the urinal. It makes them soggy and hard
to light.
-Original Message-
From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
Sent: Saturday, June 23, 2001 5:36 PM
To:
Please see prior post. The formatting seems to be hosed up.
-- Forwarded by Tracy Rahmlow on 06/25/2001 03:15 PM
---
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
I agree with His Chrisness on this one.
If the avg(NT Admin) avg(Unix Admin), we'd
all be reading this mail on Window's boxes.
Er.what I mean to say is..
sly grin
but, in all seriousnesswhen there is a way
to find a *very good* NT admin out of all the
Wendy's employees, then NT
Hi
I am getting following eror when I am executing following command.Let me
know it Is teh permission problem or any thing else?
$ls -la
rw-rw 1 oracle dba12502 Jun 22 17:09 rapid_ora_14247.trc
$ tkprof rapid_ora_14247.trc rapid_ora_14247.trc.out
TKPROF: Release 8.1.6.2.0 -
I have several questions answers for wich I couldn't find in FM (not that I
tried too hard :-) ).
1. If LONG or LOB takes more than 1 block - how part of the last block left
free is used? Can it be used to store part of another LONG or LOB which more
thatn this free peace? I think not but not
Lisa,
I have worked exclusively with Oracle on Unix, but not at all with
Oracle on NT. Our users have come to us with a requirement to run
an application with their database on NT. They want to build both a
test and production environment on the same NT box.
I would like to know some basics
Man,
It is formally TOO WEIRD you wrote that.
I *just* took my first African Dance class, and
really dug it. wow.
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Monday, June 25, 2001 5:13 PM
To: Multiple recipients of list ORACLE-L
...Dancing in Speedos to an Afro-Cuban
Is your unix user id a member of the dba group? If not, that is your
problem. Have your dba grant read to world for that trace file, i.e.,
chmod 664 rapid_ora_14247.trc
Scott Shafer
San Antonio, TX
210-581-6217
Common sense will not accomplish great things. Simply become insane and
You did not have enough contiguous space to build the extent.
-Original Message-
From: Mitchell [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 25, 2001 5:28 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Ora-1654 Unable to extend index on tablespace
Dear DBAs
Title: RE: Griping about auditing (not the Oracle Kind)
I
suggest CYA as much as possible and escalate the issue and begin search
foranother job. Also if you are an FTE - now is a good time to go on
vacation or become sick. Because if something breaks damagement knows much
better how to
Could it be you don't have a contiguous segment at least 256? to satisfy the
request?
-Original Message-
Sent: Monday, June 25, 2001 4:28 PM
To: Multiple recipients of list ORACLE-L
Dear DBAs
I have a tablespace for index with 5 file with different size from
500mb - 2000 mb.
Title: RE: Griping about auditing (not the Oracle Kind)
The way I read it was that they aren't letting it fail because they want to make a point. They are letting it fail because they were told they could not fix it. Then when it did fail, they made sure it was real inconvenient for those who
Ross,
I've had Dell's site crash on me before, last April right in the middle of
customizing a system. They apologized, but I went with Gateway anyway.
Dick Goulet
Reply Separator
Author: Mohan; Ross [EMAIL PROTECTED]
Date: 6/25/2001 1:12 PM
Seema,
There is no way to find that out.
Unless, the init.ora uses ifile option and the file pointed to by ifile
contains all the parameters. In that case you can query v$parameter view to
see what ifile points to.
By default Oracle looks for it in the $ORACLE_HOME/dbs directory.
HTH,
- Kirti
Wow. They must have known it
was you, Dick! G
solast Aprilproceeding
scientifically, that's less than
one crash a year...better than
five nines, right?
;-
-Original Message-
Sent: Monday, June 25, 2001 4:47 PM
To: Mohan; Ross; Multiple recipients of list ORACLE-L
Ross,
Mitchell wrote:
Dear DBAs
I have a tablespace for index with 5 file with different size from
500mb - 2000 mb.
Total tablespace size is 6g and used 5317mb abote 86.13% usage.
I got the error today.
ora-1654 unable to extend indx sechma.indexname by 256 in
Mitchll,
The index was trying to extend according to the next_extend parameter in
dba_segments for that object. From your message I can infer that the largest of
the available free space chunks in that tablespace was short 256 bytes. Try the
following query to tell you what is going on in
Get out of my head! The level of depravity contained therein is not for he
likes of mere mortals!!!
Scott Shafer
San Antonio, TX
210-581-6217
Common sense will not accomplish great things. Simply become insane and
desperate.
-Original Message-
From: Mohan, Ross [SMTP:[EMAIL
Why run oracle on NT? Run it on Unix and let the apps/appserver reside on
NT. I would seriously debate this requirement...
Scott Shafer
San Antonio, TX
210-581-6217
Common sense will not accomplish great things. Simply become insane and
desperate.
-Original Message-
From: Yttri,
Ross,
To this question I have a very straight answer.
I don't know. I asked a few people and couldn't
get an answer. Our SAs are not on site so talking
to them is a bit of a hassle, plus -as I said -
the decision has been made.
anyway, the changes have been done last weeked.
I'm monitoring
Can't you do it indirectly with an 'alter database backup controlfile to
trace' command? I seem to recall that there's a path to the initSID.ora
file there. 'Course, it could be just the generic path...I never tried
changing it to see...
HTH,
Mike
---
Check dba_free_space for the largest chunk available.
Also, note when it says temp segment, it has nothing to do with sorting or
temporary segments. This merely refers to the segment it is creating prior
to making it permanent segment.
Walking on water and developing software from a
Answers in-line (if it does not address your real questions, I
apologize... ;-)
Cheers !! :-)
-Original Message-
From: Hillman, Alex [SMTP:[EMAIL PROTECTED]]
Sent: Monday, June 25, 2001 4:36 PM
To: Multiple recipients of list ORACLE-L
Title: RE: Griping about auditing (not the Oracle Kind)
Alex,
Touche` , I didn't think about the
managers CYA ability. Most don't get theirjobs by being good, they
get there by knowing how to blame people and look good by
comparison... Theywere most definitely in a lose-lose
situation. I
Naw, only a city slicker or a dude would say that.
The farmer would have said she never did that before. :)
You know what the farmer said when his cow died?
__
||
||
||
\/
Geesh, he never did that before.
--
Please see the official ORACLE-L FAQ:
Hi,
Does anyone know the algorithm used in hash partitioning?
From what I have gathered so far, Oracle will evenly distribute data across
available partitions. Rows are inserted into partitions based on a hash
value of the partitioning key.
Having said that, if I create a hash partitioned
Can't you go to $ORACLE_HOME/dbs and see where the symbolic link is
pointing? ... or am I not grasping the full extent of the question?
--
Jon Walthour
Oracle DBA
Computer Horizons
Cincinnati, Ohio
From: Deshpande, Kirti [EMAIL PROTECTED]
Organization: Fat City Network Services, San Diego,
Hi,
We r building a application and need to specify the requirements of a
hardware for testing of its performance.
our performace metric includes mostly insert statements
10 million insert to 7 tables...then we have to execute some
procedures...then report.
our main concern is
Hi all
Lets say I have a table:
f1 char(10)
f2 char(2)
f3 number
where f1 is a name, f2 is a code and f3 is a number.
What I want to produce is a report that looks
something like this:
F1 F2 IS A F2 is B F2 IS C F2 is X
f1f3f3 f3
f1f3f3 f3
David,
This is about what I've come to expect from consultants/contractors in your mail
does not speak very well of
you. Most of the Critical projects that I worked on are/were run by top consultants
and good employees.
So it is too vague and broad to generalize certain job types. If you
Ron,
I'm going to say that it might be possible with some provisions.
eg - what does 24*7 actually mean in your context:
I believe 99% uptime gives 87 hours down per year
whilst 99.% uptime gives half a minute downtime per year.
Which end of the spectrum are you after?
I
Believe it or not we do run two mission critical 7x24 databases on NT with
few problems. The one system that is 'life and death' critical we run
redundant servers/databases just in case.
Debbie
-Original Message-
Sent: Monday, June 25, 2001 2:07 PM
To: Multiple recipients of list
in situations like that, you can and should document the fact that you made
the proactice request and had it turned down.
and then call that person's manager at 2AM to get permission to fix the
problem when it becomes an emergency
From: Bowes, Chris [EMAIL PROTECTED]
Reply-To: [EMAIL
Ramon,
That is not true. Setting NOLOGGING at the object
level only reduces the amount of redo generated for
bulk INSERT operations with the /*+ APPEND */ hint,
certain partition administration operations and of
course during the creation of the object itself. It
does not eliminate generation of
In this I would always make sure that a hard copy and an email was sent for
such a request and when the application is rejected ask him to reply thru
mail. So you have documented proof that your suggestions were rejected in
the first place. I only see one reason why the manager would like to do
Hello all,
I had seen a unix shell script on this list, which basically checks the space
availability for the archive log. If the space is less than 10% available for the
archive log, then it can send a pager or email stating that.
Does any one have a great script like this or do I have to
This will not give you solution. As backup of controlfile to trace will not
give initSID.ora file path.
Actually as per my knowledge there is no table which gives path of
initSID.ora file. What you can do is find all init parameter files in your
system. Then check SID part of your filename. If
please ignore this test msg, cheers
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: webmaster
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
see? just a test
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
I can supply the commiseration! You have my sympathies. I just left my
last job (also at a major online brokerage) because of exactly the same sort
of nonsense. In the good old days things ran fairly smoothly, technical
people made technical decisions, and the job was great. Then we got very
Hello Lisa...
I have been handling Oracle on NT last 6 months - and I much prefer UNIX. Here are
some things I learnt the hard way...
- can you run multiple instances of Oracle on one NT machine
yes u can. Another lister has replied to u about this - how one uses oradim80 to
create
On Monday 25 June 2001 20:00, Viraj Luthra wrote:
Hello all,
I had seen a unix shell script on this list, which basically checks the
space availability for the archive log. If the space is less than 10%
available for the archive log, then it can send a pager or email stating
that.
Here, I
hey,
why don't u querry v$parameter view.
the parameter ifile gives u the complete path and name of init.ora file.
saurabh
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, June 26, 2001 9:35 AM
This will not give you solution. As backup
Oh c'mon guys. Don't stop.
4 years replication, 3 years data warehouses - minimum
2 terabytes; Erwin, Designer 2000. Toad is a plus.
I go through 10 of these a day now. Ugh.
Yosi
[EMAIL PROTECTED] wrote:
Lisa:
You need to update this.
Must not be over 30 years old with a minimum
101 - 182 of 182 matches
Mail list logo