When you create or rebuild an index you usually lock
share the whole table. From 8.1.X and onwards you can
create and rebuild an index with the clause "online"
and transform that lock into a SSX lock. F.e.:
create index crow on ciclon(a) online;
Regards.
--- Harvinder Singh <[EMAIL PROTECTED]>
Title: RE: Sizing a new server
Yep,
the "money no object" lasted for a while, then the fab closed down
-Original Message-From: Kimberly Smith
[mailto:[EMAIL PROTECTED]]Sent: 10 July 2001
17:33To: Multiple recipients of list ORACLE-LSubject:
RE: Sizing a new server
A
List,
I am tuning a sql query, where I would like to force the optimizer
to use the index.
However not all the columns in the where clause are indexed. (all but 1)
eg.
query
SELECT SLS_ORG_CHILD,SLS_PRD_CHILD,SLS_AMOUNT AMOUNT,SLS_UNITS UNITS
FROM SLSTH3EE
WHERE SLS_PRD_CHILD = :b1
AND SLS_
Hi,
I have a requirement. Everytime when i make a session to the database i want the
Date Format to beas follows
'-mm-dd hh:mi:ss'
The existing default format is 'dd-mon-' and so I tried the following steps.
ALTER SESSION set NLS_DATE_FORMAT='-mm-dd hh:mi:ss' and put that in the
lo
Hi,
1 way to do this (for the current session) is to use in SQL Plus:
alter session set events '10032 trace name context forever, level 1';
To do for another session you could use dbms_system.set_ev or oradebug.
You could set if for all sessions by setting it in the init.ora file
I would reco
If You have indexed 5 columns in such an order
- SLS_PRD_CHILD
- SLS_ORG_CHILD
- SLS_YEAR
- SLS_PERIOD
- SLS_WEEK
Then you may use this index if where clause contains all 5 columns or first
4 or first 3
The definition of char and varchar2 is clear from docu that one is used for
fixed length and the other for variable.
We are reviewing one database desgin given to use from our developers in
that they have chosen to use CHAR(n)
data types at many places, even though the field can have variable leng
Or "metastat" if they're using Solstice DiskSuite instead of Veritas :0)
g
-Original Message-
Sent: Wednesday, July 11, 2001 12:00 AM
To: Multiple recipients of list ORACLE-L
Richard,
I think I know what you want. If you are trying to determine the actual
physical
disks that your d
Hi,
I have a requirement. Everytime when i make a session to the database i want the
Date Format to beas follows
'-mm-dd hh:mi:ss'
The existing default format is 'dd-mon-' and so I tried the following steps.
ALTER SESSION set NLS_DATE_FORMAT='-mm-dd hh:mi:ss' and put that in th
Hi List,
does anybody know where I can find memtool
for SPARC Solaris8 ?
It seems ftp.playground.sun.com is died.
Or could you advice another free tool with similar level of
capabilities ?
TIA,
Ed
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Shevtsov, Eduard
IN
Hi,
it depends on what contains this script :
for dba operations give them the necessary DBA privileges or sysdba or
sysoper
for ddl then give them system privileges like create table, index, ...
for dml then give them object privileges as select, update on
Best Regards,
Nabila Mekkaoui
DBA
My boss tells me that two major projects have come out of Berkeley in the
last 50 years. One was BSD; the other was LSD ... go figure.
-Original Message-
Sent: Tuesday, 10 July 2001 19:46
To: Multiple recipients of list ORACLE-L
Registry, services?
OH wait must be an NT thing, sorry,
On Jul 11, 2001 at 12:35:21AM, Rangachari Sundar wrote:
> Hi,
>
> I have a requirement. Everytime when i make a session to the database i want the
> Date Format to beas follows
>
> '-mm-dd hh:mi:ss'
>
> The existing default format is 'dd-mon-' and so I tried the following steps.
>
> AL
Hi Gurus,
We have an Oracle 8i database running under Solris 5.6. I have
production databases running on that. Due to space problem I have
created tablespace for which the physical datafiles are pointing to a
different linux Server thru NFSMount.
If in case the solaris has to be shutdowned next
Hi,
I have given that in Init.ora and also have tried DBMS_SESSIOM.set_nls both not
working...
can anybody know the solution.
Regards
Sundar
Greg Solomon wrote:
> My boss tells me that two major projects have come out of Berkeley in the
> last 50 years. One was BSD; the other was LSD ... go
Okay, okay I believe you all! But I DO remember Anita posting that it had
changed... time to dig through MetaLink, and bug Anita while I'm at it :)
Rachel
>From: "Farnsworth, Dave" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>S
Have you adjusted the kernel parameters It seems to be Linux's sticking point.
Although you have sufficient RAM etc either it isn't being fully utilized
or you are running out of processes, semaphores or some such.
There is a very good document that someone has posted a link to on
installing on
Scary stuff
NFS mounting tablespaces or any other database file that may affect your
integrity is not a great thing to do. NFS is UDP not TCP therefore there is
no checking to see that packets passed from one server to the other
are ever received. Your database has probably come up with that
Has ANYBODY ever been able to successfully use a response file? Please share the
secret with us!
Thanks,
Jay Hostetter
Oracle DBA
D. & E. Communications
Ephrata, PA USA
>>> [EMAIL PROTECTED] 07/10/01 04:35PM >>>
With WWS help, we have tried the non-interactive installation. We have
NEVER g
Hi,
or set NLS_DATE_FORMAT in the registry (32 bits) or oracle.ini (16 bits) in
all clients.
Best Regards,
Nabila Mekkaoui
DBA Oracle
-Message d'origine-
De : Vladimir Begun [mailto:[EMAIL PROTECTED]]
Envoyé : mercredi 11 juillet 2001 09:56
À : Multiple recipients of list ORACLE-L
Obje
try http://www.sunfreeware.com/
it may have a package with it in
Also search Sun as they may include it as part of a bundle that is on the
CD's with your system
HTH
Peter
At 07:51 PM 11/07/2001, you wrote:
>Hi List,
>
>does anybody know where I can find memtool
>for SPARC Solaris8 ?
>It seems
A couple of years ago I verified whether it was a good idea to use NFS
mounts, and Oracle Support told me that Oracle does not support NFS mounts.
They approve NFS from a handful of 3rd party vendors, but none of these are
OS vendors - not Sun, not Compaq, not IBM. 3rd party only.
Even NFS ove
We have just upgraded from 8.0.5 to 8.1.7 and are getting problems as
follows :
It appears to be related to dbms_job
Can any one help?
John
Errors in file /u01/app/oracle/admin/PRTGH1/bdump/snp2_28976_prtgh1.trc:
ORA-12012: error on auto execute of job 11223917
ORA-04031: unable to allocate 4
I would think that their behavior is laziness. When you create a form they
have a nice neat filed length to use to display their data in.
I would think that you would only use char these days for items that have a
known fixed length, Social security number, phone number, zip or postcode.
All ot
Guys,
One of our clients
wants us to audit connections to the DB. Apart from the obvious things is there
a way within auditing to view how they actually connected.
ie. from v$session
we can see whether it was via sqlplus, TOAD etc. etc.
I can't find out in
the docs whether this can be
> We have just upgraded from 8.0.5 to 8.1.7 and are getting problems as
> follows :
>
> It appears to be related to dbms_job
>
> Can any one help?
>
> John
>
> Errors in file /u01/app/oracle/admin/PRTGH1/bdump/snp2_28976_prtgh1.trc:
> ORA-12012: error on auto execute of job 11223917
>
> ORA-
MShahid,
There has been various discussions on this in the past. I have seen
arguements made that suggests that for all 1 character columns, a CHAR
format is better than a VARCHAR2.
Personally, I make everything a VARCHAR2. It provides a consistent view of
the data, and takes the question of "
John
There appears to be a number of excellent articles on Metalink regarding
tuning Shared pool space and
It seems your SGA needs a tune up to resolve this.
Go and search on the ORA-04031 to get the documents
If you don't have access let me know and I will see how I can help out.
Peter
At 0
Hi,
Put that statement in GLOGIN.sql and see.
Rgds
Vra Srinivas.
> --
> From: Rangachari Sundar[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Wednesday, July 11, 2001 2:05 PM
> To: Multiple recipients of list ORACLE-L
> Subject: How set Date
John,
Increase the Shared_Pool_Size parameter in the INIT.ORA file, and restart
the database.
I would suggest an increase of at least 50%.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, July 11, 2001 7:41 AM
To: Multiple recipients of list ORACLE-L
W
Okay folks, I *knew* I wasn't crazy! thanks to Anita for finding the post
that Bruce sent to the list, that had the metalink doc in it
There was also a bug filed on it (which was closed as "not a bug") bug#
1388186
It was filed for Solaris so this might just mean that the "feature" is
Solari
Andrea
I assume it is a shell (or batch) script, run from OS - you have "connect
internal" in your script so even if joe_doe runs the script, he connects as
internal, not as joe_doe. This can be your problem. Try it yourself - connect to
DB as internal (not yourself) and try to execute the comm
That is a bug. You have to apply, I believe, the 8.1.7.3 patchset.
-Original Message-
Sent: Wednesday, July 11, 2001 7:41 AM
To: Multiple recipients of list ORACLE-L
We have just upgraded from 8.0.5 to 8.1.7 and are getting problems as
follows :
It appears to be related to dbms_job
Ca
Andrea,
It depends - can we see the script?
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Tuesday, July 10, 2001 7:01 PM
To: Multiple recipients of list ORACLE-L
Hi all,
I wrote a script for developers to run. I have
svrmgrl, connect internal in the script.
> We have just upgraded from 8.0.5 to 8.1.7 and are getting problems as
> follows :
>
> It appears to be related to dbms_job
>
> Can any one help?
>
> John
>
> Errors in file /u01/app/oracle/admin/PRTGH1/bdump/snp2_28976_prtgh1.trc:
> ORA-12012: error on auto execute of job 11223917
>
> ORA-
I do not understand the difference between these two commands:
script_file > log_file
script_file | tee log_file
As I understand, the first runs and redirects its standard output to a log
file. The second runs and pipes its standard output to the tee command,
which copies its sta
Lyuda
That's not terribly difficult and you mentioned registry so I guess it is NT.
Make sure the files were copied after the original database was shut down.
The easiest way would be to reinstall Oracle and create the default database
with the same SID as your original database (maybe you alre
John:
List, please correct me if I'm wrong, but it appears that your
shared pool isn't big enough or is too fragmented. You can try
two things as I see it right now: (1) try pinning your large,
frequently used packages into the shared pool at instance startup
using the DBMS_SHARED_POOL package,
you could do alter system flush shared_pool from the svrmgr
Baskar
-Original Message-
Sent: 11 July 2001 14:17
To: Multiple recipients of list ORACLE-L
> We have just upgraded from 8.0.5 to 8.1.7 and are getting problems as
> follows :
>
> It appears to be related to dbms_job
>
> C
Hi,
I'm trying to tune a query which has several input
parameters. I used the bind variables in their place
to create an explain plan. Then I put some real
data in their place and created another explain plan.
The two plans were different. Which plan should I
be using in my tuning? The one wit
The NLS_DATE_FORMAT on the client always overrides the
setting in the init.ora setting. In addition the
NLS_LANG setting has an implied NLS_DATE_FORMAT of
DD-MON-YY for most settings (see note 93924.1 below
for more details) so on Windows clients, where
NLS_LANG is set in the registry by default,
Lee,
what version of the database? I'm thinking a logon trigger here, to capture
and write the session info to a table
Rachel
>From: Robertson Lee - lerobe <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Oracle Auditing
I knew you weren't crazy, Rachel. :)
So far this "feature" hasn't worked for me. I have been moving
the alert.log and let Oracle create a new one since 8.0.5 and now
on 8.1.7 when I was unware of this "feature". Now that I read about
it I am troubled. Oh I am on Solaris 7 and 8 BTW.
Hmmm...
I believ that you can also set this in the init.ora file, I know that I do:)
KK
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 11, 2001 7:40 AM
Hi,
or set NLS_DATE_FORMAT in the registry (32 bits) or oracle.ini (16 bits) in
all c
Rachel,
Hmm, doesn't ring a bell with me, but I'd expect the
Goddess to have a better memory than me ;)
According to the note Bruce Reardon mentioned (note
122401.1) the file cannot be renamed, as you
described. It might vary from platform to platform,
however. NT/Win2K, for example, will alwa
Kevin
Thanks...it that documented anywhere?
John
> -Original Message-
> From: Toepke, Kevin M [SMTP:[EMAIL PROTECTED]]
> Sent: 11 July 2001 14:06
> To: Multiple recipients of list ORACLE-L
> Subject: RE: unable to allocate 4096 bytes of shared memory -
> HELP
>
> That is a b
On Tue, 10 Jul 2001,[EMAIL PROTECTED] scribbled on the wall in...:
->Jared - we were wrong, there are worse applications than Remedy out there.
->I may be involved with one now. The application uses massive sql
->statements generated from a VB front-end connecting to COBOL on the server
->via OD
Many of you probably know this already, but it took me by surprise (and
caused no end of grief) so I thought I'd warn people.
I cloned our 8.0.4 production database onto another machine for some testing
we were doing (copy of entire Oracle filesystem, copied hot backup over) and
started it up wit
Title: RE: Sizing a new server - the Alpha Chip
Hi Bruce,
The list has done a good job of giving me warm fuzzies about the alpha. I did read through those articles describing the demise of the alpha chip. However, with the size and power of the 8400 I think we'll be OK on this server for
John:
This is bug #1640583.
Kevin
-Original Message-
Sent: Wednesday, July 11, 2001 8:54 AM
To: '[EMAIL PROTECTED]'
Cc: Toepke, Kevin M
Kevin
Thanks...it that documented anywhere?
John
> -Original Message-
> From: Toepke, Kevin M [SMTP:[EMAIL PROTECTED]]
> Sent: 11 July 200
Gene:
which everone is used in production. If the statements are dynamically built
with "variable" hard-coded values then you have a couple options.
1) Tune the query for the worst case
2) Tune the query for bind-variables and set "cursor_sharing = force"
in your init.ora
HTH
Kevin
--
Hi,
I wanted to know if there are any Oracle
User Groups in India. I visited http://www.eoug.com/usergroup-list.htm which
lists all the user groups, the two links provided for India don't seem to be the
proper ones. One is UKOUG and the other link does not work.
I am in Bangalore, India
L
Walt,
There's a grid in the following note listing the
different features, along with some info on new
features planned for Standard Edition in future 9i
releases.
Note: 149016.1 "[9.0.1.0] Generic Server README for
Oracle9i"
HTH,
-- Anita
--- "Weaver, Walt" <[EMAIL PROTECTED]> wrote:
> Speci
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
---
Appart from the bug why don't you frist try with a
shared_pool_reserved_size to a 15 or 25% if it isn't
enough ?. For instance there is another bug: 1397603.
However and just as a workaround try with the reserved
size thing.
Regards.
--- "Toepke, Kevin M" <[EMAIL PROTECTED]> wrote:
> John:
>
We are closing some cursors thru PLSQL scripts and thru JDBC as well. Every
time we run one script the cursors are not getting closed . Instead they are
shown as inactive in v$open_cursors table . Next time you run the same
transction in the same session it makes those cursors as active but adds
m
I am not sure what you are talking about. However if
it matters to a NLS thing, try with setting NLS_LANG
to language and country character set and ORA_NLS33 or
ORA_NLS32 in the registry. The key is
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE and the HOME you
would need it.
If you were talking about the f
Lyuda,
If I understand your post correctly, your networking
folks didn't install Oracle on the new server, but
instead just copied the directory structures over.
This means you don't have any of the registry entries.
While it is theoretically possible to export the
registry keys from one server
oh yes but if in a client the parameter NLS_DATE_FORMAT is set to another
format , the generic format set in init.ora is not taken.
Best Regards,
Nabila Mekkaoui
DBA Oracle
-Message d'origine-
De : Kevin Kostyszyn [mailto:[EMAIL PROTECTED]]
Envoyé : mercredi 11 juillet 2001 14:06
À : M
I've done this myself many times. This is the easiest way that works for
me.
1. Install Oracle on the new machine (B) with the starter database. This
sets up the registry correctly and gives you the database and listener
services.
2. Delete the ORANT or ORAwhatever folder on B. You don't ne
>
> try http://www.sunfreeware.com/
> it may have a package with it in
> Also search Sun as they may include it as part of a bundle
> that is on the
> CD's with your system
>
It's absent there. It used to be unbundled. SUN didn't support it.
May be things have changed ?
Thanks for t
My take on this is... if modifying the script won't hurt anything, do so.
I'd rather do MORE than less when it comes to being proactive with Oracle.
>From: "Richard Ji" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: R
Rachel,
Version is 8.0.5.0.0 - any good ??
TIA
Lee
-Original Message-
Sent: 11 July 2001 14:36
To: Multiple recipients of list ORACLE-L
Lee,
what version of the database? I'm thinking a logon trigger here, to capture
and write the session info to a table
Rachel
>From: Roberts
Sundar,
What you did obviously works, for the most part, but is totally unsupported
by Oracle and I would advise that you move that datafile back onto the local
file system as soon as possible. Why one may ask; Well the reasons are varied,
but mainly revolve around the reliability of NFS on
SORRY, I forgot to tell you that if you export and
import the registry, you cannot change the name of the
instance because of the services. If don't you do it
this way, you'll need to install the software and
create the database and the services as well.
Regards.
--- Rangachari Sundar <[EMAIL
Jay,
Did that several months ago with our HP-MPE box. The problem was that we
changed the IP address of the box and brought a new one online, with the old
ones original IP. Now MPE has NO idea of what a DNS server is so one has to
bury the actual IP address into things like listener.ora and
The "tee" command simply does what you say: it writes a copy to a file
as well as writing it to the console. You could get a similar result by
tail -f log_file
script_file >log_file &
Are you writing a script that needs to have two stream outputs? Or is it
important that you watch the script as
Anybody know the associated command for a Hitachi disk farm? (we've got
7700 and 9900's here).You would think the thing handles our files,
makes coffee, and washes my car every Saturday morning by reading the
marketing literature. :-) We are on AIX 4.3.3 w/ Oracle 8.0.5 headed
to 8.1.7.
Wow! Your ONS is frequently down? What version and what server? I've been
running ONS on an 8.0.5.0.1 DB on OpenVMS for 419 days with the only
interruption being a planned IP Class-B-to-Class-C upgrade on the network
(Note: The SERVER didn't need rebooting -- just the networking!). Our
backup
The TEE command basically duplicates the output. It sends a copy to the
file specified and a copy to the standard output. This is the difference in
just redirecting it. When you redirect it, none goes to standard out, just
to the file specified.
-Original Message-
Sent: Wednesday, Jul
For the list, because we have already discussed it... nope, it's an 8i
feature
>From: Robertson Lee - lerobe <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Oracle Auditing
>Date: Wed, 11 Jul 2001 07:11:43 -0800
>
>Ra
Hi Gaja (AKA "oraperfman"),
Why search google when I can just ask you? :-)
We had some NetApp sales drones here last week and they made tremendous
claims about their performance with Oracle. The sales engineer claims to
have been an Oracle DBA for a few years and he made a compelling case but I
Thanks Rachel. I agree. But I am still troubled by one thing. If I do adopt this
method. What if after I copy the alert.log and before null it, Oracle writes
something (a line or two) to the alert.log? It seems that I will lose those
messages.
What do you think?
>>> [EMAIL PROTECTED] 07/11/
tee copies its standard input to its standard output AND the log_file.
HTH
David Lord
-Original Message-
Sent: 11 July 2001 15:12
To: Multiple recipients of list ORACLE-L
I do not understand the difference between these two commands:
script_file > log_file
script_file
It might be the bug.
The Oracle bug number is 1397603. According to Oracle, the bug involves a
memory leak in their internal caching mechanism. The workaround is to put
the following line in the init.ora file, and then restart Oracle:
_db_handles_cached = 0
This is supposed to disable the bug
Title: Oracle on NT unattended installation
Dear list !
Is there a possibility to do an unattended installation of Oracle server (8.1.7) on NT (Win2000) ?
I mean an installation with a script or so without answering questions and clicking 'Next' during the installation.
If there is such a poss
Depends, if your using bind variables in production, then you can expect to
have a very static choice of explain plans.
Although bind variables are great for promoting more efficient use of the
shared pool, you do hinder the optimizer's ability to use selectivity and
histograms to detirmine if an
The access plan obtained with bind variables is a
guess plan because the optimiser lacks information.
The plan obtained with real data is a definitive plan
because the optimiser knows everything he needs in
order to make a decision.
It's nice to used bind variables to save on parsing
but real
Fellow LISTERS,
Is anybody running 9iAS on MicroSoft's IIS ?
Damagement has reservations on using Apache since it is Open Source. I guess
they fear hack attacks.
Any information will be highly appreciated.
TIA
Tavo
begin:vcard
n:de Urioste;Luis Octavio
tel;fax:850.455.0673
tel;work:850.457.3
Title: RE: Sizing a new server - the Alpha Chip
Only
the support issue would bother me. From two standpoints: 1) Compaq and 2)
Oracle.
Compaq
has made many promises with it's Digital acquisition, but has not really lived
up to them. The OpenVMS development and alpha development has
gr
Steve;
We use netapp filers at our current location. I really like them myself.
>From a backup point of view, we only take our databases down for about 5
minutes each night and still get a full cold backup.
On the netapp you just stop the DB, make a new snapshot, and then restart
the DB. A
We had configured long time ago Oracle Aps-Fixed Asset management on NT4.0
under local "ADMINISTRATOR"
account. The server is connected to the network domain, but we did all
installation by logging in as "ADMINISTRATOR".
Now we have created another local user, grant him administrator role and
res
Lisa,
I went from a large AIX shop to a small shop with ALPHA. Find out what
version of the operating system you have. The newer versions of the
operating are supposed to be better than the older for administration. I am
currently at 4.0d which is off support and can not compare to AIX. As I
Yeah, you discovered one of the gaping holes in SQL Net.
Putting a password on the listener is of little help either.
As I recall, you can prevent someone from starting the
listener, but not from remotely stopping it.
Someone please correct me if I have this wrong, but we
tested it a few mont
The tee command duplicates its input, sending one copy to the file, and the
other to the screen (or the next command in the pipe).
You get to see your data and save it too.
Brian Norrell
Manager, MPI Development
QuadraMed
511 E John Carpenter Frwy, Su 500
Irving, TX 75062
(972) 831-6600
-O
Erik:
This is from the HP-UX man page for tee:
DESCRIPTION
The tee command transcribes the standard input to the standard output
and makes copies in the files.
What this means in relative English is that the output is recorded to a file
(as in script_file > log_file) but you see it
Hi all,
I wonder if anyone has seen this before.
I export an user A, then import it into user B in a different database
and everything is ok. Then I use the same export file to import into
user C in the same database as user B and all the "CREATE TYPE"
failed because Oracle retains the obj
erm... looks like 8i only for logon triggers.
Thanks anyway
Lee
-Original Message-
Sent: 11 July 2001 16:12
To: Multiple recipients of list ORACLE-L
Rachel,
Version is 8.0.5.0.0 - any good ??
TIA
Lee
-Original Message-
Sent: 11 July 2001 14:36
To: Multiple recipients of
Thank you very much to all who replied to this post and the post about
oradim. Mission was accomplished successfully and everybody is happy.
-Original Message-
Sent: Wednesday, July 11, 2001 10:09 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Lyuda,
If I understand your post correctly,
I would say that "it depends". You've got the field defined as a char(n) [which
I really wish you had specified what 'n' was]. Now is this field initially left
null and then later updated? Or will it be initially filled with a very small
value like '01' and then later updated to a larger (I gua
Hi,
I'm doing a migration from 8.0.6.2 to 8.1.7.1 on HP/UX 11.0. Because of all
sorts of storage manipulation and other fun stuff, I'm going to be using the
export/import method.
So, everything I've ever read or ever been taught about doing a full
export/import on any database of even smallish
Hi all,
I was measuring the i/o performance of my scsi drives and I have a quick
question that maybe someone could shed some light upon. Currently I am
using Ultra 2/Wide scsi conrollers, this is supposed to have an I/O of
80mb/s. Well, when I perform the test all of the machines seem to
Hi,
Oracle 816, I just had 13 unusable indexes (btree and
bitmap).
I have no partition and no sql*loader load so how come
those 13 indexes are unusable ?
=
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
[EMAIL PROTECTED]
_
Hi,
Oracle 816, I just had 13 unusable indexes (btree and
bitmap).
I have no partition and no sql*loader load so how come
those 13 indexes are unusable ?
=
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
[EMAIL PROTECTED]
_
Another thing to watch are the dbms_job entries, especially ones which interact with
other databases. For example a job which pulls data from another database and writes
back to that database the success of its efforts. If this job were to run in the
clone, it might perform this task before
Hi Everybody
I'm running 8.1.7 and i just read that i should have a second rollback
segment in the system tablespace.
Can someone tell me why this is and how big should i create it?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: hp
INET: [EMAIL PROTECTED]
Fat City
Been there, done that;-)
-Original Message-
Sent: Wednesday, July 11, 2001 7:57 AM
To: Multiple recipients of list ORACLE-L
Many of you probably know this already, but it took me by surprise (and
caused no end of grief) so I thought I'd warn people.
I cloned our 8.0.4 production databa
Your questions are good ones...
Driver issues may exist.
Contact adaptec, or scsi card maker.
- jeremy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, Californ
Luis DeUrioste wrote:
>
> Fellow LISTERS,
>
> Is anybody running 9iAS on MicroSoft's IIS ?
> Damagement has reservations on using Apache since it is Open Source. I guess
> they fear hack attacks.
> Any information will be highly appreciated.
>
> TIA
>
> Tavo
we tried but never got it working.
There is a bug in 8.1.7 in which the connect/disconnect causes a memory leak
in the shared pool. You need to patch to 8.1.7 and then apply a bug fix.
Not
sure what the bug number is but its up there on the ftp site. It took me
approximately
10 hours to get the first page regarding this issue aft
1 - 100 of 195 matches
Mail list logo