Re: using oracle 817 driver against oracle 92 database

2004-01-27 Thread Paul Drake
/sb/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: ORA-12540: TNS: internal limit restriction exceeded

2004-01-21 Thread Paul Drake
(like subscribing). === message truncated === __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Drake INET: [EMAIL

Re: Re: pga_aggregate_target and a memory leak

2004-01-21 Thread Paul Drake
-- __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: FW: Disk capacity planning

2004-01-20 Thread Paul Drake
--- Niall Litchfield [EMAIL PROTECTED] wrote: Hi The bad news is that I don't believe that calculating IO/Sec *can* be done for a *new* system. At least I'd like to see how it is done. I'm willing to bet that any formula for doing it will include (x%) for 'overhead', which actually means

Re: problem with log version

2004-01-20 Thread Paul Drake
__ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- 858

resend: Re: Disk capacity planning

2004-01-13 Thread Paul Drake
is the list smart enough to block my posts made after 2 am? Pd --- Paul Drake [EMAIL PROTECTED] wrote: --- [EMAIL PROTECTED] wrote: Hi everyone! Can anybody point me to any good documentation regarding disk capacity planning? Sharing your experience or approach will also give me

RE: ORA-3113 errors after switching W2K server to new network

2004-01-12 Thread Paul Drake
leaving it running idle all day... It's now a political decision rather than a technical problem. A satisfactory end to the problem, which may well have not been the case without the input from this list, for which many thanks, particularly to Tim Onions, Paul Drake and Tim's resident

Re: test

2004-01-12 Thread Paul Drake
own posts. mmm, could be ... Pd __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Drake INET: [EMAIL PROTECTED

Re: Export bigger then 2G with Oracle7.3.4

2004-01-09 Thread Paul Drake
://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Oracle Standby.

2004-01-09 Thread Paul Drake
!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: internet secure solutions

2004-01-09 Thread Paul Drake
: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: [Fwd: Joseph Testa has sent you a 10% discount]

2004-01-09 Thread Paul Drake
FAQ: http://www.orafaq.net -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE

Re: ORA-3113 errors after switching W2K server to new network

2004-01-08 Thread Paul Drake
: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

OT: RE: DBA position

2004-01-08 Thread Paul Drake
Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

Re: Apple RAID marketing?

2004-01-07 Thread Paul Drake
). __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: DBA tasks

2004-01-07 Thread Paul Drake
subscribing). __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network

RE: HOTSOS Conference

2004-01-06 Thread Paul Drake
://www.orafaq.net -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing

RE: Upgrade

2004-01-06 Thread Paul Drake
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Upgrade

2004-01-06 Thread Paul Drake
! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: Progress of an index rebuild

2004-01-06 Thread Paul Drake
subscribing). __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network

Re: oracle client on PC's

2004-01-06 Thread Paul Drake
! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: oracle client on PC's

2004-01-06 Thread Paul Drake
__ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

Re: oracle client on PC's

2004-01-06 Thread Paul Drake
: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Upgrade

2004-01-06 Thread Paul Drake
://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: TNSPING VS. REGULAR PING..! WHY SUCH A DIFFERENCE

2003-12-22 Thread Paul Drake
ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Linux

2003-12-20 Thread Paul Drake
Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Unable to coonect to database after server upgraded from NT to W2K

2003-12-20 Thread Paul Drake
] __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: problem with mult datafiles and local mng tblspaces

2003-12-20 Thread Paul Drake
that I work with is under 100 GB. A File size of 2000 MB scare me, bugs in the past with 2 GB files. Pd __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul

RE: NT - Win2K causes performance degradation..

2003-12-16 Thread Paul Drake
my sysadmin tells me (after checking with MS). Yechiel Adar Mehish - Original Message - From: Paul Drake To: Multiple recipients of list ORACLE-L Sent: Wednesday, December 10, 2003 6:49 PM Subject: Re: NT - Win2K causes

Re: connection pooling from an application server to oracle

2003-12-15 Thread Paul Drake
Mladen, Tread lightly on the "solar flares" my friend. Last time we had some severe flares, 2 of my client sites lost their air conditioning units, which resulted in media failures. Hadn't had any air conditioning outages in at least 3 years at sites. Just a strange (circumstantial) coincidence,

OT - RE: Re: Who are certified Oracle Masters?

2003-12-15 Thread Paul Drake
how scary would it be to arrive at the exam, and the inquisitioner is dressed as Gandalf. Right after he hands out the exam he slams his staff to the floor and screams "NONE SHALL PASS". I'm looking forward to the midnight showing of LOTR - ROTK tomorrow night. The movie is 3 hours, 42 minutes -

Re: Re: New TPC benchmarks

2003-12-15 Thread Paul Drake
Nuno, The whole thing is an extravagant waste. I beg to differ. When I ask for 2 external storage units of 14 drives apiece (DAS), and they look at me like I obviously have no clue about their intentions of a 3 drive RAID something other than 10 config, a configuration that they can download

Re: Re: New TPC benchmarks

2003-12-15 Thread Paul Drake
what's really helpful about these, are the server tweaks made (if you deploy on win32). check out http://www.tpc.org/results/FDR/TPCC/dell_2650_261103_fdr.pdf Pg 170 - there's a list of all of the services that are disabled/stopped - 24 in all. Pg 224 - the section of the MS diagnostics report

Re: automate backup and export

2003-12-13 Thread Paul Drake
John, Oracle publishes reference material available on OTN. You can sign up for an account on http://otn.oracle.com, where you can find their documentation and articles. for example: Configuring Oracle Recovery Manager http://otn.oracle.com/oramag/oracle/02-nov/o62support.html or the RMAN

Re: Performance tuning in complex environment

2003-12-12 Thread Paul Drake
All, This sounds wy too familiar to me. My (blind) guess is that sql*net round trips is killing performance. System-wide could indicate this, but, as Jared states, trace out a specific session, and grab the session-specific info from v$sesstat, before and after. We brute forced the issue of

RE: for security patches - going to 9.2.0.4

2003-12-12 Thread Paul Drake
Paula, since you use the export utility - patch to 9.2.0.4. a full export will throw an error in 9.2.0.3, on W2K and on RH 8.0. regarding security, I haven't yet applied the 8.1.7.4.13 patchset (its not yet available) or the SSL-related issues in Oracle Security Alert #62. but the patchset

RE: for security patches - going to 9.2.0.4

2003-12-12 Thread Paul Drake
if you have compatible set to 8.1.7, I'll bet that optimizer features from 9.2.0 aren't available. you would have to decide if you want to use the 9.2 CBO or the 8.1.7 CBO. The only reason that I can think of that you'd want to use the 8.1.7 CBO is if your code ran well in 8.1.7 and some

RedHat Advanced Server v3.0, anyone?

2003-12-12 Thread Paul Drake
Has anyone kicked the tires on RH AS 3.0? There is a strong possibility that in a migration early next year, that a client wants to move off of MS w2k adv svr and onto either RH AS or SLES (they are an HP (compaq) shop). It seems like a bad idea to start them off on RH AS 2.1 now, when they likely

RE: NT - Win2K causes performance degradation..

2003-12-11 Thread Paul Drake
Mark, MS w2k3 server supports large memory in the standard product, advanced edition not required.For me,those (client) systems are still in acceptance testing, and I have not yet actually run them with a process memory 2 GB. I'll let you know after I do, sounds like a good test for a rainy

Re: Re[2]: http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.a sp

2003-12-11 Thread Paul Drake
Maybe they should rename the product Petadata. If they did, then its a good thing that they didn't name it "TeraFile". PdJonathan Gennick [EMAIL PROTECTED] wrote: Thursday, December 11, 2003, 5:14:26 PM, Ryan ([EMAIL PROTECTED]) wrote:R very nice. what is teradata? I never hear that dbms

RE: for security patches - going to 9.2.0.4

2003-12-11 Thread Paul Drake
Paula, I hope that you are just confused. AFAIK, if you have created a database with a locally managed system tablespace, that you cannot set compatible to anything lower than 9.0.1. Ok, you can set it, but oracle will complain during instance startup and you won't have a database instance to

RE: Windows clustering???

2003-12-11 Thread Paul Drake
I'm guessing that you removed the monitor, keyboard and mouse, disabled terminal services, removed it from the domain, unbound NetBIOS from TCP/IP and shut down all of the non-required services (especially "Server")- and - put a penguin sticker on the front of it, so that people thought it was a

Re: NT - Win2K causes performance degradation..

2003-12-10 Thread Paul Drake
Mark, My guess is, that the new OS re-instated the file system caching. By default, 41% (yes, it should have been 42%) of physical memory will be allocated to filesystem caching, as W2K thinks it a fileserver(and domain controller, web server, print server, etc) until you tell it otherwise. This

anyone seen this? (possible controlfile corruption)

2003-12-05 Thread Paul Drake
Hi. tar already opened - awaiting feedback. W2K Adv Svr Sp4 Oracle 9i R2 Std Ed 9.2.0.4 NTFS 5.0 filesystem Dell 2650, PERC3/Di controller, writeback caching enabled qa database, not a huge deal at the moment. I have a backup controlfile, but would rather not open resetlogs, as there is a remote

Re: tis a puzzlement...

2003-12-05 Thread Paul Drake
Bill, There are several bugs out there in exp.exe land. my current favorite is the ORA-00907 that shows up when importing (8.1.7.4 - just hit this one again last night). my second favorite is the ORA-00942 that appears when exporting (9.2.0.3 - fixed in 9.2.0.4). neither of these seem to be what

Re: How windows manage memory: oracle

2003-12-04 Thread Paul Drake
Hi. The 2 GB process limit kicks in well under 2 * 1024 *1024 * 1024. its between 1.7 and 1.8 GB. I'm quite familiar with hitting it in win32, as large memory support was not enabled in every 8.1.7.x patchset. Large memory support sure works great in 9.2.0.4. W2K3 Server (not Advanced) ships

Re: FW: SAN configuration for Banner

2003-11-20 Thread Paul Drake
, and still stay up. Even more beneficial, in the RAID 01 if you lose on drive, you will lose 50% of read throughput. Losing a single drive in the RAID 10 will cost you about 10% throughput. If Matthew Zito is still here, he can no doubt enlighten us with no end of detail on the subject. Jared Paul

RE: FW: SAN configuration for Banner

2003-11-20 Thread Paul Drake
10% throughput. If Matthew Zito is still here, he can no doubt enlighten us with no end of detail on the subject. Jared Paul Drake [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/19/2003 12:20 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

Re: FW: SAN configuration for Banner

2003-11-19 Thread Paul Drake
Sam, Dell was perfectly happy to configure the following for me on a CX200 unit: (2 trays of 15 drives, 1 tray 36 GB 15K, 1 tray 73 GB 10K, 1 hot spare per tray) 3 x RAID 1 for online redo logs (members a,b,c, 6 drives total) 2 x RAID 01 for datafiles (8 drives each, 16 drives total) 1 x RAID 1

Re: Test mesg

2003-11-16 Thread Paul Drake
Hey! that looks like my switch_logfile proc (scheduled with dbms_job), which I still like better than archive_lag_target (except that it only looks at the first character being an 'S') Why generate a log every half hour over the weekend? Pd[EMAIL PROTECTED] wrote: [EMAIL

Re: Security : Denial Of Service

2003-11-09 Thread Paul Drake
Saminathan, How dare you post such a message with that subject line. Here is my response, which you will not appreciate highly: read the fscking manual. http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/secure.htm#2193 how does oracle address it? by having it as configurable

RE: long time to kill a session

2003-11-07 Thread Paul Drake
dead connection detection is supposed to work on 9.2.0.4, but I can't seem to find any docs on this. has anyone exmained this? thanks, Pd"Khedr, Waleed" [EMAIL PROTECTED] wrote: Did you try orakill? -Original Message-From: Mauricio "Vilez [mailto:[EMAIL PROTECTED]Sent: Thursday,

Re: This is just wrong

2003-11-06 Thread Paul Drake
Tim, Oracle has even produced a "developer's release" of Oracle9.2 for Mac OS X, downloadable from OTN. that was released in Sept 2002. releases of 8.1.6 and 8.1.7 were supposed to be released for production usage, according to articles floated by Bob Shrimpi. Those never happened. What do you

Re: Bitmap join indexes

2003-11-05 Thread Paul Drake
Mladen, If you are not currently running Enterprise Edition, they are indeed very expensive indexes. :D PdMladen Gogala [EMAIL PROTECTED] wrote: Has anybody here ever used bitmap join indexes? I have a very expensive jointhat I'd like to optimize and I'd like to hear about any, positive or

RE: redhat/oracle

2003-11-04 Thread Paul Drake
Debian. http://www.debian.org/social_contract "Thater, William" [EMAIL PROTECTED] wrote: Joe Testa scribbled on the wall in glitter crayon: And now novell is eating up Suse, http://www.slashdot.org 8:45A today. joeso now that Linux has "made it" are we going to have a Linux provider meltdown?

RE: redhat/oracle

2003-11-04 Thread Paul Drake
developer-oriented Fedora Project, which is a free download. http://www.computerworld.com/newsletter/0,4902,86827,00.html?nlid=AM -Original Message-From: Paul Drake [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 04, 2003 1:35 PMTo: Multiple recipients of list ORACLE-LSubject: RE

RE: redhat/oracle

2003-11-04 Thread Paul Drake
think it off topic here, as many of us use it to run Oracle. And there is usually far too much garbage as /. to get involved in the discussions, at least IMO. Jared Paul Drake [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/04/2003 01:19 PM Please respond to ORACLE-L To:Multiple

Re: Oracle 7.3.4.0 on Win 2000

2003-11-03 Thread Paul Drake
Arif, I have not tried this particular arragement (9.2 listener, 7.3.4 db) but, The current Oracle 9i Release 2 (9.2.0.4) listener would be the recommended listener to use. If you do not want to install that version, please use the 8.1.7 listener with the 8.1.7.4.1 and 8.1.7.4.12 patchsets

Re: Redo log corruption

2003-10-31 Thread Paul Drake
Shibu, How can i check the "health" of archive logs ?? apply them to a standby database. daily. grep the alert logs for errors. If you have 2 servers with adequate storage space, have standby databases for each database on the other server. use one set of scripts, all using environment

RE: DBA Support Database

2003-10-30 Thread Paul Drake
I recall seeing a "command center database" in the book Oracle 8i DBA Handbook by Loney, Theriault. chapter 6 - Managing multiple databases. its a start. I haven't read the 9i version. Rachel, were there any improvements to it? Paul"Loughmiller, Greg" [EMAIL PROTECTED] wrote: I'll throw

Re: Test : Because I haven't got a mail since yesterday

2003-10-30 Thread Paul Drake
solar flares? http://www.theregister.co.uk/content/archive/21961.html where is that excuse calendar, when I need it? Pd Mladen Gogala [EMAIL PROTECTED] wrote: On 2003.10.30 21:59, Satya Prakash Viswanath wrote: Are the email services down?Nope, they're up in smoke.-- Mladen GogalaOracle DBA--

Re: 2G trace files

2003-10-29 Thread Paul Drake
Richard, Are you sure that you are targeting your diagnostic efforts appropriately? If all users are using dedicated servers, then each trace file should only have the info for one session. If your interval for a statspack report is an entire week, its going to be pretty tough to find the

Re: Set processes at init.ora

2003-10-27 Thread Paul Drake
Mitchell, It would be most helpful if you supplied the Oracle Server version info. You may have simply had legitimately 190 users connected. You may have a problem with sessions being disconnected by the client that are not being terminated properly. It is a known issue that support for dead

Re: Set processes at init.ora

2003-10-27 Thread Paul Drake
$resource_limit after I reset processes No to 250. andsaw the No. is up and stable to 110 process. I will keep monitor it and make sure all session disconnected. I wonder if processes is set to higher, any impact to memory or resource usage? Mitchell - Original Message - From: Paul Drake

RE: Performance tuning book

2003-10-22 Thread Paul Drake
Cary, I detoured from the new Tom Kytebook after chapter 4 to read your test through. chapter 6 of the tom kyte book might have been a better band aid for me at the moment, but - I finally (4 weeks after the issue was raised) got a user to let me know when he was going to run a posting routine.

RE: Transportable tablespaces

2003-10-22 Thread Paul Drake
Pete, I remember trying to read an 8.1.7.3 database on w2k (ntfs)from a Suse Linux 7.1 install (dual boot). In theory, it was supposed to work. In practice, it hanged the system. Rachel, someday, I'll get LILO on that box to default into windows so that you don't have to catch it during bootup.

Re: Your new book

2003-10-22 Thread Paul Drake
Ryan, I do not recall seeing a single dy/dx or integrand in the text. Thetype of math that he used, I saw in high school, and that was in the US, at a public school. Cary easily could have used "real" math to prove his points. He didn't. He used graphical methods, visual basic and intuition. But

Re: CLOB data

2003-10-16 Thread Paul Drake
how about using tablespaces UMDOTBS (instead of UNDOTBS) and SYTSEM? thanks for the laugh. PdMladen Gogala [EMAIL PROTECTED] wrote: This is because "ENABLE STORAGE IN ROW" is the default, which meansthat oracle will store the first 4000 bytes in the original block.The first part of a LOB is,

RE: Database just stops, now 8.1.7 support

2003-10-15 Thread Paul Drake
ctually end, then? The reason I ask is that the word from Ken Jacobs in September was that 8i would only be supported through the end of this calendar year. This is incredibly relevant information, for I will have to guide my clients accordingly. Regards, Melanie -----Original Message- From:

Re: question on multibyte character storage

2003-10-14 Thread Paul Drake
would anyone care to take a whack at this? thanks. From: Paul Drake 14-Oct-03 19:52 Subject: sqlnet.expire_time support in 9.2 on NT (w2k) RDBMS Version:: 9.2.0.4Operating System and Version:: MS W2K Advanced Server SP4Error Number (if applicable):: Server Net Version:: 9.2.0.4Client Operating

Re: question on multibyte character storage

2003-10-14 Thread Paul Drake
sorry about posting that not under its own thread. Pd[EMAIL PROTECTED] wrote: would anyone care to take a whack at this? thanks. Do you Yahoo!? The New Yahoo! Shopping - with improved product search

Re: Database just stops

2003-10-14 Thread Paul Drake
Ron, Its highly likely that if you were to open a TAR on this, that the analyst would recite the following: "please apply the currently supported patchset" - which would be 8.1.7.4.1. Unfortunately, there are numerous security fixes that have been made available that are not in a full patchset

Re: SAME and separating disk and index tablespaces

2003-10-09 Thread Paul Drake
Gaja, No cups in this analogy? I'm thoroughly dissappointed. I would have liked the idea of a twelve pack that can only provide one can at a time, vs. 2 six packs that could each provide a beer. Paul Gaja Krishna Vaidyanatha [EMAIL PROTECTED] wrote: David and list,I think this provides

Re: auditing is my friend

2003-10-08 Thread Paul Drake
Pete, I readyour paper before I turned auditing on (in the first place). I've spent many an evening reading papers posted on your site and on the sans.org site. I haven't picked up your book in awhile, but I'm due to do so in updating our install docs for Oracle 9i on w2k3 svr. Has content been

more on Oracle Standard One

2003-10-08 Thread Paul Drake
http://www.crn.com/sections/BreakingNews/dailyarchives.asp?ArticleID=44997 Oracle Standard Edition One, based on the current Oracle 9i code, will cost $5,995 and is limited to use on one-processor servers, the company said. Alternatively, it can be sold for $195 per named user with a minimum of

Re: Help with a scripting problem

2003-10-08 Thread Paul Drake
Ron, one could include that directory in the path, then you would not have to provide the path in the command. Pd"Smith, Ron L." [EMAIL PROTECTED] wrote: I am trying to issue the following command in SQL*PLUS but it doesn't like the space between 'program' and 'files'. Can anyone tell me how

Re: alter session

2003-10-08 Thread Paul Drake
it raises the DBA's blood pressure by 50 mm Hg. if found, it prevents the user from having an unlocked account. if found, it is possible that it gets the user a termination notice. you're in the sys schema for what purpose? testing recovery from dictionary corruption? Pd[EMAIL PROTECTED] wrote:

Re: sid/serial# vs. audsid: why both?

2003-10-07 Thread Paul Drake
--- Paul Drake [EMAIL PROTECTED] wrote: --- Jacques Kilchoer [EMAIL PROTECTED] wrote: In what cases does the SERIAL# need to be used? orakill. sqlnet.expire_timeout did not work on NT for 8.1.7. garbage middle-tier apps that don't close connections require the use of orakill

A funny thing happened today on the way to OraPerf.com ...

2003-10-07 Thread Paul Drake
and I ended up here: http://oraperf.veritas.com/index.html Hmm. so now Veritas has the statspack reports that I uploaded previously. I don't know what to think. Maybe they'll see the source code, and the sales staff will think - "too far gone for any of our utils" and leave me alone? Pd Do you

auditing is my friend

2003-10-07 Thread Paul Drake
Hi. I just wanted to plug the use of auditing. By simply enabling audit session, I detemined that users that were accessing a database via a vpn connection were being timed out (LOGOFF BY CLEANUP). It wasn't the application that was causing the apparent hangs, it was the network. How bout that?

SDU in 9.2.0.4 - dynamic registration

2003-10-07 Thread Paul Drake
I thought that I saw something posted somewhere recently concerning the TNS listener SDU setting an support for non-2k sizes with dynamic registration in 9.2.0.4. Must have seen it late night, can't track it down. Has anyone come across this? At 2 sites, it was a choice between connect-time

RE: SDU in 9.2.0.4 - dynamic registration

2003-10-07 Thread Paul Drake
Melanie, Yes - in the appendix, there was a direct hit on the SDU setting working with 9.2.0.4 with dynamic registration. thanks much. Paul Do you Yahoo!? The New Yahoo! Shopping - with improved product search

Re: sid/serial# vs. audsid: why both?

2003-10-06 Thread Paul Drake
!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: How to set DBWR_WRITE_PROCESSES in Oracle8i?

2002-01-15 Thread Paul Drake
waits on RBS headers are likely due to simple I/O waits on an over-utilized storage subsystem. Different symptom, same problem. Btw, are your statistics up to date? hth, Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat

Re: Move DB to Another Schema

2001-12-21 Thread Paul Drake
://www.planetchristmas.com/pictures_2001.htm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: parallel import

2001-12-08 Thread Paul Drake
ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: recover on different hardware

2001-11-01 Thread Paul Drake
may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

Re: recover on different hardware

2001-11-01 Thread Paul Drake
the database normally? Or do you think it's cuz I really do have bad archive files?? Thanks for your response. Much appreciated. Barb -- From: Paul Drake[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Thursday, November 01, 2001 1:05 AM

Re: Clarification from your Paper Implementing RAID in Oracle Systems

2001-10-04 Thread Paul Drake
). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Extents size.

2001-10-02 Thread Paul Drake
curve on the right side. It would be interesting to see where the curve breaks, as it's not likely a linear rise. Of course, if you're using LMT's, this exercise is a waste of time. :) Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET

Re: Package standard - 9i for W2000 installation

2001-09-30 Thread Paul Drake
dba_ias_objects for dba_ias_objects * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network

Re: database hang on, no responsing

2001-09-25 Thread Paul Drake
those lock (like killing the user sql session, or better way) without restarting database. Is there any performance problem. How could I find the problem soon and fix it? Thank you so much. Wendy. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET

impressed with OUI/dbca 2.0 security features

2001-09-25 Thread Paul Drake
with an account the same as the username. Back to my network intrusion book ... Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: DB Restore

2001-09-24 Thread Paul Drake
ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: File/RAID layout for Oracle database???

2001-09-21 Thread Paul Drake
helpful. back to my upgrade. Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Lots and lots of redo logs

2001-09-18 Thread Paul Drake
CKPT process? Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: lots and lots of redo logs

2001-09-14 Thread Paul Drake
spewing email. Personally, I try to send fewer, higher quality emails rather than dozens of things that are the first thing that pops into my head. Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858

RE: Is Virus protection software safe on an NT / Oracle

2001-09-14 Thread Paul Drake
). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Hanging processes on NT

2001-09-12 Thread Paul Drake
: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from

Re: slightly OT: Way to prevent FTP users from changing dirs?

2001-09-12 Thread Paul Drake
-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

  1   2   3   >