RE: SAN configuration for Banner

PROTECTED] On Behalf Of Sam Bootsma Sent: 19 November 2003 15:55 To: Multiple recipients of list ORACLE-L Subject: FW: SAN configuration for Banner Hi List, We are approaching the cusp of a decision on how to store Oracle data files on our SAN. We dont have the SAN yet, but it is due to arrive

FW: SAN configuration for Banner

Title: SAN configuration for Banner Hi List, We are approaching the cusp of a decision on how to store Oracle data files on our SAN. We dont have the SAN yet, but it is due to arrive any week (if not any day). I passed Carys Is RAID 5 Really a Bargain? paper to our Sys Admin,

Oracle Application Server Listener Anomalies

OAS 4.0.8.2.4 running on Windows 2000 SP2, connecting to Oracle 7.3.4.5 database. Server housing OAS regularly rebooted at 4:00 a.m. every morning. Hi Everyone, We have recently had some anomalies with our OAS server. On the weekend, we had an internal user try to connect to our web

Book Recommendation for Apache

Hi, Any recommendations on good Apache books? We will be bringing in Oracle 9iAS shortly. Third party application constraints require the use of Forms 6i, which in turn requires that we stay with 9iAS Release 1 (version 1.0.2.x.x). We are currently running Oracle Application Server.

RE: Limiting Concurrent Sessions Not Working

Hi Dick, Thanks for the tip. Metalink says the bug applies to RDBMS 8.0.4. I tested it as well, using a modified version of their test case. I did not encounter this bug at all. Perhaps it is OK on Oracle 7.3.4? Sam Bootsma George Brown College [EMAIL PROTECTED] 416-415-5000

Limiting Concurrent Sessions Not Working

--- -- oracle oracle oracle oracle oracle oracle oracle oracle oracle oracle oracle oracle SYS sam SAM sam SAM 14 rows selected. SVRMGR Sam Bootsma George Brown College [EMAIL PROTECTED] 416-415-5000 x4933

RE: Limiting Concurrent Sessions Not Working

= true in init.ora? If you don't it defaults to FALSE the profile has no effect. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- From: Sam Bootsma [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 2:10 PM To: Multiple recipients of list ORACLE-L

How to Determine Oracle Session ID given UNIX PID?

Oracle 7.3.4 running on AIX 4.3.3 The ps command on our AIX box shows a UNIX process taking 50% of the CPU. The PID is 89510. When I try to find the corresponding session on the Oracle database it returns no rows. Is there a way I can map the given PID on UNIX to a session id on Oracle?

OT - Concerns raised over CSU computer security

to respect others' privacy . For full details check this out: http://www.fresnobee.com/local/story/6425479p-7370408c.html Sam Bootsma [EMAIL PROTECTED]

RE: DBV Cannot Load Module LIBDCE.A - SOLUTION

for your responses, Sam Bootsma George Brown College [EMAIL PROTECTED] 416-415-5000 x4933 -Original Message- From: Scott Behrens [mailto:[EMAIL PROTECTED] Sent: March 13, 2003 9:59 AM To: Multiple recipients of list ORACLE-L Subject: RE: DBV Cannot Load Module LIBDCE.A Sam

RE: DBV Cannot Load Module LIBDCE.A

by a more experience colleague that .exe's do not run on UNIX. So now I am at a loss on what to try next. Any ideas? Thanks, Sam Bootsma George Brown College [EMAIL PROTECTED] 416-415-5000 x4933 -Original Message- Sent: March 11, 2003 7:14 PM To: Multiple recipients of list ORACLE-L

DBV Cannot Load Module LIBDCE.A

We are running Oracle 7.3.4.5.0 on an IBM/AIX RISC System/6000: Version 2.3.4.0.0. When I attempt to run DBV I get the following error messages $ dbv help=y exec(): 0509-036 Cannot load program dbv because of the following errors: 0509-150 Dependent module libdce.a(shr.o) could

RE: ORA-00018: maximum number of sessions exceeded

based on our number of licenses. Can anybody confirm this for me? I have also set up a TAR with Oracle Support, and they too say we need to increase the SESSION parameter (but we want to confirm it has no link to licenses). Thanks again! Sam Bootsma 416-415-5000 x4933 -Original

Listener Hangs

. However, I did note that the listener.log file was 200 MB in size. Would the large size of the listener.log file contribute to the Listener hanging? This problem has occurred 6 to 8 times in the past couple of weeks. I do plan on starting a new listener.log file. Thanks, Sam Bootsma [EMAIL

RE: Listener Hangs

Thank-you! This should prove to be helpful. Sam Bootsma George Brown College [EMAIL PROTECTED] 416-415-5000 x4933 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: March 4, 2003 2:22 PM To: Multiple recipients of list ORACLE-L Subject: RE

Script to Turn Off All Oracle Auditing Options?

, but no corresponding view. Is there supposed to be a view for this? I am new to this company, and new to the database. Any help you can provide is appreciated. Thanks, Sam Bootsma [EMAIL PROTECTED]

ORA-00018: maximum number of sessions exceeded

reached. Has anybody encountered this problem before. Is there a simple reason for this erratic behavior? Management is looking for an answer as to why this has happened. Thanks for any input! Sam Bootsma [EMAIL PROTECTED]

Autoextend on Oracle 7.3.4.5.0

We are running Oracle 7.3.4.5.0 on an IBM/AIX RISC System/6000: Version 2.3.4.0.0. I know there is SQL that allows setting a data file to auto extend. I am trying to find out where in the data dictionary you can find out whether a data file is set to auto-extend or not. In later

INSERT ... RETURNING ROWIDTOCHAR(ROWID) INTO problem on 9.2.0.2.1

',SYSDATE,Misc.GetDefaultErKey('0001','000-3')) 8 RETURNING ROWIDTOCHAR(ROWID) INTO cRow; 9 end; 10 end; 11 / begin * ERROR at line 1: ORA-03113: end-of-file on communication channel SQL connect canadian_575/sql@paristest Connected. Thanks for any help ... Sam Bootsma, OCP Technical

System Tablespace and Autoextend

are running Oracle versions 7.3.4, 8.0.5, 8.1.7, and 9.2. All our Oracle versions are running on Windows NT (or Windows 2000). Thanks for any feedback. Sam Bootsma, OCP [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Bootsma INET: [EMAIL PROTECTED] Fat

Oracle 8i R3, and 9i R2 on Same NT Box

and Oracle 9.2 on the same NT box. Thanks for any input. Sam Bootsma, OCP Technical Support Analyst CPAS Systems Inc. 416-422-0563 x237 [EMAIL PROTECTED] http://www.cpas.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Bootsma INET: [EMAIL PROTECTED] Fat

Same SQL statement, Same Oracle, Different OS == Different Expla

. Between the following 2 indexes, Oracle 9.0x chooses (2) on Unix and (1) on Windows NT. 1) clnt, mkey, planno, fu_code, date_from, source, tracode, tsecond... 2) date_from, clnt, planno, mkey, fu_code Any insights from anybody out there? Thanks. Sam Bootsma, OCP Technical Support Analyst

Oracle 9.2 Stability Feedback Requested

are running UNIX. Appreciate any feedback anybody can provide. Thanks a lot. Sam Bootsma, OCP Technical Support Analyst [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Bootsma INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: Is Anybody Aware of Temporary Table Problem in 9i

Aware of Temporary Table Problem in 9i What is the duration of the data in the table? Is it session or transaction? If it's session, you need an intervening commit. -Original Message- From: Sam Bootsma [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 3:01 PM To: Multiple

Is Anybody Aware of Temporary Table Problem in 9i

Windows 2000 and Oracle 9.1, both scenario's return data. Has anybody experienced problems with temporary tables on Oracle 9.1? Especially on UNIX. Is anybody aware of Oracle bugs? Appreciate any responses. Thanks, Sam Bootsma, OCP Technical Support Analyst CPAS Systems Inc. 416-422-0563 x237

Foreign Keys and Table Locking

and to the list. That way I get a response much quicker. Thanks! Sam Bootsma, OCP Technical Support Analyst CPAS Systems Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Bootsma INET: [EMAIL PROTECTED] Fat City Network Services-- (858

RE: Enqueue and DB File Sequential Read Waits Problem

5.8667 1038 Thanks again for any pointers and suggestions. Sam Bootsma, OCP Technical Support Analyst -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Bootsma INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

RE: Enqueue and DB File Sequential Read Waits Problem

- From: Sam Bootsma Sent: April 18, 2002 5:33 PM To: '[EMAIL PROTECTED]' Subject: Enqueue and DB File Sequential Read Waits Problem We have a batch job taking a long time to process. Querying the v$session_wait view, I discovered there have been over 1200 enqueue waits

Enqueue and DB File Sequential Read Waits Problem

to client 111 .090909091 1 SQL*Net message from client 555 32565.8667 1038 Thanks again for any pointers and suggestions. Sam Bootsma, OCP Technical Support Analyst -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author

Moving From Rule-Based to Cost-Based

the optimization mode and analyzing tables and indexes)? Most clients run our database on NT, although some use UNIX. Assume Oracle 9i. Our database (at client sites) tends to be small, with the largest being about 25 GB. Thanks for any suggestions, Sam Bootsma Technical Support Analyst -- Please see

RE: Connect to Oracle via ODBC gives error sometimes

') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Bootsma INET

RE: 9i install

of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam

RE: Personal Experiences in Oracle

Are you happy with your career in DBA? I am about 2/3 of the way to loving my job. I have been since I started my job as DBA three years ago. Has the training been worth it? I was disappointed with the instructor in thesingle Oracle course I took ... so no. I took one MS TCP/IP course

ot: Interesting article on GPL (open source license model)

http://www.newscientist.com/hottopics/copyleft/copyleftart.jsp Sam Bootsma, OCP Technical Support Analyst CPAS Systems Inc. 416-422-0563 x237 [EMAIL PROTECTED] http://www.cpas.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Bootsma INET: [EMAIL PROTECTED

RE: Performance Conundrum Selecting varchar2(2000) Column

33.21 6.23 SQL*Net Msg from client 168037.06 22.06 Thanks for any responses! Sam. -Original Message- Sent: January 29, 2002 7:50 PM To: Multiple recipients of list ORACLE-L On Tuesday 29 January 2002 15:32, Sam Bootsma wrote: Hello, Most

Performance Conundrum Selecting varchar2(2000) Column

is appreciated. Thank-you! Sam Bootsma, OCP Technical Support Analyst CPAS Systems Inc. [EMAIL PROTECTED] http://www.cpas.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Bootsma INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

Q$INSTL Package From Savant Does not Import

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

FW: Rama Velpuri's 9i Backup and Recovery Book Available?

? Or if there are plans to produce a 9i version of the book and when it might be available? Thanks, Sam. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Bootsma INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

Script to Generate SQL To Recreate All Tables and Indexes for Sch

tables using the dump file created in step 1) We are running Oracle 8.1.6 on Windows NT. Thanks! Sam Bootsma, OCP Technical Support Analyst CPAS Systems Inc. 416-422-0563 x237 [EMAIL PROTECTED] http://www.cpas.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam

RE: Oracle Gateway Product for Progress Database

between the Oracle database and Progress database? Thanks. Sam Bootsma Technical Support Analyst CPAS Systems Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Bootsma INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

Oracle Gateway Product for Progress Database

Does anybody know if a gateway exists between the Oracle database and Progress database? Thanks. Sam Bootsma Technical Support Analyst CPAS Systems Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Bootsma INET: [EMAIL PROTECTED] Fat City Network Services

Oracle Compiler Bug? (+) symbol in Decode Allowed?

Thanks for any input... Sam Bootsma -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Bootsma INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mai

RE: Converting DOS batch file to UNIX script

VER\Scripts\Install.bat parm1 parm2 parm3 sqlplus system/manager@db ---snip--- Thanks for your help. Sam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Bootsma INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX:

Guy Harrison's High Performance Tuning Book - 2nd Edition

. The Book Pool website says it has 630 pages vs. around 490 for the first edition, so it looks like there is substantial stuff added. Thanks for any comments. Sam Bootsma, OCP Technical Support Analyst -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Bootsma

Converting DOS batch file to UNIX script

543\SERVER\Scripts\Install.bat parm1 parm2 parm3 sqlplus system/manager@db ---snip--- Thanks for your help. Sam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Bootsma INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051