We are moving from 8.0.5 to 8.1.7
For 8.0.5 there was a Oracle client disk for NT Workstation.
Is there one for 8.1.7 or do I install the client onto NT using the server
install disk Universal installer? If so do I need a Java Run Time to run the
installer on NT Workstation?
John
--
Please
Thanks to all who responded.
Sure, I meant Coordinated Universal Time (UTC).
After all, there seems no simple way to get UTC in PL/SQL,
i.e. without a switch-over table for daylight saving time,
although at least UNIX-like operating systems use UTC internally
and POSIX conformant systems
Hello,
I have a table with 39 rows (3 blocks of 4Ko).
When I delete 4 rows from this table, the output of the SQL+ AUTOTRACE
is the following :
Statistics
--
8 recursive calls
7 db block gets
8 consistent
Thanks for all the
responses guys
Lee
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader
of this message is not the intended recipient, you are
hereby notified that any
Hi,
In a Unix Machine I want to create two instance on a single server.Its
memory size is 1GB.
I am trying to up one instance it is opening well .While Creating other
instance I am getting this error.
ORA-07279: spcre: semget error, unable to get first semaphore set.
SVR4 Error: 28: No space
List, our server has suddenly ahead 1 hour... it happened last year also
something to do with the timezone... TZ variable..
is there a timezonewe could set which remains constant (does not go ahead 1
hour)
thruout the year ?
regards
--
Please see the official ORACLE-L FAQ:
CASE When Passing 6600 Transactions spread across 250 Concurrent users on
SUN APP Server
as part of Benchmarking Exercise
Hardware - Sun APP Server 4 CPU , 4 GB RAM , 3.5 GB Swap
Software - Solaris 2.6 on Oracle 7.3.4.5
Application - Pro*c Application with Embedded SQLs in a Banking
Dear all
!
I'm leaving my
current job soon , but before i leave i need to teach one of the developers here
some very-very basic DBA / DBO stuff.
This guy is going to
support our existing databases .
I'm just wondering
what should i teach him . The training must be short and very
Waleed,
That is an answer. Opening and closing the files might be an option.
Unfortunately, I have to work within the environment I was given. The
application from which I'm extracting the data is poorly designed.
Space and memory are a problem, and the table containing the master
records is
Are you saying that Microsoft products don't come with useful documentation?
Documentation that can help you diagnose problems when things go wrong???
gasp
Regards,
Patrice Boivin
Systems Analyst (Oracle DBA)
Bedford Institute of Oceanography
Fisheries and Oceans Canada
-Original
Saroj,
It appears you do not have enough semaphores available to bring up both
instances. What flavor of UNIX are you operating on?
David A. Barbour
Oracle DBA
"Dash, Saroj (CAP,CEF)" wrote:
Hi,
In a Unix Machine I want to create two instance on a single server.Its
memory size is 1GB.
Teach him to write a resume...
[EMAIL PROTECTED] 04/04/01 07:50AM
Dear all !
I'm leaving my current job soon , but before i leave i need to teach one of
the developers here some very-very basic DBA / DBO stuff.
This guy is going to support our existing databases .
I'm just wondering what
I don't think you're having memory problems; check for the number of available
semaphores; sounds like that should increase;
[EMAIL PROTECTED] 04/04/01 07:00AM
Hi,
In a Unix Machine I want to create two instance on a single server.Its
memory size is 1GB.
I am trying to up one instance it
Hi
There is a whole lot of semaphores that can and need to be set on most
flavours of UNIX (like shmmax etc..) I do not know exactly what should be
set but your platform specific doc's should give you a pretty good idea.
Basically they will set the boundaries within oracle can operate and if
Have a look at the following web page for your database sizing.
http://members.spree.com/business/cnaude/Unix_system_parameters_for_Oracle.h
tm
If it does not go through, tyr the following link and then go to Unix
parameters link.
http://members.spree.com/business/cnaude/welcome_page.htm
Good
Hi!
Give this list address and other links such as technet where to find info.
Gints Plivna
"andrey"
Speaking of cost-cutting, anyone have any idea when Oracle will bottom out
on the stock market?
I am wondering whether now would be a good time to invest...
I think we are getting close to that now, but I say that every day lately
and the stock seems to be dropping further every few days.
Pat.
you have to set the semaphores to run both the databases ..temporarily you
reduce the number of process in both the instanes and start both the
databases.
deepen
oracle dba
-Original Message-
Barbour
Sent: Wednesday, April 04, 2001 5:41 PM
To: Multiple recipients of list ORACLE-L
How
about how to back up the database? Also recovery? A quick overview on users, and
authorities/permissions.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of andreySent: Wednesday,
April 04, 2001 12:50To: Multiple recipients of list
FOR YOUR INFORMATION
ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has
changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails
using the old format will continue to be delivered until 31st March 2001.
Saroj,
You need to change your kernel
[EMAIL PROTECTED] wrote:
Hi!
Give this list address and other links such as technet where to find info.
Gints Plivna
and give him a copy of _Oracle DBA 101_, and yes i have done that with
my JR. DBA and it's helped.
--
Bill Thater Certifiable ORACLE DBA
Telergy, Inc [EMAIL
Patrice,
DO YOU REALLY THINK I'D BE PLUGGING AWAY AT A Database if I could accurately
predict the markets ...
I'd be on the beach, with a one young beauty to bring me cocktails on my
left, and another on my right to rub in the suntan lotion (Don't tell my
wife about this fantasy ...)
In my
Hi All,
I'm on AIX and want to check how much memory each Oracle session uses.
Can anybody let me know how to achieve this?
Jack
=
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor
Hello list,
We have a Sun e3500 with 4x300 MH processors, 1 GB Ram and OS 2.6.
The server runs 4 small instances ( 7.3.4.5), two PeopleSoft apps and one
more help desk app. As the below shows, or SGA's are very small (same for
all 4 databases):
SVRMGR show sga
Hallo
Anyoine know about any program that can check all the constraints after the database
is designed?
Roland Skldblom
--
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
Hi!
In case You have free time or like object oriented modelling, class
diagrams and oracle You may explore such a link:
http://www.itsystems.lv/gints/files/oracle/oracle_s.htm
All suggestions and errors are welcome!
Gints Plivna
--
Please see the official ORACLE-L FAQ:
Hi,
On system such as NT,Win200, AIX, and Linux,
you have no control over memory and semaphore parameters as they are
automatically set for you.
Sample Changes on UNIX System Shared Memory
and Semaphore Parameters
HP-UX Release
10.0 DYNIX /ATT UNIX sys V SUN
4
SHMMAX
0X400
I have installed 8.1.5, 8.1.6, and 8.1.7 w OPS. Perhaps you can try to
install use the 8.1.7 w. OPS.
Richard
-Original Message-
Taylor
Sent: Tuesday, April 03, 2001 12:57 PM
To: Multiple recipients of list ORACLE-L
8.1.7 R3 Enterprise Edition. No OPS
At 08:20 AM 4/3/01 -0800, you
Thanks Raj and others. That definitely leads me to the right direction.
Surjit
Raj Gopalan wrote:
On subsequent select
select *
from mytable
where rownum 40
minus
select *
from mytable
where rownum 20.
This will bring rows between 20 and 40. On the next select, replace 40
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Friday, March 30, 2001 19:36
* Any equivalent Fatcity/LazyDBA list servers for SQL Server?
try these:
http://www.swynk.com/discuss_sql7
OK. Here goes.
This is the relevant portion of the ftp script. The SAP ABAP program executes a
system call to execute this script. It passes in things like the userid, remote
host name, remote and local file names, password, get or put command, etc. This
is the piece of the script that we
Just from looking at what you've described, you don't use the memory you
have on the machine. But I'm on the outside looking in. If your databases
are memory bound, my recommendation is to look into tuning your database
memory first, and expanding each SGA.
I'm also assuming that this is only a
Rahul,
You can set the time so it won't recognize Daylight Savings Time, if that's
what the problem is. The sysadmin needs to do the following:
smitty
choose System Environments
choose Change / Show Date and Time
choose Change Time Zone Using System Defined Values
You'll get a pop-up window
Is anyone else having problems with Metalink today?
Todd Carlson
Oracle 8i Certified DBA
Bunge Corporation
--
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,
OS HP10.20
Oracle 7.3.3 (ya I know)
Every now and then we get the situation were application grows to a
standstill as far as loading data. These should all be straight forward
inserts. Rebuilding the indexes causes the problem to go away. These
indexes are all based on primary key values like
Roland,
Oracle Designer can reverse engineer an Oracle database and
capture all constraint (and other) info. You can then run
various reports and/or display the data model in diagrams to
allow you to validate the accuracy and completeness of the
constraints.
It can do much, much more as well.
Hi Mike,
There are lots of papers/documents on the web describing how Solaris uses
memory and tools to monitor usage. One place to start is:
http://www.unixinsider.com/unixinsideronline/swol-03-1998/swol-03-perf.html
The list of references from there should also help.
Hope this helps.
Dave
I read the caption at the bottom, and I dutifully deleted the message from
my machine.
Ooops! Now I am going to receive a copy of my reply!
My, this will never end...
Pat.
-Original Message-
From: lerobe - Lee Robertson [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, April 04, 2001
Title: RE: Check the constraints
Hi,
The SQL impact from Toad maybe can help.
rgds,
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, April 04, 2001 10:21 AM
To: Multiple recipients of list ORACLE-L
Subject: Check the constraints
Hallo
I'm having a hard time starting up my database
and the only log I know is the ALERT_database.LOG
but I get no details of what to do.
Is there any other log?
ORA-000445 does not tell me where the TRACE file is if any.
TIA
Joe
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Sure am!! Can't search - AGAIN. For months now, the search and advanced
buttons have not worked (I click on the button, the screen gets busy and
2-15 minutes later it refreshes - no change in the screen - ARG!). My
solution has been to go into Forums and use the advanced search link there,
but
Is it possible to set a default index tablespace, rather than specify it in
the create table statement?
Database is 8.1.7
John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Dunn
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX:
Hi:
I am using exp/imp to do nightly refresh of a schema (which has about 400
tables) from one instance ("A") to another instance ("B").
Here is the exp.parfile:
BUFFER = 64000
COMPRESS = Y
CONSISTENT = N
CONSTRAINTS = Y
DIRECT = N
FILE = /oracle/exports/oracle.dmp.pipe
GRANTS = Y
INDEXES = Y
Hi Steve,
I completely agree with using standard file sizes. (Even when using UFS?) So
would someone like to suggest standard file sizes? Last time I went raw I
used sizes of 128MB, 1GB, and 8GB (adding 64K or 128K for overhead) and it
worked just fine.
Regarding raw vs. QuickIO... By using
As to #1: If you have C experience and enough Forms experience to
understand all the interdependencies between objects, and it is a simple
form, then go for it. The online help has a specs on all the function
calls. There is some need to reed between the lines, but it is not too bad.
The
Cherie,
Yes funcidx_status will be ENABLED and there'll be a row in
User_Ind_Expressions for each function-based index.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
No, it's that my RRSP (pension plan in Canada) has been dropping steadily in
value the past months, and I am getting antsy.
I thought that a bit a diversifying (investing in the U.S. as well as
Canada) might not be a bad thing, esp. if solid companies are currently
undervalued.
I can wait
Suprisingly, I just logged on and it took only a second. Amazing!! They
must have gotten that other Tandy computer running again.
-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, April 04, 2001 11:35 AM
To: Multiple recipients of list ORACLE-L
Is anyone else having problems
Well I somehow managed to sell off all my stock at the end of '99 before the
NAZ meltdown. Not necessarily because of investment savvy but because of
virtuous paranoia. Maybe I missed some profits by getting out before the
full expansion of the "Internet bubble" but neither have I lost any money
Here's some resources in no specific order:
http://gearbox.maem.umr.edu/~batch/batchtoc.htm
ftp://garbo.uwasa.fi/pc/ts/
http://garbo.uwasa.fi/pc/batchutil.html
http://www.uwasa.fi/~ts/http/http2.html
http://home7.inet.tele.dk/batfiles/
http://users.cybercity.dk/~bse26236/batutil/batutil.htm
Thanks for the help with this guys, I have now upgraded to 2.2 in a
seperate Oracle_Home, and all is working sweet as a nut.
Cheers
Mark
-Original Message-
Naude
Sent: Tuesday, April 03, 2001 11:21
To: Multiple recipients of list ORACLE-L
Hi Mark.
Yea, 2.2 is worth the wait, but if
Michael,
Yes, that's what I want to do. In fact, I've pin pointed some areas, such as
redolog buffers that can user larger memory segments. However I do not want
to do this at the expense of the servers total memory use. That's why I'm
wondering about the overall memory use (all databases and
John,
Unless you specify the index's tablespace it ends up in the users default
tablespace. The only other way I can think of to do what you ask is to create
table, change the users default tablespace then build the indexes.
Dick Goulet
Reply
Easiest bet is to use any one of the gui tools available,
such as Toad, or Procedure Builder, etc...
hth,
Yosi
-Original Message-
From: Ron Rogers [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 03, 2001 5:07 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: SQL Command to
I'll be installing Suse 7.1 with Oracle this week.
I'll let ya'll know how it goes.
Jared
On Mon, 2 Apr 2001, Ron Rogers wrote:
List,
I am playing with the idea of loading my PC with Linux and Oracle for test
purposes( We have to migrate from Novell in the near future). What have you
Yep. As you're loading, Oracle keeps trying to re-balance the tree. Oracle 8i
handles this better. I have a client who avoided this problem by reversing the order
of the digits of the sequence generated key, so, for example, if your next key is
123456789, you would reverse that and use
Title: RE: Metalink Again
LOL!!
== -Original Message-
== From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]]
== Sent: Wednesday, April 04, 2001 12:41 PM
== To: Multiple recipients of list ORACLE-L
== Subject: RE: Metalink Again
==
==
== Suprisingly, I just logged on and it took only
Title: RE: Unix memory used
-Original Message-
From: David Miller [mailto:[EMAIL PROTECTED]]
There are lots of papers/documents on the web describing how
Solaris uses
memory and tools to monitor usage. One place to start is:
Waiting is probably good.
Besides knowing a couple of investment advisors (fellow soccer/little
league dads, members of theology study study groups, and so forth), I
try to listen to Louis Rukeyser's show on PBS every week
(http://www.pbs.org/mpt/rukeyser), and as much of Bob Brinker's
SQL-Backtrack was a good product at one time. In theory it still is.
Here's the problem though. When Data Tools sold SQL-Backtrack to BMC,
it seems that anyone that knew anything about the product left.
There is no one in tech support that can help you beyond the menu
items. There is no one
Hello,
I know I am missing something. I just can't
see it right now. Could someone please tell me what is wrong here?
We use version 8.1.6 on Spar Solaris 7.
I am getting the following error when I try to
create this function as sys.
PLS-00201: identifier 'CALANDERSTRING' must be
declared
Title: RE: 'PMON did not start after 120 seconds'
What version of oracle and OS?
I have seen this on 8.1.7 on hp when
trying to use asyc i/o and the setprivgrp
command has not been run.
Matt Adams - GE Appliances - [EMAIL PROTECTED]
Doing linear scans over an associative array is
Not as far as I know John, if so I should think it would be a part of the
ALTER USER command, and there is no listing for this in any manual or book I
have read.
List correct me if I'm wrong, as I'd love to see this too..
Regards
Mark
-Original Message-
Sent: Wednesday, April 04, 2001
A TRS-80?
Why not a Sinclair?
: )
-Original Message-
From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, April 04, 2001 1:41 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Metalink Again
Suprisingly, I just logged on and it took only a second.
I don't use OEM but am considering starting to use it.
One requirement is that after an Oracle instance starts,
then a number of Unix scripts need to be run.
How easily, if at all, does OEM provide the ability
to invoke scripts both before after both
STARTUP SHUTDOWN; in other words
before
Niel,
You have declared CALAND'A'RSTRING. Change that from 'a' to 'e'.
Prakash
-Original Message-
Sent: Wednesday, April 04, 2001 2:41 PM
To: Multiple recipients of list ORACLE-L
Hello,
I know I am missing something. I just can't see it right now. Could
someone please tell me
You didn't spell calanderstring consistently bi guy...(calendarstring...)
[EMAIL PROTECTED] 04/04/01 02:41PM
Hello,
I know I am missing something. I just can't see it right now. Could someone please
tell me what is wrong here? We use version 8.1.6 on Spar Solaris 7.
I am getting the
ROFL!
On 3 Apr 2001, at 19:35, Steve Adams scribbled with alacrity and cogency:
... There have been growing pains, mostly caused by
Oracle bugs, but they certainly seem to be able to make their Oracle stuff scale
much better than MetaLink does. Maybe its because of the performance consultant
This may be a weird idea, but if you have bandwidth, you
could experiment by downloading the free Forms6 (Developer6?)
stuff from technet, and look at the installer on that.
regards,
ep
On 4 Apr 2001, at 1:45, John Dunn wrote:
Date sent: Wed, 04 Apr 2001 01:45:26 -0800
To:
I need to determine how much space some tables/indexes are really
using, as opposed to how much is allocated to them. Anyone have a
script you'd be willing to share?
Cheers!
--
My employers like me, but not enough to let me speak for them.
Greg Norris
Sprint LTD Database Administration
example:
http://news.morningstar.com/doc/article/0,1,4382,00.html?hSection=fromAnalysts
---excerpt---
...
One Hand Washes the Other
I was talking to a reporter a couple of days ago about some upcoming
accounting changes that could potentially boost some companies' reported
earnings by
Neil,
I bet
you saw your spelling error the second you hit send.
;-)
calendarString vs.
calenderString
Jack
Jack C.
ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit,
Inc.Austin,
Texaswww.iNetProfit.com[EMAIL PROTECTED]
-Original
Easy one, Neil, you spelled calendar two different ways.
(both of which are incorrect, not that it matters!)
calandarString CHAR(10) := ' ';
RETURN (calanderString);
-Original Message-
Sent: Wednesday, April 04, 2001 11:41 AM
To: Multiple recipients of list ORACLE-L
Hello,
Title: RE: DB2 forums/listserves
Also, DB2-L
Send note to: [EMAIL PROTECTED]
Subject: blank or space
Body of note: subscribe DB2-L firstname lastname
DB2 Level 1 and Level 2 monitor this list, and all the vendor company reps
participate.
-Original Message-
From: Marin
Jack,
Thanks for your helpful reply. Looks like my index is not function-based.
Darn! Now I don't know why I'm getting this error and Metalink won't let
me in to update my TAR.
Cherie
Is there a way to kill (other than kill session) a thread that is doing an
insert - nologging?
I have tried "alter system kill session" to no avail. It gives me the
message
"marked for kill" but the process continues to hang.
The process has a row exclusive lock with a lock type of TM(dml).
When running master to master replication, we experience an error that
caused a deferred sys transaction error. The cause of the original error is
fixed and we attempted to run DBMS_DEFER_SYS.EXECUTE_ERROR to rerun the
transaction in error. This fails with the same original error of ORA-01403.
Thanks all of you for reply. I'm now use following to adjusted the logic:
declare V_AKTIV_NR aktiv.AKTIV_NR%TYPE; V_PROBLEM aktiv.PROBLEM%TYPE; V_ENDDAT aktiv.ENDDAT%TYPE; V_ENDUHR aktiv.ENDUHR%TYPE; V_AUSSAGEW aktiv.AUSSAGEW%TYPE; V_LANGTEXT aktiv.LANGTEXT%TYPE; V_LONGTEXT VARCHAR2(2);
Hi !
I don't think it so. But there is an enhancement
request pending with Oracle (I don't have the number
right now) pending with oracle. Probably in next
versions.
So they answer is NO.
=
Have a nice day !!
Best Regards,
K
another example:
http://www.tcwgroup.com/press4.shtml
-
This guy was on Rukeyser's show several weeks ago, and
reportedly has a knack for picking good tech stocks amidst
the rubble:
http://www.tcwgroup.com/bios/bickerstaff_glen.htm
---
Mark,
Yeah, I've wanted that for years. I tried to automate
changing the User's default tablespace in a Before Create
trigger on a schema, but couldn't figure out how to tell if
an index was being created and, anyway, you can't do that
kind of DDL in that kind of trigger.
What I've done is run
I guessed (emphasis on "guess") that you weren't using the memory you had
because you originally showed your SGAs were very small. I looked at a Sun
server that I run 2 databases on and the Total SGA for my training database
was 35 MB, while my production was over 100Mb.
Another thing I said,
Gregory,
This will give you the number of extents allocated and the the last used
block# for a given segment.
select extent_id+1, block_id
from dba_extents
where extent_id = (select max(extent_id)
from dba_extents
where segment_name =
Hello!
Does recovery MANAGER support bfiles?
if so any idea when Oracle plans to support them?
THanx
- Original Message --
[EMAIL PROTECTED] wrote:
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
From:[EMAIL PROTECTED]
Date:Wed, 04 Apr 2001 10:20:29 -0800
Also use dbms_space.unused_space procedure. This gives the number of unused
blocks. You need to subtract this from the below formula to get the exact
size.
-Original Message-
Sent: Wednesday, April 04, 2001 2:48 PM
To: '[EMAIL PROTECTED]'
Gregory,
This will give you the number of
MMmmm TRS-80.
what's a Sinclair?
-Original Message-
Patrice J
Sent: Wednesday, April 04, 2001 3:02 PM
To: Multiple recipients of list ORACLE-L
A TRS-80?
Why not a Sinclair?
: )
-Original Message-
From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]]
Sent:
Hi!
I know there has been a thread about this topic recently, but I can't find
the emails... And the archives don't have them either.
Does anybody have a script to compare two schemas and show the differences?
I know that I can do it with TOAD, but I would need the script anyway.
Sorry for
Sinclair was a brand of personal computers that came out in the UK about 20
years ago,
If memory serves , they started of with the ZX 81 which had a whole 1K of
memory.
Their next offering was the Spectrum 16K followed by the 48K. with rubber
keys and programmable in basic.
I remember back in
Probably you are exceeding the length of the PL/SQL variable when you are
assigning values to it.
Check the length by inserting the following line in your code:
dbms_output.put_line(length(V_LONGTEXT));
dbms_output.put_line(length(V_LONGTEXT_TRIM));
-Original Message-
Sent:
Sinclair Spectrum and Z80 (UK built machine I think)... I used to have a
Sinclair Spectrum... top of the line at 48Kb of RAM. I used to spend my
time trying to load games into memory from tape and then copy them back to
another tape. The games used to be copy proof... they used to poke a value
did you try alter system kill session immediate?
-Original Message-
Eric
Sent: Wednesday, April 04, 2001 3:11 PM
To: Multiple recipients of list ORACLE-L
Is there a way to kill (other than kill session) a thread that is doing an
insert - nologging?
I have tried "alter system kill
Wow, it was like the Tandy for the UK. I didn't get my first computer until
I was like 20 or 21. I am jealous of all of the people who got started
early.
-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, April 04, 2001 4:16 PM
To: Multiple recipients of list ORACLE-L
Sinclair
I had a Spectrum 48K and the rest of the story is about the same for me.
Same downward spiral and all...
-Original Message-
Sent: Wednesday, April 04, 2001 4:16 PM
To: Multiple recipients of list ORACLE-L
Sinclair was a brand of personal computers that came out in the UK about 20
I am running Caldera Linux 2.5 (?) and Oracle 8.1.7 rel 2. Installed
cleanly. Runs flawlessly.
This is a personal sandbox not production.
Pete Barnett
Oracle Database Administrator
Regence BlueCross BlueShield
[EMAIL PROTECTED]
On Wed, 4 Apr 2001 [EMAIL PROTECTED] wrote:
I'll be
I would try to answer your questions by a series of
observations
1. Only upto 4 ARs could be attached to a L or N
class HPs. Moreover this is possible only if you daisy
chain the 2 ARs which will in turn degrade the
performance .
2. The Parallel server Option has to be approached
with
In 1982ish, Dad brought home a used TRS-80 mod III with 16k ram and a tape
drive. Started a downward spiral. I tried to get out, no I really did.
Got a degree in mathematics instead of CompSci. Joined the Air Force as an
aircraft maintenance officer. But alas, it didn't last. I spent my time
I've got my Commodore 64.
Brian L. Anderson
Flunky/SA/DBA/DERT
Darton College
[EMAIL PROTECTED]
Any more spectrum owners out there that want to admit to it ?
--
Please see the official ORACLE-L FAQ:
On Wed, 4 Apr 2001,Dasko, Dan scribbled on the wall in glitter crayon:
-In 1982ish, Dad brought home a used TRS-80 mod III with 16k ram and a tape
all you youngsters! i started programming in 1968 [yes i *am* that old, yes we
*did* to have computers back then.;-)] first project was a payroll
On 4 Apr 2001, Cyril Thankappan wrote:
Hello!
Does recovery MANAGER support bfiles?
if so any idea when Oracle plans to support them?
THanx
I don't know, but I doubt it.
Jared
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Yea I started with the ZX 80, got a kit and built it.
My background is on the hardware end of MainFrames,
so I borrowed a Logic Analyzer from Work, hooked it up,
and scoped all the revelent CPU timings, using memory loops and BIOS calls,
what fun that was.
Then we got the TIMEX version of
1 - 100 of 127 matches
Mail list logo