I had read from a paper that . NEVER EXCEED 55% of totaL memORY FOR NT . but
I KNOW THAT YOU CAN NOT EXCEED 2 GB TOO.
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Monday, June 25, 2001 10:53 PM
> Does anyone have an idea of what percentage of t
Hi All,
The Environment is Windows NT Server 4 SP5 with Oracle 8i Ver 8.1.6
Enterprise edition.
When i am trying to install forms6i it takes the current oracle home and
denies to install it as it is already being used.
Moreover i can not even change the oracle home from this list item of Forms
Thanks Jared for the script, have modified (the little that had to be done :-), and
works like a charm.
the next problem that I have, is that I want to make this an automatic affair, so I
want that this shell should first read the parameter, LOG_ARCHIVE_DEST, get the
archive destination from t
Hi,
Can some one send me a sample program on arrays ,like how to place values in
arrays( PL/SQL tables ) and how to retrieve values from the array etc.,
Thanks for your help in advance,
Venu
--
This e-mail may contain confidential and/or privileged information. If you are not the
inten
With 8i, you MUST use raws on Solaris. With 9i, you can use raws or
certified (only) cluster file systems. Veritos, for one, has an approved
Sun PDB Cluster file system. You can't do it with UFS or a "normal" VxFS -
even with 9i.
I would also argue with those who claim that journaled file syst
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 minim
Well the best way. If you are using a UNIX box. go to the $ORACLE_HOME/bin
and view the file dbstart. Here you will find the locaton of you
initSID.ora file. This is only true if you use the dbstart for starting
your database or you use the /etc/oratab file to startup the database at
boot up.
R
Title: RE: NOLOGGING
True,
but somebody on the list talked about "delete nologgin". I did not find immense benifit in this option. Any views on this?
-Original Message-
From: Gaja Krishna Vaidyanatha [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 26, 2001 6:10 AM
To: Multiple recipie
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
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.
Her
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 "ins
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
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
-
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
--
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 yo
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 re-
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
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 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 PR
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 ORACLE
Larry,
Care to tell us what white paper it was that you found helpful?
- Donna
-Original Message-
Sent: Monday, June 25, 2001 5:36 PM
To: Multiple recipients of list ORACLE-L
As I've been working my way through a lot of new features in 8 and 8i, I
have now moved on from the analytical
Listers,
As I've been working my way through a lot of new features in 8 and 8i, I
have now moved on from the analytical functions to the CAST function.
Anybody have some good links on this feature and great ideas on when to use
it to solve typical issues that we might have handled differently in
Greetings All,
Has anyone out there figured out how to format the output from the STATSPACK
report (statsrep.sql) into a format that is easily imported into an MS
Excel Spreadsheet eg. comma delimited ...
The way I see it there are two ways that this can be done. 1) edit
the statsrep.sql file so
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 ha
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 hir
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 insert
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 (differe
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 D
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 tab
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: http
Title: RE: Griping about auditing (not the Oracle Kind)
Alex,
Touche` , I didn't think about the
managers CYA ability. Most don't get their jobs by being good, they
get there by knowing how to blame people and look good by
comparison... They were most definitely in a lose-lose
situa
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
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 specificati
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
---
==
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
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,
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 PROTE
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 t
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
Wow. They must have known it
was you, Dick!
so"last April"proceeding
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,
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
All,
Over here we have a configuration control process that does track all
changes made on the production servers. We classify these changes as
"emergency" and "routine". An emergency change is one that needs to be done NOW
to keep manufacturing running. You can make the change and them do
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 P
You know what the farmer said when his cow died?
__
||
||
||
\/
Geesh, he never did that before.
"Walking on water and developing software from a specification are easy if
both are frozen."
Christopher R. Spence
Oracle DBA
Fuelspot
-Origi
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 wh
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)
I
suggest CYA as much as possible and escalate the issue and begin search
for another 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 av
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 DBA
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
desp
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 dru
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 "ba
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 tes
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 - Produ
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 tablespace
tablespacename.
The fol
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..
but, in all seriousnesswhen there is a way
to find a *very good* NT admin out of all the
Wendy's employees, then NT boxes wi
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]>
...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
> T
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
--
Please see the official ORAC
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 m
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,
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 reje
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 sy
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 Pip_Prem
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
u
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
>
> 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*
> BU
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
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 Pip_Prem
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 g
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
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 will
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 cha
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
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
genera
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
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 t
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
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 t
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 jan
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 4
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, some
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: http://www.orafa
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 wh
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 app
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 PM
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
Wouldn't that depend on which one it is? I know on NT, I can just take the
tablespace off line, copy it and then alter it using dba studio. However,
this will not work for the system tablespace, since I don't think you can
take it offline:)
Kev
-Original Message-
Kawatra
Sent: Monday,
One of the ways around this is to have "Executive Delegation" set up within
your change management procedures. Generally this boils down to
recognizing that there are some areas where your "experts" (generally the
SA and DBA) have more knowledge and need more flexibility than developers,
contrac
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 ha
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. A
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, J
Hi Joe,
EMN0 is responsible for AQ. I assume
that Dave 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 y
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 develop
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.co
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
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:
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: Mul
Hi gurus
How we know which initSID.ora file are in use in running instance if disk is
not designed as OFA?
Where can I found referenced tables name menas which Data dictionary table?
Thanks
-Seema
_
Get your FREE download of MSN Exp
I would go for creating a separate table for coverage , to make design more
flexible. If you add 10 cols in vehicle table and and a new coverage is
added later you will have to alter your table.
Still you think performance and space you can cluster the two tables .
-Big P
- Original Message
Do I need to make the tablespace READONLY before cpying it to another disk
location - ora can I simply - take the file offline - and copy the file
across
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vikas Kawatra
INET: [EMAIL PROTECTED]
Fat City Network Services
1 - 100 of 237 matches
Mail list logo