I would like to be able to have multiple undo tspaces simply as an aid to
IO balancing...
Connor, you can...
Oooo... You meant you want them active at the same TIME :-)
They are saving that as a new feature for some later release I'm sure.
It's probably on some marketing guys white
Title: unix time conversion function
Cary I once thought I wanted to do some Perl coding... So I bought a
book and started to play with it. It made my head bleed... literally I had
little droplets of blood emerging from my head They rushed me to the
hospital and put me in the Perl
Hi,
My brain is slow today Can someone help me ?
I can do :
select idu+1 from user_group_members where fk_user
in(44541,41402,41813) ;
IDU+1
--
41411
41821
44546
But I can't do :
select 'insert into XXX (IDU,PEN_ID,LAST_ACCESS,FK_APPLICATION) values ('||IDU + 1
Hi
We could always use the old programmer trick.
nm oracle | grep time This will give os all external function with a
name like time
after some man / google work gethrtime() look like interesting.
Assuming that gethrtime()
is the correct function it will be random depending on the hardware
the only time i've had the need for a regular shutdown
was when there was that lovely old solaris problem
where an os clock wrapped and put junk into the
controlfile (and thus made a little bit of a mess of
the database) so a db had to be bounced at least once
every (I think) 248 days, but other
Try
select 'insert into XXX
(IDU,PEN_ID,LAST_ACCESS,FK_APPLICATION) values ('||(IDU +
1)||','||PEN_ID||',sysdate,'||FK_APPLICATION||');' from
app_users
where pen_id in
(44541,41402,41813);
-Original Message-From: Henrik Ekenberg
[EMAIL PROTECTED][mailto:[EMAIL PROTECTED]]Sent:
You might want to try using () around the idu+1 part!
like:
select 'insert into XXX (IDU,PEN_ID,LAST_ACCESS,FK_APPLICATION)
values ('||(IDU + 1)||','||PEN_ID||',sysdate,'||FK_APPLICATION||');'
from app_users
where pen_id in (44541,41402,41813) ;
That should do it!
Best Regards
Johan
Title: Message
hi, here are more info for our actual
config.
Server for 9iAS : OS=win2000
db=Oracle9i
Each db is on a separate
server.
App 1 : 8 users Database server 1
Oracle 9i / unix NCR
App 2 : 3 users Database server 2
Oracle9i / NT
App 3 : 87 users Database server3
Oracle9i / NT
select 'insert into XXX (IDU,PEN_ID,LAST_ACCESS,FK_APPLICATION) values
('||(IDU + 1 )||','||PEN_ID||',sysdate,'||FK_APPLICATION||');' from
app_users
where pen_id in (44541,41402,41813) ;
IDU + 1 must be replaced by (IDU + 1).
HTH.
Nirmal.,
-Original Message-
Sent: Tuesday, January 28,
try this ((IDU + 1)):
select 'insert into XXX (IDU,PEN_ID,LAST_ACCESS,FK_APPLICATION) values
(' || (IDU + 1)
||','||PEN_ID||',sysdate,'||FK_APPLICATION||');' from app_users
where pen_id in (44541,41402,41813) ;
HEheac Hi,
HEheac My brain is slow today Can someone help me ?
HEheac I can do
Hi Listers,
I would like to know the differences between Development and
Production DBA w.r.t. Roles and Responsibilities, Scope etc. Is there any
difference in the role(s) played by a DBA in OLTP and DSS environments?
Your invaluable viewpoints in this regard is most welcome.
Thanks
Whoops! Sorry about that...
...grumble...over-40 eyes.over-40 brain..grumble...mutter
- Original Message -
To: [EMAIL PROTECTED]; Tim Gorman [EMAIL PROTECTED]
Sent: Monday, January 27, 2003 11:27 PM
If that were the case, he would not have seen 88640 rows
from
Title: unix time conversion function
I think its like almost any subjective
idea: its beautiful if you love it, heinous if you hate it.
I love Perl; it does what I mean. The only
thing I really dont like about Perl 5 is its yucky way of supporting complex
data structures. Im eager to
Hi Listers,
Are there any websites and/or documents on Writing Efficient SQL
queries? I know there are numerous tips in Guy Harrison's book. But I
need some kind of Power point presentation or PDF document for the same.
Can anybody point me some good URLs and/or douments please? Any
The first query says where FK_USER in (44541,41402,41813) and the second
query says where PEN_ID in (44541,41402,41813)...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, January 27, 2003 11:43 PM
Hi,
My brain is slow today Can
I've managed to successfully avoid learning Perl for a while now... my
reaction, while not quite so dramatic as yours, was that it made my
head hurt to try to understand it! :)
--- Robert Freeman [EMAIL PROTECTED] wrote:
unix time conversion functionCary I once thought I wanted to do
some
Roy,
I missed the first run of the question, so you've
probably had this answer already.
You can set a role inside a procedure if
the procedure is declared with invoker
rights (authid current_user) although the
procedure cannot then be run in a logon
trigger.
However, in Oracle 9, you could
Personally... I think that if I had the same teacher to help me through Perl
that REALLY taught me what C was doing in memory and got me to REALLY
understand the power and elegance of pointers, I would code more in Perl. I
can, and occasionally do, code in Perl, but nothing fancy or real
Thanks that solved the problem
Regards
Henrik
--
---
Henrik EkenbergAnoto AB
On Tue, 28 Jan 2003, Johan Malmberg wrote:
-!-You might want to try using () around the idu+1 part!
-!-
The first query also says 'from user_group_members' and the second one 'from
app_users' ... I am not sure that the comparison is anything but confusing ...
Looks like the implicitly converted varchar2() column which contains '***', 'N/A' or
the like ...
The first query says where FK_USER in
Hi,
I installed Oracle 9i under Windows 2000 professional with a domain user
who has admin rights.
After installing I couldn't use it:
- If I log in with Administrator/Local Computer then the message of Net
Manager (when testing the service)
I got the error message Oracle not available
After
A development DBA is a developer who wants to design the schemas his/her
application will rely on. I prefer calling them application designers,
because that's what they are. Sometimes you have another role, that of
Application Administrator. This second group is for larger applications
that
Check the file and folder permissions of installation files as well as
database files.
Give full permissions to local administrator on all the files (from root
level) , things
should work fine after that.
HTH,
Rajesh
-Original Message-
Csillag
Sent: Tuesday, January 28, 2003 4:19 PM
Title: RE: Perl - Was Unix time conversion function
I used to be, but I finally bit the bullet ... I ordered my copy of Jared's book from Amazon.com yesterday !!
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot
Rick,
Might there be a Scheduled Task or DBMS_Job that runs shortly after the
load and deletes rows?
Just a thought - such automagic processes have bitten me in the past.
Jack C. Applewhite
Database Administrator
Austin Independent School District
Austin, Texas
512.414.9715 (wk)
512.935.5929
Perl is great for getting the job done fast. It's harder to
write a large maintainable system in perl than other languages
but you use the right tool for the job. And, IMO, if you are ever
writing fancy or real creative code rewrite it. K.I.S.S.
On Tue, 28 Jan 2003, April Wells wrote:
The only problem I had was differentiating between the actual code and the
encrypted version of the same ;) But we will get there eventually.
Denny
Quoting Robert Freeman [EMAIL PROTECTED]:
unix time conversion functionCary I once thought I wanted to do
some
Perl coding... So I
It's not quite so hard and fast
I'm considered a development DBA here. I design the schemas, the
database layouts, the initialization parameters that are set etc
I work with a hosting company to manage the staging and production
databases. I create scripts for ALL changes to any of these
Title: Case of the Missing Rows
Rick,
Try the following to see which rows are missing. It the
same rows are missing each time, perhaps there is a common thread. If not,
well
After Step 2, do a create table as select or sql*plus copy.
This will create a backup version. Do a count(*)
Perl kind of makes sense but I haven't reached the point where it clicks and
becomes natural. I still need to think about it very hard when I'm writing
it. Hence, a lot of the time I fall back on shell scripts supplemented by
pre-written (some would say shamelessly ripped off) perl code for the
Hi All,
Does anybody have any good resources that discuss the pros and cons of each
RAID level, and their respective set up procedures?
Thanks in advance for any pointers.
Mark
===
Mark Leith | T: +44 (0)1905 330 281
Sales
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Mark Leith
Enviado el: martes, 28 de enero de 2003 15:34
Para: Multiple recipients of list ORACLE-L
Asunto: OT - Raid
Hi All,
Does anybody have any good resources that discuss the pros and cons of each
9iAS Release1 uses 8.1.7 libraries.
9iAS Release2 users 9i libraries. 9i [either client or server] connections
to 7.3 aren't supported and may well give errors.
Hemant
At 07:59 AM 27-01-03 -0800, you wrote:
It works here for both 9iAS R1 R2!
Amos
KABORE
Hi Juan,
Thanks for the reply!
Unfortunately Oracle-L doesn't allow attachments, would you be so kind as to
forward the original to [EMAIL PROTECTED]?
Many thanks!
Mark
-Original Message-
Miranda
Sent: 28 January 2003 15:04
To: Multiple recipients of list ORACLE-L
-Mensaje
Title: unix time conversion function
Now
that's what I call a "Perl Breakdown!!"...A nervous breakdown brought on
by pathological eclecticism. The cure for this is a healthy dose of Python. It
is truly refreshing!!
Steve
Orr
Oracle
DBA and part-time Python Evangelist.
-Original
Original Message
In my mind there is nothing obvious about Perl,
Anyone else feel that way about Perl or am I a
lone wolf in a Perl world?
I think the correct progression is to start with ksh; then mix in sed, awk,
For very obscure reasons (read: one of those developer decisions that you
want to use a time-machine to go back and change), we're storing some
information in base-36 (0,1,2,3...8,9,A,B,C,...,Y,Z) in a varchar field.
And you thought hexadecimal was fun :-)
Now some bright spark would like me to
Title: Case of the Missing Rows
Could they be in the .bad file? I have had stuff go
there if a column was too long or something.
Ruth
- Original Message -
From:
Tim Gorman
To: Multiple recipients of list ORACLE-L
Sent: Monday, January 27, 2003 7:43
PM
For me, it was either Perl or an icky bass-ackward pipe-laden awk/sed/regex
unmaintainable bastion. OK, I couldn't get rid of the regex. While I'll
not be entering the Obfuscated Perl contest anytime soon, I think Perl is
much easier to understand for a traditional programmer (Assembly, BASIC,
please don't take umbridge, but I feel enticed to quote
what you don't know, dosn't (really) matter
Larry Wall, programming with perl, O'Reilly.
just for a giggle.
sorry
apologies for any typos overlooked
kr mr
[EMAIL PROTECTED] 01/28/03 12:22 PM
I've managed to successfully avoid
Title: Case of the Missing Rows
Rick,
Another idea is to check the explain plans of each of the
queries. If there is a difference it could indicate that the data is there, but
a particular access path is invalid.
Dan
Fink
-Original Message-From: Fink, Dan
[mailto:[EMAIL
Just happen to have this lying around
CREATE OR REPLACE function
base_x2y
(
input varchar2,
basein integer,
baseout integer
)
Return varchar2 is output varchar2(255);
output_val integer := 0;
char_valvarchar2(1) := null;
number_val integer := 0;
Try this:
CREATE FUNCTION to_dec
( p_str in varchar2,
p_from_base in number default 16 ) return number
AS
l_num number default 0;
--l_hex varchar2(16) default '0123456789ABCDEF';
l_base varchar2(16) default '0123456789ABCDEFYZ';-- fill
in the blanks
begin
Title: Message
Nope,
.BAD file is empty, I have been experimenting this morning with cloning the
table as suggested earlier, but every DDL statement against the table drops the
rows (#'s 70-1417) of the ID PK Column. Still working on that
angle
Rick
Weiss
-Original
Sounds like something the bright spark or Duhveloper should fix. It's better
when they experience their own pain.
Reply Separator
Author: Grant Allen [EMAIL PROTECTED]
Date: 1/28/2003 7:45 AM
For very obscure reasons (read: one of those developer
Ranganath
You are getting some excellent responses to your question (which I consider
very on topic). We had a good discussion on this list previously. I went
to Google and entered fatcity production dba and was able to pick up the
thread.
As to your question of OLTP vs. DSS situations, I think
Mark
You could try the following links for details about the various RAID
configurations.
http://www.solumedia.com/raidinfo.htm
http://www.webopedia.com/TERM/R/RAID.html
http://www.acnc.com/raid.html
Eddie Watkins
The Moray Council
email: [EMAIL PROTECTED]
tel: 01343 563247
Hi All,
Does
I've started writing some perl and it is hard to learn, but once you learn,
it can do some great things. And if you learned it from the Larry Wall book
like I did, then it's even harder.
The thing I've discovered about perl it that it may be the only language
(computer or otherwise) that is
Title: RE: Slightly OT: Development Vs. Production DBA
I agree 100%. I am fighting this battle as we speak. Many Duhvelopers think they can do it all until something goes wrong then guess who they call to bail them out. Then Damagement is breathing down your neck to get it fixed when you
Title: Message
Dan:
Thanks, I think I got through it, here's what I've found (explanations
would be greatly appreciated)
1)
Created table as before from Designer/2000 scripts with indexes and
constraints
2)
SQLLDR to create initial data list
3)
SELECT COUNT(*) FROM TB - yields 88640 rows
If SQL*Loader had not loaded all the stuff, then the first count(*) would return the
same thing as the second one.
My (wild) guess would rather be some mishandling of the high-water mark or something
similar. Really looks like a bug.
Things I would try :
- Analyzing the table (compute) after
My impression of Programming Perl was that it was primarily intended as an
ego trip for the author. I found Learning Perl 2nd Ed. and Perl Core
Language / Little Black Book to be much more useful. Yes, I have the Perl
for Oracle DBA's too, but haven't had the time to get into it yet.
Oracle made rowids base 64. Try to identify a corrupt block number from
that when you do select rowid, last_column_of_table from table; to see
where the thing breaks. Does anyone, perchance, know if they provided a
base 64 converter to go with the base 64 rowids?
-Original Message-
1. Is there any way we can tune the forms/reports application ?
2. How can we check which form/report is actually the bottleneck.
We have a large no. of forms/reports and almost all are very big/complex.
Is there any third party utility to do this ?
TIA
Shuja
--
Please see the official
What's the title of Jared's book?
-Scott
At 05:03 AM 1/28/03 -0800, you wrote:
I used to be, but I finally bit
the bullet ... I ordered my copy of Jared's book from Amazon.com
yesterday !!
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
sounds like a bug to me.
nice investigative work.
Jared
Weiss, Rick [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/28/2003 09:08 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Case of the
Hi
I wanted to migrate my database from SUN solaris to WINDOWS 2000
platform.Curetly I am having sun cluster as failover with shared disk.
I wanted to setup similar kind of setup with windows 2000.
Is any failover option available in Windows2000?
Let me know if anyone does such kind of setup
Is the table in an autoallocate tablespace -
is the tablespace using assm ?
Are the appropriate list of extents apparently
present in the table. Can you dump the
segment header block to see if the extent
list looks sensible. Is the tablespace free space
consistent with the tablespace used space
Also, on scant nights I've even been rolling my own KISS-method Perl/Tk
OEM
replacement. Sorry Jared, but sometimes I like GUIs! :)
Why? Look up OraC and OracleTool on google.
Jared
Jesse, Rich [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/28/2003 07:58 AM
Please respond to
Title: RE: tuning forms/reports application
1. you sure can, but it depends on what you want to tune for ...
2. Usually in my case, I trust my user, if they say form xyz is running slow like a drunk snail, there is a good chance that it is, so I work on that.
Raj
Here's a packaged and modified version of Tom Kyte's conversion routines.
--- the package
create or replace package radix
is
/*
base code courtesy of Thomas Kyte
*/
function to_base( p_dec in number, p_base in number )
return varchar2;
swag -- is there a trigger on either of those tables?
sounds like the possibility of an AFTER STATEMENT trigger
this is of course, total guesswork
but it only occurs when you create the table from scratch, or at least
that's how I'm reading what you wrote
--- Weiss, Rick [EMAIL PROTECTED]
Robert,
Perl isn't really that hard.
As with any language, it can be difficult to grasp at first, but once
you begin to understand it, it can be extremely powerful.
Regarding Cary's comments about the difficulty of complex Perl
data structures, I would have to say that they aren't any more
I am going to be taking over the implementation of DataGuard for 9.2.
Before I do, I'd like to learn as much about it as I can. Have any books
been written about DataGuard? Or do any books out there have portions
addressing DataGuard?
Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX:
Title: RE: Slightly OT: Development Vs. Production DBA
-realizing that marketing people are a different species
-that will never know their needs in advance.
... and don't actually care what *our* needs are ...
Raj
__
Rajendra
-realizing that marketing people are a different species
-that will never know their needs in advance.
Amen brother, Amen
-Original Message-
Sent: Tuesday, January 28, 2003 10:49 AM
To: Multiple recipients of list ORACLE-L
Ranganath
You are getting some excellent responses to your
Title: RE: Perl - Was unix time conversion function
If you can do it in Perl chances are you can do it better in Python and someone can actually read and understand it without a PHD... AKA Perl Helper Dweeb. :-) In Perl it takes effort to write readable code but it comes naturally in Python.
-Original Message-
I wanted to migrate my database from SUN solaris to WINDOWS 2000
platform.
-
... and there was a time when I thought it would be neat to put splinters in
my bathroom tissue.
--
Please see the official ORACLE-L FAQ:
Title: RE: Perl - Was unix time conversion function
I
haven't done anything with Python but my problem with Python or Ruby is
that
they
don't come with many OS variants. Perl comes with any OS and there is
a
huge
repository of ready made scripts. I have to confess stealing some from
HP has such a software. It used to be know as Compaq TrueCluster. As for
migrating from Solaris to Windows,it's a good decision. Many software
packages do not work at all with Solaris or any Unix version. One that has
become very popular lately is called slammer. It only works with Win2k
and
I'll add a clarification. With its object interface, Perl actually lets
one define much more easily accessible data structures than one can in
C. The problem with that is that the extra code path consumed by the
accessor methods is too slow to actually *use* them in some of our code
(think tens of
Stephen,
The code I posted earlier is easily adapted to do base 64.
Please share your mods. :)
Jared
Stephen Lee [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/28/2003 09:13 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Title: Global Stats
Hi everyone,
Back to the lovely world of Oracle :) I've been reading up on statistics. Out of the 8.1.7 doco:
/*
Partitioned schema objects may contain multiple sets of statistics. They can have statistics which refer to the entire schema object as a whole (global
-Original Message-
I'll bet Stephen has a toolbox in his garage that contains
a single flat blade screwdriver and no phillips screwdrivers nor any
wrenches. ;)
-
Don't need tools. Got pshycokinesis (got milk too). Been taking lessons
Title: Message
I'm
thinking it is related to the execution plan. When you compute stats, you don't
seem to have a problem. Run the same tests and check the execution plans in
autotrace.
-Original Message-From: Weiss, Rick
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 28,
amazingly the oracle docs are pretty good on data guard
implementation(as compared to oracle docs in v5/v6 days). :)
joe
Ball, Terry wrote:
I am going to be taking over the implementation of DataGuard for 9.2.
Before I do, I'd like to learn as much about it as I can. Have any books
been
Yes, only after an empty build from scratch
No triggers at all on either table
Rick
-Original Message-
Sent: Tuesday, January 28, 2003 11:34 AM
To: Multiple recipients of list ORACLE-L
swag -- is there a trigger on either of those tables?
sounds like the possibility of an AFTER
LMAOROTF
--- Gogala, Mladen [EMAIL PROTECTED] wrote:
HP has such a software. It used to be know as Compaq
TrueCluster. As for
migrating from Solaris to Windows,it's a good
decision. Many software
packages do not work at all with Solaris or any
Unix version. One that has
become very
- because it would be fun to write your own app
- sense of accomplishment
- you'd get a better handle on the language knowing
it's strength and weaknesses
etc...
Not saying that you should go and write your own dbms
or word processor or OS. But sometimes writing a
little utility from scratch
-Original Message-
Stephen,
The code I posted earlier is easily adapted to do base 64.
Please share your mods. :)
-
OK. I figured out that A is zero (I think). Now, only 63 more to go!
--
Please see the official ORACLE-L FAQ:
On Tue, 2003-01-28 at 13:29, Ball, Terry wrote:
I am going to be taking over the implementation of DataGuard for 9.2.
Before I do, I'd like to learn as much about it as I can. Have any books
been written about DataGuard? Or do any books out there have portions
addressing DataGuard?
Go to
Lisa,
On our home grown partitioned databases, I am still using the ANALYZE command for
partitions. There were some bugs associated with DBMS_STATS and partitions, although
I don't remember the specifics at the moment (it may have been with 8.1.6). I haven't
had a chance to go back and see
Hi:
Oracle 8173 on Sun 2.8.
When we had tablespace created as DMT, I used to occuasionally find all
indexes in a schema which have multiple extents and run a script to compress
each of them into one single extent (maybe this is not necessary, but that's
another topic). But I find lately that
There is an excellent white paper by Gaja Krishna Vaidyanatha:
http://www.quest.com/whitepapers/Raid1.pdf
Mark Leith wrote:
Hi All,
Does anybody have any good resources that discuss the pros and cons of each
RAID level, and their respective set up procedures?
Thanks in advance for any
Here ya go:
create or replace package radix
is
/*
base code courtesy of Thomas Kyte
*/
function to_base( p_dec in number, p_base in number )
return varchar2;
function to_dec (
p_str in varchar2,
p_from_base
1) No, you can't compress into a single extent if the TBS is
LMT with uniform extent size, and the size of the index is
extent size. Don't know about auto extent size feature.
2) Why would you want to compress into a single extent?
There's no benefit to doing so.
Jared
Guang Mei [EMAIL
You can always outsource your perl development to me. :)
On Tue, 28 Jan 2003, Hately, Mike (NESL-IT) wrote:
Perl kind of makes sense but I haven't reached the point where it clicks and
becomes natural. I still need to think about it very hard when I'm writing
it. Hence, a lot of the time I
Is there any possible way to retain/reinstate/continue a SQLNet connection
if there is say a 10-second network outage?
For example: If a session is established and then the network cable is
unplugged for 5 seconds and then replaced. Is there anyway to keep that
connection alive?
Michael
I tinkered with Perl, but could never really get used to the syntax.
I basically gave up (still maintain familiarity since Perl is very
common) and started using Python. I've grown to enjoy coding in Python
and use it now for all of the system maintenance and monitoring scripts
I write as well
Title: RE: Perl - Was unix time conversion function
Are you sure? It's written in C and is supposed to be relatively portable. I've not tried it on other platforms but, in addition to HP-UX and AIX, Python runs on: AS/400; Solaris; OS/2; Amiga; AROS; BeOS; PalmOS; QNX; VMS; VxWorks; Sony
Title: Peoplesoft & Oracle
Welcome Lisa,
I've
got PeopleSoft with 8.1.7 and AIX also (peoplesoft 8.4). It's not quite the dark
side, more like Dante's Inferno. There are a number of websites and lists, but I
haven't found any to be all that useful. A lot of the problems you mention arise
If I remember right, global stats are computed/inferred from partition level
stats if its available. If thats the case, then it may make sense to
compute/estimate the stats at the partition level. You also have the advantage
of being able to run analyze each partition in parallel.
Regards,
If using TCP/IP, you don't have to do anything. 10 seconds is short
enough time for the connection to still be alive.
--
Lyndon Tiu
Quoting Bond Mike A Contr OC-ALC/LPRC [EMAIL PROTECTED]:
Is there any possible way to retain/reinstate/continue a SQLNet
connection
if there is say a
We have been using SQLBacktrack to backup our databases on Unix and NT for
several years. We have been VERY please with the product. We have a
mixture of Oracle 8.1.7 and 7.3.4 databases. We are being pushed to use
RMAN because it is free. Does anyone have any experience with both and be
We are buying books for DBA group and developers . It will be great if u can provide
ur feedback about following books:
Oracle SQL High-Performance Tuning (2nd Edition)
by Guy Harrison
High-Performance Oracle: Proven Methods for Achieving Optimum Performance and
Availability [DOWNLOAD: ADOBE
If you are using TCP/IP, then yes. It's highly dependent on your OS
TCP/IP stack though. I tried it with Linux and it seems fine.
--
Lyndon Tiu
Quoting Bond Mike A Contr OC-ALC/LPRC [EMAIL PROTECTED]:
Is there any possible way to retain/reinstate/continue a SQLNet
connection
if there is
You could try the following, set up
by David Kurtz who has been
specialising in Peoplesoft on Oracle
for several years.
web: www.go-faster.co.uk
PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Coming soon a new one-day
Hi all,
Please forgive this newbie question; I'm just getting started with PL/SQL.
I want to write a procedure to copy all rows from one table to another one
with an identical structure. The table has many rows so I'm committing
every thousand records (error handling to be added later). The
Lisa,
Sounds like a default install of PeopleSoft. Step 1 that you can do is
re-assign everyone to use a real temp tablespace. Step 2 is break up that db
onto seperate spindles. Step 3 is to turn off autoextend exept for those
tablespaces that are nearing say 90% full, then set autoextend to
On Tue, Jan 28, 2003 at 09:59:46AM -0800, Orr, Steve wrote:
If you can do it in Perl chances are you can do it better in Python and
someone can actually read and understand it without a PHD... AKA Perl Helper
Dweeb. :-) In Perl it takes effort to write readable code but it comes
naturally in
1 - 100 of 127 matches
Mail list logo