Guy Harrison - Oracle SQL High Performance Tuning
Jonathan Lewis - Practical Oracle 8i
and at the moment - Couchman and Schwinn - Oracle 8i DBA Certification Exam
Guide.
Regards
Lee
-Original Message-
Sent: 14 August 2001 18:07
To: Multiple recipients of list ORACLE-L
On Mon, Aug 13
Hi All,
Is there any way to speed up the truncating a big table with 12 million
rows?
Basically, I implemented truncating that big table on Production, but it
affected the performance much, so I had to stop it in the middle of way. All
the rows were truncated but the HWM was not shrunk at al
Oh yes, and when I save up some money after buying the Certification book, I
should be purchasing DBA 101, can't remember who wrote that one though :-)
Lee
-Original Message-
Sent: 15 August 2001 08:50
To: Multiple recipients of list ORACLE-L
Guy Harrison - Oracle SQL High Performance
Title: RE: rman/standby
Ravindra,
Two thoughts
1) Why not copy the archivelogs as they are created by setting the log_archive_dest_1 parameter in your init.ora. This will make 2 copies of the archivelog file, the 2nd one of which can be either be local or to the remote server.
2)
Title: RE: Speed up Truncate tables
Chuan,
Are you sure you were using the TRUNCATE TABLE command rather than DELETE
It sounds as if you are running a delete, especially if the HWM was not shrunk
John
-Original Message-
From: Chuan Zhang [mailto:[EMAIL PROTECTED]]
Sent: 15 August 0
Title: RE: Splitting a database: pro and cons
Quick thoughts
Downside
Resource overhead of another instance (system temp tablespace memory etc)
Support requirements
Conectivity between the 2 instances via db_links although if theye are on the same server network traffic is negated
Upside
Upg
Dear gurus !
I have a table of phone calls , 2 fields : CALL_START DATE , CALL_END
DATE .
I need an SQL statement or a PL/SQL block to calculate the maximum number of
SIMULTANIOUS phone conversations.
Please help !!!
Thanks a lot in advance !
Andrey.
--
Please see the official ORACLE-L FAQ: h
Dear gurus !
I have a table of phone calls , 2 fields : CALL_START DATE ,
CALL_END DATE .
I need an SQL statement or a PL/SQL block to calculate the maximum
number of SIMULTANIOUS phone conversations.
Consider there are 4 calls ,
one started at 12:10 and ended at 12:40
Title: I admit this is dumb. NT/W2K Services?
Hi
Lisa,
Yes,
I agree it can be confusing. The service is a background process that provides
an environment for Oracle to execute in - I don't know about the specifics in
this case, but Oracle on Unix is comprised of two logical parts, the VOS
Quick and dirty solution:
Pick a time and look for all calls which started before that time and
ended after that time. That will tell you how many calls were in
progress at that time.
Repeat this at, say, half hour intervals, and graph the results. This
will show you a trend. Where it looks like
Give me some time :-)))
Jan Pruner
Dne st 15. srpen 2001 12:40 jste napsal(a):
> Dear gurus !
> I have a table of phone calls , 2 fields : CALL_START DATE ,
> CALL_END DATE .
> I need an SQL statement or a PL/SQL block to calculate the maximum
> number of SIMULTANIOUS phone conver
Quick follow up to the bitmap sizing for
larger files: I've quoted this 20-30,000
figure in my book as applying to both
'ordinary' LMTs and 'temporary' LMTs.
However following our discussions, and
a conversation with Ken Robinson from
Oracle, I've run a couple of tests on 8.1.7
and the 2-bytes
Ignore (or at least treat very lightly) the comments about DBWm.
Excessive database writes can cause log file sync waits, as
dbwr calls lgwr to write the log protecting the blocks it is
about to write. In this case, you will see v$session_event
for the db writers showing log file waits. Unfor
1. Create table CC with 2 fields: DT DATE, CALL_COUNT NUMBER .
2. Fill table CC with tuples with DT started from MIN(CALL_START) up to
MAX(CALL_END) and CALL_COUNT = 0. Step of DT value is 1 minute (or second =
36mil tuples/year).
3. for every tuple in a table of phone calls update table CC an
Pursuing Guy's method in a non-procedural way:
select
ts.timestamp,
count(*)
from
(
select
to_date('1-jan-2001','dd-mon-') +
(rownum / 1440) timestamp
from short_narrow_table_of_numbers
where rownum <= 1440
)ts,
phone_calls
where
ts.tim
Thanks Guy !
The problem is that i need it in one non-interactive PL/SQL block .
Thanks a lot !!
-Original Message-
Sent: Wednesday, August 15, 2001 1:00 PM
To: Multiple recipients of list ORACLE-L
Quick and dirty solution:
Pick a time and look for all calls which started before that t
Like the block editor Oracle used to make available ?
BDE or something like that?
DUL tool would be cool, too.
Especially, if it handled the odd-ball cases like LMTs and IOTs.
I would only use DUL on production if it was total S.O.L.
and there was nothing left (besides READING won't make the muc
How about: -
declare
l_count pls_integer := 0;
begin
for rec in (
select call_start time, 1 incr from table
union all
select call_end time, -1 incr from table
order by 1
) loop
l_count := l_cou
Anybody using Mamba without the luminate.net service. Opinions of
it.
Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional
Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216)
781-4204
Check the extent sizes... truncate can take a VERY long time if there
are a very large number of extents. At one point we had a large table
with approximately 60,000 extents (accidentally created with
INITIAL/NEXT 80k MAXEXTENTS UNLIMITED), which took about 2.5 hours to
truncate. After recre
http://www.dilbert.com/comics/dilbert/archive/dilbert-20010723.html
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique
Mar
David,
Here's the output from your suggestion based on a table
with the following rows;
CALL_STARTCALL_END
- -
01-AUG-2001 12:10 01-AUG-2001 12:40
01-AUG-2001 12:15 01-AUG-2001 12:30
01-AUG-2001 12:25 01-AUG-2001 12:55
01-AUG-2001 12:45 01-AUG-2001 12:47
Thanks for investigating and sharing this with us
- Babette
-Original Message-
Lewis
Sent: Wednesday, August 15, 2001 7:16 AM
To: Multiple recipients of list ORACLE-L
Quick follow up to the bitmap sizing for
larger files: I've quoted this 20-30,000
figure in my book as applying to bot
Rachel Carmichael wrote:
> wish we could... we are not setup to record the presentations. One of these
> years, when we become a rich users group (or is that an oxymoron?)
>
> Hey, I'm lucky I can persuade people to give me the slides and papers...
> there are a few people on this list who still
When you restored, did you restore the control files etc... EVERYTHING from
the cold backup? It should not have been looking at the new file at all if
you added it after the backup.
Now... rewrite your cold backup script to read the names of the datafiles,
logfiles and controlfiles to be backe
Hi,
Oracle'e block editor is called BBED and it will be in your
$ORACLE_HOME/bin. DUL will not be in standard oracle instalations and
it is a support tool.
--- Babette Turner-Underwood <[EMAIL PROTECTED]> wrote:
> Like the block editor Oracle used to make available ?
> BDE or something like th
living on the bleeding edge are we?,
let me try it on my 9.0.1 and let you know.
joe
>>> [EMAIL PROTECTED] 08/15/01 10:07AM
>>>Thanks to everyone who replied yesterday. It appears I had
already been onthe right track, as I did attempt backups with the database
in noarchivelogmode and m
Note that whenever a call starts, this increases the current number of calls
by 1, and whenever a call ends, this decreases the current number of calls
by 1. Hence you can "uncouple" the start and end times - you don't need to
know that a given start time and a given end time belong to the same ca
I'm working on this one, almost got a solution... ;-)
Kev.
-Original Message-
Sent: 15 August 2001 14:05
To: Multiple recipients of list ORACLE-L
Thanks Guy !
The problem is that i need it in one non-interactive PL/SQL block .
Thanks a lot !!
-Original Message-
Sent: Wednesday
Hi
gurus,
When my DB is starting I
am getting an error of corrupt block in controlfile (block 1, block #1)
Ora-00202
'c:\oracle\oradata\control01.con'
Ora-00207
I have 3 controlfiles, no
copies, sorry, shame.
In the init.ora I
commented the line of the control file No1, then it gi
Yes, so the maximum is 3, between 12:25 and 12:30. To explicitly show the
maximum (and a little histogram) you could amend it as follows: -
declare
l_count pls_integer := 0;
l_max_count pls_integer := 0;
begin
for rec in (
select call_start time, 1 inc
Yes, it's pretty good although it does take quite a punch out of the server
running it. What I really like is that it provides a deep look into the
database for non-dba types without allowing them to do anything harmful to the
database. I was somewhat surprised when I spent a little time teachin
Title: RE: I admit this is dumb. NT/W2K Services?
DING! (That's the light bulb going on in my head)
That makes complete sense. Thanks Guy for outlining this in email. I understand now.
It took me ~4 hours to create my very first ORA-600 on my w2k oracle database and crash it. :) Tha
She was from the Tammy Fae school of makeup application. Big hair too.
"Charles
Wolfe"
I found the problem--O/S enviroment variable NLS_LANG must be set. Thanks.
Paul Baumgartel
MortgageSight Holdings, LLC
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, August 15, 2001 9:10 AM
To: '[EMAIL PROTECTED]'
Thanks to everyone who replied yesterday. It appears I had alr
Yes. It does. But, as someone pointed out earlier, as an individual it's
only partially deductible. If you're a business then it is an expense that
can be offset against income (and thus is 100% deductible). If you're not
already a DBA (or at least in an IT field) then it's probably not
deduct
some hack writer who haunts this list. don't believe anything she says :)
>From: Robertson Lee - lerobe <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: RAID or NOT to RAID? What's the diff???
>Date: Wed, 15 Aug 2001 00
truncate doesn't change the hwm unless you drop storage
also, depending on the number of extents (not the number of rows), it can
take a long time to free up storage if you do truncate table ... drop
storage.
Oracle has to update the UET$ and FET$ tables for each extent you release.
>From: H
We have decided to get Hansen's IWOS system to interface with out
Utility Billing System and I am looking for any information about it
from organizations which may already have it.
Operating System
Number of Utility Billing Accounts?
How long have you been using it? size and growth ?
Are you
running it on 9.0.1 on linux no problems, only change to your
script was location of where to put the files.
i've not doing the controlfile thing, i've got a
repository.
joe
>>> [EMAIL PROTECTED] 08/15/01 10:07AM
>>>Thanks to everyone who replied yesterday. It appears I had
already be
Title: RE: Speed up Truncate tables
Chuan,
You can use the 'REUSE STORAGE' clause of truncate table. That's a heck of a lot faster if you have a whole load of extents allocated to the table. What it does is mark the table as empty and keep all extents.
However, I have a feeling that i
If all
three are corrupted, you have to run the "create controlfile" statement and to
make sure that you list all your data files and redo logs. You will loose
the archiving and RMAN (if you have it) info though.
At
least you will not forget now to backup control files regularly
;-).
D
Thanks to everyone who replied yesterday. It appears I had already been on
the right track, as I did attempt backups with the database in noarchivelog
mode and mounted but not open.
Hot backups, with DB in archivelog mode, worked fine. However, cold
backups, performed in the manner stated above
Thanks for the advice
>
>Jared-
>
>Have you tried wine? I've looked at win4lin, but they don't seem to
>support my distribution/kernel
>level (Suse/2.4.7).
>
>Ron Thomas
>Hypercom, Inc
>[EMAIL PROTECTED]
>"Either lead by example, or become a terrible warning"
>
>
>
> jkstil
Yusron,
One item I have noted from those who love OCI is that they rarely if ever
include the sqlca.h file which defines a structure called sqlca (wonder where
that name came from).This is regrettable since it works with OCI just as
well as Pro*C. There is a data point in sqlca called sq
I'm currently engaged in trying to join two databases that were split. The
databases are supposed to be twin images of each other but, of course,
they're not.
But you may be taking a different route. WIll any objects in database A be
twinned in database B? Do you have lookup tables that will b
oops, should be > not <
:o)
select a.call_start, count(b.call_start) interruptions
from phone_call a, phone_call b
where a.call_start <= b.call_start and a.call_end > b.call_start
group by a.call_start
Cheers
Greg
-Original Message-
Sent: 15 August 2001 15:43
To: '[EMAIL PROTECTED]'
This client, a world leader in the electronic manufacturing industry, in San
Jose, CA
is currently seeking an Oracle HRMS System Administrator.
You will facilitate and maintain the setup of the Application so the users
can work in
a stable environment that produces expected results.
Must be very
Hi All,
Once again sinking into the depths of Oracle code.
> BUG INFO
>
>
> /
>
> Base
>
> Fixed In Ver: 9.0.2
>
> Abstract: CANNOT DROP PARTITION IF ADDED VIA SYNONYM - ORA-2149
Still waiting for instructions on how to cleanup my data dictionary.
Apologies for reviving a dead thread, but I was incommunicado for a week and
just now saw this rather interesting thread. One of my pet rants is about
the difference between "knowledge" and "understanding". I am not sure of
the clinical definitions of the words used in this discussion, but will
Hense transportable tablespaces.
"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."
Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275
Fuelspot
73 Princeton Street
North, Che
Or use a self-join
select a.call_start, count(b.call_start) interruptions
from phone_call a, phone_call b
where a.call_start <= b.call_start and a.call_end < b.call_start
group by a.call_start
-Original Message-
Sent: 15 August 2001 16:02
To: Multiple recipients of list ORACLE-L
Yes, s
List,
In one of our applications, my boss wants to define all the numeric columns
as NUMBER or leave it as floating point. He wants to define all the tables
like this wherever numeric column is defined in the table.
Example:
Location_ID NUMBER
We know, from our application character, that th
I have Oracle 7.3.4 running on Windoze NT4.0. I have been trying to
determine if I have an application problem or a database problem. I have an
application called MP2 that is causing a user to have their PC freeze up
when they try to print from the application. I ran a trace on their session
to
I had the same problem when truncating a huge table (24 Mill rows). It
turned out that the reason my table was taking so long was the amount of
extents I had on it. I could look at what was actually happening during a
truncate and it had to go and take each individual block and put them back
in
Is this not flawed in that given these results:
eventtimeevent
-
01-AUG-2001 12:10:00 start > add 1- 1
01-AUG-2001 12:15:00 start > add 1- 2
01-AUG-2001 12:25:00 start > add 1- total 3
01-AUG-2001 12:30:00 end< subtract 1 - 2
0
At which version of Oracle did they remove this?
It is NOT in any my directories. I checked:
- 8.0.3 ORACLE_HOME/bin
- 8.1.5 ORACLE_HOME/bin
- 8.1.6 ORACLE_HOME/bin
- 7.3.4 ORACLE_HOME/bin
Thanks,
Babette
-Original Message-
Gopalakrishnan
Sent: Wednesday, August 15, 2001 10:16 AM
To:
sqlca has been around for a LONG LONG time. I used it years ago with my
COBOL SQL Reports. Its the SQL Communications Area.
-Original Message-
Sent: Wednesday, August 15, 2001 10:02 AM
To: Multiple recipients of list ORACLE-L
Yusron,
One item I have noted from those who love OC
Title: LDAP and Oracle
Anyone use LDAP to work with Oracle to handle single login between various applications.
"Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes."
Christopher R. Spence
Oracle DBA
P
So, would that be irrational or imaginary?
BTW - I once made a mistake on a blackboard demonstration and ended up
presenting Newton's Macroscope instead of Newton's Microscope. Turns out
the math works as well for infinitudes as for infinitesimals. (g)
I have found that if they did not close their session properly, as in the
case of a reboot, that sessions can hang around until they timeout and die
on their own. You can see about the timeout settings in their profiles.
-Original Message-
Sent: Wednesday, August 15, 2001 11:11 AM
To: M
Title: Message
I believe they discontinued it, I used it
like that, and it was ok. Didn't really give alot of
information.
"Do not criticize someone until you walked a
mile in their shoes, that way when you criticize them, you are a mile a way and
have their shoes."
Christopher R. Spence
Kevin,
Very true, I remember it from way back in 85 on Version 4 of Oracle. The
problem with sqlca and OCI is that it's "not required" and therefore often left
out.
Dick Goulet
Reply Separator
Author: Kevin Lange <[EMAIL PROTECTED]>
Date: 8/15/
Ok, settle down. I just migrated from 80520 to 81600 on Siemens and
the migrate consistently choked on the AQ$ update stuff. Something
to do with objects...raw data types
Oracle provided a patch which did not work. We finally had to migrate
holding the database at compatible=8.0.5.2.0, but...
Thanks,
And what is
the sintax of the create controlfile command ?
How do I
use it ?
Now I will
backup them :-)
Ramon E. Estevez
[EMAIL PROTECTED]
809-565-3121
-Mensaje original-De: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]En nombre de Djordje JankovicEnviado
el: W
I've stayed out of this one up till now. But based on the original I assume
that all of the control files where on the same disk drive & directory. Bad
idea. If you have a problem with the drive and/or controller then you've been
had. Place the control files on multiple spindles that are prefe
Ian and Riyaj,
These "table_..." objects look like Java classes. The way to find this out is
matching the kgl handle address and looking at the indx column of x$kglob.
Matching this indx column with dba_objects.object_id.
Yong Huang
[EMAIL PROTECTED]
you wrote:
I use the following statment whe
A truncate (reuse storage) should not do that -
it simply drops the HWM to zero and updates the
segment header. However, when a truncate
is issued, and dirty blocks in the buffer from
that object have to be written to disk before
the truncate takes place, so that might be
slowing things (a little
If the user already has his information displayed on the screen( retrieve
already took place) and his/her machine freezes it is definitely application
problem, may be networking problem but not back end problem. Printing
problem is not an Oracle problem.
If he/she is retrieving while printing i
Dave,
Yes it is normal. The original session was communicating with the PC when
the re-boot abnormally terminated the connection. It is now an orphan and will
remain so until either you restart Oracle or the DB finds a way to close the
session, most likely leaving it sniped.
The reason is
Hi, DBAs
Anybody knows about PS lock , mode in 6, and exchange deadlocks equal to 1
in v$sysstat, can this be a problem?
this is ver 8.0.5 on hp unix.
thanks®ards,
Li
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Li, Xiangli
INET: [EMAIL PROTECTED]
Fat City Networ
I think I had some issues with this also when we went
from 805 to 816 on Solaris 2.6. Remeber removing all
AQ params from my init.ora (job_queue* params).
--- "Mohan, Ross" <[EMAIL PROTECTED]> wrote:
> Ok, settle down. I just migrated from 80520 to 81600
> on Siemens and
> the migrate consisten
True, but just enough.
Dick Goulet
Thought for the day: Never be afraid to try something new. Remember that
a lone amateur built the Ark. A large group of professionals built the
Titanic.
Reply Separator
Author: Christopher Spence <[EMAIL PROTECTED]>
Da
My apologies David,
I was reading Andreys initial email as give me the number of concurrent
calls being made of which there are 4.
Kev (eating humble pie by the spadeful!) ;-)
-Original Message-
Sent: 15 August 2001 16:02
To: Multiple recipients of list ORACLE-L
Yes, so the maximum is
Rao,
The boss is somewhat right, but are you absolutely certain that the current
program interface to the data will remain forever? What is the likelihood of
someone having to "correct" the data via SQL*Plus or some other method where the
restrictions will have no effect. The main reason of
Andrey,
At first glance, I think this SQL statement gives you the answer. It gives you
a count of the simultaneous calls for each call. If you like this, then all you
have to do is find the row with the maximum count.
select a.call_start,a.call_end,count(*)+ 1
from pc a, pc b
where a.call_end
I hate to be on the side of management but much time is spent going
back and resizing fields and applications because the field defined is no
longer big enough. Been there and done that many times.
-Original Message-
Sent: Wednesday, August 15, 2001 10:41 AM
To: Multiple recipient
Chris,
True, but you can't transport them across OS platforms.
Dick Goulet
Reply Separator
Author: Christopher Spence <[EMAIL PROTECTED]>
Date: 8/15/2001 6:56 AM
Hense transportable tablespaces.
"Do not criticize someone until you walked a mil
No, but I'd also be mighty interested to hear about the details. My
problem here is that I've got a couple of applications (heck, most of the
applications - including all the Oracle ones) that are not LDAP compliant.
Most have their own internal security setup.
David A. Barbour
Oracle DBA, OCP
Where can I find their profiles. If your talking about the .profile then is
there a Windoze equivalent cuz I'm not on unix. :(
Dave
-Original Message-
Sent: Wednesday, August 15, 2001 11:41 AM
To: Multiple recipients of list ORACLE-L
I have found that if they did not close their sess
Hi Babette,
I think you are -UNIX. Check M$ and you will find that under
/ORANT/bin.
--- Babette Turner-Underwood <[EMAIL PROTECTED]> wrote:
> At which version of Oracle did they remove this?
> It is NOT in any my directories. I checked:
>
> - 8.0.3 ORACLE_HOME/bin
> - 8.1.5 ORACLE_HOME/bin
>
hi,
if you
have 3 controlfiles (it means that you have two copies of your controlfile), so
if there is a problem with one controlfile, you had to change the parameter
control_files in the init.ora so that you eliminate the corrupted
file.
Best Regards,
Nabila Mekkaoui
DBA Oracle
-
I have a simplistic view of things:
Knowledge = ideas linked by associations, purely intellectual in nature.
You can do the word association game re. these, quite fun.
Understanding = experience involving the whole person, including movement,
emotions and intellect. So to understand, you must
Title: RE: user holding session even after a re-boot
Well, that sounds like an optimal environment, Kevin. I've seen Oracle client zombie sessions hang around for days and chew up CPU. I had to write a shell script to identify these sessions and kill them in both the OS and in Oracle. This
Dear Gurus !
Lots of thanks to everybody who replied.
I've got numerous great solutions from U - now i need to choose one among
them ;-)
This is a great list with genius people subscribed !
I love to belong to Oracle DBAs brotherhood.
Thank U all very much & have a great day !
-Original Mes
Chuan,
Kevin is correct. If your truncate table is taking a *long* time (and the
table is not locked by another process), it's because your storage params
are incorrect for the amount of data you are holding.
Look at initial and next in comparison with the number of extents
(DBA_EXTENTS view) f
Hi All,
I am facing a very different problem.
I am using Oracle as a XA Resouce Manager for Encina.
The Encina applications built using Oracle 8.0.6 are working fine. When we moved
the Oracle version to
Oracle 8.0.6.3 the applications are not able to connect to the database.
It gives the fo
I was talking about the connection profiles that you can use to set resource
limits when you run the
create profile
command.
With this you can create a profile for a set of users that you can then
attach to a user either when you create it or thru the alter user command.
The profile lets you
Title: RE: user holding session even after a re-boot
DBA_PROFILES, and if a user has been assigned a profile other than default, it will be in DBA_USERS
-Original Message-
From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, August 15, 2001 1:56 PM
To: Multiple re
In this case, I think your boss is right. If you feel the need to have
some integrity checking at the DB level, use FKs. CHECK and possibly NOT
NULL constraints will subject you to the type of application/database
maintenance a well-thought out plan should endeavor to avoid. Just be sure
that
I think I have an alternative solution that, if you're using 8.1.6 or better, would
provide a pure SQL solution. It's probably not the tidiest SQL, but it works (as far
as I can tell):
SELECT c1 AS start_time
, c2 AS end_time
, total
FROM (SELECT LAG (call_time, 1) OVER (ORDER BY ca
Our setup is one application per database (9 instances and growing), not all
databases are
integrated, but the majority are.
Some of the things to consider :
If one database goes down, the others have to right away. Or at least those
ones that have
integration.
As we are a distrubuted environm
Kevin,
I believe that is because Oracle on NT is a single multi-threaded process
where one can handle this easier. On HP-UX and most other Unix variant OS's
that I know Oracle runs as a bunch of independent processes, including the
dedicated servers, and consequently it's harder. BTW: the b
If did 'alter database backup control file to
trace' prior to your control files going bad check your user dump
directory. Open that control file (it'll have .trc extension). They
syntax will be right there. You will have to edit it deleting unnecessary
info.
HTH,
[Lyuda
Hoska]
-
On Mon, 13 Aug 2001, [EMAIL PROTECTED] wrote:
> Who is the vendor for EZSQL? Do you have a web site for them?
www.google.com, type in ezsql and the first thing you get is
http://www.ezsql.net/
--
Galen Boyer
It seems to me, I remember every single thing I know.
--
Please see the official OR
Hi All:
There's one really neat thing about this thread...it's helped me solve an
on-going problem. I've
got managers who want to see graphs of their system's usage. Using this
mechanism applied
against the DBA_AUDIT_TRAIL view works perfectly.
Thanks!
Mike
---
===
Never got an answer from my "JMS person here". Which we don't technically
have one.
I do know we have two topics, one used for all the price feeds, and one for
the heartbeat and trade updates.
I believe it is on a Raid 1 (Veritas VM) volume.
There are a few disks for Export and other such unix
"Boivin, Patrice J" wrote:
>
>
> P.S. Are Orasoruses herbivores, or carnivores?
i thought they were omni[back]vores.;-)
--
Bill "Shrek" Thater ORACLE DBA
Telergy,Inc. [EMAIL PROTECTED]
One pi
Wednesday, August 15, 2001, 2:10:58 PM, David wrote:
>If for whatever reason this becomes a four-digit number
>(skip the technical explanations of why that will NEVER
>happen, just think of the logical approach - we dial 1 to
>get long-distance, why not a an additional digit(s) to
>access a region
You are correct, unless your using 9i, you cannot alter the initial extent
without dropping the table.
"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."
Christopher R. Spence
Oracle DBA
Phone: (978) 32
1 - 100 of 199 matches
Mail list logo