RE: help
its a single instance system..here is some more details ...pls suggest if something needs to be corrected SHARED_POOL_SIZE=190MB DB_BLOCK_SIZE = 4KB DB_BLOCK_BUFFERS = 125000 (488MB) LOG_BUFFER = 5MB SORT_AREA_SIZE = 2MB SORT_AREA_RETAINED_SIZE = 1MB DB_WRITER_PROCESSES =4 LOG_ARCHIVE_MAX_PROCESS = 3 AND THE MOST WAITED EVENT IN V$SYSTEM_EVENT IS 'DB_FILE_SCATTERED_READ' ,TO REDUCE ITS WAIT TIME I HAVE INCREASED THE DB_FILE_MULTIBLOCK_READ_COUNT FROM 16 TO 64 ,BUT STILL SWAPPING SIZE IS SAME FROM 'TOP' COMMAND IN UNIX Regards Arvind -Original Message- Sent: Monday, March 31, 2003 10:19 PM To: Multiple recipients of list ORACLE-L Hi! You didn't send your SHARED_POOL_SIZE parameter value... but... usually, when the machine swaps is due to not enough memory allocated! I would check your shared_pool_size, sort_area_size, and db_block_buffer for verifying that there's enough memory asigned. Of course, you should diagnose memory problems on your OS and Oracle. HTH JL --- Arvind Kumar [EMAIL PROTECTED] wrote: Hello all, i am facing swapping problem ..below is the details System - IBM RS 6000, two CPU,2GB RAM,AIX 4.3,4GB SWAP SPACE DATABASE - ORACLE 8i 8.1.5, SGA 800MB, BUFFER CACHE HIT RATIO IS ABOVE 93% Now the problem is of swapping there are about 70 oracle users using this database ,swap utilization is always above 1.5gb. what could be the problem... Thanks Arvind Kumar -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arvind Kumar INET: [EMAIL PROTECTED] (by way of Jared Still [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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jose Luis Delgado 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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.net -- Author: Arvind Kumar 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
MIGRATION FROM Oracle 8.1.6 to 8.1.7 - Invalid Table Partitions
Hi gurus, I have just migrated from Oracle 8.1.6 to Oracle 8.1.7 (Enterprise Edition on Windows 2000) but when I try to query my partitoned tabless I get the error ORA-00604 'error occured at recursive SQL level 1' ORA -00904 'Invalid column name' I have run the scripts U0801060.sql (which calls catalog.sql and catproc.sql) in vain. I can access unpartitioned tables without errors. Any ideas? Moses Mmoya This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the network manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
Re: How to delete name service
Title: RE: How to delete name service There is also controlset001 and 002. Be sure to remove from all. Be sure what you are deleting. Yechiel AdarMehish - Original Message - From: Jacques Kilchoer To: Multiple recipients of list ORACLE-L Sent: Monday, March 31, 2003 10:48 PM Subject: RE: How to delete name service -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Oracle 8.1.7.4 Win 2000 Does anyone know how to delete a name server. I created thru net8 assistant however it will the service will not start. I want to remove it. When I highlight it the 'X' is not deleted nor thru menu options. How can I safely remove name service. If you run regedit (registry editor) Start-Run... regedit then you should see the service in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services But be sure you know what you're removing and why when you change the Windows Registry!
RE: MIGRATION FROM Oracle 8.1.6 to 8.1.7 - Invalid Table Partitions
Hi We had a different problem with our upgrade but the same error message - there is a patch available from Oracle that is supposed to help(did n't for us though) Regards, N. -Original Message- [EMAIL PROTECTED] Sent: 01 April 2003 09:04 To: Multiple recipients of list ORACLE-L Hi gurus, I have just migrated from Oracle 8.1.6 to Oracle 8.1.7 (Enterprise Edition on Windows 2000) but when I try to query my partitoned tabless I get the error ORA-00604 'error occured at recursive SQL level 1' ORA -00904 'Invalid column name' I have run the scripts U0801060.sql (which calls catalog.sql and catproc.sql) in vain. I can access unpartitioned tables without errors. Any ideas? Moses Mmoya This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the network manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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.net -- Author: Nuala Cullen 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
Loaded options - finding out
Good day to everyone How do I find what options are actually loaded into database? Not only installed, but loaded? For example, I may choose "Spatial" in Or. Installer, butlater I may create basic database (catalog.sql and catproc.sql) without any option... It seems that V$OPTION is returning "true" for everything, although I know I DIDN'T loaded everything. Thanks Vladimir Barac
How to prevent single point-of_failure with ONAMES
Hi All, Oracle 8.1.7.4 Win 2000 ONAMES with region database I have ONAMES repository on server1 I have 2 additional onames services on server2 and server3(no database/repository). I received a NNO-50 serious errors in configuration data. I do not know how it happened but I had to truncate and reload nmo_master and the 3 onrs_* tables. However this error caused a single point-of-failure. None of the oname services on all 3 servers would start. I was under the impression under these circumstances that Oracle would use CHKP* files. How can I prevent a single point-of-failure other than some type of hot standby? Can I have 2 repositories? If so where can I get doc to set this up? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
RE: Any tips to installing Designer 9i?
Hi, Do not make the path to the Oracle home you install Designer into any longer than 13 characters long, or you will find that certain tools do not work. The drive designator (e.g. C:\) does not count toward this total. Regards Pete -Original Message- Sent: 31 March 2003 22:49 To: Multiple recipients of list ORACLE-L Check the readme file or installation notes. It will tell you where to install Designer to make it work. I installed a couple of years old version, and I was asked to install in another Oracle_home. Hope this helps --- Jesse, Rich [EMAIL PROTECTED] wrote: Hey all, I'm downloading Designer 9.0.2.4.0 to try it out. I don't want to #$%^@ up my current ORACLE_HOME, like I've done while testing every other Oracle product for Winders 2000. Any tips? Without reading the docs yet (still downloading), I plan to install it into another ORACLE_HOME. Other than that and some Registry scraping so I can actually remove Designer when I'm done, anything else I should be aware of? TIA, Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mohammed Shakir 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hitchman, Peter 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
Upgrade 8.1.7.0 to 8.1.7.4.x Tru64 Parallel Server
Hi All, I have my first upgrade of parallel server coming up and am wondering what the major differences are between a normal upgrade and this one. Am I correct in assuming that the installer will detect both nodes and install the upgrade on both nodes? Is it correct that I only need to run the datadictionary upgrade script once on one of the instances? I'm now off to find more info on this on Metlink as well, but if someone has done this already and could share the steps involved I'd be thankful. TIA Jacob A. van Zanen Oracle DBA Quant Systems Europe b.v. Tel : +31 (0) 251 - 268 268 Mobile: +31 (0) 6 51308813 Fax: +31 (0) 251 - 268 269 E-mail: mailto:[EMAIL PROTECTED] Visit our web site at http://www.quantsystems.nl/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
OT- Start a process after oracle on Win 2K
Hi Slightly OT I have a couple of programs that need to be run after Oracle has started and want to run them without a user logging in. The likely place seems to be in the scheduled tasks running at startup or as a program under the local run key in the registry. The processes are a couple of scripts and I would envisage running them as a batch file What is best? Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
RE: how to calculate table size
Hi Ravindra,
Use the following, supposing your db_block_size is 2048 (change as appropiate).
SELECT segment_type, segment_name,BLOCKS*2048/1024 Kb
FROM DBA_SEGMENTS
WHERE OWNER=UPPER('owner') AND SEGMENT_NAME = UPPER('table_name');
You should substract emptied blocks from this table, using:
ANALYZE TABLE owner.table_name ESTIMATE STATISTICS;
SELECT TABLE_NAME, EMPTY_BLOCKS*2048/1024 Kb
FROM DBA_TABLES
WHERE OWNER=UPPER('owner') AND TABLE_NAME = UPPER('table_name');
This will give you how many kb are occupied by empty blocks, so substract this
amount from the prior result.
Hope this helps.
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Basavaraja,
Ravindra
Enviado el: martes, 01 de abril de 2003 1:24
Para: Multiple recipients of list ORACLE-L
Asunto: how to calculate table size
Hi,
Anyone having any formula to calculate table size?Basically to estimate the growth of
table over a peroid of time.
I have the row_size,db_block_size.How do i get the table size.
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Basavaraja, Ravindra
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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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.net
--
Author: Fermin Bernaus Berraondo
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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).
OLAP Window Functions e.g. rank()
There is a script, over on DBA-village.com, that uses rank() and ration_to_report(), which are features that I apparently didn't install along with the database (8i) :-( Do I have to install this from the CD and re-start the database in order to use? Are there any possible problems with installing this? Regards Craig Healey ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. Statements and opinions expressed in this e-mail may not represent those of the company. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses (www.mimesweeper.com) *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Healey 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
RE: OLAP Window Functions e.g. rank()
and ration_to_report() That should of course be ratio_to_report(), as we're not yet on rationing here in the UK (only a matter of time according to sections of the media and some MPs!). Craig ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. Statements and opinions expressed in this e-mail may not represent those of the company. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses (www.mimesweeper.com) *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Healey 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
RE: Upgrade 8.1.7.0 to 8.1.7.4.x Tru64 Parallel Server
Hi Jack: the answer to your second question is yes, because you only have one DB, ;-). about you first question there are some platforms on which the distribution of binaries to all the nodes goes wrong but with 8.1.7.4 on tru64 it doesn't ( as far as I know ;-)) You will be pretty safe if you follow the patch instalation instructions by the book, be aware of some bug releases that might apply to your case. rgds -Original Message- Sent: Tuesday, April 01, 2003 1:14 PM To: Multiple recipients of list ORACLE-L Hi All, I have my first upgrade of parallel server coming up and am wondering what the major differences are between a normal upgrade and this one. Am I correct in assuming that the installer will detect both nodes and install the upgrade on both nodes? Is it correct that I only need to run the datadictionary upgrade script once on one of the instances? I'm now off to find more info on this on Metlink as well, but if someone has done this already and could share the steps involved I'd be thankful. TIA Jacob A. van Zanen Oracle DBA Quant Systems Europe b.v. Tel : +31 (0) 251 - 268 268 Mobile: +31 (0) 6 51308813 Fax: +31 (0) 251 - 268 269 E-mail: mailto:[EMAIL PROTECTED] Visit our web site at http://www.quantsystems.nl/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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.net -- Author: MARREIROS,RUI (HP-Portugal,ex1) 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
RE: RMAN question....
Title: RE: RMAN question
Dennis,
I wasn't actually restoring the control file. Only 'validating' that RMAN could do it. I also backup the control file several other ways and would likely never ask RMAN to perform that function. The only reason I issued 'restore controlfile validate' was because it would help me figure out what those mystery files are for. I just checked the directory and there are 3 more files with similar names corresponding to the 3 databases we back up on that machine. I need to talk to the other DBA and find out if he has been manually deleting them because I haven't noticed this and we have been using RMAN for over a month now.
In addition, I don't believe these are the snapshot control files as there are 3 other files in $ORACLE_HOME/dbs named:
-rw-r- 1 oracle dba 41213952 Apr 1 00:35 snapcf_ASTU.f
-rw-r- 1 oracle dba 14376960 Apr 1 00:08 snapcf_PRD1.f
-rw-r- 1 oracle dba 16281600 Apr 1 00:36 snapcf_PRD2.f
The files in question are:
-rw-r- 1 oracle dba 16290816 Apr 1 00:36 26eje5g8_1_1
-rw-r- 1 oracle dba 14394368 Apr 1 00:08 28eje3r5_1_1
-rw-r- 1 oracle dba 41231360 Apr 1 00:35 2seje5e5_1_1
They seem to have corresponding file sizes. I just don't see what statement in my simple little scripts would cause the files to be written there.
Again here is the backup script I use:
#!/bin/sh
export ORACLE_HOME=/u01/app/oracle/product/8.1.7
export ORACLE_SID=ASTU
export ARCH_DEST=/u01/app/oracle/admin/$ORACLE_SID/arch/
rm /oracle_backup/$ORACLE_SID/*
$ORACLE_HOME/bin/rman EOF
set dbid=1337318309
connect target
connect catalog rman_cat/[EMAIL PROTECTED]
run{
allocate channel d1 type disk;
backup database format '/oracle_backup/ASTU/%U'
(current controlfile);
}
sql alter system switch logfile;
sql alter system archive log all;
sql alter database backup controlfile to trace;
sql alter database backup controlfile to
''/oracle_backup/ASTU/astu_ctl'';
exit;
EOF
#
Thanks for the input Dennis!!
Ps. I read your review of The Art and Science of Oracle Performance Tuning on amazon and decided to give it a try myself. I'm about 60 pages into it. It is easily the best read of any Oracle text I have come across. I definitely agree it belongs on everyone's bookshelf!!!
[Chris Stephens]
RE: PGA
Get GAJA's Book .. Oracle 101 Perf. Tunning.. U will find a Lot there .. HTH Best Regards, Ganesh R DID : +65-6215-8413 HP : +65-9067-8474 -Original Message- C.S.Venkata Subramanian Sent: Tuesday, April 01, 2003 2:04 PM To: Multiple recipients of list ORACLE-L where can one find the other myths about oracle? Venkat -- On Mon, 31 Mar 2003 06:18:35 Connor McDonald wrote: Oracle Myth #1745 When u set the sort_area_size for a database, it will allocate that much memory PER USER for any sort operation being performed on the database --- SARKAR, Samir [EMAIL PROTECTED] wrote: Arvind, When u set the sort_area_size for a database, it will allocate that much memory PER USER for any sort operation being performed on the database. In practice, it means that if u allocate too high a value for the sort_area_size and multiple users are performing multiple sorts, the Unix system may run out of memory and Oracle will return u a process memory error. For eg. if u have ur sort_area_size as 100MB and u have 10 users performing sort operations on the database, Oracle will take up 100*10 MB memory. This might degrade ur system performance. Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 31 March 2003 11:04 To: Multiple recipients of list ORACLE-L hello all, how does increasing the value of SORT_AREA_SIZE affect the unix system perfomance. Thanks Arvind -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arvind Kumar 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). _ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: SARKAR, Samir 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Yahoo! Plus For a better Internet experience http://www.yahoo.co.uk/btoffer -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). _ Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year. http://login.mail.lycos.com/brandPage.shtml?pageId=plusref=lmtplus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: C.S.Venkata
Re: PGA
- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 4:03 PM where can one find the other myths about oracle? Venkat -- A number of Oracle Press books ... Cheers Richard -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Foote 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
Re: OT- Start a process after oracle on Win 2K
Hi Peter, Sounds like a job for an after startup database event trigger (check out CREATE TRIGGER doco). Cheers Richard - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 10:28 PM Hi Slightly OT I have a couple of programs that need to be run after Oracle has started and want to run them without a user logging in. The likely place seems to be in the scheduled tasks running at startup or as a program under the local run key in the registry. The processes are a couple of scripts and I would envisage running them as a batch file What is best? Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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.net -- Author: Richard Foote 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
Re: Upgrade 8.1.7.0 to 8.1.7.4.x Tru64 Parallel Server
I assume that the existing 8.1.7.0 environment is already running OPS. In that case, the 8.1.7.4 patchset should apply successfully. If it is a TruCluster 5.x or higher, it would be a Cluster File System, in which case it would most probably be a single ORACLE_HOME shared by both nodes. [I have a 9iRAC install on TruCluster that way]. In that case, only one ORACLE_HOME needs to be patched ! Data Dictionary scripts are against the database so they need to be run only once. Hemant At 04:13 AM 01-04-03 -0800, you wrote: Hi All, I have my first upgrade of parallel server coming up and am wondering what the major differences are between a normal upgrade and this one. Am I correct in assuming that the installer will detect both nodes and install the upgrade on both nodes? Is it correct that I only need to run the datadictionary upgrade script once on one of the instances? I'm now off to find more info on this on Metlink as well, but if someone has done this already and could share the steps involved I'd be thankful. TIA Jacob A. van Zanen Oracle DBA Quant Systems Europe b.v. Tel : +31 (0) 251 - 268 268 Mobile: +31 (0) 6 51308813 Fax: +31 (0) 251 - 268 269 E-mail: mailto:[EMAIL PROTECTED] Visit our web site at http://www.quantsystems.nl/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). Hemant K Chitale My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
RE: enterprise manager console and sqlplus worksheet can't work
Its the Java JVM you have installed with the Jdeveloper. Have a look at your Environment variables and see what Java is in the path and what classpath is set. I would say OEM isn't compatible with the one installed when you installed JDeveloper Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Mohammed Shakir [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/04/2003 08:04 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: enterprise manager console and sqlplus worksheet can't work I installed Jdeveloper 9.x on oracle 9.0.1.3 and did not have a problem with OEM or SQL worksheet. I believe, you need to install it in a separate directory. Also it does not give you any startup Icon or put the Jdeveloper in Start and program menu, so you need to start from the directory. --- [EMAIL PROTECTED] wrote: If it is NT/2000 platform, Oracle installer normally screws up the registry entries, for example TNS_ADMIN in registry etc. Some product also screws up DLL ( specially microsoft DLL) files , if installed in the same oracle Home ( overwrite good DLLs with new but incompatible DLL) . 1. See, if OLD TNS_ADMIN is overridden by new TNS_ADMIN. Copy old stuff into the tnsnames.ora of new TNS_ADMIN. You will be lucky if this is the case. 2. Deinstall and reinstall all of the stuff in seperate home. Lots of work. In between install(s), you can export registry entries for backup and compare. 3. Some products have to be in same oracle home and will still screw up. In that case call Oracle :). Meanwhile, you can again deinstall everything and try, change the order of install of the product. I am assuming here that you have no other work, but do these over and over again. Pradip -Original Message- Sent: Thursday, March 27, 2003 12:09 AM To: Multiple recipients of list ORACLE-L afer installed the development tools I downloadd the developer suites from www.oracle.com such as jdeveloper. But after I installed it .my oracle enterprise manager console and sqlplus worksheet cant work which I installed before. Why ,and how to make them work . Thanks in advance! Regards Liujd -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: liujd 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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.net -- Author: 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mohammed Shakir INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego,
RE: PGA
http://www.quest-pipelines.com/newsletter-v3/0302_F.htm (Gaja Krishna Vaidyanatha) www.jlcomp.demon.co.uk/myths.html (Jonathan Lewis) http://www.orapub.com/cgi/genesis.cgi?p1=subp2=abs119 (Cary Milsap) -Original Message- Foote Sent: 01 April 2003 14:34 To: Multiple recipients of list ORACLE-L - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 4:03 PM where can one find the other myths about oracle? Venkat -- A number of Oracle Press books ... Cheers Richard -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Foote 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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.net -- Author: Mark Leith 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
RE: OT- Start a process after oracle on Win 2K
If you want no user to log in, you may wish to start your database in restricted mode (and use an account which has the appropriate privilege to log into Oracle if you have to). The snag is that you have to issue an ALTER DATABASE once your job is done. Another solution, assuming that your programs run on the server and all users connect from elsewhere, is to run your programs after the database has been started but before the listener is. 'local run key in the registry' is Greek to me ... :-) Regards, Stephane Faroult Oriole - --- Original Message --- - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tue, 01 Apr 2003 04:28:36 Hi Slightly OT I have a couple of programs that need to be run after Oracle has started and want to run them without a user logging in. The likely place seems to be in the scheduled tasks running at startup or as a program under the local run key in the registry. The processes are a couple of scripts and I would envisage running them as a batch file What is best? Cheers -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
myths and inaccuracies
Richard, hopefully not in mine! And if you do believe we have mistakes in our book, please do tell me or one of my co-authors. We really do want to present accurate information and any corrections will be sent to the publisher for the next printing. That goes for everyone on the list Along the same lines, if there is something you think we left out or spent too much time on or didn't spend enough time on in the book, please let me know as well and we will attempt to fix that in the next version. Please note two things: 1) I said 'attempt'... we have restrictions on page count and sometimes we have to leave out something because we just don't have the space 2) do NOT write to me via the list. Please write offline, and if you want me to read that message, mark it as PRIVATE or it may hit the circular file Rachel --- Richard Foote [EMAIL PROTECTED] wrote: - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 4:03 PM where can one find the other myths about oracle? Venkat -- A number of Oracle Press books ... Cheers Richard -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Foote 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). __ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
RE: RMAN question....
Chris - Thanks. Sorry for the tirade, bad day, reading too fast, thinking
too slow. I checked my systems and I see the snapcf_SID.f files, one for
each database being backed up. I do not see the other files you mention. I
notice the mystery file names have a format quite close to your backup
format. I also notice the dates on the mystery files are today's date, so
something must have written to them. Did the size change as well? Is there
any possibility that another backup script is running? Maybe a cron job from
another userid. Have you verified that your RMAN backup files are getting
created in the expected location? You could also check the catalog for
additional backups. And just to be sure, you might connect to the target
database alone and check for backups. A record of recent backups are stored
in the controlfile even if you are using a catalog.
Glad you are enjoying Lawson's book.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, April 01, 2003 7:24 AM
To: Multiple recipients of list ORACLE-L
Dennis,
I wasn't actually restoring the control file. Only 'validating' that RMAN
could do it. I also backup the control file several other ways and would
likely never ask RMAN to perform that function. The only reason I issued
'restore controlfile validate' was because it would help me figure out what
those mystery files are for. I just checked the directory and there are 3
more files with similar names corresponding to the 3 databases we back up on
that machine. I need to talk to the other DBA and find out if he has been
manually deleting them because I haven't noticed this and we have been using
RMAN for over a month now.
In addition, I don't believe these are the snapshot control files as there
are 3 other files in $ORACLE_HOME/dbs named:
-rw-r- 1 oracle dba41213952 Apr 1 00:35 snapcf_ASTU.f
-rw-r- 1 oracle dba14376960 Apr 1 00:08 snapcf_PRD1.f
-rw-r- 1 oracle dba16281600 Apr 1 00:36 snapcf_PRD2.f
The files in question are:
-rw-r- 1 oracle dba16290816 Apr 1 00:36 26eje5g8_1_1
-rw-r- 1 oracle dba14394368 Apr 1 00:08 28eje3r5_1_1
-rw-r- 1 oracle dba41231360 Apr 1 00:35 2seje5e5_1_1
They seem to have corresponding file sizes. I just don't see what statement
in my simple little scripts would cause the files to be written there.
Again here is the backup script I use:
#!/bin/sh
export ORACLE_HOME=/u01/app/oracle/product/8.1.7
export ORACLE_SID=ASTU
export ARCH_DEST=/u01/app/oracle/admin/$ORACLE_SID/arch/
rm /oracle_backup/$ORACLE_SID/*
$ORACLE_HOME/bin/rman EOF
set dbid=1337318309
connect target
connect catalog rman_cat/[EMAIL PROTECTED]
run{
allocate channel d1 type disk;
backup database format '/oracle_backup/ASTU/%U'
(current controlfile);
}
sql alter system switch logfile;
sql alter system archive log all;
sql alter database backup controlfile to trace;
sql alter database backup controlfile to
''/oracle_backup/ASTU/astu_ctl'';
exit;
EOF
#
Thanks for the input Dennis!!
Ps. I read your review of The Art and Science of Oracle Performance Tuning
on amazon and decided to give it a try myself. I'm about 60 pages into it.
It is easily the best read of any Oracle text I have come across. I
definitely agree it belongs on everyone's bookshelf!!!
[Chris Stephens]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).
Re: How to delete name service
Hi, You can also download the delsrv.exe (free download) from the Windows 2000 Resource kit and use it delete a service. delsrv sevice name deletes the service. http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B274305 Regards, Madhavan http://www.dpapps.com On Tue, 01 Apr 2003 02:03:39 -0800, Yechiel Adar [EMAIL PROTECTED] said: RE: How to delete name serviceThere is also controlset001 and 002. Does anyone know how to delete a name server. I created thru net8 assistant however it will the service will not start. I want to remove it. When I highlight it the 'X' is not deleted nor thru menu options. How can I safely remove name service. -- Madhavan Amruthur DecisionPoint Applications -- http://www.fastmail.fm - Choose from over 50 domains or use your own -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Madhavan Amruthur 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
Whose function is executing.
Hi, Is there a way to see whose function a user is executing? Development and production schemas exist on the same database and both accounts have granted object privileges to the user roles. (I think public synonyms are being used). I'm wondering if there is a way to check that a user is executing x's procedure. Is this available in a trace? Thanks for any help. chaim -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
Oracle urban legends and myths needed
Hi all, I'm currently writing an Oracle user guide for our developpers about how Oracle is implemented, SQL and PL/SQL good practices, tuning, rule base vs cost base (90 on 120 databases are still rule base) ... I want to add an Oracle urban legends and myths section focussed on development. I'm missing inspiration as I only have the use an index it'll go faster one. I'm sure you have lots of them. TIA Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
RE: Perl DBD::Oracle - discontinuing support for Oracle 7 and Ora
I couldn't support you more Tim. -Original Message- Sent: Monday, March 31, 2003 6:54 PM To: Multiple recipients of list ORACLE-L Oraperl? I released DBD::Oracle 1.14 a few days ago. In the release notes I said: NOTE: OCI 7 and Oraperl will not be supported in future releases. I'm keen to rip out the old OCI7 API code to make it easier to add support for more OCI8 features. I've had no reaction to that yet so I can't gauge how much of a problem that might be for some people. I know Oracle are ceasing to support Oracle 7 but there are certainly some Oracle 7 installation in production in strange places/situations. And there may be some script/applications based on Oraperl but now talking to Oracle 8 or 9 servers. So I thought I'd ask here. At the end of the day I guess anyone using Oracle 7 in production with DBD::Oracle / Oraperl has to live with the bugs in Oracle 7 and whatever version of DBD::Oracle / Oraperl they're using. (At least they wouldn't need such a fat cheque book to get support from me if they really needed it :) And converting from Oraperl is a fairly mechanincal process. Tim. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Bunce 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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.net -- Author: Gogala, Mladen 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
RMAN - Some basic Qs.
Qs.1 Why is NO excessive Redo Generated wsing RMAN Backups unlike HOT Backups when taking backup of an OPEN Database which is undergoing User Transactions ? (Or am i mistaken ?) Qs.2 How does RMAN manage Incremental Database Backups ? What is the Concept behing it ? Qs.3 How does RMAN Check for Block Corruption while taking backup ? Qs.4 Is it easy to integrate 3rd part tools like Legato etc with RMAN for enabling taking of backups onto backup devices OR does it need an extensive setup ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
RE: How to prevent single point-of_failure with ONAMES
Wierd. Our primary ONAMES server is 8.0.5 on OpenVMS, with the Region DB being on the same box. Our secondary ONAMES server is 9.2.0.2 on WinTuke using the same Region DB as the primary (amazing that 9iR2 can still use an 8.0.5 Region DB). Yes, we are working on upgrading this config, despite it being extremely stable due to non-support by Oracle Corp. One upon a time, a controller on the primary ONAMES / region DB server puked, causing the server to crash. While it was down, all Oracle Net connections eventually failed over to the secondary ONAMES server, which was indeed using the local checkpoint files for names resolution. It worked well with the only downside being that the clients had to wait for a TCP/IP timeout on the primary ONAMES server until it failed over to the secondary, but at least connections were able to be made. So when your primary failed the secondary/tertiary failed, too??? You stated that they wouldn't start, as though they hadn't been running. If they hadn't been running, there's probably no local checkpoint files, which I would think would prevent them from starting successfully. Were there any error messages? Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Tuesday, April 01, 2003 5:09 AM To: Multiple recipients of list ORACLE-L Hi All, Oracle 8.1.7.4 Win 2000 ONAMES with region database I have ONAMES repository on server1 I have 2 additional onames services on server2 and server3(no database/repository). I received a NNO-50 serious errors in configuration data. I do not know how it happened but I had to truncate and reload nmo_master and the 3 onrs_* tables. However this error caused a single point-of-failure. None of the oname services on all 3 servers would start. I was under the impression under these circumstances that Oracle would use CHKP* files. How can I prevent a single point-of-failure other than some type of hot standby? Can I have 2 repositories? If so where can I get doc to set this up? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
RE: help
Arvind, Try cutting DB_BLOCK_BUFFERS in half. Yeah it's a strange concept, but if the swapper is running them giving back some memory to the system may stop it the improvement in response time will more than make up for the additional wait in getting data into the cache. Dick Goulet -Original Message- Sent: Tuesday, April 01, 2003 3:04 AM To: Multiple recipients of list ORACLE-L its a single instance system..here is some more details ...pls suggest if something needs to be corrected SHARED_POOL_SIZE=190MB DB_BLOCK_SIZE = 4KB DB_BLOCK_BUFFERS = 125000 (488MB) LOG_BUFFER = 5MB SORT_AREA_SIZE = 2MB SORT_AREA_RETAINED_SIZE = 1MB DB_WRITER_PROCESSES =4 LOG_ARCHIVE_MAX_PROCESS = 3 AND THE MOST WAITED EVENT IN V$SYSTEM_EVENT IS 'DB_FILE_SCATTERED_READ' ,TO REDUCE ITS WAIT TIME I HAVE INCREASED THE DB_FILE_MULTIBLOCK_READ_COUNT FROM 16 TO 64 ,BUT STILL SWAPPING SIZE IS SAME FROM 'TOP' COMMAND IN UNIX Regards Arvind -Original Message- Sent: Monday, March 31, 2003 10:19 PM To: Multiple recipients of list ORACLE-L Hi! You didn't send your SHARED_POOL_SIZE parameter value... but... usually, when the machine swaps is due to not enough memory allocated! I would check your shared_pool_size, sort_area_size, and db_block_buffer for verifying that there's enough memory asigned. Of course, you should diagnose memory problems on your OS and Oracle. HTH JL --- Arvind Kumar [EMAIL PROTECTED] wrote: Hello all, i am facing swapping problem ..below is the details System - IBM RS 6000, two CPU,2GB RAM,AIX 4.3,4GB SWAP SPACE DATABASE - ORACLE 8i 8.1.5, SGA 800MB, BUFFER CACHE HIT RATIO IS ABOVE 93% Now the problem is of swapping there are about 70 oracle users using this database ,swap utilization is always above 1.5gb. what could be the problem... Thanks Arvind Kumar -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arvind Kumar INET: [EMAIL PROTECTED] (by way of Jared Still [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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jose Luis Delgado 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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.net -- Author: Arvind Kumar 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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.net -- Author: Goulet, Dick 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
RE: OT- Start a process after oracle on Win 2K
One other way to go would be to use a system startup script (see http://support.microsoft.com/default.aspx?scid=kb;en-us;198642 for details) that first started your db, and then followed up w/whatever other scripted tasks were necessary. Theoretically, anyway... HTH, -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Tuesday, April 01, 2003 5:39 AM To: Multiple recipients of list ORACLE-L Hi Peter, Sounds like a job for an after startup database event trigger (check out CREATE TRIGGER doco). Cheers Richard - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 10:28 PM Hi Slightly OT I have a couple of programs that need to be run after Oracle has started and want to run them without a user logging in. The likely place seems to be in the scheduled tasks running at startup or as a program under the local run key in the registry. The processes are a couple of scripts and I would envisage running them as a batch file What is best? Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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.net -- Author: Richard Foote 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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.net -- Author: Pardee, Roy E 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
Re: Oracle urban legends and myths needed
Title: Re: Oracle urban legends and myths needed Do a search for myth on asktom.oracle.com: e,g.: Whenever possible, issue frequent COMMIT statements in all your programs. By issuing frequent COMMIT statements, the performance of the program is enhanced and its resource requirements are minimized as COMMIT frees up the following resources ... explicit cursors are faster than implicit cursers. count(1) is faster than count(*) (or any variation/combination thereof). At 06:53 AM 4/1/2003 -0800, you wrote: Hi all, I'm currently writing an Oracle user guide for our developpers about how Oracle is implemented, SQL and PL/SQL good practices, tuning, rule base vs cost base (90 on 120 databases are still rule base) ... I want to add an Oracle urban legends and myths section focussed on development. I'm missing inspiration as I only have the use an index it'll go faster one. I'm sure you have lots of them. Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com This email communication is intended as a private communication for the sole use of the primary addressee and those individuals listed for copies in the original message. The information contained in this email is private and confidential and if you are not an intended recipient you are hereby notified that copying, forwarding or other dissemination or distribution of this communication by any means is prohibited. If you are not specifically authorized to receive this email and if you believe that you received it in error please notify the original sender immediately. We honour similar requests relating to the privacy of email communications. Cette communication par courrier lectronique est une communication prive l'usage exclusif du destinataire principal ainsi que des personnes dont les noms figurent en copie. Les renseignements contenus dans ce courriel sont confidentiels et si vous n'tes pas le destinataire prvu, vous tes avis, par les prsentes que toute reproduction, tout transfert ou toute autre forme de diffusion de cette communication par quelque moyen que ce soit est interdit. Si vous n'tes pas spcifiquement autoris recevoir ce courriel ou si vous croyez l'avoir reu par erreur, veuillez en aviser l'expditeur original immdiatement. Nous respectons les demandes similaires qui touchent la confidentialit des communications par courrier lectronique.
RE: RMAN - Some basic Qs.
1: RMAN does not generate excessive redo because it does not use the 'alter tablespace ... begin backup' command. It instead coordinates with dbwr, somehow, to be sure it is getting a consistent view of the tablespace. 2: The concept of an incremental backup is that you only backup the database blocks that have changed since the last incremental of the same or higher level. Somehow the date that the block changed is being managed, probably in the header somewhere. 3: If your reading a block for backup purposes, it's pretty easy to checksum it and compare with what's in the header just like the Oracle kernel does. 4: I've tried before with OmniBack and it's fairly simple. You only have to relink Oracle including a MML library file. The package you want to integrate with should have instructions. Dick Goulet -Original Message- Sent: Tuesday, April 01, 2003 10:19 AM To: Multiple recipients of list ORACLE-L Qs.1 Why is NO excessive Redo Generated wsing RMAN Backups unlike HOT Backups when taking backup of an OPEN Database which is undergoing User Transactions ? (Or am i mistaken ?) Qs.2 How does RMAN manage Incremental Database Backups ? What is the Concept behing it ? Qs.3 How does RMAN Check for Block Corruption while taking backup ? Qs.4 Is it easy to integrate 3rd part tools like Legato etc with RMAN for enabling taking of backups onto backup devices OR does it need an extensive setup ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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.net -- Author: Goulet, Dick 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
RE: How to prevent single point-of_failure with ONAMES
What had happened was the data in the table onrs_region got corrupted but the region database was still up. Somehow this caused all 3 name services to shutdown on all 3 servers. I do not have a clue how that is possible. There were checkpoint file on all servers but still no one connected. Perhaps the corrupted data got replicated to the other servers. The only error was the nno-50. Thanks Rick Jesse, Rich [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] world.comcc: Sent by: Subject: RE: How to prevent single point-of_failure with ONAMES [EMAIL PROTECTED] m 04/01/2003 10:18 AM Please respond to ORACLE-L Wierd. Our primary ONAMES server is 8.0.5 on OpenVMS, with the Region DB being on the same box. Our secondary ONAMES server is 9.2.0.2 on WinTuke using the same Region DB as the primary (amazing that 9iR2 can still use an 8.0.5 Region DB). Yes, we are working on upgrading this config, despite it being extremely stable due to non-support by Oracle Corp. One upon a time, a controller on the primary ONAMES / region DB server puked, causing the server to crash. While it was down, all Oracle Net connections eventually failed over to the secondary ONAMES server, which was indeed using the local checkpoint files for names resolution. It worked well with the only downside being that the clients had to wait for a TCP/IP timeout on the primary ONAMES server until it failed over to the secondary, but at least connections were able to be made. So when your primary failed the secondary/tertiary failed, too??? You stated that they wouldn't start, as though they hadn't been running. If they hadn't been running, there's probably no local checkpoint files, which I would think would prevent them from starting successfully. Were there any error messages? Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Tuesday, April 01, 2003 5:09 AM To: Multiple recipients of list ORACLE-L Hi All, Oracle 8.1.7.4 Win 2000 ONAMES with region database I have ONAMES repository on server1 I have 2 additional onames services on server2 and server3(no database/repository). I received a NNO-50 serious errors in configuration data. I do not know how it happened but I had to truncate and reload nmo_master and the 3 onrs_* tables. However this error caused a single point-of-failure. None of the oname services on all 3 servers would start. I was under the impression under these circumstances that Oracle would use CHKP* files. How can I prevent a single point-of-failure other than some type of hot standby? Can I have 2 repositories? If so where can I get doc to set this up? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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:
RE: RMAN - Some basic Qs.
Vivek 1. RMAN works on an entirely different principle than hot backups. Much more transparent to the database. 2. RMAN incremental backups work by checking if a block has changed since the last incremental backup of the current level or lower. So only changed blocks get backed up on an incremental. 3. According to some recent postings on this list, not very well. 4. Easy is in the eye of the beholder. If you own an MML, make sure your version is compatible with RMAN. If your organization has already paid the big bucks for the MML, get started making it work. If not, you may want to consider beginning by backing up to disk. Buy Robert Freeman's Oracle9i RMAN Backup Recovery. It covers MML integration. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 01, 2003 9:19 AM To: Multiple recipients of list ORACLE-L Qs.1 Why is NO excessive Redo Generated wsing RMAN Backups unlike HOT Backups when taking backup of an OPEN Database which is undergoing User Transactions ? (Or am i mistaken ?) Qs.2 How does RMAN manage Incremental Database Backups ? What is the Concept behing it ? Qs.3 How does RMAN Check for Block Corruption while taking backup ? Qs.4 Is it easy to integrate 3rd part tools like Legato etc with RMAN for enabling taking of backups onto backup devices OR does it need an extensive setup ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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.net -- Author: DENNIS WILLIAMS 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
RE: RMAN - Some basic Qs.
No excessive Redo ...one of RMans new features.. I will have to write a book here to give you good answers... I would suggest reading the really good cheat sheet on technet on Backup and recovery...they are very good and complete.. If not that just search google for RMAN faq and you should Get you what you need. Brian -Original Message- Sent: Tuesday, April 01, 2003 10:19 AM To: Multiple recipients of list ORACLE-L Qs.1 Why is NO excessive Redo Generated wsing RMAN Backups unlike HOT Backups when taking backup of an OPEN Database which is undergoing User Transactions ? (Or am i mistaken ?) Qs.2 How does RMAN manage Incremental Database Backups ? What is the Concept behing it ? Qs.3 How does RMAN Check for Block Corruption while taking backup ? Qs.4 Is it easy to integrate 3rd part tools like Legato etc with RMAN for enabling taking of backups onto backup devices OR does it need an extensive setup ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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.net -- Author: Spears, Brian 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
RE: Perl DBD::Oracle - discontinuing support for Oracle 7 and Ora
Does this mean the 'use Oraperl' and the oraperl subroutine syntax (like ora_login) would be deprecated? I wouldn't ordinarily care, as I haven't used that syntax for years. However, quite a few of our application areas wrote entire applications using oraperl. Just getting them to plug a 'use lib' and 'use Oraperl' at the top of their code to get them off of Perl 4 was like herding cats, and took almost a year. I'm sure Tim could care less about this. Personally I'm all for the move. We can certainly march merrily along with version 1.03 of DBD::Oracle we are currently using. Gogala, Mladen [EMAIL PROTECTED] T To: Multiple recipients of list ORACLE-L Sent by: [EMAIL PROTECTED] [EMAIL PROTECTED] cc: bcc: Subject: RE: Perl 04/01/03 10:18 AMDBD::Oracle - discontinuing support for Oracle 7 and Ora Please respond to ORACLE-L I couldn't support you more Tim. -Original Message- Sent: Monday, March 31, 2003 6:54 PM To: Multiple recipients of list ORACLE-L Oraperl? I released DBD::Oracle 1.14 a few days ago. In the release notes I said: NOTE: OCI 7 and Oraperl will not be supported in future releases. I'm keen to rip out the old OCI7 API code to make it easier to add support for more OCI8 features. I've had no reaction to that yet so I can't gauge how much of a problem that might be for some people. I know Oracle are ceasing to support Oracle 7 but there are certainly some Oracle 7 installation in production in strange places/situations. And there may be some script/applications based on Oraperl but now talking to Oracle 8 or 9 servers. So I thought I'd ask here. At the end of the day I guess anyone using Oracle 7 in production with DBD::Oracle / Oraperl has to live with the bugs in Oracle 7 and whatever version of DBD::Oracle / Oraperl they're using. (At least they wouldn't need such a fat cheque book to get support from me if they really needed it :) And converting from Oraperl is a fairly mechanincal process. Tim. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Bunce 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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.net -- Author: Gogala, Mladen 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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.net -- Author: 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: OT- Start a process after oracle on Win 2K
From: [EMAIL PROTECTED] I have a couple of programs that need to be run after Oracle has started and want to run them without a user logging in. The likely place seems to be in the scheduled tasks running at startup or as a program under the local run key in the registry. The processes are a couple of scripts and I would envisage running them as a batch file What is best? If you have Active Directory just set it up in the GPO for the machine to run at startup. Chris Berry [EMAIL PROTECTED] Systems Administrator JM Associates Without change, something sleeps inside us, and seldom awakens. The sleeper must awaken. -- Duke Leto Atreides _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Berry 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
Index usage in 8.1.6
How do you monitor if the indexes are being used in 8i? Individually the tkprof and explain plans do the trick. However from a running system, how can the index usage be determined? If the index is being used? How many times did the index get used during a specific time frame etc. Regards MenonDo you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more
Re: RMAN - Some basic Qs.
I need help, I have a procedure to insert xml data into a table. The xml data is store in CLOB, and i user xml parser and DOM to get the value and insert into table. If the file is is under 1 MB, everything is OK. But when the xml size is larger than 1 mb i'll get error message ORA-29532: Java call terminated by uncaught Java exception: java.lang.OutOfMemoryError BEGIN * ERROR at line 1: ORA-29554: unhandled Java out of memory condition I found 1 people in expert-exchange forum that have the same problem with me, and until now he dont have the solution. anyone here have experience with oracle xml parser. I already try to free the parser and document, and add more memory to java parameter, but this still not help. I read from metalink there is a bug like this in oracle 9i, but i'm using 8.1.7. I'm still looking for a way to fix this, before i run the pacth ( but i'm still not sure this will fix the problem) T.I.A __ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bong 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
RE: RMAN - Some basic Qs.
Qs.4 Is it easy to integrate 3rd part tools like Legato etc with RMAN for enabling taking of backups onto backup devices OR does it need an extensive setup ? I found it to be fairly easy to get RMAN working with Legato NetWorker. We had to go through a few hoops to get it working on a Veritas Cluster, but the problems were related to implementing Legato NetWorker on the cluster rather than the RMAN/Legato interface. The setup and configuration is well documented. -Original Message- Sent: Tuesday, April 01, 2003 10:19 AM To: Multiple recipients of list ORACLE-L Qs.4 Is it easy to integrate 3rd part tools like Legato etc with RMAN for enabling taking of backups onto backup devices OR does it need an extensive setup ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ed Bittel 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
RE: Upgrade from Oracle 10.7 char to 11.5.8 HP-UX 11.00
Hello Gurus We are in process of planning to upgrade our existing Oracle Financials 10.7 Character Applications to 11i( ver 11.5.8) Existing env HP-UX 11.00 32bits Oracle Financials 10.7 Char with Manufacturing Bill of Material Some customization (of Forms Reports) No middle tier Database 7.3.4.5 Existing Database size is 70G(We don't expect migration as export) Planning for HP-UX 11.0 32 bits (same platform) Oracle Financials 11i(11.5.8) with Manufacturing Bill of Material Customization upgrade to Forms6i and Report 6i Database 8.1.7.4 What shall be the best path for this upgrade. I would like some personal experiences / guidance or pointer to some white papers (besides Metalink). At this stage we are putting some high level plan for management information and their approval. Regards Rafiq _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
Do triggers cause a context switch between SQL PL/SQL
Question: If some idiot decides to circumvent Oracle's referential integrity and re-implement it by using triggers (insert, update, delete) that checks the foreign (parent/child) key fields in other tables like this, declare numrows INTEGER; begin -- ApplicationForm is used if the state and other criteria match that in -- ApplicationFormCriteria ON PARENT DELETE RESTRICT select count(*) into numrows from ApplicationFormCriteria where ApplicationFormCriteria.applicationFormId = :old.applicationFormId; if (numrows 0) then raise_application_error( -20343, 'Database Integrity Violation - Cannot DELETE row in Table ''ApplicationForm'' because referencing row exists in table ''ApplicationFormCriteria'' for Primary Key (applicationFormId)=' || :old.applicationFormId ); end if; end; would it cause context switching between the SQL PL/SQL engines? Yes, some genius did this in one of our databases. Two hundred third/fourth normal form tables enforced by 800 triggers... I have him registered to be stoned in public. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
Re: Perl DBD::Oracle - discontinuing support for Oracle 7 and Oraperl?
Tim, Personally, I have a few v7 db's around. My DBD interaction with them however is limited to logging on to the database just to make sure it's still up. Would removing OCI7 support include removing the ability to logon to a v7 db? Jared Tim Bunce [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/31/2003 03:53 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Perl DBD::Oracle - discontinuing support for Oracle 7 and Oraperl? I released DBD::Oracle 1.14 a few days ago. In the release notes I said: NOTE: OCI 7 and Oraperl will not be supported in future releases. I'm keen to rip out the old OCI7 API code to make it easier to add support for more OCI8 features. I've had no reaction to that yet so I can't gauge how much of a problem that might be for some people. I know Oracle are ceasing to support Oracle 7 but there are certainly some Oracle 7 installation in production in strange places/situations. And there may be some script/applications based on Oraperl but now talking to Oracle 8 or 9 servers. So I thought I'd ask here. At the end of the day I guess anyone using Oracle 7 in production with DBD::Oracle / Oraperl has to live with the bugs in Oracle 7 and whatever version of DBD::Oracle / Oraperl they're using. (At least they wouldn't need such a fat cheque book to get support from me if they really needed it :) And converting from Oraperl is a fairly mechanincal process. Tim. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Bunce 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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.net -- Author: 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
Re: Do triggers cause a context switch between SQL PL/SQL
Since you the action switches from SQL to PL/SQL to enforce the trigger, it sounds like a context switch to me. FYI: This can be improved somewhat by adding and rownum 2 into the WHERE clauses of these. There will be noticable improvement when there are many child rows. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 04/01/2003 09:48 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Do triggers cause a context switch between SQL PL/SQL Question: If some idiot decides to circumvent Oracle's referential integrity and re-implement it by using triggers (insert, update, delete) that checks the foreign (parent/child) key fields in other tables like this, declare numrows INTEGER; begin -- ApplicationForm is used if the state and other criteria match that in -- ApplicationFormCriteria ON PARENT DELETE RESTRICT select count(*) into numrows from ApplicationFormCriteria where ApplicationFormCriteria.applicationFormId = :old.applicationFormId; if (numrows 0) then raise_application_error( -20343, 'Database Integrity Violation - Cannot DELETE row in Table ''ApplicationForm'' because referencing row exists in table ''ApplicationFormCriteria'' for Primary Key (applicationFormId)=' || :old.applicationFormId ); end if; end; would it cause context switching between the SQL PL/SQL engines? Yes, some genius did this in one of our databases. Two hundred third/fourth normal form tables enforced by 800 triggers... I have him registered to be stoned in public. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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.net -- Author: 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
RE: Do triggers cause a context switch between SQL PL/SQL
Title: RE: Do triggers cause a context switch between SQL PL/SQL Yes ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 01, 2003 12:49 PM To: Multiple recipients of list ORACLE-L Subject: Do triggers cause a context switch between SQL PL/SQL Question: If some idiot decides to circumvent Oracle's referential integrity and re-implement it by using triggers (insert, update, delete) that checks the foreign (parent/child) key fields in other tables like this, declare numrows INTEGER; begin -- ApplicationForm is used if the state and other criteria match that in -- ApplicationFormCriteria ON PARENT DELETE RESTRICT select count(*) into numrows from ApplicationFormCriteria where ApplicationFormCriteria.applicationFormId = :old.applicationFormId; if (numrows 0) then raise_application_error( -20343, 'Database Integrity Violation - Cannot DELETE row in Table ''ApplicationForm'' because referencing row exists in table ''ApplicationFormCriteria'' for Primary Key (applicationFormId)=' || :old.applicationFormId ); end if; end; would it cause context switching between the SQL PL/SQL engines? Yes, some genius did this in one of our databases. Two hundred third/fourth normal form tables enforced by 800 triggers... I have him registered to be stoned in public. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: Sun HA Monitoring and Oracle 9
Scott (or anyone runing HA 2.2 wishing to upgrade to 9i): I noticed you did not receive a response from this message a couple of months back. We're in same situation (Sun Cluster 2.2, wishing to upgrade to Oracle 9i). It's not clear from the Oracle certification matrix if this is supported. (Clearly not supported if you're running RAC, but we're not) We're not convinced we want to upgrade to Sun cluster 3.0 (and certainly not clear we want to pay for it.) I'm wondering if there are others with this configuration, and if so what you decided to do. Thanks in advance for any information. Barb -Original Message- Sent: Monday, January 06, 2003 10:14 AM To: Multiple recipients of list ORACLE-L Here's a little background. We are currently running Oracle 8.1.6.0, 8.1.7.0, and 8.1.7.4 on a Sun cluster. We use HA monitoring for failover, in case there is a problem with any of the nodes. The version of HA is 2.2. We installed Oracle 9.2.0.1 on the cluster and created a new database using it. When the SA tried to start the HA monitoring, it wouldn't run. We ended up recreating the database in 8.1.7.4. When the SA contacted Sun, he was told that HA version 2.2 only supports up to Oracle 8.1.7. In order to monitor Oracle 9, we had to buy (not upgrade to) HA 3.0, which would require a rebuild of the entire cluster. Has anyone else run into this problem? If so, what have you done to get around it? Let me know if I forgot any important piece of information. Thank you. -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. __ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
RE: Upgrade from Oracle 10.7 char to 11.5.8 HP-UX 11.00
We did something very close to this in November of last year. We have the same OS and hardware. We were also character mode however we differed in that we used GEMMS for process manufacturing rather than discrete manufacturing in Oracle. We also had some customization. Our database was a little larger than yours at 98 GB. We were also at 7.3.4.5. We went to 11.5.7 rather than 11.5.8 The most important thing that we did right as I look on it in retrospect was that we did the full migration 3 times before we did it for real on one long weekend that started on Thursday afternoon and ended on Sunday morning. Two of the practice runs were functional in nature and the third was a full dress rehersal to establish that we could get it done in the predicted time frame. The practice helps in finding patches and things that don't work as advertised. In particualar, you will face some necessity to change business processes as 11i is not exactly the same as 10.7, so you must involve your users in the practice runs. Be prepared to have your database double on you as you go. We went from 98GB to now 230GB. We had to split the tiers to avoid buying all new hardware. We currently run on an N4000 as the apps tier with 10GB of RAM and 4 CPU's of the 440MHz flavor. We had an RP7200 that was originally the sole machine for Fin Apps which is now the DB server. We added 2 CPU's to get to 6 and we added 6Gb of RAM to get to 12GB. We have about 130 concurrent users. We used rough estimates of about 20MB per form for each user. This is not really a Fin Apps list so I will defer more discussion to e-mail. I can be reached as [EMAIL PROTECTED] with the obvious exclusion. Allan -Original Message- Sent: Tuesday, April 01, 2003 11:29 AM To: Multiple recipients of list ORACLE-L Hello Gurus We are in process of planning to upgrade our existing Oracle Financials 10.7 Character Applications to 11i( ver 11.5.8) Existing env HP-UX 11.00 32bits Oracle Financials 10.7 Char with Manufacturing Bill of Material Some customization (of Forms Reports) No middle tier Database 7.3.4.5 Existing Database size is 70G(We don't expect migration as export) Planning for HP-UX 11.0 32 bits (same platform) Oracle Financials 11i(11.5.8) with Manufacturing Bill of Material Customization upgrade to Forms6i and Report 6i Database 8.1.7.4 What shall be the best path for this upgrade. I would like some personal experiences / guidance or pointer to some white papers (besides Metalink). At this stage we are putting some high level plan for management information and their approval. Regards Rafiq _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
backup strategy for a database over 1 TB running SAP R/3
Hi, What is the backup strategy for a database over 1 TB running SAP R/3 on Solaris? We are using Legato products and they have NetWorker Module for Oracle and NetWorker Module for SAP on Oracle. Which one is better? Thanks, Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 This email has been scanned for all viruses by the MessageLabs SkyScan service. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.messagelabs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
Re: Do triggers cause a context switch between SQL PL/SQL
I thought as much, from what I've heard and read. Does anyone know if there's a way to figure out how much overhead the switches generate? I'm guessing they would show up in trace files in the 'other CPU' category. [EMAIL PROTECTED] T Sent by: To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: bcc: 04/01/03 01:19 PMSubject: Re: Do Please respond totriggers cause a context switch between SQL PL/SQL ORACLE-L Since you the action switches from SQL to PL/SQL to enforce the trigger, it sounds like a context switch to me. FYI: This can be improved somewhat by adding and rownum 2 into the WHERE clauses of these. There will be noticable improvement when there are many child rows. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 04/01/2003 09:48 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Do triggers cause a context switch between SQL PL/SQL Question: If some idiot decides to circumvent Oracle's referential integrity and re-implement it by using triggers (insert, update, delete) that checks the foreign (parent/child) key fields in other tables like this, declare numrows INTEGER; begin -- ApplicationForm is used if the state and other criteria match that in -- ApplicationFormCriteria ON PARENT DELETE RESTRICT select count(*) into numrows from ApplicationFormCriteria where ApplicationFormCriteria.applicationFormId = :old.applicationFormId; if (numrows 0) then raise_application_error( -20343, 'Database Integrity Violation - Cannot DELETE row in Table ''ApplicationForm'' because referencing row exists in table ''ApplicationFormCriteria'' for Primary Key (applicationFormId)=' || :old.applicationFormId ); end if; end; would it cause context switching between the SQL PL/SQL engines? Yes, some genius did this in one of our databases. Two hundred third/fourth normal form tables enforced by 800 triggers... I have him registered to be stoned in public. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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.net -- Author: 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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.net -- Author: 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
Re: Upgrade to AIX 5.2
Kirti, This what oracle support said; -joan As the doc says When running Oracle9i 64-bit on AIX 5L, the machine can be booted indifferently with the 32-bit kernel or the 64-bit kernel. Switching kernels simply involves a reboot, there is no need to reinstall AIX or to modify the Oracle 9.2 64-bit installation. Deshpande, Kirti wrote: Joan, From what I have found Oracle 9.2 64-bit can be run in a 32-bit mode on AIX 5L. So, one can have 5L running Oracle 8.1.7.4 and 9.2.0 in 32-bit modes. However, the H/W running AIX must be 64-bit. Please see note # 169426.1. Let us know what Oracle support has to say. Cheers! - Kirti -Original Message- From: Joan Hsieh [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 7:44 PM To: Multiple recipients of list ORACLE-L Subject: Re: Upgrade to AIX 5.2 Kirti, I did some home work toward our near future upgrading from aix 4.3.3 to 5.1 and 817.4-32 bit to 9i2-64 bit. (8 servers) Note:206569.1 and Note:223521.1 on which said -When running oracle8i 32-bit on aix 5l, the machine must be booted with the 32-bit kernel. this restriction doesn't apply to oracle 9.2 64-bit. Is that mean 9i-64 bit can coexist with 8.1.7 32-bit with the 32-bit kernet on aiz 5L? I opened a tar with oracle support, want to clear that out. I thought 817 and 9i can not coexisted on aix 5L. Thanks, joan Deshpande, Kirti wrote: Tracy, We are still debating this issue with our preferred App Vendor... Since there is no 64-bit 8.1.7.4 on AIX 5L, upgrading to 9i is what we will pursue. Testing the Vendor App on 9i/AIX 4.3.3 should not take considerable amount of time, as *none* of the new features of 9i would be used by the Vendor. Sad but true. There will be more testing time allocated to 9i/AIX 5L update, as several other software pieces would be tested for the first time with that combination. We will need to install 9i for AIX 5L after the OS upgrade. We may choose to install it in the same ORACLE_HOME as before. These are just my initial thoughts, no concrete plans, yet. If Oracle would have supported 64-bit 8.1.7.4 on AIX 5L, this would have been a bit simpler... Regards, - Kirti -Original Message- Sent: Thursday, February 27, 2003 1:36 PM To: Multiple recipients of list ORACLE-L John/Kirti, We are in the same boat with you. However, we were looking to first upgrade to AIX 5L first and leave our existing 8.1.7 32-bit databases (booting the server in 32 bit mode). In a subsequent phase we would upgrade 8.1.7 32-bit to 9.2 64-bit. The downside to this is that it will affect all databases on the server. We would need to test the complexity/timing/risk to determine if this is the appropriate choice. Kirti, with the option that you are leaning towards, as I see it, you need to upgrade to 5L and then install 9.2 for 5L (there is also a 9.2 for 4.3.3) and then migrate the databases from 9.2/4.3.3 to 9.2/5L. Do you know what effort is involved in that transition? Is it complex/time consuming or just pointing to a new oracle_home? Thanks 02/27/2003 05:43 AM PST Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: It appears that way. We are also pondering on this upgrade as well. But if one takes this route, that is, running 5L in 32-bit mode, one can not install 9i on the same server. And Oracle has not certified 8.1.7 64-bit on AIX 5L. It is not planned to be available, either. So, we are leaning towards upgrading to 9i first on AIX 4.3.3. Next upgrade OS to AIX 5L 5.1 and then 5.2 (some of the apps will become available on 5.2 later this year).. - Kirti -Original Message- Sent: Thursday, February 27, 2003 7:09 AM To: Multiple recipients of list ORACLE-L So 8.1.7 is supported on AIX 5L provided AIX is booted in 32 bit mode??? John -Original Message- Sent: 27 February 2003 12:24 To: Multiple recipients of list ORACLE-L Certify - Additional Info Oracle Server - Enterprise Edition Version 8.1.7 (8i) On IBM AIX -Based Systems Operating System: IBM AIX -Based Systems Version 5.2 (5L) Oracle Server - Enterprise Edition Version 8.1.7 (8i) N/A Version N/A Status: Certified Product Version Note: Terminal Oracle8i release To obtain Patch Sets from MetaLink, click the Patches button to the left. Certification Note: Existing patch sets: 8.1.7.1.0 (without JDBC), 8.1.7.1.0b (includes JAVAVM, Context and JDBC), 8.1.7.2.0 8.1.7.3.0 8.1.7.4.0 Oracle 8i 32-bit on AIX 5L (5.1 5.2) Kernel modes AIX 5L introduces the option to run the AIX kernel in 64-bit mode. This mode is not supported, as Oracle 8i uses at least one
RE: backup strategy for a database over 1 TB running SAP R/3
Roger We don't run SAP, but are you considering using RMAN as a part of your plans? Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 01, 2003 1:39 PM To: Multiple recipients of list ORACLE-L Hi, What is the backup strategy for a database over 1 TB running SAP R/3 on Solaris? We are using Legato products and they have NetWorker Module for Oracle and NetWorker Module for SAP on Oracle. Which one is better? Thanks, Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 This email has been scanned for all viruses by the MessageLabs SkyScan service. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.messagelabs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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.net -- Author: DENNIS WILLIAMS 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
RE: Index usage in 8.1.6
Murali If I'm not mistaken, the first Oracle version that offers real support for this is Oracle9i. I think what you are doing is about all that can be done -- capture SQL, run explain plan on it and make a list of the indexes that are used. If you look around, there are scripts to help and packages that automate this. But in the end you still have to answer the question of how long do you wait to see if an index isn't used before you drop it -- a day, a week, a month? There is always that danger that there will be a really critical report that is only run on irregular occasions that will need that index. For example, a manufacturing plant tends to go through a production season. The applications running at the first of the season are different from those run toward the end. If you pick a month at the first of the season, you may drop indexes needed toward the end. If you have a definite indication that your application is over-indexed, this effort may be worth your trouble. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 01, 2003 10:59 AM To: Multiple recipients of list ORACLE-L How do you monitor if the indexes are being used in 8i? Individually the tkprof and explain plans do the trick. However from a running system, how can the index usage be determined? If the index is being used? How many times did the index get used during a specific time frame etc. Regards Menon _ Do you Yahoo!? Yahoo! Tax http://us.rd.yahoo.com/finance/mailsig/*http://tax.yahoo.com Center - File online, calculators, forms, and more -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
RE: RMAN - Some basic Qs.
Answer 1: RMAN keeps track of increasing SCNs of any changing datablock within the datafile being backedup. Hence not much redo. Answers to other questions have been posted by others. HTH GovindanK |XXX| |You should treat others the way you want to be treated - Mahatma Gandhi| |XXX| VIVEK_SHARMA [EMAIL PROTECTED] wrote: Qs.1 Why is NO excessive Redo Generated wsing RMAN Backups unlike HOT Backups when taking backup of an OPEN Database which is undergoing User Transactions ? (Or am i mistaken ?) Qs.2 How does RMAN manage Incremental Database Backups ? What is the Concept behing it ? Qs.3 How does RMAN Check for Block Corruption while taking backup ? Qs.4 Is it easy to integrate 3rd part tools like Legato etc with RMAN for enabling taking of backups onto backup devices OR does it need an extensive setup ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). __ Try AOL and get 1045 hours FREE for 45 days! http://free.aol.com/tryaolfree/index.adp?375380 Get AOL Instant Messenger 5.1 for FREE! Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promo=380455 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
RE: Oracle urban legends and myths needed
I seem to be missing some of the replies etc to this so apologies for repeating anything anyone else has said. 1. A BCHR of x% means that you have a well tuned system (where x is usually 95) 2. Minimise the number of extents for each object 3. Set PCTIncrease to a small value (typically 1%) to minimise fragmentation. 4. Index blocks never get reused. 5. Rebuild indexes frequently. 6. Separation of data and indexes improves performance 7. The most selective column of a concatenated index should be the leading Column 8. If its in print it must be true 9. If 'x' says so it must be true. 10. Avoid Full Table Scans, they are always bad. Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stephane Paquette Sent: 01 April 2003 15:54 To: Multiple recipients of list ORACLE-L Subject: Oracle urban legends and myths needed Hi all, I'm currently writing an Oracle user guide for our developpers about how Oracle is implemented, SQL and PL/SQL good practices, tuning, rule base vs cost base (90 on 120 databases are still rule base) ... I want to add an Oracle urban legends and myths section focussed on development. I'm missing inspiration as I only have the use an index it'll go faster one. I'm sure you have lots of them. TIA Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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.net -- Author: Niall Litchfield 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
RE: RMAN - Some basic Qs.
All, The primary reason why RMAN does not generate excessive redo is because because it does not put the tablespace in hot backup mode. Thus any blocks belonging to a given tablespace that are modified before the END BACKUP command is processed, do not require block-level before and after images. Hence the reduction in redo generation. So how does RMAN backup without hot backups? RMAN is aware of the format of an Oracle datafile, and reads datafiles for the backup in DB_BLOCK_SIZE chunks. This is not the case with most OS utilities (tar, cpio, cp, dd etc.), which read files in 512-byte OS blocksize chunks. As a result, the issue of a fractured block (for which block-level before/after images are taken) on the destination where the backup is done, does not come into play in RMAN. Hope that helps, Gaja --- Goulet, Dick [EMAIL PROTECTED] wrote: 1: RMAN does not generate excessive redo because it does not use the 'alter tablespace ... begin backup' command. It instead coordinates with dbwr, somehow, to be sure it is getting a consistent view of the tablespace. 2: The concept of an incremental backup is that you only backup the database blocks that have changed since the last incremental of the same or higher level. Somehow the date that the block changed is being managed, probably in the header somewhere. 3: If your reading a block for backup purposes, it's pretty easy to checksum it and compare with what's in the header just like the Oracle kernel does. 4: I've tried before with OmniBack and it's fairly simple. You only have to relink Oracle including a MML library file. The package you want to integrate with should have instructions. Dick Goulet -Original Message- Sent: Tuesday, April 01, 2003 10:19 AM To: Multiple recipients of list ORACLE-L Qs.1 Why is NO excessive Redo Generated wsing RMAN Backups unlike HOT Backups when taking backup of an OPEN Database which is undergoing User Transactions ? (Or am i mistaken ?) Qs.2 How does RMAN manage Incremental Database Backups ? What is the Concept behing it ? Qs.3 How does RMAN Check for Block Corruption while taking backup ? Qs.4 Is it easy to integrate 3rd part tools like Legato etc with RMAN for enabling taking of backups onto backup devices OR does it need an extensive setup ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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.net -- Author: Goulet, Dick 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). = __ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gaja Krishna Vaidyanatha 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
Re: Perl DBD::Oracle - discontinuing support for Oracle 7 and Ora
On Tue, Apr 01, 2003 at 09:08:51AM -0800, [EMAIL PROTECTED] wrote: Does this mean the 'use Oraperl' and the oraperl subroutine syntax (like ora_login) would be deprecated? They would be more than deprecated. They wouldn't work at all. I wouldn't ordinarily care, as I haven't used that syntax for years. However, quite a few of our application areas wrote entire applications using oraperl. Just getting them to plug a 'use lib' and 'use Oraperl' at the top of their code to get them off of Perl 4 was like herding cats, and took almost a year. :-) I'm sure Tim could care less about this. Personally I'm all for the move. We can certainly march merrily along with version 1.03 of DBD::Oracle we are currently using. That's my thinking. Places that have stuck with Oracle 7 can't really complain about being stuck with DBD::Oracle = 1.14. Tim. Gogala, Mladen [EMAIL PROTECTED] T To: Multiple recipients of list ORACLE-L Sent by: [EMAIL PROTECTED] [EMAIL PROTECTED] cc: bcc: Subject: RE: Perl 04/01/03 10:18 AMDBD::Oracle - discontinuing support for Oracle 7 and Ora Please respond to ORACLE-L I couldn't support you more Tim. -Original Message- Sent: Monday, March 31, 2003 6:54 PM To: Multiple recipients of list ORACLE-L Oraperl? I released DBD::Oracle 1.14 a few days ago. In the release notes I said: NOTE: OCI 7 and Oraperl will not be supported in future releases. I'm keen to rip out the old OCI7 API code to make it easier to add support for more OCI8 features. I've had no reaction to that yet so I can't gauge how much of a problem that might be for some people. I know Oracle are ceasing to support Oracle 7 but there are certainly some Oracle 7 installation in production in strange places/situations. And there may be some script/applications based on Oraperl but now talking to Oracle 8 or 9 servers. So I thought I'd ask here. At the end of the day I guess anyone using Oracle 7 in production with DBD::Oracle / Oraperl has to live with the bugs in Oracle 7 and whatever version of DBD::Oracle / Oraperl they're using. (At least they wouldn't need such a fat cheque book to get support from me if they really needed it :) And converting from Oraperl is a fairly mechanincal process. Tim. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Bunce 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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.net -- Author: Gogala, Mladen 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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.net -- Author:
Re: Perl DBD::Oracle - discontinuing support for Oracle 7 and Oraperl?
On Tue, Apr 01, 2003 at 10:08:31AM -0800, [EMAIL PROTECTED] wrote: Tim, Personally, I have a few v7 db's around. My DBD interaction with them however is limited to logging on to the database just to make sure it's still up. Would removing OCI7 support include removing the ability to logon to a v7 db? You can login to whatever the oracle client libs you link with will let you log into. For v8 libs that includes v7. I did hear recently that v9.x no longer lets you connect to v7. You could always keep a copy of DBD::Oracle 1.14 for use with Oracle 7. Just install it into a different directory. Tim. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Bunce 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
RE: Do triggers cause a context switch between SQL PL/SQL
Title: RE: Do triggers cause a context switch between SQL PL/SQL A context switch is order because a trigger is a pl/sql object ... if you can change the trigger ... instead of count(*) try using exists assuming you have a usable index ... select count(*) into numrows from dual where exists ( select 1 from ApplicationFormCriteria where ApplicationFormCriteria.applicationFormId = :old.applicationFormId); If you have an index on ApplicationFormCriteria.applicationFormId, this should fly ... and still accomplish what you need. The basic problem here is the developer doesn't understand the question. If the question is Is there at-least one row that mayches a given value so that I can restrict the delete? then my solution is the right one. If the question is How many rows do I have matches a given value so I can ... ? then the SQL you have is the right one. Looking at the pl/sql code, the question is the former one and the SQL used by the developer is the wrong one. When you do a count(*) oracle will search the table till the HWM, if the table is large, it will make lot of difference. Where the query above will stop after it finds the first matching row, most likely doing less work that the query you have. You can say I am picking on the semantics, but see how much difference it makes? YMMV Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: Oracle Mail
Kirti, Can I add to your request? I'd appreciate knowing of anyone who migrated to collaborative suite instead of Exchange and if there was a $$ difference how much it was and which way. Also if you did make the move from Exchange to Collaborative did you save any money in the process? Dick Goulet -Original Message- Sent: Tuesday, April 01, 2003 3:34 PM To: Multiple recipients of list ORACLE-L Hello All, Anyone migrated to Oracle Mail from MS Exchange Server? Care to share the experience? I was asked about it. I have no idea how it works. I am trying to gather as much info as possible from Oracle.com, Google etc.. Thanks. - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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.net -- Author: Goulet, Dick 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
Lies, damn lies and statistics
The case is not as bad as the subject may let you believe, but not quoting Disreali was above my strength ... Anyway, an interesting case encountered today. Basically, a dreadful query, involving a reasonably big table with an innate tree structure (the stuff connect bys are made of), accessed through a view with outer joins, user-written functions called for each line, and search for text (upper(column) like '%STUFF%') in a number of related columns. The row must be returned whether the text is found for the row itself, a descendent or an ascendent, which means that the text search is found twice in two different START WITH subqueries. The query of hell. The execution plan is made of a whopping 176 steps. In spite of all this, the execution time is close to 25s, which is not that bad, given the context. There would be much to say about the design, now we're in 'fix it' mode. Noting the huge number of 'nested loops', the first attempt is to try the ALL_ROWS hint, to see whether hash joins couldn't improve our case. Here is the result : original all_rows Steps in plan176 166 recursive calls 259 1776 db block gets 72 324 consistent gets 474556 6700 physical reads 12497 1981 redo size152 21736 bytes to client 3060 3060 bytes from client 5811 4500 SQL*Net roundtrips 2 2 memory sorts 1013 disk sorts 0 0 rows 6 6 Elapsed time 24.75 4 mn Although LIOs have drastically reduced, and so have PIOs, our time is about 10 times worse! BCHR zealots will note that our original 97% hit-ratio has become a 72% hit-ratio, but the reason is more likely to be found in the HUGE increase of recursive calls and the surprising increase of the 'redo size' stat (why does it generate redo? It's a SELECT ... Must be something weird going on). I had no access to the server, which prevented me from tracing, and not much time (this is a customer I visit only once a week - results first) which means that I have not had time to inquire about events. But wait, it gets weirder. After having tried the easy solution, I dug into rewriting. Here are the stats for 3 successive rewritings : original 1st rewriting 2nd rewriting 3rd rewriting Steps in plan176 112158 113 recursive calls 259 259259 252 db block gets 7266 60 69 consistent gets 474556 80276 376501 80727 physical reads 12497 1068 21091406 redo size152 0 0 0 bytes to client 3060 3060 30603060 bytes from client 5811 3705 53063803 SQL*Net roundtrips 2 2 2 2 memory sorts 1010 10 11 disk sorts 0 0 0 0 rows 6 6 6 6 Elapsed time 24.75 Look at the values. How would you rank the variations ? Answer below . . . . . . . . . . . . . . . . . . . . . 1st rewriting: 38.06 2nd rewriting: 13.48 3rd rewriting: 3.56 Not an April's fools joke. A moral to the story? SET TIMING ON. What matters is elapsed time, not stats. That said, I must check events next week. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
RE: backup strategy for a database over 1 TB running SAP R/3
Yes. In fact, I am trying to decide using RMAN or SAP BR-tools. -Original Message- Sent: Tuesday, April 01, 2003 2:04 PM To: Multiple recipients of list ORACLE-L Roger We don't run SAP, but are you considering using RMAN as a part of your plans? Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 01, 2003 1:39 PM To: Multiple recipients of list ORACLE-L Hi, What is the backup strategy for a database over 1 TB running SAP R/3 on Solaris? We are using Legato products and they have NetWorker Module for Oracle and NetWorker Module for SAP on Oracle. Which one is better? Thanks, Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 This email has been scanned for all viruses by the MessageLabs SkyScan service. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.messagelabs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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.net -- Author: DENNIS WILLIAMS 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). This email has been scanned for all viruses by the MessageLabs SkyScan service. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.messagelabs.com This email has been scanned for all viruses by the MessageLabs SkyScan service. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.messagelabs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
Re: Oracle Mail
Kirti, Check the OTN training/seminars that are being presented in different areas of the world. I attended one such session that talked and demo'd the Oracle email functionality. It is an amazing product if you need all of the features that Oracle OTN had set up. The demo was for web based email that used the portal and could emulate MS outlook to a tee. Attending the OTN seminar is well worth the time and effort to attend. Ron [EMAIL PROTECTED] 04/01/03 03:33PM Hello All, Anyone migrated to Oracle Mail from MS Exchange Server? Care to share the experience? I was asked about it. I have no idea how it works. I am trying to gather as much info as possible from Oracle.com, Google etc.. Thanks. - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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.net -- Author: Ron Rogers 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
Oracle Job Task Analysis
I am putting together a prelimanary job task analysis for Oracle DBA's and would like some input from you hardworking DBA's on this list. Here is what I have so far for core competencies and I would like to add or subtract from this list based on your input. A. Oracle Architecture And Options B. Security and Network Access C. Application Design and Modelling D. Backup And Recovery E. Software Maintenance And Operation F. SEGMENT and DATA MANAGEMENT G. Tuning And Troubleshooting My Recommendations for slightly more advanced competencies that are still quite important For many installations. H. Scalability I. High Availability J. Business Intelligence Here is what I have as sub-components for the core competencies. A. ORACLE ARCHITECTURE AND OPTIONS 1. Demonstrate an understanding of memory structures and processes which make up an Oracle instance 2. Demonstrate an understanding of the logical and physical structures associated with an Oracle database 3. Demonstrate an understanding of PL/SQL constructs (triggers, functions, packages, procedures) and their processing 4. Demonstrate an understanding of distributed architecture and client server and 3 tier architectures 5. Demonstrate an understanding of Oracle Globalisation B. SECURITY and NETWORK ACCESS 1. Create, alter, and drop database users 2. Develop and implement a strategy for managing security using roles, privileges, authentication, 3. Demonstrate an Appreciation of implementing row level security using Application Contexts and Fine Grain access control 4. Demonstrate an Appreciation of implementing Network security using Oracle Internet Directory (OID) ,LDAP and Single Sign On (SSO) 5. Demonstrate an Appreciation of implementing firewalls in Oracle using Standard Oracle Net features 6. Use Database and Fine grain auditing 7.Demonstrate an understanding of the implications of distributed processing on the security model C. Appication Design and Modelling 1. Implement the physical database from the logical design 2. Understand the benefits of using stored procedures and constraints to implement the application 3. Maintain familiarity with the structure and characteristics of databaseapplications 4. Manage the bulk loading of data with SQLLDR 5. Manage Data transfer or reorganisation using EXPORT/IMPORT D. BACKUP AND RECOVERY 1. Understand Oracles Recovery Structures and Architecture 2. Understand the Functionality of RMAN and its benefits 3. Develop a suitable backup, restore and recovery Strategy 4. Understand and implement multiplexed control files 5. Understand and implement redo log groups and redo log members 6. Perform backups of databases and tablespaces with and without RMAN 7. Perform restores and recoveries with and without RMAN both complete and incomplete 8. Perform Block Media Recovery (BMR) with RMAN 9. Perform test recovery E.SOFTWARE MAINTENANCE AND OPERATION 1. Install and upgrade Oracle and supporting products using the Oracle Universal Installer and various maintenance tools 2. Configure the Oracle instance using init.ora or SPFILES and OMF 3. Create a database with or without OMF 4. Distinguish among Instance startup and shutdown options 5. Configure and Manage Listeners and client naming methods using Oracle Net 6. Demonstrate an understanding of the capabilities of underlying operating systems and File Systems as they relate to the Oracle database 7. Manage maintenance contracts and support agreements F. SEGMENT and DATA MANAGEMENT 1. Understand and Implement tablespaces - locally managed and dictionary managed and their datafiles 2. Understand the benefits of automatic segment space management 3. Understand and Implement the various types of Segments in Oracle for storing Table data, including Tables,Clusters, IOTs, External Tables 4. Understand and implement different Index options available in Oracle including B*Tree, Bitmap, reverse key, and function based 5. Implement integrity constraints 6. Understand the implementation of Workspace Management for table Versioning G.TUNING AND TROUBLESHOOTING 1. Use data dictionary and Dynamic Performance views to Monitor the Database and the Instance 2. Collect and analyze relevant database performance information 3. Identify and implement appropriate solutions for database performance problems 4. Diagnose and resolve locking conflicts 5. Diagnose Oracle Net problems 6. Perform capacity planning 7. Control system resource contention using the Oracle Resource Manager 8. Implement profiles to limit resource consumption. 9. Use vendor support services when necessary 10. Communicate with users about problem resolution and proper system usage H. SCALABILITY 1. Demonstrate an appreciation of Real Application Clusters Architecture Scaleup and Speedup capabilities 2. Demonstrate an Appreciation of Shared Server Architecture 3.Demonstrate an
Re: Do triggers cause a context switch between SQL PL/SQL
I did some bulk load testing with triggers on v8.1.7.4 a few months ago. All the trigger(s) had for code was a NULL; statement. The first trigger increased the time 100% in the insert (ie: a load that took 1 minute increased to 2 minutes with the trigger). Each additional trigger after the first cost an additional 25%. So I would read that as a 75% cost/increase to do the SQL to PLSQL switch. [EMAIL PROTECTED] .com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: Do triggers cause a context switch between SQL PL/SQL 04/01/03 12:43 PM Please respond to ORACLE-L I thought as much, from what I've heard and read. Does anyone know if there's a way to figure out how much overhead the switches generate? I'm guessing they would show up in trace files in the 'other CPU' category. [EMAIL PROTECTED] T Sent by: To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: bcc: 04/01/03 01:19 PMSubject: Re: Do Please respond totriggers cause a context switch between SQL PL/SQL ORACLE-L Since you the action switches from SQL to PL/SQL to enforce the trigger, it sounds like a context switch to me. FYI: This can be improved somewhat by adding and rownum 2 into the WHERE clauses of these. There will be noticable improvement when there are many child rows. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 04/01/2003 09:48 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Do triggers cause a context switch between SQL PL/SQL Question: If some idiot decides to circumvent Oracle's referential integrity and re-implement it by using triggers (insert, update, delete) that checks the foreign (parent/child) key fields in other tables like this, declare numrows INTEGER; begin -- ApplicationForm is used if the state and other criteria match that in -- ApplicationFormCriteria ON PARENT DELETE RESTRICT select count(*) into numrows from ApplicationFormCriteria where ApplicationFormCriteria.applicationFormId = :old.applicationFormId; if (numrows 0) then raise_application_error( -20343, 'Database Integrity Violation - Cannot DELETE row in Table ''ApplicationForm'' because referencing row exists in table ''ApplicationFormCriteria'' for Primary Key (applicationFormId)=' || :old.applicationFormId ); end if; end; would it cause context switching between the SQL PL/SQL engines? Yes, some genius did this in one of our databases. Two hundred third/fourth normal form tables enforced by 800 triggers... I have him registered to be stoned in public. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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
RE: Oracle urban legends and myths needed
ORA-01555, 0, snapshot too old: rollback segment number %s with name \%s\ too small indicates that the DBA should immediately create a hugh rollback segment -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stephane Paquette Sent: 01 April 2003 15:54 To: Multiple recipients of list ORACLE-L Subject: Oracle urban legends and myths needed Hi all, I'm currently writing an Oracle user guide for our developpers about how Oracle is implemented, SQL and PL/SQL good practices, tuning, rule base vs cost base (90 on 120 databases are still rule base) ... I want to add an Oracle urban legends and myths section focussed on development. I'm missing inspiration as I only have the use an index it'll go faster one. I'm sure you have lots of them. TIA Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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.net -- Author: Niall Litchfield 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). __ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
RE: Oracle Mail
Dick, check out this link http://www.oracle.com/jsp/events/EventsDetail.jsp?p_eventId=9595src=1544227src=1544227Act=183 it is the link top the OTN events about just what you are talking about. If your lucky you can get the slide show that did the comparisons between Oracle and MS per user per year. Ron [EMAIL PROTECTED] 04/01/03 04:08PM Kirti, Can I add to your request? I'd appreciate knowing of anyone who migrated to collaborative suite instead of Exchange and if there was a $$ difference how much it was and which way. Also if you did make the move from Exchange to Collaborative did you save any money in the process? Dick Goulet -Original Message- Sent: Tuesday, April 01, 2003 3:34 PM To: Multiple recipients of list ORACLE-L Hello All, Anyone migrated to Oracle Mail from MS Exchange Server? Care to share the experience? I was asked about it. I have no idea how it works. I am trying to gather as much info as possible from Oracle.com, Google etc.. Thanks. - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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.net -- Author: Goulet, Dick 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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.net -- Author: Ron Rogers 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
Re: RMAN - Some basic Qs.
In case of hot backup scn at then time of starting backup is frozen in datafile header , and is refreshed at the time of end backup .what happens in RMAN ? -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 12:43 PM All, The primary reason why RMAN does not generate excessive redo is because because it does not put the tablespace in hot backup mode. Thus any blocks belonging to a given tablespace that are modified before the END BACKUP command is processed, do not require block-level before and after images. Hence the reduction in redo generation. So how does RMAN backup without hot backups? RMAN is aware of the format of an Oracle datafile, and reads datafiles for the backup in DB_BLOCK_SIZE chunks. This is not the case with most OS utilities (tar, cpio, cp, dd etc.), which read files in 512-byte OS blocksize chunks. As a result, the issue of a fractured block (for which block-level before/after images are taken) on the destination where the backup is done, does not come into play in RMAN. Hope that helps, Gaja --- Goulet, Dick [EMAIL PROTECTED] wrote: 1: RMAN does not generate excessive redo because it does not use the 'alter tablespace ... begin backup' command. It instead coordinates with dbwr, somehow, to be sure it is getting a consistent view of the tablespace. 2: The concept of an incremental backup is that you only backup the database blocks that have changed since the last incremental of the same or higher level. Somehow the date that the block changed is being managed, probably in the header somewhere. 3: If your reading a block for backup purposes, it's pretty easy to checksum it and compare with what's in the header just like the Oracle kernel does. 4: I've tried before with OmniBack and it's fairly simple. You only have to relink Oracle including a MML library file. The package you want to integrate with should have instructions. Dick Goulet -Original Message- Sent: Tuesday, April 01, 2003 10:19 AM To: Multiple recipients of list ORACLE-L Qs.1 Why is NO excessive Redo Generated wsing RMAN Backups unlike HOT Backups when taking backup of an OPEN Database which is undergoing User Transactions ? (Or am i mistaken ?) Qs.2 How does RMAN manage Incremental Database Backups ? What is the Concept behing it ? Qs.3 How does RMAN Check for Block Corruption while taking backup ? Qs.4 Is it easy to integrate 3rd part tools like Legato etc with RMAN for enabling taking of backups onto backup devices OR does it need an extensive setup ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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.net -- Author: Goulet, Dick 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). = __ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gaja Krishna Vaidyanatha 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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.net --
Re: Perl DBD::Oracle - discontinuing support for Oracle 7 and Oraperl?
A V9.2 DB can't/won't talk to a V7 DB, and vice versa. So we were forced into using a V8.1.7 DB as the middle man. It works for low volume transactions. Tim Bunce [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] com cc: Sent by: Subject: Re: Perl DBD::Oracle - discontinuing support for Oracle 7 and Oraperl? [EMAIL PROTECTED] 04/01/2003 12:58 PM Please respond to ORACLE-L On Tue, Apr 01, 2003 at 10:08:31AM -0800, [EMAIL PROTECTED] wrote: Tim, Personally, I have a few v7 db's around. My DBD interaction with them however is limited to logging on to the database just to make sure it's still up. Would removing OCI7 support include removing the ability to logon to a v7 db? You can login to whatever the oracle client libs you link with will let you log into. For v8 libs that includes v7. I did hear recently that v9.x no longer lets you connect to v7. You could always keep a copy of DBD::Oracle 1.14 for use with Oracle 7. Just install it into a different directory. Tim. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Bunce 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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.net -- Author: 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
RE: Lies, damn lies and statistics
-Original Message- From: Stephane Faroult interesting tuning case study snipped A moral to the story? SET TIMING ON. What matters is elapsed time, not stats. That said, I must check events next week. Another lesson, which probably wouldn't make any difference in your case, is to run tests more than once, since caching can change both the statistics and the time. LEGAL NOTICE: Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this e-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sarnowski, Chris 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
RE: Lies, damn lies and statistics
Congratulations Stephane -- a good lesson for us all. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 01, 2003 3:14 PM To: Multiple recipients of list ORACLE-L The case is not as bad as the subject may let you believe, but not quoting Disreali was above my strength ... Anyway, an interesting case encountered today. Basically, a dreadful query, involving a reasonably big table with an innate tree structure (the stuff connect bys are made of), accessed through a view with outer joins, user-written functions called for each line, and search for text (upper(column) like '%STUFF%') in a number of related columns. The row must be returned whether the text is found for the row itself, a descendent or an ascendent, which means that the text search is found twice in two different START WITH subqueries. The query of hell. The execution plan is made of a whopping 176 steps. In spite of all this, the execution time is close to 25s, which is not that bad, given the context. There would be much to say about the design, now we're in 'fix it' mode. Noting the huge number of 'nested loops', the first attempt is to try the ALL_ROWS hint, to see whether hash joins couldn't improve our case. Here is the result : original all_rows Steps in plan176 166 recursive calls 259 1776 db block gets 72 324 consistent gets 474556 6700 physical reads 12497 1981 redo size152 21736 bytes to client 3060 3060 bytes from client 5811 4500 SQL*Net roundtrips 2 2 memory sorts 1013 disk sorts 0 0 rows 6 6 Elapsed time 24.75 4 mn Although LIOs have drastically reduced, and so have PIOs, our time is about 10 times worse! BCHR zealots will note that our original 97% hit-ratio has become a 72% hit-ratio, but the reason is more likely to be found in the HUGE increase of recursive calls and the surprising increase of the 'redo size' stat (why does it generate redo? It's a SELECT ... Must be something weird going on). I had no access to the server, which prevented me from tracing, and not much time (this is a customer I visit only once a week - results first) which means that I have not had time to inquire about events. But wait, it gets weirder. After having tried the easy solution, I dug into rewriting. Here are the stats for 3 successive rewritings : original 1st rewriting 2nd rewriting 3rd rewriting Steps in plan176 112158 113 recursive calls 259 259259 252 db block gets 7266 60 69 consistent gets 474556 80276 376501 80727 physical reads 12497 1068 21091406 redo size152 0 0 0 bytes to client 3060 3060 30603060 bytes from client 5811 3705 53063803 SQL*Net roundtrips 2 2 2 2 memory sorts 1010 10 11 disk sorts 0 0 0 0 rows 6 6 6 6 Elapsed time 24.75 Look at the values. How would you rank the variations ? Answer below . . . . . . . . . . . . . . . . . . . . . 1st rewriting: 38.06 2nd rewriting: 13.48 3rd rewriting: 3.56 Not an April's fools joke. A moral to the story? SET TIMING ON. What matters is elapsed time, not stats. That said, I must check events next week. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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.net -- Author: DENNIS WILLIAMS 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be
RE: backup strategy for a database over 1 TB running SAP R/3
Try help.sap.com and search on RMAN and Oracle. Here's one to get you started. http://help.sap-ag.de/sapdocu/core/470/helpdata/EN/3f/9d80051aec11d2b42c00609419997a/content.htm Jared Roger Xu [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 04/01/2003 01:09 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: backup strategy for a database over 1 TB running SAP R/3 Yes. In fact, I am trying to decide using RMAN or SAP BR-tools. -Original Message- Sent: Tuesday, April 01, 2003 2:04 PM To: Multiple recipients of list ORACLE-L Roger We don't run SAP, but are you considering using RMAN as a part of your plans? Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 01, 2003 1:39 PM To: Multiple recipients of list ORACLE-L Hi, What is the backup strategy for a database over 1 TB running SAP R/3 on Solaris? We are using Legato products and they have NetWorker Module for Oracle and NetWorker Module for SAP on Oracle. Which one is better? Thanks, Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 This email has been scanned for all viruses by the MessageLabs SkyScan service. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.messagelabs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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.net -- Author: DENNIS WILLIAMS 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). This email has been scanned for all viruses by the MessageLabs SkyScan service. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.messagelabs.com This email has been scanned for all viruses by the MessageLabs SkyScan service. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.messagelabs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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.net -- Author: 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
How to use small oracle database in my program
What do you thinke of how the OutLook express handle the data (email)? I think they are stored in database . Now ,I am going to program by visual c++ , In order to process large data , I want to use oracle . But I don't want to tell my users: to get a oracle database 9i and install it .The program needs them. If there is some way to get the core parts of oracle that you only install it you can use them? I just need some table and index to make my processing data fast. Thank you ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: liujd 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
RE: Do triggers cause a context switch between SQL PL/SQL
Title: RE: Do triggers cause a context switch between SQL PL/SQL Your query with the exists would be the same as doing this, right? select count(*) into numrows from from ApplicationFormCriteria where ApplicationFormCriteria.applicationFormId = :old.applicationFormId and rownum = 1 ; -Original Message- From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]] Sent: mardi, 1. avril 2003 13:04 To: Multiple recipients of list ORACLE-L Subject: RE: Do triggers cause a context switch between SQL PL/SQL A context switch is order because a trigger is a pl/sql object ... if you can change the trigger ... instead of count(*) try using exists assuming you have a usable index ... select count(*) into numrows from dual where exists ( select 1 from ApplicationFormCriteria where ApplicationFormCriteria.applicationFormId = :old.applicationFormId); If you have an index on ApplicationFormCriteria.applicationFormId, this should fly ... and still accomplish what you need. The basic problem here is the developer doesn't understand the question. If the question is Is there at-least one row that mayches a given value so that I can restrict the delete? then my solution is the right one. If the question is How many rows do I have matches a given value so I can ... ? then the SQL you have is the right one. Looking at the pl/sql code, the question is the former one and the SQL used by the developer is the wrong one. When you do a count(*) oracle will search the table till the HWM, if the table is large, it will make lot of difference. Where the query above will stop after it finds the first matching row, most likely doing less work that the query you have. You can say I am picking on the semantics, but see how much difference it makes?
Re: Index usage in 8.1.6
Murali , I have attached a script. i use the same to find index usage. hope this helps. Regards, Jp. FindIndexUsage.sql Description: Binary data
Re: How to use small oracle database in my program
From: liujd [EMAIL PROTECTED] What do you thinke of how the OutLook express handle the data (email)? I think they are stored in database . Now ,I am going to program by visual c++ , In order to process large data , I want to use oracle . But I don't want to tell my users: to get a oracle database 9i and install it .The program needs them. If there is some way to get the core parts of oracle that you only install it you can use them? I just need some table and index to make my processing data fast. Thank you ! Oracle is serious overkill for this application, and while I highly recommend it for OLTP and DSS, for your situation, you probably want something more like MySQL or MS Access. Chris Berry [EMAIL PROTECTED] Systems Administrator JM Associates Without change, something sleeps inside us, and seldom awakens. The sleeper must awaken. -- Duke Leto Atreides _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Berry 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
Re: How to use small oracle database in my program
I think the answer will depend slightly on your operating platform and intended use of the product... But the generic answer is No. I have never heard of just the engine for Oracle... Essentially Oracle is just an engine, there's not much you could remove and still have a functioning product unless you strip features like partitioning. I believe Oracle is free for some platforms - Linux comes to mind, but I believe this may be limited to non-commercial use. I guess at the end of the day Oracle has to make money to feed their programmers, etc so you aren't likely to find Oracle for free. Having said that I know some members of this list speak highly of Postgress and MySQL for small / free database engines. Alternatively perhaps you can integrate an Access style database - I've certainly done it in Visual Basic before. Regards, Mark. liujd [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cn cc: Sent by: Subject: How to use small oracle database in my program [EMAIL PROTECTED] om 02/04/2003 10:23 Please respond to ORACLE-L What do you thinke of how the OutLook express handle the data (email)? I think they are stored in database . Now ,I am going to program by visual c++ , In order to process large data , I want to use oracle . But I don't want to tell my users: to get a oracle database 9i and install it .The program needs them. If there is some way to get the core parts of oracle that you only install it you can use them? I just need some table and index to make my processing data fast. Thank you ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: liujd 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
Database character set for Webshpere access
Title: Database character set for Webshpere access list, I've searched the faq list and metalink. It appears the database character set for java etc should be al32utf8 and nls_character set of al16utf16 for a 9i R2 database. Has anyone altered a database from US7ASCII to al32utf8 and al16utf16? Any problems?
Re: How to use small oracle database in my program
What are you going to be doing? You probably can use an embedded database like BerkeleyDB or Sqlite On Tue, 1 Apr 2003, liujd wrote: What do you thinke of how the OutLook express handle the data (email)? I think they are stored in database . Now ,I am going to program by visual c++ , In order to process large data , I want to use oracle . But I don't want to tell my users: to get a oracle database 9i and install it .The program needs them. If there is some way to get the core parts of oracle that you only install it you can use them? I just need some table and index to make my processing data fast. Thank you ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: liujd 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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.net -- Author: Alex 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
RE: Oracle Mail
Thanks for the information, Ron. I will check it out in due course of time. I was more interested in knowing if anyone has done this migration. As Dick mentioned, we are interested in finding out if there is any $$ savings, and how much, and at what cost (of deployment etc etc).. These days Oracle is running some interesting Radio Ads related to Oracle Mail and Collaborative Suites, and it appears some of the Damagers types have heard it (and probably liked it too) - Kirti -Original Message- Sent: Tuesday, April 01, 2003 3:44 PM To: Multiple recipients of list ORACLE-L Dick, check out this link http://www.oracle.com/jsp/events/EventsDetail.jsp?p_eventId=9595src=1544227src=1544227Act=183 it is the link top the OTN events about just what you are talking about. If your lucky you can get the slide show that did the comparisons between Oracle and MS per user per year. Ron [EMAIL PROTECTED] 04/01/03 04:08PM Kirti, Can I add to your request? I'd appreciate knowing of anyone who migrated to collaborative suite instead of Exchange and if there was a $$ difference how much it was and which way. Also if you did make the move from Exchange to Collaborative did you save any money in the process? Dick Goulet -Original Message- Sent: Tuesday, April 01, 2003 3:34 PM To: Multiple recipients of list ORACLE-L Hello All, Anyone migrated to Oracle Mail from MS Exchange Server? Care to share the experience? I was asked about it. I have no idea how it works. I am trying to gather as much info as possible from Oracle.com, Google etc.. Thanks. - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
Developer OCP, or DBA OCP ..?
Hi gurus,what do u recommend: taking "Developer OCP" then "DBA OCP", or "DBA OCP" direct ?assuming a person who is currently a 28 years - already is a senior oracle developer.thanx for advice Regards,Salaheldin Aboali--Senior Software Developer Management Information Systems--http://www.mis-kuwait.comPhone:+965.240.64.25+965.240.67.98+965.240.80.92Ext. 235Fax. +965.240.81.53Cell. +965.790.31.65--P.O. Box: 20126 Safat-13062 Kuwait--
HELP
HELP -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
Calculate the disk capacity
Hi All, Is there any way to find out the total disk capacity available, from the PL/SQL program ? Regards, Pradeep -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
Oracle Server / W2K
Hi all, what might be the best configuration for OLTP database if you have following components: DL380 2*1.4ghz, 2GB Mem, 6*16GB 15k Disks... And what is the correct flag for Optimize Performance for Applications or Background Processes... TIA Joshua _ Gå före i kön och få din sajt värderad på nolltid med Yahoo! Express Se mer på: http://se.docs.yahoo.com/info/express/help/index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Joshua=20Becker?= 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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
RE: how to calculate table size
I've been using this query for both normal and empty tables and works so far.
For those tables with no data in them (or that have suffered no deletion) you
can ommit the second query since the table should not have any emptied block. Emptied
blocks are those who have been occupied by data from the table but that have been
deleted; for these, Oracle marks them as deleted but are still asigned to a table. I
do not know if you want to consider this free space as part of the table or not.
There is a way to deallocate unused space to a table that has been previously
used. You must use 'alter table ... deallocate' for that. You have explanations on
this in the manual, check:
http://download-west.oracle.com/docs/cd/A91202_01/901_doc/server.901/a90125/statements_32.htm#2080417
I am sending this mail to the list as well, I am a learner and do not consider
myself an expert, maybe someone else can join and comment something.
-Mensaje original-
De: Basavaraja, Ravindra [mailto:[EMAIL PROTECTED]
Enviado el: martes, 01 de abril de 2003 20:41
CC: '[EMAIL PROTECTED]'
Asunto: RE: how to calculate table size
Hi Fermin,
Thanks for your reply.
I am estimating the growth of database tables for a new database and many tables don't
have any data.
Can I still use the same queries to estimate the size of the tables or do you have
anything different?
Thanks
-Original Message-
Sent: Tuesday, April 01, 2003 4:24 AM
To: Multiple recipients of list ORACLE-L
Hi Ravindra,
Use the following, supposing your db_block_size is 2048 (change as appropiate).
SELECT segment_type, segment_name,BLOCKS*2048/1024 Kb
FROM DBA_SEGMENTS
WHERE OWNER=UPPER('owner') AND SEGMENT_NAME = UPPER('table_name');
You should substract emptied blocks from this table, using:
ANALYZE TABLE owner.table_name ESTIMATE STATISTICS;
SELECT TABLE_NAME, EMPTY_BLOCKS*2048/1024 Kb
FROM DBA_TABLES
WHERE OWNER=UPPER('owner') AND TABLE_NAME = UPPER('table_name');
This will give you how many kb are occupied by empty blocks, so substract this
amount from the prior result.
Hope this helps.
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Basavaraja,
Ravindra
Enviado el: martes, 01 de abril de 2003 1:24
Para: Multiple recipients of list ORACLE-L
Asunto: how to calculate table size
Hi,
Anyone having any formula to calculate table size?Basically to estimate the growth of
table over a peroid of time.
I have the row_size,db_block_size.How do i get the table size.
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Basavaraja, Ravindra
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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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.net
--
Author: Fermin Bernaus Berraondo
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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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.net
--
Author: Fermin Bernaus Berraondo
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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).
