RE: Case stmt not compiling
This is due to the difference betweeen the PL/SQL Compiler and SQL Compiler. This has been rectified from 9i onwards One way to achive this is to Create a view and access this View in Pl/sql. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- [EMAIL PROTECTED] Sent: Friday, June 14, 2002 10:03 AM To: Multiple recipients of list ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ganesh Raja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: Free Buffer Waits/CNTD......
Hi All, As mysteriously as it took over 6 hours to run yesterday, it was back at 35 minutes today. Free buffer waits dropped out of the top 10 again as well. My question now is: If nothing changed to the database (we did not modify anything because we could not find the source of all evil) and there are no different processes running (it's the same batch job every day) and there are no users connected (listener.ora file), could it be that for some reason my DBWR processes weren't able to write to disk and Oracle did not report an error on it Jack Cary Millsap cary.millsap@hotTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] sos.com cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: RE: Free Buffer Waits [EMAIL PROTECTED] 13-06-2002 19:08 Please respond to ORACLE-L free buffer waits waits indicate that your DBWR can't keep up with its workload. Often caused by inefficient SQL competing with DBWR for an I/O device. Cary Millsap Hotsos Enterprises, Ltd. [EMAIL PROTECTED] http://www.hotsos.com -Original Message- Zanen Sent: Thursday, June 13, 2002 4:04 AM To: Multiple recipients of list ORACLE-L Hi All, We have a production database that has a batch job running on it for months now. Last night one part of the batch job that normally takes between 20-30 minutes took well over 6 hours. The only difference I can see between today other days is that the Free Buffer Wait event was the top wait event, which it not normally is (not even top 10) This database goes down every night for backup and this is the timings I got. Total waits:22055 Total timeouts:22052 Time waited: 2225285 (is this ms or cs?) Avg.wait:100.8971 This whole thing puzzles me a bit since nothing changed to the database and nothing was in the Alert log. Also system was virtually idle during the 6 hours (no activity according to UNIX boys) I was sound asleep when this happened so I don't have much more than this info. Can anybody explain why this could have happened or point me to some documents that can. Standard answer you'll find that your DBWR can't keep up, but I have 4 of them and the sytem was idle. THX === De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for
Port access cancelling
Hello Unix Guru's! One of the port supposed to be used by db server has been occupied by application servers. When I want start a particular interface programs on DB which access the particular port is right now busy because it is used by apps server which is not supposed to be. I cancelled the PID on apps server and tried run ning the application interface on db server, but I still get the port in use error. How do I check that this port is in use by which apps server. We have 4 apps servers. Last time when we had this issue we did rebooted the apps servers to release this port. I guess that not the perm. solution. Please advice. = Thank You. Best Regards, Steve Johnson __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Johnson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: 9i R2 not automatically starting up after upgrade
Are you using a domain to connect to your PC. You should go into services and OracleServiceSID --- Properties. In the Log On tab go and choose log on as this account and choose your username and password that you are connecting to the domain. Stop and restart the service, and check that the memory is reserved for the instance. Regards Theodoros -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 8:22 PM To: Multiple recipients of list ORACLE-L I upgraded a database yesterday from 9i R1 (9.0.1) to 9i R2 (9.2.0.1.0), and am now having problems with the database starting up automatically on system reboot. This is on a Windows 2000 Pro machine. The error that I get when I try to connect with SQL*Plus is ORA-27101: shared memory realm does not exist. If I run SQL*Plus with the /nolog option, connect / as sysdba, and startup manually, everything works fine. Anyone have any idea why it won't startup automatically, or what I could try to get it to? Thanks. _YEX_ /* || Robert D. Yexley || Oracle Programmer/Analyst || Easylink Services Corporation || Professional Services || Contractor - Wright Research Site MIS || Det-1 AFRL/WSI Bldg. 45 Rm. 062 || (937) 255-1984 || [EMAIL PROTECTED] || ))) */ Robert D. Yexley (E-mail).vcf -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Theodoros Demosthenous INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: Management Reports
your ass :-) -Original Message- Sent: 13 June 2002 16:33 To: Multiple recipients of list ORACLE-L Good Morning Everyone! My management wants a chart that shows the performance of the database. If this was your boss, what would you show them? Thanks, Mike P.S. This is a repeat e-mail. I never saw my other one hit the list. --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: SunOS 5.8 I/O buffer size?
Hi Tim
Here are numbers for a Redhat 7.2 Linux with kernel 2.4.17 using
LVM1.0.3 on the disk.
There is something rotten here since the read time is not increasing
with a factor 10 as I would
expect the write time is behaving close to expected.
If you want the full strace drop a mail.
1 Mb Read / Write
0.00 execve(/bin/dd, [dd, if=system01.dbf, of=/dev/null,
bs=1024k, count=10], [/* 29 vars */]) = 0
..,
0.84 read(0, \2\0\0\0\0
\0\0\0\310\0\0]\\[Z\0\0\0\0\4\356\0\0\0\0\0..., 1048576) = 1048576
0.018887 write(1, \2\0\0\0\0
\0\0\0\310\0\0]\\[Z\0\0\0\0\4\356\0\0\0\0\0..., 1048576) = 1048576
0.000105 read(0,
\6\2\0\0\200\0@\0\330y\3\0\0\0\1\0065\32\0\0\1\0\0\0\22..., 1048576) =
1048576
0.007667 write(1,
\6\2\0\0\200\0@\0\330y\3\0\0\0\1\0065\32\0\0\1\0\0\0\22..., 1048576) =
1048576
0.000107 read(0,
\0\2\0\0\0\1\0\0\0\0\0\0\0\0\1\5\0\6\0\0\0\0\0\0\0\0\0..., 1048576) =
1048576
0.005537 write(1,
\0\2\0\0\0\1\0\0\0\0\0\0\0\0\1\5\0\6\0\0\0\0\0\0\0\0\0..., 1048576) =
1048576
0.000182 read(0,
\0\2\0\0\200\1\0\0\0\0\0\0\0\0\1\5\200\6\0\0\0\0\0\0\0..., 1048576) =
1048576
0.008132 write(1,
\0\2\0\0\200\1\0\0\0\0\0\0\0\0\1\5\200\6\0\0\0\0\0\0\0..., 1048576) =
1048576
0.000140 read(0,
\6\2\0\0\0\2@\0\331[\3\0\0\0\2\4\207%\0\0\1\0(\0D\0\0\0..., 1048576) =
1048576
0.007741 write(1,
\6\2\0\0\0\2@\0\331[\3\0\0\0\2\4\207%\0\0\1\0(\0D\0\0\0..., 1048576) =
1048576
0.000113 read(0,
\0\2\0\0\200\2\0\0\0\0\0\0\0\0\1\5\200\5\0\0\0\0\0\0\0..., 1048576) =
1048576
10 Mb Read / Write
0.00 execve(/bin/dd, [dd, if=system01.dbf, of=/dev/null,
bs=10240k,count=10], [/* 29 vars */]) = 0
..
0.86 read(0, \2\0\0\0\0
\0\0\0\310\0\0]\\[Z\0\0\0\0\4\356\0\0\0\0\0..., 10485760) = 10485760
0.084090 write(1, \2\0\0\0\0
\0\0\0\310\0\0]\\[Z\0\0\0\0\4\356\0\0\0\0\0..., 10485760) = 10485760
0.000110 read(0,
\0\2\0\0\0\5\0\0\0\0\0\0\0\0\1\5\0\2\0\0\0\0\0\0\0\0\0..., 10485760) =
10485760
0.073709 write(1,
\0\2\0\0\0\5\0\0\0\0\0\0\0\0\1\5\0\2\0\0\0\0\0\0\0\0\0..., 10485760) =
10485760
0.000160 read(0,
\0\2\0\0\0\n\0\0\0\0\0\0\0\0\1\5\0\r\0\0\0\0\0\0\0\0\0..., 10485760) =
10485760
0.070780 write(1,
\0\2\0\0\0\n\0\0\0\0\0\0\0\0\1\5\0\r\0\0\0\0\0\0\0\0\0..., 10485760) =
10485760
0.000569 read(0,
\0\2\0\0\0\17\0\0\0\0\0\0\0\0\1\5\0\10\0\0\0\0\0\0\0\0..., 10485760) =
10485760
0.071877 write(1,
\0\2\0\0\0\17\0\0\0\0\0\0\0\0\1\5\0\10\0\0\0\0\0\0\0\0..., 10485760) =
10485760
0.000154 read(0,
\6\2\0\0\0\24@\0\236(\1\0\0\0\2\4\264\357\0\0\1\0\0\0..., 10485760) =
10485760
0.071539 write(1,
\6\2\0\0\0\24@\0\236(\1\0\0\0\2\4\264\357\0\0\1\0\0\0..., 10485760) =
10485760
0.000157 read(0,
\6\2\0\0\0\31@\0{N\1\0\0\0\2\4\265\222\0\0\1\0\0\0J\0\0..., 10485760)
= 10485760
Tim Gorman wrote:
Carmen et al,
Did some testing on this. On solaris 2.8 there doesn't seem to be any
upper-limit on single, atomic disk I/O, probably because someone finally got
smart and started allocating memory buffers for I/O dynamically using the
malloc() package instead of hard-coding a fixed-length variable as a
buffer. At least, they did so for the dd command...
Ran the following, reading three 1024Kb chunks from a large file while
trussing the UNIX dd command:
$ truss -D dd if=/d01001/oradata/portal/portal_01.dbf of=/dev/null bs=1024k
count=3
0. execve(/usr/bin/dd, 0xFFBEFC8C, 0xFFBEFCA4) argc = 5
0.0036 mmap(0x, 8192, PROT_READ|PROT_WRITE|PROT_EXEC,
MAP_PRIVATE|MAP_ANON, -1, 0) = 0xFF3A
0.0005 resolvepath(/usr/lib/ld.so.1, /usr/lib/ld.so.1, 1023) = 16
0.0006 open(/var/ld/ld.config, O_RDONLY) Err#2 ENOENT
0.0004 open(/usr/lib/libc.so.1, O_RDONLY)= 3
0.0003 fstat(3, 0xFFBEF3C4)= 0
0.0002 mmap(0x, 8192, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) =
0xFF39
0.0003 mmap(0x, 794624, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) =
0xFF28
0.0004 mmap(0xFF33A000, 24784, PROT_READ|PROT_WRITE|PROT_EXEC,
MAP_PRIVATE|MAP_FIXED, 3, 696320) = 0xFF33A000
0.0005 munmap(0xFF32A000, 65536) = 0
0.0007 memcntl(0xFF28, 113272, MC_ADVISE, MADV_WILLNEED, 0, 0) = 0
0.0003 close(3)= 0
0.0003 open(/usr/lib/libdl.so.1, O_RDONLY) = 3
0.0003 fstat(3, 0xFFBEF3C4)= 0
0.0003 mmap(0xFF39, 8192, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED,
3, 0) = 0xFF39
0.0004 close(3)= 0
0.0004 open(/usr/platform/SUNW,Ultra-5_10/lib/libc_psr.so.1, O_RDONLY) =
3
0.0004 fstat(3, 0xFFBEF254)= 0
0.0003 mmap(0x, 8192, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) =
0xFF38
0.0003 mmap(0x, 16384, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) =
0xFF37
0.0004 close(3)= 0
0.0015 munmap(0xFF38, 8192)= 0
0.0009
Re: ORA-00604 and ORA-01578
Hi BigP Create a tablespace corrupt.dbf fill it with a table. Use dd to write junk in the middle of the datafile and you have a ora-1578 BigP wrote: Just to learn this thing , ..how can I corrupt a block in my test environment . o . but be ready to help me if I am not able to repair it . Thanks , Bp - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 13, 2002 4:23 AM Is there any PERFORMANCE Overhead on Setting DB_BLOCK_CHECKING = TRUE in the init.ora . Any Best practice on this parameter Setting ? Thanks -Original Message- Sent: Wednesday, June 12, 2002 12:34 AM To: Multiple recipients of list ORACLE-L Resend. -Original Message- Sent: Tuesday, June 11, 2002 12:45 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Peter - You can use the DBMS_REPAIR package included with Oracle to locate the corrupt blocks. If the data in the corrupted blocks is extremely important, you can use this to dump the block contents. Then you can change the blocks so Oracle will skip the corrupted blocks. Then you can export the table or copy the contents to another table. Dropping the tables and recreating it from your export is also an option. Don't forget to rebuild indexes afterward. Run ANALYZE TABLE VALIDATE CASCADE to find any other corrupt blocks in other tables. And turn on the init.ora parameter DB_BLOCK_CHECKING to detect any further corruptions before they occur. Good luck. -Original Message- Sent: Tuesday, June 11, 2002 12:29 PM To: Multiple recipients of list ORACLE-L I have a system when I issued a select statement, I get the following error. ORA-00604 Error Occur at recursive level 1 ORA-01578 Oracle Datablock corrupted. File 6 Block 2853 ORA-01110 Datafile 6 E:\ORANT\DATABASE\RBS1.DBS We have an export that we may be able to restore. The database is running in non-archive mode. Any idea on how to resolve this problem? Thank you in advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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). -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk /* The process of preparing programs for a digital computer is especially attractive, not only because it can be economically and scientifically rewarding, but also because it can be an aesthetic experience much like composing poetry or music Donald Knuth */ smime.p7s Description: application/pkcs7-signature
change Language on server after Oracle install
We have a AIX server with Oracle 8.1.7 installed. The language is set to ISO8859-1 English US. We want to change the language to French for testing purposes. Do we need to re-install Oracle? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Management Reports
Keep the report short, just a page once a week, and have three key things highlighted -- your most important measurements of performance. People like to skim a report and focus on a few key things. A good idea for these metrics just might be the three most critical business transactions. A performance report could show whether they complete in a timely manner, week after week. That's the definition of performance, right? Simply measure how long they take - perhaps via trace/TKPROF. Keep the detailed TKPROF reports in a notebook and just provide Elapsed Time Total number for the management report. You could have these three totals in three graphs, so as weeks go by they can watch the graphs fill in and see if they are taking more, less, or the same amount of time to complete. Besides this there could be an optional Other Items section you sometimes include, in which you suggest ideas, report successes, or beg for more disk drives. ;-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: INITRANS question
INITRANS reserves block header control blocks for each row potentially locked in the block by a transaction. Find out how many rows there are on average in your data blocks and that is the absolute maximum you need for INITRANS for that object. Of course, in reality you would most likely be using a LOT less than that max. As a rule of thumb, I set it to the number of CPUs in the system. The logic: well, there can only be number of CPU threads actually concurrently updating the same block at the same time. So that is my setting. Works fine from where I'm standing. Most likely even that is excessive. Particularly if you use a 64 CPU system. I wouldn't go much higher than 6. Of course YMMV, IMHO, you-may-be-running-V6, etc etc. Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - I have few tables with a lot of transaction by many users, I change the Initrans from 1 to 5 and for some to 25, My question is what's the best way to findout which value is the optimum value for INITRANS for each table? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: Case stmt not compiling
Another alternative, no better or worse than Ganesh's reply, is to use
native dynamic SQL:
Declare
l_ln_status varchar2(1);
Begin
execute immediate 'select (case when ''N'' in (''C'',''N'',''U'',''V'') then
''C''
else (case when ''N'' = ''P'' then ''P''
end)
end) from dual' into l_ln_status;
dbms_output.put_line('Here: '||l_ln_status);
end;
/
Now I *really* have to ask, though, why the original poster, Manoj, wants to
do the CASE statement selecting from dual when a simple IF/THEN/ELSE
construct could be used to populate the variable. Why bring a SQL statement
and dual into the mix? Or was this just a sample query to illustrate the
question?
Regards,
Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ganesh Raja
Sent: Friday, June 14, 2002 2:23 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Case stmt not compiling
This is due to the difference betweeen the PL/SQL Compiler and SQL
Compiler. This has been rectified from 9i onwards
One way to achive this is to Create a view and access this View in
Pl/sql.
HTH
Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax : +971 (4) 397 6262
HP : +971 (50) 745 6019
Live to learn... forget... and learn again.
-Original Message-
[EMAIL PROTECTED]
Sent: Friday, June 14, 2002 10:03 AM
To: Multiple recipients of list ORACLE-L
Hi,
The following case stmt is not compiling in stored proc.
select (case when 'N' in ('C','N','U','V') then 'C' else (case when
'N' = 'P' then 'P'
end) end)
into l_ln_status
from dual;
I get the following error :
PLS-00103: Encountered the symbol CASE when expecting one of the
following:
( - + mod not null others an identifier
a double-quoted delimited-identifier a bind variable avg
count cur
the same sql runs at sqlprompt.
Thanks
Manoj.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Larry Elkins
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from 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: I/O contention with external process reading the oracle logs (online redo logs)
Title: RE: I/O contention with external process reading the oracle logs (online redo logs) My experience is that they do nothing for free. -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Tim Gorman [EMAIL PROTECTED] Sent: Thursday, June 13, 2002 9:23 PM To: Multiple recipients of list ORACLE-L Subject: Re: I/O contention with external process reading the oracle logs (online redo logs) It shouldn't need to be a theoretical or statistical claim at all. A prospective customer should be able to ship a few archived redo log files (the more the better!) to Quest and have them run it through that part of SharePlex that will read the redo and produce SQL. I'm surprised they haven't suggested it already... :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: SunOS 5.8 I/O buffer size?
On 2.7 0.8128 read(3, \0\0\0\0\0\002\0\0\0F0\0.., 10485760) = 10485760 0.1003 write(4, \0\0\0\0\0\002\0\0\0F0\0.., 10485760) = 10485760 0.7603 read(3, \0\00386\0\0 P\01BAFD0FA.., 10485760) = 10485760 0.1039 write(4, \0\00386\0\0 P\01BAFD0FA.., 10485760) = 10485760 1.0187 read(3, \0\00386\0\0A0\01BAFF486.., 10485760) = 10485760 0.1074 write(4, \0\00386\0\0A0\01BAFF486.., 10485760) = 10485760 But isn't this a moot point - I'm pretty sure SSTIOMAX is fixed at 1M for all 'current' Oracle versions Cheers Connor --- Tim Gorman [EMAIL PROTECTED] wrote: Carmen et al, Did some testing on this. On solaris 2.8 there doesn't seem to be any upper-limit on single, atomic disk I/O, probably because someone finally got smart and started allocating memory buffers for I/O dynamically using the malloc() package instead of hard-coding a fixed-length variable as a buffer. At least, they did so for the dd command... Ran the following, reading three 1024Kb chunks from a large file while trussing the UNIX dd command: $ truss -D dd if=/d01001/oradata/portal/portal_01.dbf of=/dev/null bs=1024k count=3 0. execve(/usr/bin/dd, 0xFFBEFC8C, 0xFFBEFCA4) argc = 5 0.0036 mmap(0x, 8192, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_ANON, -1, 0) = 0xFF3A 0.0005 resolvepath(/usr/lib/ld.so.1, /usr/lib/ld.so.1, 1023) = 16 0.0006 open(/var/ld/ld.config, O_RDONLY) Err#2 ENOENT 0.0004 open(/usr/lib/libc.so.1, O_RDONLY) = 3 0.0003 fstat(3, 0xFFBEF3C4) = 0 0.0002 mmap(0x, 8192, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0xFF39 0.0003 mmap(0x, 794624, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0xFF28 0.0004 mmap(0xFF33A000, 24784, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_FIXED, 3, 696320) = 0xFF33A000 0.0005 munmap(0xFF32A000, 65536) = 0 0.0007 memcntl(0xFF28, 113272, MC_ADVISE, MADV_WILLNEED, 0, 0) = 0 0.0003 close(3) = 0 0.0003 open(/usr/lib/libdl.so.1, O_RDONLY) = 3 0.0003 fstat(3, 0xFFBEF3C4) = 0 0.0003 mmap(0xFF39, 8192, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED, 3, 0) = 0xFF39 0.0004 close(3) = 0 0.0004 open(/usr/platform/SUNW,Ultra-5_10/lib/libc_psr.so.1, O_RDONLY) = 3 0.0004 fstat(3, 0xFFBEF254) = 0 0.0003 mmap(0x, 8192, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0xFF38 0.0003 mmap(0x, 16384, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0xFF37 0.0004 close(3) = 0 0.0015 munmap(0xFF38, 8192) = 0 0.0009 brk(0x00023F68) = 0 0.0003 brk(0x00025F68) = 0 0.0005 open64(/d01001/oradata/portal/portal_01.dbf, O_RDONLY) = 3 0.0004 creat64(/dev/null, 0666) = 4 0.0004 sysconfig(_CONFIG_PAGESIZE) = 8192 0.0003 brk(0x00025F68) = 0 0.0002 brk(0x00127F68) = 0 0.0004 sigaction(SIGINT, 0xFFBEFA70, 0xFFBEFAF0) = 0 0.0002 sigaction(SIGINT, 0xFFBEFA70, 0xFFBEFAF0) = 0 0.0985 read(3, \0\0\0\0\0\0 \0\0\0 }80.., 1048576) = 1048576 0.0005 write(4, \0\0\0\0\0\0 \0\0\0 }80.., 1048576) = 1048576 0.0777 read(3, \002\0\0\0\0\080\0\0\0\0.., 1048576) = 1048576 0.0005 write(4, \002\0\0\0\0\080\0\0\0\0.., 1048576) = 1048576 0.0744 read(3, 0602\0\0028001\0\003 s.., 1048576) = 1048576 0.0004 write(4, 0602\0\0028001\0\003 s.., 1048576) = 1048576 0.0004 close(4) = 0 0.0003 close(1) = 0 3+0 0.0006 write(2, 3 + 0, 3) = 3 records in 0.0004 write(2,r e c o r d s i n\n, 12) = 12 3+0 0.0006 write(2, 3 + 0, 3) = 3 records out 0.0003 write(2,r e c o r d s o u t.., 13) = 13 0.0006 llseek(0, 0, SEEK_CUR) = 37672 0.0002 _exit(0) Note that each of the three read() and write() calls use 1048576 bytes (i.e. 1024 Kbytes) apiece. Please also note the two brk() calls, which allocate more memory to the process heap from the O/S, probably through the malloc() package. Last, please note the elapsed time (i.e. -D option on truss) for the three read() calls are 0.0985, 0.0777, and 0.0744 seconds respectively. Next, I tried making the requested read size 10x bigger... $ truss -D dd if=/d01001/oradata/portal/portal_01.dbf of=/dev/null bs=10240k count=3 0. execve(/usr/bin/dd, 0xFFBEFC8C, 0xFFBEFCA4) argc = 5 ... 0.8446 read(3, \0\0\0\0\0\0 \0\0\0 }80.., 10485760) = 10485760 0.0006 write(4, \0\0\0\0\0\0 \0\0\0 }80.., 10485760) = 10485760 0.8052 read(3,
Re: Installing Oracle 9i Developper suite
Stephane, This deals with Section 508 of the Rehabilitation Act. The following link gives additional info, should anyone have an interest http://www.access-board.gov/508.htm Hope this helps Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Case stmt not compiling
or wrap it within execute immediate hth connor --- Ganesh Raja [EMAIL PROTECTED] wrote: This is due to the difference betweeen the PL/SQL Compiler and SQL Compiler. This has been rectified from 9i onwards One way to achive this is to Create a view and access this View in Pl/sql. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- [EMAIL PROTECTED] Sent: Friday, June 14, 2002 10:03 AM To: Multiple recipients of list ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ganesh Raja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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 http://www.oracledba.co.uk http://www.oaktable.net Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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).
Capacity Planning
Good morning, I am trying determine whether a proposed 8-way Intel (Unisys ES7000) system running Windows 2000 will support our anticipated work load. I know this question has a LOT of variables but I don't even have a feel for some of the numbers. Two things: One - just to get an idea of the scale of things, is 300 concurrent users a 'lot' on such a system? Like I said, I KNOW there are many other variables - specifically, what the users are doing at the time, tunning, ... but I am wondering (assuming well written queries, apps, database design, ...) if this number is in the range of 'THIS SYSTEM IS OVERKILL' 'PROBABLY OK' 'HMM BETTER LOOK OUT' 'YOU ARE INSANE AND WILL BE JOB HUNTING SOON' Does anyone have a similar system running with say ... 1000 concurrent users? 100? 5000??? Two - Can anyone point me to resources (other than the vendors) that might help. I don't know why I have such distrust for someone who wants my money. Thanks, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bond Mike A Contr OC-ALC/TILC INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: set sort_area_size, sort_retained_size,hash_area_size but sti
Title: RE: set sort_area_size, sort_retained_size,hash_area_size but sti Sorry the OS is Solaris 2.8 the database version 8.1.7.2 -Original Message- From: Reardon, Bruce (CALBBAY) [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 9:03 PM To: Multiple recipients of list ORACLE-L Subject: RE: set sort_area_size, sort_retained_size,hash_area_size but sti Paula, and what OS / database version? eg if Windows is the server setup to use all 16 Gb of memory? Bruce Reardon -Original Message- Sent: Friday, 14 June 2002 2:29 Paula, what is the size of your hash_area_size, sort_area_size, and sort_area_retained_size? what does your explain plan look like? hashes, sort/merge, or nested loops? do you have a lot of parallel to parallel, parallel to serial in your plans? jack silvey --- [EMAIL PROTECTED] wrote: Have 12Gb RAM available , using parallel query with large mv joined to small code tables and setting session parameters to use Gb's of memory (have system to myself at the time) but system shows 12Gb RAM available still and writing to temporary segment - why or why or why? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from 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: Locally Managed Tablespaces
One can 'plug' in a DMT via TTS. but can not make it writable... ;) - Kirti -Original Message- Sent: Thursday, June 13, 2002 12:39 PM To: Multiple recipients of list ORACLE-L I would treat dmt's as obsolete. (In 9.2, all tablespaces default to locally managed, and furthermore, if you create system as lmt in 9.2, all subsequent tablespaces must also be lmt).. I would not be surprised to see dmt's disappear altogether at some stage in future. hth connor --- [EMAIL PROTECTED] wrote: Hi All, I am setting up a 9i instance and am wondering if there are any tablespaces that you would not set up as locally managed. Would system and rollback tablespaces be set up as dictionary managed or locally managed? Are there any guidelines when considering lmt or dmt? Thanks, Michele Armstrong -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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).
Stop Store proc from running
BDY.RTF Description: RTF file
Re: I/O contention with external process reading the oracle logs (online redo logs)
Title: RE: I/O contention with external process reading the oracle logs (online redo logs) who does? :-) - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Friday, June 14, 2002 6:28 AM Subject: RE: I/O contention with external process reading the oracle logs (online redo logs) My experience is that they do nothing for free. -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of "Tim Gorman" [EMAIL PROTECTED] Sent: Thursday, June 13, 2002 9:23 PM To: Multiple recipients of list ORACLE-L Subject: Re: I/O contention with external process reading the oracle logs (online redo logs) It shouldn't need to be a "theoretical" or "statistical" claim at all. A prospective customer should be able to ship a few archived redo log files (the more the better!) to Quest and have them run it through that part of SharePlex that will read the redo and produce SQL. I'm surprised they haven't suggested it already... :-)-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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: SunOS 5.8 I/O buffer size?
Live and learn! I'd never heard of SSTIOMAX, but there's a decent MetaLink article on it (#131530.1)... I tried using nm and strings on the oracle executable and many of the .a and .so objects and couldn't find it mentioned, so it must be a #define compiler directive in the source code or something. One of the MetaLink forums stated that it is set: 7.3.x -- SSTIOMAX = 128K 8.0.3 -- SSTIOMAX = 512K 8.0.4 -- SSTIOMAX = 1M Thanks Connor! - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 14, 2002 7:13 AM On 2.7 0.8128 read(3, \0\0\0\0\0\002\0\0\0F0\0.., 10485760) = 10485760 0.1003 write(4, \0\0\0\0\0\002\0\0\0F0\0.., 10485760) = 10485760 0.7603 read(3, \0\00386\0\0 P\01BAFD0FA.., 10485760) = 10485760 0.1039 write(4, \0\00386\0\0 P\01BAFD0FA.., 10485760) = 10485760 1.0187 read(3, \0\00386\0\0A0\01BAFF486.., 10485760) = 10485760 0.1074 write(4, \0\00386\0\0A0\01BAFF486.., 10485760) = 10485760 But isn't this a moot point - I'm pretty sure SSTIOMAX is fixed at 1M for all 'current' Oracle versions Cheers Connor --- Tim Gorman [EMAIL PROTECTED] wrote: Carmen et al, Did some testing on this. On solaris 2.8 there doesn't seem to be any upper-limit on single, atomic disk I/O, probably because someone finally got smart and started allocating memory buffers for I/O dynamically using the malloc() package instead of hard-coding a fixed-length variable as a buffer. At least, they did so for the dd command... Ran the following, reading three 1024Kb chunks from a large file while trussing the UNIX dd command: $ truss -D dd if=/d01001/oradata/portal/portal_01.dbf of=/dev/null bs=1024k count=3 0. execve(/usr/bin/dd, 0xFFBEFC8C, 0xFFBEFCA4) argc = 5 0.0036 mmap(0x, 8192, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_ANON, -1, 0) = 0xFF3A 0.0005 resolvepath(/usr/lib/ld.so.1, /usr/lib/ld.so.1, 1023) = 16 0.0006 open(/var/ld/ld.config, O_RDONLY) Err#2 ENOENT 0.0004 open(/usr/lib/libc.so.1, O_RDONLY) = 3 0.0003 fstat(3, 0xFFBEF3C4) = 0 0.0002 mmap(0x, 8192, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0xFF39 0.0003 mmap(0x, 794624, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0xFF28 0.0004 mmap(0xFF33A000, 24784, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_FIXED, 3, 696320) = 0xFF33A000 0.0005 munmap(0xFF32A000, 65536) = 0 0.0007 memcntl(0xFF28, 113272, MC_ADVISE, MADV_WILLNEED, 0, 0) = 0 0.0003 close(3) = 0 0.0003 open(/usr/lib/libdl.so.1, O_RDONLY) = 3 0.0003 fstat(3, 0xFFBEF3C4) = 0 0.0003 mmap(0xFF39, 8192, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED, 3, 0) = 0xFF39 0.0004 close(3) = 0 0.0004 open(/usr/platform/SUNW,Ultra-5_10/lib/libc_psr.so.1, O_RDONLY) = 3 0.0004 fstat(3, 0xFFBEF254) = 0 0.0003 mmap(0x, 8192, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0xFF38 0.0003 mmap(0x, 16384, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0xFF37 0.0004 close(3) = 0 0.0015 munmap(0xFF38, 8192) = 0 0.0009 brk(0x00023F68) = 0 0.0003 brk(0x00025F68) = 0 0.0005 open64(/d01001/oradata/portal/portal_01.dbf, O_RDONLY) = 3 0.0004 creat64(/dev/null, 0666) = 4 0.0004 sysconfig(_CONFIG_PAGESIZE) = 8192 0.0003 brk(0x00025F68) = 0 0.0002 brk(0x00127F68) = 0 0.0004 sigaction(SIGINT, 0xFFBEFA70, 0xFFBEFAF0) = 0 0.0002 sigaction(SIGINT, 0xFFBEFA70, 0xFFBEFAF0) = 0 0.0985 read(3, \0\0\0\0\0\0 \0\0\0 }80.., 1048576) = 1048576 0.0005 write(4, \0\0\0\0\0\0 \0\0\0 }80.., 1048576) = 1048576 0.0777 read(3, \002\0\0\0\0\080\0\0\0\0.., 1048576) = 1048576 0.0005 write(4, \002\0\0\0\0\080\0\0\0\0.., 1048576) = 1048576 0.0744 read(3, 0602\0\0028001\0\003 s.., 1048576) = 1048576 0.0004 write(4, 0602\0\0028001\0\003 s.., 1048576) = 1048576 0.0004 close(4) = 0 0.0003 close(1) = 0 3+0 0.0006 write(2, 3 + 0, 3) = 3 records in 0.0004 write(2,r e c o r d s i n\n, 12) = 12 3+0 0.0006 write(2, 3 + 0, 3) = 3 records out 0.0003 write(2,r e c o r d s o u t.., 13) = 13 0.0006 llseek(0, 0, SEEK_CUR) = 37672 0.0002 _exit(0) Note that each of the three read() and write() calls use 1048576 bytes (i.e. 1024 Kbytes) apiece. Please also note the two brk() calls, which allocate more memory to the process heap from the O/S, probably through the malloc() package. Last, please note the elapsed time (i.e. -D option on truss) for the three read() calls are 0.0985, 0.0777, and 0.0744 seconds respectively. Next, I tried making the requested read size 10x bigger... $ truss -D dd if=/d01001/oradata/portal/portal_01.dbf of=/dev/null bs=10240k count=3 0.
Re: change Language on server after Oracle install
John, I think you're confusing characterset with language; you can pack a lot of languages into the WE8ISO8859P1 or P15 charactersets! I think the P15 is new for including the euro character, by the way...? Look in the view NLS_INSTANCE_PARAMETERS for a list of the configurable NLS initialization parameter settings that are current. The view NLS_DATABASE_SETTINGS is a little more extensive, including settings such as CHARACTERSET which are set using CREATE/ALTER DATABASE in addition to those configurable by initialization parameters (shown in NLS_INSTANCE_PARAMETERS)... All of the NLS parameters in NLS_INSTANCE_PARAMETERS can be changed with ALTER SESSION for testing, but they can't be changed globally using ALTER SYSTEM; requires the instance to be bounced. Most Oracle releases have a separate NLS reference manual (http://docs.oracle.com) for more info... Hope this helps... -Tim - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 14, 2002 3:38 AM We have a AIX server with Oracle 8.1.7 installed. The language is set to ISO8859-1 English US. We want to change the language to French for testing purposes. Do we need to re-install Oracle? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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).
Replication question
We are just starting to look at replication so each manufacturing plant can have their own server. The applications are being developed in-house. I feel the first issue is to analyze each table and decide how it will be replicated and what schema changes need to me made to accommodate replication. Instead, one of the developers wants to talk to Quest about their solution. It seems to me that you need to make the same evaluation and schema changes where needed. If anyone can point me to a white paper on schema changes to consider, that would be appreciated. Dennis Williams DBA, 20% OCP Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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).
two different 9i install problems!
Installing 9i (9.2.0.1.0) for the first time on a Win2K server and on my Win2K pro client SERVER ISSUE: standard install- enterprise edition - standard starter datababse - software appears to install and then config tools launch net config assistant complets dbca has now been running for about 18 hours - says in progress and an empty sqlplus command window is also open I see all the datafiles got created, and task manager shows varying CPU utilization between 20 and 50%, most of which is the System Idle process and my pcAnywhere connection . . appears hung! CLIENT ISSUE installing client only into a separate Oracle Home (already have an 8.1.7 client on my box). install appears to complete, but near the end I get a Windows File Protection box that says: Files that are required to run windows have been replace by unrecognized versions. To maintain system stability Windows must restore the original versions of these files. Then get prompted to insert my original Windows CD any and all help appreciated thanks bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: Cannot connect to DB error
Joe: Good question. I checked services and it was not running. So I started it. But I still get these errors. PARTS database - ORA-12541: TNS: no listener KEN database - ORA-12154: TNS: could not resolve service name. Any idea what the problem is? Thanks, Ken - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 13, 2002 8:03 PM ok i'll ask the obvious, is the listener running? if so you better go and catch it. joe KENNETH JANUSZ wrote: I have installed 9.0.1 on my Dell PC with XP Prof. When I installed it I installed the demo DB and everything worked fine. Now I have installed a second DB and I cannot connect. I made changes to listener.ora and tnsnames.ora as recommended by others on this list. I also added the IP addresses to the HOSTS file as such: 127.0.0.1localhost (original entry) 127.0.0.1DC0X4411 (Oracle generated name for KEN db manually added) 127.0.0.1PARTS (new DB name manually added) Here is what I get when I try to connect. KEN database - Oracle generated name is DC0X4411 ORA-12154: TNS: could not resolve service name PARTS database ORA-12541: TNS: no listener Any help I can get to solve this problem will be greatly appreciated. Thanks much, Ken Janusz, CPIM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: sequence question
Bigp Remember that when you issue sequence.nextval you are incrementing one value and eitheryour process function corrector not that number is used. But, the more important is that if your system crash or you issue an SHUTDOWN ABORT you will loose the sequence numbers cached. Also you can loose numbers after an Import / Export. Luck, Ramon - Original Message - From: BigP To: Multiple recipients of list ORACLE-L Sent: Thursday, June 13, 2002 8:23 PM Subject: sequence question Hi List , I want to create a sequence which will be used by some external process to generate some unique number . since this sequence will be used very frequently I would prefer to cache around 1 numbers . Am I going to loose some numbers ? what is SEQUENCE_CACHE_ENTRIES and how does it affect number or sequence cached ? Thanks , -Bp
RE: 9i R2 not automatically starting up after upgrade
I tried that...didn't fix the problem. The service actually starts without any problems, but for some reason, starting the service doesn't actually start the database. I have to actually login to SQL*Plus in /nolog mode, connect / as sysdba and then do a startup manually to get the database running. Thanks though. _YEX_ ))) -Original Message- Sent: Friday, June 14, 2002 3:38 AM To: Multiple recipients of list ORACLE-L Are you using a domain to connect to your PC. You should go into services and OracleServiceSID --- Properties. In the Log On tab go and choose log on as this account and choose your username and password that you are connecting to the domain. Stop and restart the service, and check that the memory is reserved for the instance. Regards Theodoros -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 8:22 PM To: Multiple recipients of list ORACLE-L I upgraded a database yesterday from 9i R1 (9.0.1) to 9i R2 (9.2.0.1.0), and am now having problems with the database starting up automatically on system reboot. This is on a Windows 2000 Pro machine. The error that I get when I try to connect with SQL*Plus is ORA-27101: shared memory realm does not exist. If I run SQL*Plus with the /nolog option, connect / as sysdba, and startup manually, everything works fine. Anyone have any idea why it won't startup automatically, or what I could try to get it to? Thanks. _YEX_ /* || Robert D. Yexley || Oracle Programmer/Analyst || Easylink Services Corporation || Professional Services || Contractor - Wright Research Site MIS || Det-1 AFRL/WSI Bldg. 45 Rm. 062 || (937) 255-1984 || [EMAIL PROTECTED] || ))) */ Robert D. Yexley (E-mail).vcf -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Theodoros Demosthenous INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: Yexley Robert D Contr Det 1 AFRL/WSI INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: I/O contention with external process reading the oracle logs (online redo logs)
Title: RE: I/O contention with external process reading the oracle logs (online redo logs) Quest. -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Tim Gorman [EMAIL PROTECTED] Sent: Friday, June 14, 2002 10:38 AM To: Multiple recipients of list ORACLE-L Subject: Re: I/O contention with external process reading the oracle logs (online redo logs) who does? :-) - Original Message - From: [EMAIL PROTECTED] File: mailto:[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L File: mailto:[EMAIL PROTECTED] Sent: Friday, June 14, 2002 6:28 AM Subject: RE: I/O contention with external process reading the oracle logs (online redo logs) My experience is that they do nothing for free. -Original Message- From: [EMAIL PROTECTED]@SUNGARD File: mailto:[EMAIL PROTECTED]@SUNGARD On Behalf Of Tim Gorman [EMAIL PROTECTED] File: mailto:[EMAIL PROTECTED] Sent: Thursday, June 13, 2002 9:23 PM To: Multiple recipients of list ORACLE-L Subject: Re: I/O contention with external process reading the oracle logs (online redo logs) It shouldn't need to be a theoretical or statistical claim at all. A prospective customer should be able to ship a few archived redo log files (the more the better!) to Quest and have them run it through that part of SharePlex that will read the redo and produce SQL. I'm surprised they haven't suggested it already... :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: SunOS 5.8 I/O buffer size?
Hey Tim! That /dev/null device is really fast! Solaris wrote 10 megabytes to it in 0.5 seconds. Where can I get one of those? Jared ;) On Thursday 13 June 2002 19:13, Tim Gorman wrote: Carmen et al, Did some testing on this. On solaris 2.8 there doesn't seem to be any upper-limit on single, atomic disk I/O, probably because someone finally got smart and started allocating memory buffers for I/O dynamically using the malloc() package instead of hard-coding a fixed-length variable as a buffer. At least, they did so for the dd command... Ran the following, reading three 1024Kb chunks from a large file while trussing the UNIX dd command: $ truss -D dd if=/d01001/oradata/portal/portal_01.dbf of=/dev/null bs=1024k count=3 0. execve(/usr/bin/dd, 0xFFBEFC8C, 0xFFBEFCA4) argc = 5 0.0036 mmap(0x, 8192, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_ANON, -1, 0) = 0xFF3A 0.0005 resolvepath(/usr/lib/ld.so.1, /usr/lib/ld.so.1, 1023) = 16 0.0006 open(/var/ld/ld.config, O_RDONLY) Err#2 ENOENT 0.0004 open(/usr/lib/libc.so.1, O_RDONLY)= 3 0.0003 fstat(3, 0xFFBEF3C4)= 0 0.0002 mmap(0x, 8192, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0xFF39 0.0003 mmap(0x, 794624, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0xFF28 0.0004 mmap(0xFF33A000, 24784, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_FIXED, 3, 696320) = 0xFF33A000 0.0005 munmap(0xFF32A000, 65536) = 0 0.0007 memcntl(0xFF28, 113272, MC_ADVISE, MADV_WILLNEED, 0, 0) = 0 0.0003 close(3)= 0 0.0003 open(/usr/lib/libdl.so.1, O_RDONLY) = 3 0.0003 fstat(3, 0xFFBEF3C4)= 0 0.0003 mmap(0xFF39, 8192, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED, 3, 0) = 0xFF39 0.0004 close(3)= 0 0.0004 open(/usr/platform/SUNW,Ultra-5_10/lib/libc_psr.so.1, O_RDONLY) = 3 0.0004 fstat(3, 0xFFBEF254)= 0 0.0003 mmap(0x, 8192, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0xFF38 0.0003 mmap(0x, 16384, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0xFF37 0.0004 close(3)= 0 0.0015 munmap(0xFF38, 8192)= 0 0.0009 brk(0x00023F68) = 0 0.0003 brk(0x00025F68) = 0 0.0005 open64(/d01001/oradata/portal/portal_01.dbf, O_RDONLY) = 3 0.0004 creat64(/dev/null, 0666) = 4 0.0004 sysconfig(_CONFIG_PAGESIZE) = 8192 0.0003 brk(0x00025F68) = 0 0.0002 brk(0x00127F68) = 0 0.0004 sigaction(SIGINT, 0xFFBEFA70, 0xFFBEFAF0) = 0 0.0002 sigaction(SIGINT, 0xFFBEFA70, 0xFFBEFAF0) = 0 0.0985 read(3, \0\0\0\0\0\0 \0\0\0 }80.., 1048576) = 1048576 0.0005 write(4, \0\0\0\0\0\0 \0\0\0 }80.., 1048576) = 1048576 0.0777 read(3, \002\0\0\0\0\080\0\0\0\0.., 1048576) = 1048576 0.0005 write(4, \002\0\0\0\0\080\0\0\0\0.., 1048576) = 1048576 0.0744 read(3, 0602\0\0028001\0\003 s.., 1048576) = 1048576 0.0004 write(4, 0602\0\0028001\0\003 s.., 1048576) = 1048576 0.0004 close(4)= 0 0.0003 close(1)= 0 3+0 0.0006 write(2, 3 + 0, 3) = 3 records in 0.0004 write(2,r e c o r d s i n\n, 12)= 12 3+0 0.0006 write(2, 3 + 0, 3) = 3 records out 0.0003 write(2,r e c o r d s o u t.., 13) = 13 0.0006 llseek(0, 0, SEEK_CUR) = 37672 0.0002 _exit(0) Note that each of the three read() and write() calls use 1048576 bytes (i.e. 1024 Kbytes) apiece. Please also note the two brk() calls, which allocate more memory to the process heap from the O/S, probably through the malloc() package. Last, please note the elapsed time (i.e. -D option on truss) for the three read() calls are 0.0985, 0.0777, and 0.0744 seconds respectively. Next, I tried making the requested read size 10x bigger... $ truss -D dd if=/d01001/oradata/portal/portal_01.dbf of=/dev/null bs=10240k count=3 0. execve(/usr/bin/dd, 0xFFBEFC8C, 0xFFBEFCA4) argc = 5 ... 0.8446 read(3, \0\0\0\0\0\0 \0\0\0 }80.., 10485760) = 10485760 0.0006 write(4, \0\0\0\0\0\0 \0\0\0 }80.., 10485760) = 10485760 0.8052 read(3, 0602\0\0028005\0\0\f R c.., 10485760) = 10485760 0.0006 write(4, 0602\0\0028005\0\0\f R c.., 10485760) = 10485760 0.7454 read(3, \002\0\0\0\0\n\0\0\0\0\0.., 10485760) = 10485760 0.0006 write(4, \002\0\0\0\0\n\0\0\0\0\0.., 10485760) = 10485760 ... Please note that the third argument to the read() and write() calls is now 10 Mbytes (i.e. 10,485,760 bytes) and that the elapsed time for the three calls are now about 10x
RE: I/O contention with external process reading the oracle logs
I feel compelled to respond. There are many fine consultants that take time to respond on this list with free advice. I could name a few names, but I'd slight someone, so I'll just say that you know who you are and your efforts are GREATLY appreciated. Say Tim, wouldn't you fall within that category? Or maybe Jared is slipping a few bucks on the side ;-) Dennis Williams DBA, 20% OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, June 14, 2002 9:38 AM To: Multiple recipients of list ORACLE-L (online redo logs) who does? :-) - Original Message - To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] Sent: Friday, June 14, 2002 6:28 AM (online redo logs) My experience is that they do nothing for free. -Original Message- Behalf Of Tim Gorman [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Sent: Thursday, June 13, 2002 9:23 PM To: Multiple recipients of list ORACLE-L logs (online redo logs) It shouldn't need to be a theoretical or statistical claim at all. A prospective customer should be able to ship a few archived redo log files (the more the better!) to Quest and have them run it through that part of SharePlex that will read the redo and produce SQL. I'm surprised they haven't suggested it already... :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: sequence question
what do you mean about losing numbers after an import/export? -Original Message-From: Ramon E. Estevez [mailto:[EMAIL PROTECTED]]Sent: Friday, June 14, 2002 10:44 AMTo: Multiple recipients of list ORACLE-LSubject: Re: sequence question Bigp Remember that when you issue sequence.nextval you are incrementing one value and eitheryour process function corrector not that number is used. But, the more important is that if your system crash or you issue an SHUTDOWN ABORT you will loose the sequence numbers cached. Also you can loose numbers after an Import / Export. Luck, Ramon - Original Message - From: BigP To: Multiple recipients of list ORACLE-L Sent: Thursday, June 13, 2002 8:23 PM Subject: sequence question Hi List , I want to create a sequence which will be used by some external process to generate some unique number . since this sequence will be used very frequently I would prefer to cache around 1 numbers . Am I going to loose some numbers ? what is SEQUENCE_CACHE_ENTRIES and how does it affect number or sequence cached ? Thanks , -Bp
Re: Memory utilization
Hi Tim, FF21 8K read/write/exec [ anon ] FF34 8K read/write/exec/shared [ anon ] FF3A 8K read/write/exec [ anon ] I don't know what anon means, but let's assume that it is also private to this specific process, The anon refers to anonymous pages that are mapped to /dev/zero by calling mmap() which is a bunch of zeroes and not mapped from a file. It can be shared between processes with common ancestors as it does not have data as such and just zeroes, but processes having access to a single mapping of /dev/zero can share this memory region. In the above case, we have a 8K that is shared and the 16K that is private to this process. I am sure I will be corrected if I am wrong :-) Hope this helps. Regards, Madhavan -- Madhavan Amruthur DecisionPoint Applications -- http://fastmail.fm - You've just been FastMailed! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Madhavan Amruthur INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: Stop Store proc from running
In Oracle, find the sid and serial# of the session and do an alter system kill session command. That will kill it. It might take awhile to kill, depending on how much rollback it has to do. [EMAIL PROTECTED] wrote: Hi, I want to immediately stop a running stored proc.I tried kill -9 pid . It shows killed. But procedure is still continuing.. Thanks Manoj -- 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: Wait event problems
Well, with all the caveats that's a long and boring story, so I'll shorten it up. ;) 1) SDU/TDU values of 32768, as were specified by our 3rd-party vendor in their extremely non-OFA f'd-up install, are not valid. 2) Specifying SDU/TDU in TNSNAMES.ORA (or ONAMES) is useless unless it's corresponding value is also in the server's LISTENER.ORA. If you don't specify the value in LISTENER.ORA, you will be using the default SDU value of 2048. 3) Specifying SDU/TDU in a LISTENER.ORA will not work out-of-the-box in 8i. I've verified this thru a client trace. Apparently, in 8i, the automatic registry of an instance to the listener will overwrite any SDU/TDU values specified in the LISTENER.ORA. The workaround to override the auto registry, you must declare a bogus SERVICE_NAMES and LOCAL_LISTENER in the DB's init.ora and restart the instance. 4) What value to set SDU? Test! On a TEST client set an SDU value in the TNSNAMES.ORA (see Oracle docs for how/where). Then, set the following in the client's SQLNET.ORA: TRACE_LEVEL_CLIENT = SUPPORT TRACE_FILE_CLIENT = sqlnet TRACE_DIRECTORY_CLIENT = /some/directory TRACE_UNIQUE_CLIENT = on 4a) If you aren't using TNSNAMES, make sure your NAMES.DIRECTORY_PATH in the SQLNET.ORA starts with TNSNAMES. 5) Connect a test client. Do some work from this client, preferrably as close to a real user as possible. Note that the tracefile created will contain every bit from every packet sent to and from the client, as well as all the overhead involved for debugging, so the file can grow large quick. It only less than 5 minutes of testing to produce a 55MB trace file for us. 6) Disconnect the test client. Before running trcasst, you'll need to edit the trace file in order to workaround a bug in trcasst. If you're Unix-y, you can use this instead of trying to pull 50+MB into mem (VERY crude SED -- there's a much more elegant way of doing this!): mv sqlnet_.trc t.t sed -e 's/nspsend: /nspsend:/g' t.t t.tt rm t.t sed -e 's/nsprecv: /nsprecv:/g' t.tt t.t rm t.tt sed -e 's/nsprcvs: /nsprcvs:/g' t.t t.tt rm t.t rm sqlnet_.trc mv t.tt sqlnet_.trc The rms are in there to reduce the amount of disk needed. PLEASE adjust for your own environment! If you're using Winders, get CygWin to use sed (or use any of a number of tools for search/replace). 7) trcasst -od sqlnet_.trc sqlnet_.lis 8) Examine the .lis file for send/receive packet sizes. I dumped the output from a grep of the .lis file to MS Exhell to graph the send and recieve packets. It's easier for me to see the need for a larger SDU when the graph shows a nice square wave pattern. The theory being that if SQL*Net is pushing the maximum SDU size several packets in a row (a nice, flat horizontal line at the top of the graph), that the SDU could stand to be larger so as to minimize the length of that line. 9) Repeat steps 5 thru 8 with different values of SDU, remembering to change both the client and the server, and to restart the listener after each change. Anyone care to comment on this? This is pretty much just what I figured out yesterday, so I'm interested to know of any whoopses I may have made. One thing I'm not sure of is How big is too big for an SDU value?. HTH! GL! Happy Flag Day! :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Seefelt, Beth [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 7:28 PM To: Multiple recipients of list ORACLE-L Subject: RE: Wait event problems Hi Rich, I'm curious, what value did you decide on for SDU? Let us know how it works out. Thanks, Beth -Original Message- Sent: Thursday, June 13, 2002 1:39 PM To: Multiple recipients of list ORACLE-L Hi Lee, I'm investigating a very similar problem on 8.1.6.0.0 on Solaris. So far, I've found out that the 3rd-party vendor who setup this debacle had inserted invalid values for SDU/TDU in tnsnames.ora on the client and listener.ora on the server. I'm correcting them now as we speak. (Incidentally, Oracle recommends NOT modifying TDU and gives no guidelines as to how to select a value.) Also, our clients are Java apps, which would be my guess as to the root of the problem. The clients just aren't fast enough to deal with the rather large overhead of Java. But I'm cautiously optimistic on the SDU/TDU fix... And www.fatcity.com doesn't want to respond, so we'll have to wait a bit to search the archives. GL! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Thursday, June 13, 2002 10:23 AM To: Multiple recipients of list ORACLE-L All, Oracle 8.0.5.0.0 Tru64 v4.0f We are running a job and statspack reports show that our only problem (it is
RE: Wait event problems
Excellent information! Thanks for taking the time to write it all down. Beth -Original Message- Sent: Friday, June 14, 2002 10:42 AM To: '[EMAIL PROTECTED]' Cc: Seefelt, Beth Well, with all the caveats that's a long and boring story, so I'll shorten it up. ;) 1) SDU/TDU values of 32768, as were specified by our 3rd-party vendor in their extremely non-OFA f'd-up install, are not valid. 2) Specifying SDU/TDU in TNSNAMES.ORA (or ONAMES) is useless unless it's corresponding value is also in the server's LISTENER.ORA. If you don't specify the value in LISTENER.ORA, you will be using the default SDU value of 2048. 3) Specifying SDU/TDU in a LISTENER.ORA will not work out-of-the-box in 8i. I've verified this thru a client trace. Apparently, in 8i, the automatic registry of an instance to the listener will overwrite any SDU/TDU values specified in the LISTENER.ORA. The workaround to override the auto registry, you must declare a bogus SERVICE_NAMES and LOCAL_LISTENER in the DB's init.ora and restart the instance. 4) What value to set SDU? Test! On a TEST client set an SDU value in the TNSNAMES.ORA (see Oracle docs for how/where). Then, set the following in the client's SQLNET.ORA: TRACE_LEVEL_CLIENT = SUPPORT TRACE_FILE_CLIENT = sqlnet TRACE_DIRECTORY_CLIENT = /some/directory TRACE_UNIQUE_CLIENT = on 4a) If you aren't using TNSNAMES, make sure your NAMES.DIRECTORY_PATH in the SQLNET.ORA starts with TNSNAMES. 5) Connect a test client. Do some work from this client, preferrably as close to a real user as possible. Note that the tracefile created will contain every bit from every packet sent to and from the client, as well as all the overhead involved for debugging, so the file can grow large quick. It only less than 5 minutes of testing to produce a 55MB trace file for us. 6) Disconnect the test client. Before running trcasst, you'll need to edit the trace file in order to workaround a bug in trcasst. If you're Unix-y, you can use this instead of trying to pull 50+MB into mem (VERY crude SED -- there's a much more elegant way of doing this!): mv sqlnet_.trc t.t sed -e 's/nspsend: /nspsend:/g' t.t t.tt rm t.t sed -e 's/nsprecv: /nsprecv:/g' t.tt t.t rm t.tt sed -e 's/nsprcvs: /nsprcvs:/g' t.t t.tt rm t.t rm sqlnet_.trc mv t.tt sqlnet_.trc The rms are in there to reduce the amount of disk needed. PLEASE adjust for your own environment! If you're using Winders, get CygWin to use sed (or use any of a number of tools for search/replace). 7) trcasst -od sqlnet_.trc sqlnet_.lis 8) Examine the .lis file for send/receive packet sizes. I dumped the output from a grep of the .lis file to MS Exhell to graph the send and recieve packets. It's easier for me to see the need for a larger SDU when the graph shows a nice square wave pattern. The theory being that if SQL*Net is pushing the maximum SDU size several packets in a row (a nice, flat horizontal line at the top of the graph), that the SDU could stand to be larger so as to minimize the length of that line. 9) Repeat steps 5 thru 8 with different values of SDU, remembering to change both the client and the server, and to restart the listener after each change. Anyone care to comment on this? This is pretty much just what I figured out yesterday, so I'm interested to know of any whoopses I may have made. One thing I'm not sure of is How big is too big for an SDU value?. HTH! GL! Happy Flag Day! :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Seefelt, Beth [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 7:28 PM To: Multiple recipients of list ORACLE-L Subject: RE: Wait event problems Hi Rich, I'm curious, what value did you decide on for SDU? Let us know how it works out. Thanks, Beth -Original Message- Sent: Thursday, June 13, 2002 1:39 PM To: Multiple recipients of list ORACLE-L Hi Lee, I'm investigating a very similar problem on 8.1.6.0.0 on Solaris. So far, I've found out that the 3rd-party vendor who setup this debacle had inserted invalid values for SDU/TDU in tnsnames.ora on the client and listener.ora on the server. I'm correcting them now as we speak. (Incidentally, Oracle recommends NOT modifying TDU and gives no guidelines as to how to select a value.) Also, our clients are Java apps, which would be my guess as to the root of the problem. The clients just aren't fast enough to deal with the rather large overhead of Java. But I'm cautiously optimistic on the SDU/TDU fix... And www.fatcity.com doesn't want to respond, so we'll have to wait a bit to search the archives. GL! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Thursday, June 13,
RE: sys corrupted in warehouse, sev1 tar open - resolved
Bruce, Thanks for the info, it is a useful thing to remember. Now for the post-game analysis: the way we found this was that RMAN stopped functioning with a dbms_backup_restore.somethingorother must be declared because the one in the wrong schema was invalid. RMAN logs in as sys. When the oncall ran catproc again under the advice of tech support, it recreated all the stored procedures in the schema set by the alter schema. This rendered people logging in from sqlplus unable to find dbms_application_info, although the public synonym was pointing to the sys package. This was the red herring that kept throwing us off - the public synonyms were pointing to the sys objects, but the processes kept trying to go to the schema set by the login trigger. We were working under the implicit assumption (oops! Unproven Assumptions Bite DBAS, Details at 10) that the object refs in the rman and sqlplus login code were hard-coded (after all, why would you NOT hardcode the sys owner in your dd refs? not like anyone else will ever own those objects) and that somehow sys and the new schema were crossed up in the data dictionary. so, What We Learned: 1) be vewwwy careful with alter schema command, wabbit 2) apparently neither the sqlplus nor the rman code use schema prefixes in their object references. Lot of work for that little tidbit of info, I would say! ;) jack --- Reardon, Bruce (CALBBAY) [EMAIL PROTECTED] wrote: Jack, Something you may find useful if you're not already aware is the schemaname field in v$session. Compare this to username and this may help determine if set current_schema is being used. We use the set current_schema in a login trigger, though the trigger has smarts in it to only do it for application users and not for schema owners, sys, system etc. HTH, Bruce Reardon -Original Message- Sent: Thursday, 13 June 2002 4:20 To: Multiple recipients of list ORACLE-L It was the alter system set current_schema=x statement after all. I am sure that this raises some interesting questions, if only I had time to dwell on it. Just now cleaning up all the broken indexes from the loads that abended when the db went down. I love this job. Where else do you get to play at work? jack --- Jack Silvey [EMAIL PROTECTED] wrote: All, thanks for the input. Looks like someone implemented a login trigger. haven't seen the code yet, but I would venture a guess he used the unsupported alter system set current_schema=x. sometimes you live and learn, sometimes you just live! thx, jack silvey --- Hately Mike [EMAIL PROTECTED] wrote: I don't hold out much hope here Jack. It sounds like data dictionary corruption; maybe somewhere round user$(?). That's not to say the situation's irretrievable; I've seen OTS fix some bad situations in my time but I'm not sure that I'd want to keep the database even if Oracle Support can fix the problem. Regards, Mike -Original Message- Sent: 12 June 2002 14:23 To: Multiple recipients of list ORACLE-L Listers, Our warehouse now has a split personality and we have a sev1 open on it. Suspect recovery is in the cards, but want to avoid if possible. Yesterday, users unable to get to their own functions. Soon after, RMAN cannot find package dbms_backup_restore, even though it exists under sys. Oncall ran the sql script to recreate - and the pacakge was recreated under a schema called dma_rbate2. RMAN now finds the package under dma_rbate2, although it is invalid. Drop the package under dma_rbate2, and now RMAN cannot find the package any longer, although it still exists under sys. Logged in as sys. Tried to desc dbms_backup_restore - no luck. Tried to desc sys.dbms_backup_restore - success. Analyst reccomends running catalog.sql. Oncall does so, and it creates as many packages as it is able under dma_rbate2. I get up this AM and can't login, because the sessions can't find the package dma_rbate2.dbms_application_info. Anyone? Buhler? Buhler? thx, jack -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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
RE: I/O contention with external process reading the oracle logs
I'd say any company ... but there is an exception ... you pay exorbitant licensing fees for MS and Oracle software, but you get software for the money and bugs for free -- (on the lines of Money for nothing and the ... ) Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- [EMAIL PROTECTED] Sent: Friday, June 14, 2002 10:38 AM To: Multiple recipients of list ORACLE-L logs (online redo logs) who does? :-) - Original Message - To: Multiple recipients of list ORACLE-L File: mailto:[EMAIL PROTECTED] Sent: Friday, June 14, 2002 6:28 AM (online redo logs) My experience is that they do nothing for free. *2 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. *2
RE: 9i R2 not automatically starting up after upgrade
The parameter to look in the registry is ORA_ORA9I_PFILE and points to the parameter file. Make sure that it is located there. Regards -Original Message- Sent: Friday, June 14, 2002 6:16 PM To: '[EMAIL PROTECTED]' Check whether the service finds your initsid.ora file. The parameter in the registry might point to a different location for the service. You can find the parameter file and copy paste it to the location that the service is looking for it. I hope that this will help. Regards Theodoros -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 5:44 PM To: Multiple recipients of list ORACLE-L I tried that...didn't fix the problem. The service actually starts without any problems, but for some reason, starting the service doesn't actually start the database. I have to actually login to SQL*Plus in /nolog mode, connect / as sysdba and then do a startup manually to get the database running. Thanks though. _YEX_ ))) -Original Message- Sent: Friday, June 14, 2002 3:38 AM To: Multiple recipients of list ORACLE-L Are you using a domain to connect to your PC. You should go into services and OracleServiceSID --- Properties. In the Log On tab go and choose log on as this account and choose your username and password that you are connecting to the domain. Stop and restart the service, and check that the memory is reserved for the instance. Regards Theodoros -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 8:22 PM To: Multiple recipients of list ORACLE-L I upgraded a database yesterday from 9i R1 (9.0.1) to 9i R2 (9.2.0.1.0), and am now having problems with the database starting up automatically on system reboot. This is on a Windows 2000 Pro machine. The error that I get when I try to connect with SQL*Plus is ORA-27101: shared memory realm does not exist. If I run SQL*Plus with the /nolog option, connect / as sysdba, and startup manually, everything works fine. Anyone have any idea why it won't startup automatically, or what I could try to get it to? Thanks. _YEX_ /* || Robert D. Yexley || Oracle Programmer/Analyst || Easylink Services Corporation || Professional Services || Contractor - Wright Research Site MIS || Det-1 AFRL/WSI Bldg. 45 Rm. 062 || (937) 255-1984 || [EMAIL PROTECTED] || ))) */ Robert D. Yexley (E-mail).vcf -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Theodoros Demosthenous INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: Yexley Robert D Contr Det 1 AFRL/WSI INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: Theodoros Demosthenous INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: Replication question
Hi all I will work on replication soon. any advice for reference I can get. Thanks in advance. Mitchell - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 14, 2002 10:58 AM We are just starting to look at replication so each manufacturing plant can have their own server. The applications are being developed in-house. I feel the first issue is to analyze each table and decide how it will be replicated and what schema changes need to me made to accommodate replication. Instead, one of the developers wants to talk to Quest about their solution. It seems to me that you need to make the same evaluation and schema changes where needed. If anyone can point me to a white paper on schema changes to consider, that would be appreciated. Dennis Williams DBA, 20% OCP Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: mitchell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: 9i R2 not automatically starting up after upgrade
The database should start when you start the service if the registry entry ORA_SID_AUTOSTART is set to TRUE. When you upgraded the database, did the ORA_SID_* registry keys get moved into the new HKLM\Software\Oracle\HOMEx key, and removed from the old one? ORA-27101 can indicate its trying to start from the wrong ORACLE_HOME. Beth -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 10:44 AM To: Multiple recipients of list ORACLE-L I tried that...didn't fix the problem. The service actually starts without any problems, but for some reason, starting the service doesn't actually start the database. I have to actually login to SQL*Plus in /nolog mode, connect / as sysdba and then do a startup manually to get the database running. Thanks though. _YEX_ ))) -Original Message- Sent: Friday, June 14, 2002 3:38 AM To: Multiple recipients of list ORACLE-L Are you using a domain to connect to your PC. You should go into services and OracleServiceSID --- Properties. In the Log On tab go and choose log on as this account and choose your username and password that you are connecting to the domain. Stop and restart the service, and check that the memory is reserved for the instance. Regards Theodoros -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 8:22 PM To: Multiple recipients of list ORACLE-L I upgraded a database yesterday from 9i R1 (9.0.1) to 9i R2 (9.2.0.1.0), and am now having problems with the database starting up automatically on system reboot. This is on a Windows 2000 Pro machine. The error that I get when I try to connect with SQL*Plus is ORA-27101: shared memory realm does not exist. If I run SQL*Plus with the /nolog option, connect / as sysdba, and startup manually, everything works fine. Anyone have any idea why it won't startup automatically, or what I could try to get it to? Thanks. _YEX_ /* || Robert D. Yexley || Oracle Programmer/Analyst || Easylink Services Corporation || Professional Services || Contractor - Wright Research Site MIS || Det-1 AFRL/WSI Bldg. 45 Rm. 062 || (937) 255-1984 || [EMAIL PROTECTED] || ))) */ Robert D. Yexley (E-mail).vcf -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Theodoros Demosthenous INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: Yexley Robert D Contr Det 1 AFRL/WSI INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: Port access cancelling
On Unix, use netstat -a | grep port_number to see if there is any service listening on the port. At 11:58 PM 13-06-02 -0800, you wrote: Hello Unix Guru's! One of the port supposed to be used by db server has been occupied by application servers. When I want start a particular interface programs on DB which access the particular port is right now busy because it is used by apps server which is not supposed to be. I cancelled the PID on apps server and tried run ning the application interface on db server, but I still get the port in use error. How do I check that this port is in use by which apps server. We have 4 apps servers. Last time when we had this issue we did rebooted the apps servers to release this port. I guess that not the perm. solution. Please advice. = Thank You. Best Regards, Steve Johnson __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Johnson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: 9i R2 not automatically starting up after upgrade
Check whether the service finds your initsid.ora file. The parameter in the registry might point to a different location for the service. You can find the parameter file and copy paste it to the location that the service is looking for it. I hope that this will help. Regards Theodoros -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 5:44 PM To: Multiple recipients of list ORACLE-L I tried that...didn't fix the problem. The service actually starts without any problems, but for some reason, starting the service doesn't actually start the database. I have to actually login to SQL*Plus in /nolog mode, connect / as sysdba and then do a startup manually to get the database running. Thanks though. _YEX_ ))) -Original Message- Sent: Friday, June 14, 2002 3:38 AM To: Multiple recipients of list ORACLE-L Are you using a domain to connect to your PC. You should go into services and OracleServiceSID --- Properties. In the Log On tab go and choose log on as this account and choose your username and password that you are connecting to the domain. Stop and restart the service, and check that the memory is reserved for the instance. Regards Theodoros -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 8:22 PM To: Multiple recipients of list ORACLE-L I upgraded a database yesterday from 9i R1 (9.0.1) to 9i R2 (9.2.0.1.0), and am now having problems with the database starting up automatically on system reboot. This is on a Windows 2000 Pro machine. The error that I get when I try to connect with SQL*Plus is ORA-27101: shared memory realm does not exist. If I run SQL*Plus with the /nolog option, connect / as sysdba, and startup manually, everything works fine. Anyone have any idea why it won't startup automatically, or what I could try to get it to? Thanks. _YEX_ /* || Robert D. Yexley || Oracle Programmer/Analyst || Easylink Services Corporation || Professional Services || Contractor - Wright Research Site MIS || Det-1 AFRL/WSI Bldg. 45 Rm. 062 || (937) 255-1984 || [EMAIL PROTECTED] || ))) */ Robert D. Yexley (E-mail).vcf -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Theodoros Demosthenous INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: Yexley Robert D Contr Det 1 AFRL/WSI INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: Theodoros Demosthenous INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: 9i R2 not automatically starting up after upgrade
Robert, Check SID_AUTORTART key in Windows registry (regedit.exe) under HKEY_LOCAL_MACHINE\Software\Oracle\Home. Set this key to TRUE, thus telling Oracle to automatically startup/open the db, when Oracle service is starting. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 14, 2002 10:43 AM I tried that...didn't fix the problem. The service actually starts without any problems, but for some reason, starting the service doesn't actually start the database. I have to actually login to SQL*Plus in /nolog mode, connect / as sysdba and then do a startup manually to get the database running. Thanks though. _YEX_ ))) -Original Message- Sent: Friday, June 14, 2002 3:38 AM To: Multiple recipients of list ORACLE-L Are you using a domain to connect to your PC. You should go into services and OracleServiceSID --- Properties. In the Log On tab go and choose log on as this account and choose your username and password that you are connecting to the domain. Stop and restart the service, and check that the memory is reserved for the instance. Regards Theodoros -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 8:22 PM To: Multiple recipients of list ORACLE-L I upgraded a database yesterday from 9i R1 (9.0.1) to 9i R2 (9.2.0.1.0), and am now having problems with the database starting up automatically on system reboot. This is on a Windows 2000 Pro machine. The error that I get when I try to connect with SQL*Plus is ORA-27101: shared memory realm does not exist. If I run SQL*Plus with the /nolog option, connect / as sysdba, and startup manually, everything works fine. Anyone have any idea why it won't startup automatically, or what I could try to get it to? Thanks. _YEX_ /* || Robert D. Yexley || Oracle Programmer/Analyst || Easylink Services Corporation || Professional Services || Contractor - Wright Research Site MIS || Det-1 AFRL/WSI Bldg. 45 Rm. 062 || (937) 255-1984 || [EMAIL PROTECTED] || ))) */ Robert D. Yexley (E-mail).vcf -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Theodoros Demosthenous INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: Yexley Robert D Contr Det 1 AFRL/WSI INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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).
Wait Event Calculation
I am trying to break the response time of my system into the wait and service times. I am able to determine the service time by the CPU used by this session line in the statspack report. The wait time I am having trouble with. I am working from the 'Yet Another Performance Profiling Method' document. The document lists a number of events that should not be included in the calculation because they are caused by background process waits. I am tuning an 8.1.6 databases and want to be sure I am only counting the appropriate events in this calculation. How can I get the list of events to include for my version of the database (the doc is quite old)? Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: SunOS 5.8 I/O buffer size?
Title: RE: SunOS 5.8 I/O buffer size? Yeah, I've been using this device for backups for years. Always get very good performance. (This is a joke folks!) Matt Adams - GE Appliances - [EMAIL PROTECTED] When someone says I want a programming language in which I only need say what I want done, give him a lollipop. -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 11:18 AM To: Multiple recipients of list ORACLE-L Subject: Re: SunOS 5.8 I/O buffer size? Hey Tim! That /dev/null device is really fast! Solaris wrote 10 megabytes to it in 0.5 seconds. Where can I get one of those? Jared ;) On Thursday 13 June 2002 19:13, Tim Gorman wrote: Carmen et al, Did some testing on this. On solaris 2.8 there doesn't seem to be any upper-limit on single, atomic disk I/O, probably because someone finally got smart and started allocating memory buffers for I/O dynamically using the malloc() package instead of hard-coding a fixed-length variable as a buffer. At least, they did so for the dd command... Ran the following, reading three 1024Kb chunks from a large file while trussing the UNIX dd command: $ truss -D dd if=/d01001/oradata/portal/portal_01.dbf of=/dev/null bs=1024k count=3 0. execve(/usr/bin/dd, 0xFFBEFC8C, 0xFFBEFCA4) argc = 5 0.0036 mmap(0x, 8192, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_ANON, -1, 0) = 0xFF3A 0.0005 resolvepath(/usr/lib/ld.so.1, /usr/lib/ld.so.1, 1023) = 16 0.0006 open(/var/ld/ld.config, O_RDONLY) Err#2 ENOENT 0.0004 open(/usr/lib/libc.so.1, O_RDONLY) = 3 0.0003 fstat(3, 0xFFBEF3C4) = 0 0.0002 mmap(0x, 8192, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0xFF39 0.0003 mmap(0x, 794624, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0xFF28 0.0004 mmap(0xFF33A000, 24784, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_FIXED, 3, 696320) = 0xFF33A000 0.0005 munmap(0xFF32A000, 65536) = 0 0.0007 memcntl(0xFF28, 113272, MC_ADVISE, MADV_WILLNEED, 0, 0) = 0 0.0003 close(3) = 0 0.0003 open(/usr/lib/libdl.so.1, O_RDONLY) = 3 0.0003 fstat(3, 0xFFBEF3C4) = 0 0.0003 mmap(0xFF39, 8192, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED, 3, 0) = 0xFF39 0.0004 close(3) = 0 0.0004 open(/usr/platform/SUNW,Ultra-5_10/lib/libc_psr.so.1, O_RDONLY) = 3 0.0004 fstat(3, 0xFFBEF254) = 0 0.0003 mmap(0x, 8192, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0xFF38 0.0003 mmap(0x, 16384, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0xFF37 0.0004 close(3) = 0 0.0015 munmap(0xFF38, 8192) = 0 0.0009 brk(0x00023F68) = 0 0.0003 brk(0x00025F68) = 0 0.0005 open64(/d01001/oradata/portal/portal_01.dbf, O_RDONLY) = 3 0.0004 creat64(/dev/null, 0666) = 4 0.0004 sysconfig(_CONFIG_PAGESIZE) = 8192 0.0003 brk(0x00025F68) = 0 0.0002 brk(0x00127F68) = 0 0.0004 sigaction(SIGINT, 0xFFBEFA70, 0xFFBEFAF0) = 0 0.0002 sigaction(SIGINT, 0xFFBEFA70, 0xFFBEFAF0) = 0 0.0985 read(3, \0\0\0\0\0\0 \0\0\0 }80.., 1048576) = 1048576 0.0005 write(4, \0\0\0\0\0\0 \0\0\0 }80.., 1048576) = 1048576 0.0777 read(3, \002\0\0\0\0\080\0\0\0\0.., 1048576) = 1048576 0.0005 write(4, \002\0\0\0\0\080\0\0\0\0.., 1048576) = 1048576 0.0744 read(3, 0602\0\0028001\0\003 s.., 1048576) = 1048576 0.0004 write(4, 0602\0\0028001\0\003 s.., 1048576) = 1048576 0.0004 close(4) = 0 0.0003 close(1) = 0 3+0 0.0006 write(2, 3 + 0, 3) = 3 records in 0.0004 write(2, r e c o r d s i n\n, 12) = 12 3+0 0.0006 write(2, 3 + 0, 3) = 3 records out 0.0003 write(2, r e c o r d s o u t.., 13) = 13 0.0006 llseek(0, 0, SEEK_CUR) = 37672 0.0002 _exit(0) Note that each of the three read() and write() calls use 1048576 bytes (i.e. 1024 Kbytes) apiece. Please also note the two brk() calls, which allocate more memory to the process heap from the O/S, probably through the malloc() package. Last, please note the elapsed time (i.e. -D option on truss) for the three read() calls are 0.0985, 0.0777, and 0.0744 seconds respectively. Next, I tried making the requested read size 10x bigger... $ truss -D dd if=/d01001/oradata/portal/portal_01.dbf of=/dev/null bs=10240k count=3 0. execve(/usr/bin/dd, 0xFFBEFC8C, 0xFFBEFCA4) argc = 5 ... 0.8446 read(3, \0\0\0\0\0\0 \0\0\0 }80.., 10485760) = 10485760 0.0006 write(4, \0\0\0\0\0\0 \0\0\0 }80.., 10485760) = 10485760 0.8052 read(3, 0602\0\0028005\0\0\f R c.., 10485760) = 10485760 0.0006 write(4, 0602\0\0028005\0\0\f R c.., 10485760) = 10485760 0.7454 read(3, \002\0\0\0\0\n\0\0\0\0\0.., 10485760) = 10485760 0.0006 write(4, \002\0\0\0\0\n\0\0\0\0\0.., 10485760) = 10485760 ... Please note that the third argument to the read() and write() calls is now 10 Mbytes (i.e. 10,485,760 bytes) and that the elapsed time for the three calls are now about 10x slower at 0.8446, 0.8052, and 0.7454 seconds respectively. So, it seems that Solaris 2.8 doesn't split large I/O requests into smaller ones. What would be interesting would be whether
RE: partial restore of a database
Sorry for the late response, you probably are long done with your partial restore - but I'll add my $0.2 cents to the discussion: When I have done these partial restores I have limited my create controlfile script to only system, rollback, and the tablespaces I wanted. I have ONLY had success when I have listed the SYSTEM and ROLLBACK datafiles FIRST in the create controlfile script - I have gotten 600 errors otherwise - just my experience. Roll the database forward, open it, and pull out what you need I usually build a DB link and copy the data to another database rather than exporting it. I don't drop the datafiles I don't need - just let them get marked as missing. This is obviously a *very* temporary database and after I get what I need I blow it up. I'm sure there are other methods of doing this - this works for me. HTH John Dailey Oracle DBA ING Americas - Application Services Atlanta, GA DENNIS WILLIAMS DWILLIAMS@LIFE To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] TOUCH.COMcc: Sent by: Subject: RE: partial restore of a database [EMAIL PROTECTED] m 06/12/2002 06:05 PM Please respond to ORACLE-L Gene I can't think of anything you're missing. I recall that read-only tablespaces if you have any must be offline, but maybe that is only for a database restore, not a tablespace restore. I assume you have a plan to move the tables back to your production system, maybe just export/import if they are small. Dennis Williams DBA, 20% OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 12, 2002 3:59 PM To: Multiple recipients of list ORACLE-L Hi all: I'm doing a partial restore of a database in order to recover two lost tables. I figured I would only need to restore the tablespaces where the tables are stored, SYSTEM and RBS tablespaces. I will also need to restore to a specific point in time (last Friday). I'm a little less clear on what I will have to do after the restore of the datafiles, archived logs and controlfile is done. I will need to recover the datafiles, drop all other datafiles that I don't need and open the database in resetlogs mode. Is that a good plan or am I missing something? thanks Gene __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note
Re: Oracle 9.0.1.3 or 9.2.0? -- planned 9.0.1 and 9.2.0
Check Note 190435.1 on MetaLink. [It is under Upcoming Oracle Product Desupports]. At 09:41 AM 13-06-02 -0700, Charlie Mengler wrote: I just went to Metalink viewed the desupport notices. I did not see where any 9i version is listed. Where did you find the notice for 9iR1? Hemant K Chitale wrote: We are currently planning to upgrade an 8.1.5 OPS instance to 9i. We had rejected the idea of upgrading to the first release of 9i -- implementing a standing rule not to upgrade to Release1 of any new version. Therefore, we had always planned to wait for 9iRelease2. Within two weeks of the 9iRelease2 release-date, the desupport date for Release1 was set as 30-June-2003 while Release2 was specified as 30-September-2005. We have positioned an 8hour downtime for the OPS to RAC upgrade but will be allowed only 2hours. If we start testing 9iRAC now and do the production upgrade in September/October, do you think we would be allowed a second downtime before end-June-03 ? We must go for 9iRelease2 --- only one downtime in two-and-a-half-years will be allowed. Hemant - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, 13 June, 2002 7:00 PM I thought the original question was what is more stable 9.0 or 9.2. If that is the basis for your decission stick with 9.0.1.3 or better until 9.2 gets a couple dot releases on it. With all the problems we have had with 9.0.1.x, I have not had one support person recommend we go to 9.2 to solve problems. In fact, they are backporting a bug found during internal testing of 9.2 beta to 9.0.1.3 instead of asking us to upgrade. The basis for these decissions being (in my opinion) that 9.2 is not as stable as our current release. Bill --- Connor McDonald [EMAIL PROTECTED] wrote: Thats what Metalink has to say ( dunno what the note id is)..Expect '10i' sometime next year I'd say. For similar reasons, 8.1.7 is supported longer than 9.0 (since 9.2 is the terminal release) hth connor --- Grabowy, Chris [EMAIL PROTECTED] wrote: Hello? 9.2 is the terminal release for Oracle9? So Oracle10 is next, aside from patches, etc. to 9? -Original Message- Sent: Wednesday, June 12, 2002 1:33 PM To: Multiple recipients of list ORACLE-L I'd go 9.2 - its the terminal release so will supported for longer and removes Oracle's standard reply of 'please move to 9.2 and see if the problem disappears' hth connor --- Raj Gopalan [EMAIL PROTECTED] wrote: Hi DBAs We are upgrading from 8.1.5 to 9.x. I thought of finding out which release of 9i is more stable. As We have got 9.2 couple of weeks back, I was just wondering what is worth going for 9.2 instead of 9.0.1.3? TIA, Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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 http://www.oracledba.co.uk http://www.oaktable.net Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: Replication question
Mitchell, There are a LOT of good papers in Metalink. I've been getting my own education over the last few months. Replication is a really great swiss army knife though, you need to do a little looking for what you specifically need to do, then test, test, test. Oh, and did I mention test? :) I found Note: 138181.1 particularly helpful. Oh, and plan on some TARs. I have found Support very helpful/informative in this area. Good Luck, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 12:05 PM To: Multiple recipients of list ORACLE-L Hi all I will work on replication soon. any advice for reference I can get. Thanks in advance. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: SunOS 5.8 I/O buffer size?
Tim, I don't believe that you can see that by strace. The whole thing is happening entirely in the kernel. The problem is that each device has a fixed size buffer allocated in the kernel address space. When you allocate user buffer, it's contents it being copied to either the buffer cache (file system) or the drive buffer from which driver writes the data to the disk when the buffer is full. The process is repeated as long as necessary to get the user buffer written to the disk. Evertything happens within the system call. Size of the maximum atomic write is the size of that buffer that is allocated per device. I think htat the only way to find that out is to contact SUN support. HP support, for instance, tells me that that on HP-UX 11 (64 bit) the maximum size is 1MB. -Original Message- From: Tim Gorman [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 10:13 PM To: Multiple recipients of list ORACLE-L Subject: Re: SunOS 5.8 I/O buffer size? Carmen et al, Did some testing on this. On solaris 2.8 there doesn't seem to be any upper-limit on single, atomic disk I/O, probably because someone finally got smart and started allocating memory buffers for I/O dynamically using the malloc() package instead of hard-coding a fixed-length variable as a buffer. At least, they did so for the dd command... Ran the following, reading three 1024Kb chunks from a large file while trussing the UNIX dd command: $ truss -D dd if=/d01001/oradata/portal/portal_01.dbf of=/dev/null bs=1024k count=3 0. execve(/usr/bin/dd, 0xFFBEFC8C, 0xFFBEFCA4) argc = 5 0.0036 mmap(0x, 8192, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_ANON, -1, 0) = 0xFF3A 0.0005 resolvepath(/usr/lib/ld.so.1, /usr/lib/ld.so.1, 1023) = 16 0.0006 open(/var/ld/ld.config, O_RDONLY) Err#2 ENOENT 0.0004 open(/usr/lib/libc.so.1, O_RDONLY)= 3 0.0003 fstat(3, 0xFFBEF3C4)= 0 0.0002 mmap(0x, 8192, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0xFF39 0.0003 mmap(0x, 794624, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0xFF28 0.0004 mmap(0xFF33A000, 24784, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_FIXED, 3, 696320) = 0xFF33A000 0.0005 munmap(0xFF32A000, 65536) = 0 0.0007 memcntl(0xFF28, 113272, MC_ADVISE, MADV_WILLNEED, 0, 0) = 0 0.0003 close(3)= 0 0.0003 open(/usr/lib/libdl.so.1, O_RDONLY) = 3 0.0003 fstat(3, 0xFFBEF3C4)= 0 0.0003 mmap(0xFF39, 8192, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED, 3, 0) = 0xFF39 0.0004 close(3)= 0 0.0004 open(/usr/platform/SUNW,Ultra-5_10/lib/libc_psr.so.1, O_RDONLY) = 3 0.0004 fstat(3, 0xFFBEF254)= 0 0.0003 mmap(0x, 8192, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0xFF38 0.0003 mmap(0x, 16384, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0xFF37 0.0004 close(3)= 0 0.0015 munmap(0xFF38, 8192)= 0 0.0009 brk(0x00023F68) = 0 0.0003 brk(0x00025F68) = 0 0.0005 open64(/d01001/oradata/portal/portal_01.dbf, O_RDONLY) = 3 0.0004 creat64(/dev/null, 0666) = 4 0.0004 sysconfig(_CONFIG_PAGESIZE) = 8192 0.0003 brk(0x00025F68) = 0 0.0002 brk(0x00127F68) = 0 0.0004 sigaction(SIGINT, 0xFFBEFA70, 0xFFBEFAF0) = 0 0.0002 sigaction(SIGINT, 0xFFBEFA70, 0xFFBEFAF0) = 0 0.0985 read(3, \0\0\0\0\0\0 \0\0\0 }80.., 1048576) = 1048576 0.0005 write(4, \0\0\0\0\0\0 \0\0\0 }80.., 1048576) = 1048576 0.0777 read(3, \002\0\0\0\0\080\0\0\0\0.., 1048576) = 1048576 0.0005 write(4, \002\0\0\0\0\080\0\0\0\0.., 1048576) = 1048576 0.0744 read(3, 0602\0\0028001\0\003 s.., 1048576) = 1048576 0.0004 write(4, 0602\0\0028001\0\003 s.., 1048576) = 1048576 0.0004 close(4)= 0 0.0003 close(1)= 0 3+0 0.0006 write(2, 3 + 0, 3) = 3 records in 0.0004 write(2,r e c o r d s i n\n, 12)= 12 3+0 0.0006 write(2, 3 + 0, 3) = 3 records out 0.0003 write(2,r e c o r d s o u t.., 13) = 13 0.0006 llseek(0, 0, SEEK_CUR) = 37672 0.0002 _exit(0) Note that each of the three read() and write() calls use 1048576 bytes (i.e. 1024 Kbytes) apiece. Please also note the two brk() calls, which allocate more memory to the process heap from the O/S, probably through the malloc() package. Last, please note the elapsed time (i.e. -D option on truss) for the three read() calls are 0.0985, 0.0777, and 0.0744
RE: Replication question
Mitchell - My knowledge is mostly from reading at this point, but here are some thoughts that a colleague provided from his experience: - backup and recovery is much more complicated in a replicated environment so it needs to be planned - replicated databases inevitably get out of sync so some process outside the usual replication method must be built to re-sync the databases. this can either be done proactively or reactively - proactive is more fun. - a process to monitor the overall health of the replicated environment is a good idea. i.e. how latent are the transactions, are the replicated transactions actually being replicated, have there been any data conflicts. - schema changes get real fun. planning ahead again a good idea. - additional testing is needed to prove the replication will work especially on the performance front. I have found only two books on replication (is that a hint that most sites avoid it??) Oracle Distributed Systems by Charles Dye, O'Reilly 1999 Data Replication by Marie Buretta, Wiley 1997 -Original Message- Sent: Friday, June 14, 2002 11:05 AM To: Multiple recipients of list ORACLE-L Hi all I will work on replication soon. any advice for reference I can get. Thanks in advance. Mitchell - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 14, 2002 10:58 AM We are just starting to look at replication so each manufacturing plant can have their own server. The applications are being developed in-house. I feel the first issue is to analyze each table and decide how it will be replicated and what schema changes need to me made to accommodate replication. Instead, one of the developers wants to talk to Quest about their solution. It seems to me that you need to make the same evaluation and schema changes where needed. If anyone can point me to a white paper on schema changes to consider, that would be appreciated. Dennis Williams DBA, 20% OCP Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: mitchell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: sequence question
Bill, When you do an export you have sequence numbers in cache. Ramon - Original Message - From: Magaliff, Bill To: Multiple recipients of list ORACLE-L Sent: Friday, June 14, 2002 10:53 AM Subject: RE: sequence question what do you mean about losing numbers after an import/export? -Original Message-From: Ramon E. Estevez [mailto:[EMAIL PROTECTED]]Sent: Friday, June 14, 2002 10:44 AMTo: Multiple recipients of list ORACLE-LSubject: Re: sequence question Bigp Remember that when you issue sequence.nextval you are incrementing one value and eitheryour process function corrector not that number is used. But, the more important is that if your system crash or you issue an SHUTDOWN ABORT you will loose the sequence numbers cached. Also you can loose numbers after an Import / Export. Luck, Ramon - Original Message - From: BigP To: Multiple recipients of list ORACLE-L Sent: Thursday, June 13, 2002 8:23 PM Subject: sequence question Hi List , I want to create a sequence which will be used by some external process to generate some unique number . since this sequence will be used very frequently I would prefer to cache around 1 numbers . Am I going to loose some numbers ? what is SEQUENCE_CACHE_ENTRIES and how does it affect number or sequence cached ? Thanks , -Bp
RE: I/O contention with external process reading the oracle logs
Dennis, I was not referring to any one on this list. I was responding to the statement that Quest should run a benchmark on someone actual redo logs... I say, they might for a cost only I run Shareplex and haven't written full response to this thread yet because at this moment I am still iin the midst of Production issues with their product. But to expound a little on my statement. When we first purchased Quest, we were told that we would be able to do many things. We get it installed and then start to play with the *mentioned* optinos. Can't find it Oooohh you need Live Reorg for THAT option.. Happened so many times with supposed *features* that I can't count it and it has become a joke in my groupyeah yeah, so and so must have attended Quest sales training (when someone is being pushy etc). Of course, software firms need to sell their wares. Just like Oracle need to license (enough said on that one). But with this company in particular, it's always ... yeah we can fix that but you need another product product of ours that can that can do that etc. Now bottom line on the product as follows (as I responded to Tim privately): When they are GOOD, they are VERY VERY good When they are BAD, they are VERY VERY bad. They are more often good then bad. But sometimes a little bit of dirt can spoil the honey. It would take ony one or two extended prod down times to lose clilents (my companies clients) so a little bit a bad sometimes cannot be tolerated. SALES: always want to talk to the person above you. they get to the person above you. Then then want the person above them Got to the point that they pretty much told our Sr. Vice President that they only wanted to talk to our CEO. Uh hmm. We are no small company, quite large actually. So, CEO is OUT. Even their directors did it. But they are the only product that can do what we need with as little impact on the source , and no triggers (we are not allowed triggers on the source). So they won the contract. And when they are up they are robust and stable. gotto go. Hannah -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of DENNIS WILLIAMS [EMAIL PROTECTED] Sent: Friday, June 14, 2002 11:29 AM To: Multiple recipients of list ORACLE-L Subject: RE: I/O contention with external process reading the oracle logs I feel compelled to respond. There are many fine consultants that take time to respond on this list with free advice. I could name a few names, but I'd slight someone, so I'll just say that you know who you are and your efforts are GREATLY appreciated. Say Tim, wouldn't you fall within that category? Or maybe Jared is slipping a few bucks on the side ;-) Dennis Williams DBA, 20% OCP Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Port access cancelling
When I gave this command on my db server nothing responded for 10 mnts. then I cancelled the command ; please advice. --- Hemant K Chitale [EMAIL PROTECTED] wrote: On Unix, use netstat -a | grep port_number to see if there is any service listening on the port. At 11:58 PM 13-06-02 -0800, you wrote: Hello Unix Guru's! One of the port supposed to be used by db server has been occupied by application servers. When I want start a particular interface programs on DB which access the particular port is right now busy because it is used by apps server which is not supposed to be. I cancelled the PID on apps server and tried run ning the application interface on db server, but I still get the port in use error. How do I check that this port is in use by which apps server. We have 4 apps servers. Last time when we had this issue we did rebooted the apps servers to release this port. I guess that not the perm. solution. Please advice. = Thank You. Best Regards, Steve Johnson __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Johnson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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). = Thank You. Best Regards, Steve Johnson __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Johnson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: 9i R2 not automatically starting up after upgrade
That was the problem. I checked out that registry entry, and then looked in the directory that it was pointing to, and there was no init.ora file in that directory. I looked at the one that was in my previous ORACLE_HOME, copied and pasted it into the directory in the new ORACLE_HOME (the one that the registry entry was pointing to) and rebooted, and now it works fine. Evidently for some reason or other, the initsid.ora file didn't get copied over into the new ORACLE_HOME during the upgrade. Thanks for the advice. _YEX_ ))) -Original Message- Sent: Friday, June 14, 2002 12:24 PM To: Multiple recipients of list ORACLE-L The parameter to look in the registry is ORA_ORA9I_PFILE and points to the parameter file. Make sure that it is located there. Regards -Original Message- Sent: Friday, June 14, 2002 6:16 PM To: '[EMAIL PROTECTED]' Check whether the service finds your initsid.ora file. The parameter in the registry might point to a different location for the service. You can find the parameter file and copy paste it to the location that the service is looking for it. I hope that this will help. Regards Theodoros -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 5:44 PM To: Multiple recipients of list ORACLE-L I tried that...didn't fix the problem. The service actually starts without any problems, but for some reason, starting the service doesn't actually start the database. I have to actually login to SQL*Plus in /nolog mode, connect / as sysdba and then do a startup manually to get the database running. Thanks though. _YEX_ ))) -Original Message- Sent: Friday, June 14, 2002 3:38 AM To: Multiple recipients of list ORACLE-L Are you using a domain to connect to your PC. You should go into services and OracleServiceSID --- Properties. In the Log On tab go and choose log on as this account and choose your username and password that you are connecting to the domain. Stop and restart the service, and check that the memory is reserved for the instance. Regards Theodoros -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 8:22 PM To: Multiple recipients of list ORACLE-L I upgraded a database yesterday from 9i R1 (9.0.1) to 9i R2 (9.2.0.1.0), and am now having problems with the database starting up automatically on system reboot. This is on a Windows 2000 Pro machine. The error that I get when I try to connect with SQL*Plus is ORA-27101: shared memory realm does not exist. If I run SQL*Plus with the /nolog option, connect / as sysdba, and startup manually, everything works fine. Anyone have any idea why it won't startup automatically, or what I could try to get it to? Thanks. _YEX_ /* || Robert D. Yexley || Oracle Programmer/Analyst || Easylink Services Corporation || Professional Services || Contractor - Wright Research Site MIS || Det-1 AFRL/WSI Bldg. 45 Rm. 062 || (937) 255-1984 || [EMAIL PROTECTED] || ))) */ Robert D. Yexley (E-mail).vcf -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Theodoros Demosthenous INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: Yexley Robert D Contr Det 1 AFRL/WSI INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: Theodoros Demosthenous INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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
RE: Management Reports
Title: RE: Management Reports I'm currently working on producing statistics for mid-managers. We have a lot of tools that collect statistics for our 30 production databases so my challenge it to map their individual repositories with the categories I want to report. But these are the categories I'm proposing, and they can be collected from v$ views and application tables: Total CPU time used DISK I/O counts Network I/O counts Session count (peak and average) Total number of Oracle transactions Total number of application transactions (the logical unit of work for the application. i.e. orders taken for our Order Entry app., packages shipped forFulfillment, IVR calls, outbound calls placed, etc.) HTH Tony -Original Message-From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]]Sent: Thursday, June 13, 2002 12:26 PMTo: Aponte, Tony; [EMAIL PROTECTED]Subject: RE: Management Reports Tony: Scorecard/historical. My management would not know what to make of a Spotlight screen if they sat on it. Can I say that? Mike -Original Message-From: Aponte, Tony [mailto:[EMAIL PROTECTED]]Sent: Thursday, June 13, 2002 8:33 AMTo: [EMAIL PROTECTED]Cc: Vergara, Michael (TEM)Subject: RE: Management Reports Is your management looking for real-time charts or are they looking for higher-level scorecard-like info (i.e.. number of transactions yesterday, last 7 days, yada yada yada?) Tony Aponte -Original Message- From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 11:33 AM To: Multiple recipients of list ORACLE-L Subject: Management Reports Good Morning Everyone! My management wants a chart that shows the performance of the database. If this was your boss, what would you show them? Thanks, Mike P.S. This is a repeat e-mail. I never saw my other one hit the list. --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from 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 error logging
One more link with a complete package. http://www.quest-pipelines.com/Pipelines/PLSQL/archives.htm#code35 Tony -Original Message-From: Aponte, Tony Sent: Thursday, June 13, 2002 12:29 PMTo: Multiple recipients of list ORACLE-LSubject: RE: oracle error logging PL/SQL Tips Techniques from Oracle Press hasa few sections that may interest you. There's one on encapsulating exception blocks, with code to set up an infrastructure for exception routines. Another good on is a complete package to encapsulate UTL_FILE exception handling. HTH Tony Aponte -Original Message-From: BigP [mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 12, 2002 6:54 PMTo: Multiple recipients of list ORACLE-LSubject: oracle error logging I am looking for some good design to log and handle oracle /user defined error messgaes in our system , which can be used for debugging and error reporting also .Can any body out there share their experience ? Bp
RE: I/O contention with external process reading the oracle logs (online redo logs)
Title: RE: I/O contention with external process reading the oracle logs (online redo logs) Actually, for us the percentage is lower since the OLTP application we're using itfor is heavily indexed (with the exception of single SQL that updates many rows.) It's one of those claims that is usually followed by "your mileage may vary." Tony -Original Message-From: Tim Gorman [mailto:[EMAIL PROTECTED]]Sent: Thursday, June 13, 2002 9:23 PMTo: Multiple recipients of list ORACLE-LSubject: Re: I/O contention with external process reading the oracle logs (online redo logs) It shouldn't need to be a "theoretical" or "statistical" claim at all. A prospective customer should be able to ship a few archived redo log files (the more the better!) to Quest and have them run it through that part of SharePlex that will read the redo and produce SQL. I'm surprised they haven't suggested it already... :-) - Original Message - From: Aponte, Tony To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, June 13, 2002 8:47 AM Subject: RE: I/O contention with external process reading the oracle logs (online redo logs) I think Yechiel is referring to a statistical claim by Quest that only 30% of the redo stream is usable in re-assembling the SQL statement. The rest is like you suspect, index maintenance, rbs segment maintenance, etc. But you are right to point out (so right) that a multi-row update by a single SQL on the source results in individual updates on the target. That's a little nugget that the marketing folks left out of their 30% claim. Tony -Original Message- From: Tim Gorman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 10:48 PM To: Multiple recipients of list ORACLE-L Subject: Re: I/O contention with external process reading the oracle logs (online redo logs) Just curious, why do you think replication will be less bandwidth? Are you replicating only certain schemas/accounts and not the entire database? Is Quest asserting that shipping the SQL statements are more "compact" than shipping the redo? That could be possible, but I'm quite certain that it is near thing, unless the heavily-modified tables in the app have been indexed with a heavy hand. For example, unless SharePlex has some remarkable logic, it won't be "coalescing" a million-row update into the single SQL statement that spawned it, which ironically Oracle's advanced replication might be able to do! Instead, they'll need to reverse-engineer individual UPDATE statements for each row, just like Oracle's LogMiner. The only circumstances under which I can imagine individual row-level SQL statements being more compact that the redo resulting from them is when there are lots of large indices on the table... --- On another note, the 9iR2 "logical standby" feature is a direct knockoff of SharePlex, in that the RDBMS ships the SQL instead of the redo logfile, so the characteristics should be very similar. Of course, 9iR2 is very new and *very* raw at the moment, while SharePlex has been around for something like 5-6 years already (i.e. eons!), so that should be a strong consideration. But, when I last worked with SharePlex (3.0, I think), it had lots of bad habits like demanding "DBA" role to be granted to it's account both for installation as well as run-time, setting SETUID on executables owned by "root" (17-18 of them! drove the UNIX sysadmins insane! with good reason); just a lot of lazy development practices that I hope have been fixed... - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Wednesday, June 12, 2002 8:48 AM (online redo logs) Hello Tim and Rachel There is band width problem. The line is 256K (we are checking upgrade to 512k). The database, during peek time produce 10MB of logs every 2-3 minutes. On this line it will take 7-8 minutes to pass 10MB if the line was dedicate and it is not dedicated. Upgrading the line to more then 512K need E1 at least and it is expansive. Since replication will need less band width we are checking it. To return to my original question: Quest Shareplex - Any success stories? Why use this and not replication? Ant performance tests between Shareplex and Oracle replication? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, June 10, 2002 4:33 AM (online redo logs) and if you need the remote site to support users, you could use the logical standby feature of 9iR2, which generates SQL statements to be applied and allows the database to be open
Re: Strange Bug
Are you executing two sql's from two different sessinons . Because it may happen that you might not have commited the records you inserted in tableA , as soon as you create a temp table oracle does commit by itself and you start finding records . Can you try issuing a commit and then doing select on tableA without creating temp table. -Bp - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 13, 2002 5:28 PM List, I have a table when I run a query on this table return nothing(no record returns!!!), but when I create a temp table from this table return the records E.G: select cola,colb,colc from tableA where cola=1 and colb='A' 0 records return Now: create table a_temp as select * from tableA then select cola,colb,colc from tableA where cola=1 and colb='A' cola colb colc 1 Axx 1 A 1 Ammm Any Idea? what's wrong and what's cause a problem? I appreciate any recommendation. Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: BigP INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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 9.0.1.3 or 9.2.0?
Yep. We just upgraded to 8.1.7.x. v9.x isn't even on the radar screen, yet... Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Freeman, Robert [SMTP:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 9:48 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle 9.0.1.3 or 9.2.0? We are toying with the idea of crafting a policy that we only upgrade to a terminal release of a given version (e.g. 8.1.7, 9.0.1.3) in most cases, unless a different version is required by a vendor. It seems that these terminal release versions tend to be the most stable. Anyone else doing that? RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration Author: Oracle9i New Features Mastering Oracle8i Clark Griswold: Eddie, has anyone ever told you that you're bad luck? Cousin Eddie: Those were my mother's dying words. But I guess if your body's covered in third degree burns, and your foot's caught in a bear trap, you tend to start talkin' crazy. -Original Message- Sent: Thursday, June 13, 2002 7:01 AM To: Multiple recipients of list ORACLE-L I thought the original question was what is more stable 9.0 or 9.2. If that is the basis for your decission stick with 9.0.1.3 or better until 9.2 gets a couple dot releases on it. With all the problems we have had with 9.0.1.x, I have not had one support person recommend we go to 9.2 to solve problems. In fact, they are backporting a bug found during internal testing of 9.2 beta to 9.0.1.3 instead of asking us to upgrade. The basis for these decissions being (in my opinion) that 9.2 is not as stable as our current release. Bill --- Connor McDonald [EMAIL PROTECTED] wrote: Thats what Metalink has to say ( dunno what the note id is)..Expect '10i' sometime next year I'd say. For similar reasons, 8.1.7 is supported longer than 9.0 (since 9.2 is the terminal release) hth connor --- Grabowy, Chris [EMAIL PROTECTED] wrote: Hello? 9.2 is the terminal release for Oracle9? So Oracle10 is next, aside from patches, etc. to 9? -Original Message- Sent: Wednesday, June 12, 2002 1:33 PM To: Multiple recipients of list ORACLE-L I'd go 9.2 - its the terminal release so will supported for longer and removes Oracle's standard reply of 'please move to 9.2 and see if the problem disappears' hth connor --- Raj Gopalan [EMAIL PROTECTED] wrote: Hi DBAs We are upgrading from 8.1.5 to 9.x. I thought of finding out which release of 9i is more stable. As We have got 9.2 couple of weeks back, I was just wondering what is worth going for 9.2 instead of 9.0.1.3? TIA, Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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 http://www.oracledba.co.uk http://www.oaktable.net Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: set sort_area_size, sort_retained_size,hash_area_size but sti
16 Gig of RAM on Windoze? Bruce, have you had your coffee yet? Jared Reardon, Bruce (CALBBAY) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/13/2002 06:03 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: set sort_area_size, sort_retained_size,hash_area_size but sti Paula, and what OS / database version? eg if Windows is the server setup to use all 16 Gb of memory? Bruce Reardon -Original Message- Sent: Friday, 14 June 2002 2:29 Paula, what is the size of your hash_area_size, sort_area_size, and sort_area_retained_size? what does your explain plan look like? hashes, sort/merge, or nested loops? do you have a lot of parallel to parallel, parallel to serial in your plans? jack silvey --- [EMAIL PROTECTED] wrote: Have 12Gb RAM available , using parallel query with large mv joined to small code tables and setting session parameters to use Gb's of memory (have system to myself at the time) but system shows 12Gb RAM available still and writing to temporary segment - why or why or why? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: Replication question
Curious, that note suggests Advanced Replication as a failover methodology. Seems that a standby database would be _much_ simpler. Any thoughts ( from anyone ) on why one would use AR for failover, rather than using a standby database? Jared John Weatherman [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/14/2002 09:50 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Replication question Mitchell, There are a LOT of good papers in Metalink. I've been getting my own education over the last few months. Replication is a really great swiss army knife though, you need to do a little looking for what you specifically need to do, then test, test, test. Oh, and did I mention test? :) I found Note: 138181.1 particularly helpful. Oh, and plan on some TARs. I have found Support very helpful/informative in this area. Good Luck, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 12:05 PM To: Multiple recipients of list ORACLE-L Hi all I will work on replication soon. any advice for reference I can get. Thanks in advance. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: sequence question
while going throgh oracle manuals I found saying number of sequence cached is governed by init parameter SEQUENCE_CACHE_ENTRIES . Does it mean that this value should be set = 'number of sequence I want to cache' ...and what happens if a sequence gets aged out from sequence pool . Am I going to loose numbers ? Did any of you guys tried caching high number such as 1 or 100 . Thanks , Bp - Original Message - From: Magaliff, Bill To: Multiple recipients of list ORACLE-L Sent: Friday, June 14, 2002 8:53 AM Subject: RE: sequence question what do you mean about losing numbers after an import/export? -Original Message-From: Ramon E. Estevez [mailto:[EMAIL PROTECTED]]Sent: Friday, June 14, 2002 10:44 AMTo: Multiple recipients of list ORACLE-LSubject: Re: sequence question Bigp Remember that when you issue sequence.nextval you are incrementing one value and eitheryour process function corrector not that number is used. But, the more important is that if your system crash or you issue an SHUTDOWN ABORT you will loose the sequence numbers cached. Also you can loose numbers after an Import / Export. Luck, Ramon - Original Message - From: BigP To: Multiple recipients of list ORACLE-L Sent: Thursday, June 13, 2002 8:23 PM Subject: sequence question Hi List , I want to create a sequence which will be used by some external process to generate some unique number . since this sequence will be used very frequently I would prefer to cache around 1 numbers . Am I going to loose some numbers ? what is SEQUENCE_CACHE_ENTRIES and how does it affect number or sequence cached ? Thanks , -Bp
Re: Port access cancelling
Stalled trying to do nslookups on all those IP address probably. Try the following: netstat -an | grep port number It gives you IP address and ports numbers without doing lookups. Bill --- Steve Johnson [EMAIL PROTECTED] wrote: When I gave this command on my db server nothing responded for 10 mnts. then I cancelled the command ; please advice. --- Hemant K Chitale [EMAIL PROTECTED] wrote: On Unix, use netstat -a | grep port_number to see if there is any service listening on the port. At 11:58 PM 13-06-02 -0800, you wrote: Hello Unix Guru's! One of the port supposed to be used by db server has been occupied by application servers. When I want start a particular interface programs on DB which access the particular port is right now busy because it is used by apps server which is not supposed to be. I cancelled the PID on apps server and tried run ning the application interface on db server, but I still get the port in use error. How do I check that this port is in use by which apps server. We have 4 apps servers. Last time when we had this issue we did rebooted the apps servers to release this port. I guess that not the perm. solution. Please advice. = Thank You. Best Regards, Steve Johnson __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Johnson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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). = Thank You. Best Regards, Steve Johnson __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Johnson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Pass INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: SunOS 5.8 I/O buffer size?
That's it, I *must* read that copy of The Magic Garden Explained that is at home langushing on the shelf. Jared Gogala, Mladen [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/14/2002 10:03 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: SunOS 5.8 I/O buffer size? Tim, I don't believe that you can see that by strace. The whole thing is happening entirely in the kernel. The problem is that each device has a fixed size buffer allocated in the kernel address space. When you allocate user buffer, it's contents it being copied to either the buffer cache (file system) or the drive buffer from which driver writes the data to the disk when the buffer is full. The process is repeated as long as necessary to get the user buffer written to the disk. Evertything happens within the system call. Size of the maximum atomic write is the size of that buffer that is allocated per device. I think htat the only way to find that out is to contact SUN support. HP support, for instance, tells me that that on HP-UX 11 (64 bit) the maximum size is 1MB. -Original Message- From: Tim Gorman [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 10:13 PM To: Multiple recipients of list ORACLE-L Subject: Re: SunOS 5.8 I/O buffer size? Carmen et al, Did some testing on this. On solaris 2.8 there doesn't seem to be any upper-limit on single, atomic disk I/O, probably because someone finally got smart and started allocating memory buffers for I/O dynamically using the malloc() package instead of hard-coding a fixed-length variable as a buffer. At least, they did so for the dd command... Ran the following, reading three 1024Kb chunks from a large file while trussing the UNIX dd command: $ truss -D dd if=/d01001/oradata/portal/portal_01.dbf of=/dev/null bs=1024k count=3 0. execve(/usr/bin/dd, 0xFFBEFC8C, 0xFFBEFCA4) argc = 5 0.0036 mmap(0x, 8192, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_ANON, -1, 0) = 0xFF3A 0.0005 resolvepath(/usr/lib/ld.so.1, /usr/lib/ld.so.1, 1023) = 16 0.0006 open(/var/ld/ld.config, O_RDONLY) Err#2 ENOENT 0.0004 open(/usr/lib/libc.so.1, O_RDONLY)= 3 0.0003 fstat(3, 0xFFBEF3C4)= 0 0.0002 mmap(0x, 8192, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0xFF39 0.0003 mmap(0x, 794624, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0xFF28 0.0004 mmap(0xFF33A000, 24784, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_FIXED, 3, 696320) = 0xFF33A000 0.0005 munmap(0xFF32A000, 65536) = 0 0.0007 memcntl(0xFF28, 113272, MC_ADVISE, MADV_WILLNEED, 0, 0) = 0 0.0003 close(3)= 0 0.0003 open(/usr/lib/libdl.so.1, O_RDONLY) = 3 0.0003 fstat(3, 0xFFBEF3C4)= 0 0.0003 mmap(0xFF39, 8192, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED, 3, 0) = 0xFF39 0.0004 close(3)= 0 0.0004 open(/usr/platform/SUNW,Ultra-5_10/lib/libc_psr.so.1, O_RDONLY) = 3 0.0004 fstat(3, 0xFFBEF254)= 0 0.0003 mmap(0x, 8192, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0xFF38 0.0003 mmap(0x, 16384, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0xFF37 0.0004 close(3)= 0 0.0015 munmap(0xFF38, 8192)= 0 0.0009 brk(0x00023F68) = 0 0.0003 brk(0x00025F68) = 0 0.0005 open64(/d01001/oradata/portal/portal_01.dbf, O_RDONLY) = 3 0.0004 creat64(/dev/null, 0666) = 4 0.0004 sysconfig(_CONFIG_PAGESIZE) = 8192 0.0003 brk(0x00025F68) = 0 0.0002 brk(0x00127F68) = 0 0.0004 sigaction(SIGINT, 0xFFBEFA70, 0xFFBEFAF0) = 0 0.0002 sigaction(SIGINT, 0xFFBEFA70, 0xFFBEFAF0) = 0 0.0985 read(3, \0\0\0\0\0\0 \0\0\0 }80.., 1048576) = 1048576 0.0005 write(4, \0\0\0\0\0\0 \0\0\0 }80.., 1048576) = 1048576 0.0777 read(3, \002\0\0\0\0\080\0\0\0\0.., 1048576) = 1048576 0.0005 write(4, \002\0\0\0\0\080\0\0\0\0.., 1048576) = 1048576 0.0744 read(3, 0602\0\0028001\0\003 s.., 1048576) = 1048576 0.0004 write(4, 0602\0\0028001\0\003 s.., 1048576) = 1048576 0.0004 close(4)= 0 0.0003 close(1)= 0 3+0 0.0006 write(2, 3 + 0, 3) = 3 records in 0.0004 write(2,r e c o r d s i n\n, 12)= 12 3+0 0.0006 write(2, 3 + 0, 3) = 3 records out 0.0003 write(2,r e c o r d s o u t.., 13) = 13 0.0006 llseek(0, 0, SEEK_CUR) = 37672 0.0002 _exit(0) Note
RE: Locally Managed Tablespaces
I am using 9.0.1 - can the system tablespace be setup as lmt? Or is that new in 9.2? Michele -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Replication question
Jarad, A standby is simpler, however it has limited use for offloading some system load (opening for read access suspends roll forward, so the data is somewhat stale). By using Master-Master synchronous replication with good deadlock handlers, you can use BOTH instances so you get the benefit of not having an unused instance lying around (damagement hates that), but still have fail over available. Since you can have different users/locations attach to different instances, you also get some scalability advantages. In general, I agree a standby is MUCH simpler. John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 1:41 PM To: Multiple recipients of list ORACLE-L Curious, that note suggests Advanced Replication as a failover methodology. Seems that a standby database would be _much_ simpler. Any thoughts ( from anyone ) on why one would use AR for failover, rather than using a standby database? Jared John Weatherman [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/14/2002 09:50 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Replication question Mitchell, There are a LOT of good papers in Metalink. I've been getting my own education over the last few months. Replication is a really great swiss army knife though, you need to do a little looking for what you specifically need to do, then test, test, test. Oh, and did I mention test? :) I found Note: 138181.1 particularly helpful. Oh, and plan on some TARs. I have found Support very helpful/informative in this area. Good Luck, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 12:05 PM To: Multiple recipients of list ORACLE-L Hi all I will work on replication soon. any advice for reference I can get. Thanks in advance. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: Port access cancelling
Try it without the pipe to grep and see if the netstat -a is returning anything at all. -Original Message- Sent: Friday, June 14, 2002 1:41 PM To: Multiple recipients of list ORACLE-L When I gave this command on my db server nothing responded for 10 mnts. then I cancelled the command ; please advice. --- Hemant K Chitale [EMAIL PROTECTED] wrote: On Unix, use netstat -a | grep port_number to see if there is any service listening on the port. At 11:58 PM 13-06-02 -0800, you wrote: Hello Unix Guru's! One of the port supposed to be used by db server has been occupied by application servers. When I want start a particular interface programs on DB which access the particular port is right now busy because it is used by apps server which is not supposed to be. I cancelled the PID on apps server and tried run ning the application interface on db server, but I still get the port in use error. How do I check that this port is in use by which apps server. We have 4 apps servers. Last time when we had this issue we did rebooted the apps servers to release this port. I guess that not the perm. solution. Please advice. = Thank You. Best Regards, Steve Johnson __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Johnson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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). = Thank You. Best Regards, Steve Johnson __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Johnson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: Locally Managed Tablespaces
only in 9.2 ... that's the default. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Friday, June 14, 2002 2:04 PM To: Multiple recipients of list ORACLE-L I am using 9.0.1 - can the system tablespace be setup as lmt? Or is that new in 9.2? Michele -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.*2
RE: Wait event problems
FWIW I tried mucking around with the SDU/TDU parameters on both the client and the server and never got much success. Tried to up the 2K to 8K but it still was sending alot of 2k packets. I had more results upping the array size to 90-100 in glogin (default is 15). Kathy -Original Message- Sent: Thursday, June 13, 2002 6:53 PM To: Multiple recipients of list ORACLE-L This is never an idle event. The phrase more data from client indicates that the individual SQL operation is larger than a single SQL*Net packet. No big deal; it happens all the time, and SQL*Net handles it with continuation packets. Only issue is that the client is taking a lot of time between each packet sent. Jack's conclusion that the client process (in the client-server database connection) is not providing data in a timely fashion is exactly correct. You most likely have a slow client process... Oracle documentation frequently tries to encourage mucking about with SDU/TDU parameters in SQL*Net configuration files, but I've rarely seen this be more effective than tuning the client process... :-) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 13, 2002 10:08 AM Lee, This is an idle wait event, meaning that the query process is waiting on instructions from the client. Usually this process is benign, but sometimes can indicate that the feeding process is not providing data in a timely fashion. hth, jack silvey --- Robertson Lee - lerobe [EMAIL PROTECTED] wrote: All, Oracle 8.0.5.0.0 Tru64 v4.0f We are running a job and statspack reports show that our only problem (it is running like a dog) is the following SQL*Net more data from client. Done some reading and still none the wiser. Anyone else had this sort of problem and if so how did you get around it ?? Regards Lee The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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). Confidential This e-mail and any files transmitted with it are the property of Belkin Components and/or its affiliates, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipients or otherwise have reason to believe that you have received this e-mail in error, please notify the sender and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kathy Duret INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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
RE: Locally Managed Tablespaces
That is new in 9.2. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 2:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: Locally Managed Tablespaces I am using 9.0.1 - can the system tablespace be setup as lmt? Or is that new in 9.2? Michele -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: Locally Managed Tablespaces
9.2 [EMAIL PROTECTED] wrote: I am using 9.0.1 - can the system tablespace be setup as lmt? Or is that new in 9.2? Michele -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: Locally Managed Tablespaces
only in 9.2 can system be an lmt --- [EMAIL PROTECTED] wrote: I am using 9.0.1 - can the system tablespace be setup as lmt? Or is that new in 9.2? Michele -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: Replication question
or you can use the logical standby feature of 9.2 and then have both databases open. Replication bothers me when I start to think about synchronous vs asynchronous. Async doesn't hold up the primary site from continuing on, but the databases are not true copies of one another. Sync are true copies but you can hold up the commit waiting for a return from the remote site. And if it fails, it's messy to clean up --- John Weatherman [EMAIL PROTECTED] wrote: Jarad, A standby is simpler, however it has limited use for offloading some system load (opening for read access suspends roll forward, so the data is somewhat stale). By using Master-Master synchronous replication with good deadlock handlers, you can use BOTH instances so you get the benefit of not having an unused instance lying around (damagement hates that), but still have fail over available. Since you can have different users/locations attach to different instances, you also get some scalability advantages. In general, I agree a standby is MUCH simpler. John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 1:41 PM To: Multiple recipients of list ORACLE-L Curious, that note suggests Advanced Replication as a failover methodology. Seems that a standby database would be _much_ simpler. Any thoughts ( from anyone ) on why one would use AR for failover, rather than using a standby database? Jared John Weatherman [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/14/2002 09:50 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Replication question Mitchell, There are a LOT of good papers in Metalink. I've been getting my own education over the last few months. Replication is a really great swiss army knife though, you need to do a little looking for what you specifically need to do, then test, test, test. Oh, and did I mention test? :) I found Note: 138181.1 particularly helpful. Oh, and plan on some TARs. I have found Support very helpful/informative in this area. Good Luck, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 12:05 PM To: Multiple recipients of list ORACLE-L Hi all I will work on replication soon. any advice for reference I can get. Thanks in advance. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To
Re: Wait event problems
Hello, There are many theoretical things about tuning SDU/TDU. But, I don't think tuning SDU/TDU makes benefit in practice. Kathy Duret wrote: FWIW I tried mucking around with the SDU/TDU parameters on both the client and the server and never got much success. Tried to up the 2K to 8K but it still was sending alot of 2k packets. I had more results upping the array size to 90-100 in glogin (default is 15). Kathy -Original Message- Sent: Thursday, June 13, 2002 6:53 PM To: Multiple recipients of list ORACLE-L This is never an idle event. The phrase more data from client indicates that the individual SQL operation is larger than a single SQL*Net packet. No big deal; it happens all the time, and SQL*Net handles it with continuation packets. Only issue is that the client is taking a lot of time between each packet sent. Jack's conclusion that the client process (in the client-server database connection) is not providing data in a timely fashion is exactly correct. You most likely have a slow client process... Oracle documentation frequently tries to encourage mucking about with SDU/TDU parameters in SQL*Net configuration files, but I've rarely seen this be more effective than tuning the client process... :-) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 13, 2002 10:08 AM Lee, This is an idle wait event, meaning that the query process is waiting on instructions from the client. Usually this process is benign, but sometimes can indicate that the feeding process is not providing data in a timely fashion. hth, jack silvey --- Robertson Lee - lerobe [EMAIL PROTECTED] wrote: All, Oracle 8.0.5.0.0 Tru64 v4.0f We are running a job and statspack reports show that our only problem (it is running like a dog) is the following SQL*Net more data from client. Done some reading and still none the wiser. Anyone else had this sort of problem and if so how did you get around it ?? Regards Lee The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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). Confidential This e-mail and any files transmitted with it are the property of Belkin Components and/or its affiliates, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipients or otherwise have reason to believe that you have received this e-mail in error, please notify the sender and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kathy Duret INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing
RE: Replication question
Title: RE: Replication question Another potential HA use of AR is that you can use different platforms in an HA configuration. You can fail over to another platform with some idle capacity or a workload that can be shifted around until the failed services are restored. Yet another is during planned downtime when upgrading Oracle and OS versions. You could upgrade the target while the source is the actively used node. Then move the users off the source and let the remaining changes post to the target. Now reverse the replication source/target roles and upgrade the old source (now they new target) an let it be until the next time. The outage should be shorter. The same technique could be used to roll back to a usable database after an major application change. Just change the target and let the users try things out. If there's a problem point them back to the source and regroup. It should be much quicker that undoing the changes. Just some thoughts. Tony Aponte -Original Message- From: John Weatherman [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 2:19 PM To: Multiple recipients of list ORACLE-L Subject: RE: Replication question Jarad, A standby is simpler, however it has limited use for offloading some system load (opening for read access suspends roll forward, so the data is somewhat stale). By using Master-Master synchronous replication with good deadlock handlers, you can use BOTH instances so you get the benefit of not having an unused instance lying around (damagement hates that), but still have fail over available. Since you can have different users/locations attach to different instances, you also get some scalability advantages. In general, I agree a standby is MUCH simpler. John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 1:41 PM To: Multiple recipients of list ORACLE-L Curious, that note suggests Advanced Replication as a failover methodology. Seems that a standby database would be _much_ simpler. Any thoughts ( from anyone ) on why one would use AR for failover, rather than using a standby database? Jared John Weatherman [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/14/2002 09:50 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: RE: Replication question Mitchell, There are a LOT of good papers in Metalink. I've been getting my own education over the last few months. Replication is a really great swiss army knife though, you need to do a little looking for what you specifically need to do, then test, test, test. Oh, and did I mention test? :) I found Note: 138181.1 particularly helpful. Oh, and plan on some TARs. I have found Support very helpful/informative in this area. Good Luck, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 12:05 PM To: Multiple recipients of list ORACLE-L Hi all I will work on replication soon. any advice for reference I can get. Thanks in advance. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from 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
RE: Strange Bug
Not actualy, The data already exists but not retreived till i recreate the table with same data. When I rebuild table the correct data will be retreived. Few tables always corrupted for no reason!!! -Original Message- Sent: Friday, June 14, 2002 10:41 AM To: Multiple recipients of list ORACLE-L Are you executing two sql's from two different sessinons . Because it may happen that you might not have commited the records you inserted in tableA , as soon as you create a temp table oracle does commit by itself and you start finding records . Can you try issuing a commit and then doing select on tableA without creating temp table. -Bp - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 13, 2002 5:28 PM List, I have a table when I run a query on this table return nothing(no record returns!!!), but when I create a temp table from this table return the records E.G: select cola,colb,colc from tableA where cola=1 and colb='A' 0 records return Now: create table a_temp as select * from tableA then select cola,colb,colc from tableA where cola=1 and colb='A' cola colb colc 1 Axx 1 A 1 Ammm Any Idea? what's wrong and what's cause a problem? I appreciate any recommendation. Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: BigP INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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). === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: Wait event problems
Here is an old paper from an Oracle analyst discussing SDU/TDU settings... http://www.fors.com/eoug97/papers/0285.htm. I never came across any upgraded version of the same. - Kirti -Original Message- Sent: Friday, June 14, 2002 2:01 PM To: Multiple recipients of list ORACLE-L Hello, There are many theoretical things about tuning SDU/TDU. But, I don't think tuning SDU/TDU makes benefit in practice. Kathy Duret wrote: FWIW I tried mucking around with the SDU/TDU parameters on both the client and the server and never got much success. Tried to up the 2K to 8K but it still was sending alot of 2k packets. I had more results upping the array size to 90-100 in glogin (default is 15). Kathy -Original Message- Sent: Thursday, June 13, 2002 6:53 PM To: Multiple recipients of list ORACLE-L This is never an idle event. The phrase more data from client indicates that the individual SQL operation is larger than a single SQL*Net packet. No big deal; it happens all the time, and SQL*Net handles it with continuation packets. Only issue is that the client is taking a lot of time between each packet sent. Jack's conclusion that the client process (in the client-server database connection) is not providing data in a timely fashion is exactly correct. You most likely have a slow client process... Oracle documentation frequently tries to encourage mucking about with SDU/TDU parameters in SQL*Net configuration files, but I've rarely seen this be more effective than tuning the client process... :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: Replication question
All very true. Of course the doc in question was written for 8i, so that explains some of it. :) Question: Does logical standby in 9.2 work across platforms? Haven't had too much time to look at new 9.2 features I'm afraid. John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 2:57 PM To: Multiple recipients of list ORACLE-L or you can use the logical standby feature of 9.2 and then have both databases open. Replication bothers me when I start to think about synchronous vs asynchronous. Async doesn't hold up the primary site from continuing on, but the databases are not true copies of one another. Sync are true copies but you can hold up the commit waiting for a return from the remote site. And if it fails, it's messy to clean up --- John Weatherman [EMAIL PROTECTED] wrote: Jarad, A standby is simpler, however it has limited use for offloading some system load (opening for read access suspends roll forward, so the data is somewhat stale). By using Master-Master synchronous replication with good deadlock handlers, you can use BOTH instances so you get the benefit of not having an unused instance lying around (damagement hates that), but still have fail over available. Since you can have different users/locations attach to different instances, you also get some scalability advantages. In general, I agree a standby is MUCH simpler. John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 1:41 PM To: Multiple recipients of list ORACLE-L Curious, that note suggests Advanced Replication as a failover methodology. Seems that a standby database would be _much_ simpler. Any thoughts ( from anyone ) on why one would use AR for failover, rather than using a standby database? Jared John Weatherman [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/14/2002 09:50 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Replication question Mitchell, There are a LOT of good papers in Metalink. I've been getting my own education over the last few months. Replication is a really great swiss army knife though, you need to do a little looking for what you specifically need to do, then test, test, test. Oh, and did I mention test? :) I found Note: 138181.1 particularly helpful. Oh, and plan on some TARs. I have found Support very helpful/informative in this area. Good Luck, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 12:05 PM To: Multiple recipients of list ORACLE-L Hi all I will work on replication soon. any advice for reference I can get. Thanks in advance. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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! - Official
RE: Locally Managed Tablespaces
Well, not really. I did that by slightly modifying sql.bsq in 8.1.7.2, but I'm not quite sure that modifying sql.bsq is something that Oracle Support likes to hear about... You can do it in a supported way as of 9.2. The same goes for renaming a user. One or two quick updates of the sys.user$ table and it is done. Again, your favorite support engineer will not like that. BTW, my favorite support engineer is Anita Bardeen from FLA. She's great! -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 2:57 PM To: Multiple recipients of list ORACLE-L Subject: RE: Locally Managed Tablespaces only in 9.2 can system be an lmt --- [EMAIL PROTECTED] wrote: I am using 9.0.1 - can the system tablespace be setup as lmt? Or is that new in 9.2? Michele -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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 identify what sql statements are generating archived logs
Dear Listers: Any way (other than LogMiner) to easily identify what sql statements running now are generaing archived logs ? I have suddenly a lots of archived logs generated and almost fillup my file system. TIA --David Jones _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Jones INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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 identify what sql statements are generating archived l
Use v$sess_io.block_changes to find out who is generating changes, since each block change generates redo. Join back to v$session and v$sqlarea if need be and you have your culprits. Daniel W. Fink Sr. Oracle DBA MICROMEDEX 303.486.6456 -Original Message- Sent: Friday, June 14, 2002 1:24 PM To: Multiple recipients of list ORACLE-L logs Dear Listers: Any way (other than LogMiner) to easily identify what sql statements running now are generaing archived logs ? I have suddenly a lots of archived logs generated and almost fillup my file system. TIA --David Jones _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Jones INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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 identify what sql statements are generating archived logs
I'd start with using the data out of V$SESS_IO. [EMAIL PROTECTED] desc v$sess_io NameNull?Type --- SID NUMBER BLOCK_GETS NUMBER CONSISTENT_GETS NUMBER PHYSICAL_READS NUMBER BLOCK_CHANGESNUMBER CONSISTENT_CHANGES NUMBER I believe there is a high degree of correlation between CHANGES and the generation of redo logs. Once you have the SID of the culprit(s), it is easy identify the SQL involved. David Jones wrote: Dear Listers: Any way (other than LogMiner) to easily identify what sql statements running now are generaing archived logs ? I have suddenly a lots of archived logs generated and almost fillup my file system. TIA -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 There are no stupid questions, but there are many inquisitive idiots! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: Locally Managed Tablespaces
I concur. Anita's one of the most knowledgeable replication people to ever grace this list. Jared Gogala, Mladen [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/14/2002 12:28 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Locally Managed Tablespaces Well, not really. I did that by slightly modifying sql.bsq in 8.1.7.2, but I'm not quite sure that modifying sql.bsq is something that Oracle Support likes to hear about... You can do it in a supported way as of 9.2. The same goes for renaming a user. One or two quick updates of the sys.user$ table and it is done. Again, your favorite support engineer will not like that. BTW, my favorite support engineer is Anita Bardeen from FLA. She's great! -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 2:57 PM To: Multiple recipients of list ORACLE-L Subject: RE: Locally Managed Tablespaces only in 9.2 can system be an lmt --- [EMAIL PROTECTED] wrote: I am using 9.0.1 - can the system tablespace be setup as lmt? Or is that new in 9.2? Michele -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: sequence question
Acording to the manuals SEQUENCE_CACHE_ENTRIES is an obsolete parameter for 8.1.7 Ramon - Original Message - From: BigP To: Multiple recipients of list ORACLE-L Sent: Friday, June 14, 2002 12:49 PM Subject: Re: sequence question while going throgh oracle manuals I found saying number of sequence cached is governed by init parameter SEQUENCE_CACHE_ENTRIES . Does it mean that this value should be set = 'number of sequence I want to cache' ...and what happens if a sequence gets aged out from sequence pool . Am I going to loose numbers ? Did any of you guys tried caching high number such as 1 or 100 . Thanks , Bp - Original Message - From: Magaliff, Bill To: Multiple recipients of list ORACLE-L Sent: Friday, June 14, 2002 8:53 AM Subject: RE: sequence question what do you mean about losing numbers after an import/export? -Original Message-From: Ramon E. Estevez [mailto:[EMAIL PROTECTED]]Sent: Friday, June 14, 2002 10:44 AMTo: Multiple recipients of list ORACLE-LSubject: Re: sequence question Bigp Remember that when you issue sequence.nextval you are incrementing one value and eitheryour process function corrector not that number is used. But, the more important is that if your system crash or you issue an SHUTDOWN ABORT you will loose the sequence numbers cached. Also you can loose numbers after an Import / Export. Luck, Ramon - Original Message - From: BigP To: Multiple recipients of list ORACLE-L Sent: Thursday, June 13, 2002 8:23 PM Subject: sequence question Hi List , I want to create a sequence which will be used by some external process to generate some unique number . since this sequence will be used very frequently I would prefer to cache around 1 numbers . Am I going to loose some numbers ? what is SEQUENCE_CACHE_ENTRIES and how does it affect number or sequence cached ? Thanks , -Bp
RE: Replication question
Thanks! John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 4:10 PM To: Multiple recipients of list ORACLE-L Cross-platform is the whole reason for logical standby -- it's SQL statements that get applied to the secondary database --- John Weatherman [EMAIL PROTECTED] wrote: All very true. Of course the doc in question was written for 8i, so that explains some of it. :) Question: Does logical standby in 9.2 work across platforms? Haven't had too much time to look at new 9.2 features I'm afraid. John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 2:57 PM To: Multiple recipients of list ORACLE-L or you can use the logical standby feature of 9.2 and then have both databases open. Replication bothers me when I start to think about synchronous vs asynchronous. Async doesn't hold up the primary site from continuing on, but the databases are not true copies of one another. Sync are true copies but you can hold up the commit waiting for a return from the remote site. And if it fails, it's messy to clean up --- John Weatherman [EMAIL PROTECTED] wrote: Jarad, A standby is simpler, however it has limited use for offloading some system load (opening for read access suspends roll forward, so the data is somewhat stale). By using Master-Master synchronous replication with good deadlock handlers, you can use BOTH instances so you get the benefit of not having an unused instance lying around (damagement hates that), but still have fail over available. Since you can have different users/locations attach to different instances, you also get some scalability advantages. In general, I agree a standby is MUCH simpler. John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 1:41 PM To: Multiple recipients of list ORACLE-L Curious, that note suggests Advanced Replication as a failover methodology. Seems that a standby database would be _much_ simpler. Any thoughts ( from anyone ) on why one would use AR for failover, rather than using a standby database? Jared John Weatherman [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/14/2002 09:50 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Replication question Mitchell, There are a LOT of good papers in Metalink. I've been getting my own education over the last few months. Replication is a really great swiss army knife though, you need to do a little looking for what you specifically need to do, then test, test, test. Oh, and did I mention test? :) I found Note: 138181.1 particularly helpful. Oh, and plan on some TARs. I have found Support very helpful/informative in this area. Good Luck, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 12:05 PM To: Multiple recipients of list ORACLE-L Hi all I will work on replication soon. any advice for reference I can get. Thanks in advance. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public
RE: Locally Managed Tablespaces
Yeah Anita is my favorite support engineer too... except that she's not on the front lines of support anymore :( But I think she's going to be able to come to NY to present for the user group in December. We're looking into it now :) You are right, knowing the members of this list I should have said only in 9.2 is it supported for system to be an lmt --- Gogala, Mladen [EMAIL PROTECTED] wrote: Well, not really. I did that by slightly modifying sql.bsq in 8.1.7.2, but I'm not quite sure that modifying sql.bsq is something that Oracle Support likes to hear about... You can do it in a supported way as of 9.2. The same goes for renaming a user. One or two quick updates of the sys.user$ table and it is done. Again, your favorite support engineer will not like that. BTW, my favorite support engineer is Anita Bardeen from FLA. She's great! -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 2:57 PM To: Multiple recipients of list ORACLE-L Subject: RE: Locally Managed Tablespaces only in 9.2 can system be an lmt --- [EMAIL PROTECTED] wrote: I am using 9.0.1 - can the system tablespace be setup as lmt? Or is that new in 9.2? Michele -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: Locally Managed Tablespaces
But she is missing from this list for a while...Hope to see her again Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 14 Jun 2002 11:51:37 -0800 I concur. Anita's one of the most knowledgeable replication people to ever grace this list. Jared Gogala, Mladen [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/14/2002 12:28 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Locally Managed Tablespaces Well, not really. I did that by slightly modifying sql.bsq in 8.1.7.2, but I'm not quite sure that modifying sql.bsq is something that Oracle Support likes to hear about... You can do it in a supported way as of 9.2. The same goes for renaming a user. One or two quick updates of the sys.user$ table and it is done. Again, your favorite support engineer will not like that. BTW, my favorite support engineer is Anita Bardeen from FLA. She's great! -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 2:57 PM To: Multiple recipients of list ORACLE-L Subject: RE: Locally Managed Tablespaces only in 9.2 can system be an lmt --- [EMAIL PROTECTED] wrote: I am using 9.0.1 - can the system tablespace be setup as lmt? Or is that new in 9.2? Michele -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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 your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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
SAN - Oracle - Pitfalls - Adv/Disadvantages??
Hello Guys, any guys here who have SAN. We are inviting a SAN vendor for possible solutions for our enterprise. i am unaware about how SAN would affect me as DBA. Also we are thinking about how we can use OS level block replication between two database servers located in different cities(SF and LA). any suggestion about pitfalls? TIA Mandar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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).
VB and Oracle...memory limiting the amount of records returned?
We have a VB app that uses Oracle as the database. The users noticed a limitation in the amount of records being returned from the database. So they decided to increase the memory of the PC and some additional volume of records were returned. ?? Has anyone using VB/Oracle noticed this?? Is this simply a sign of bad coding? Trying to load up all the records into memory, and therefore failing? Any clues, references or links would be appreciated. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: VB and Oracle...memory limiting the amount of records returne
Chris - How is VB connecting to Oracle? ADO? I don't know much about your problem, but I do know that there are a half-dozen Microsoft choices, and I believe there are a few Oracle choices also, like OO4O. But I do believe that the first step to solving your problem will be establishing precisely which methods are in use. Dennis Williams DBA, 20% OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, June 14, 2002 3:44 PM To: Multiple recipients of list ORACLE-L We have a VB app that uses Oracle as the database. The users noticed a limitation in the amount of records being returned from the database. So they decided to increase the memory of the PC and some additional volume of records were returned. ?? Has anyone using VB/Oracle noticed this?? Is this simply a sign of bad coding? Trying to load up all the records into memory, and therefore failing? Any clues, references or links would be appreciated. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: VB and Oracle...memory limiting the amount of records returned?
Hi Chris, I'm not sure I understand the problem, but we have VB apps that routinely retrieve tens of thousands of records at a time, and occaissionally more, if that helps. We have not run into any limitation. If you want to send me more details on the problem I'd be happy to try to help. Beth -Original Message- Sent: Friday, June 14, 2002 4:44 PM To: Multiple recipients of list ORACLE-L We have a VB app that uses Oracle as the database. The users noticed a limitation in the amount of records being returned from the database. So they decided to increase the memory of the PC and some additional volume of records were returned. ?? Has anyone using VB/Oracle noticed this?? Is this simply a sign of bad coding? Trying to load up all the records into memory, and therefore failing? Any clues, references or links would be appreciated. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: SAN - Oracle - Pitfalls - Adv/Disadvantages??
I like SAN's for alot of reasons and if you are using them in a traditional non-replicated environment, they work well. Just don't buy into the sales hype that you don't need to do phsycial database design because we have should big caches etc... Those big caches are great for improving write performance, but don't help that much on heavy random read activity. I have seen very poor performance on very large EMC arrays due to this mentality, so do your homework. The remained of this e-mail deals w/doing block (or track) level replication between SANS... The only method of real-time block level replication supported by oracle is synchronous. So you need to worry about the impact synchronous replication will have on your transaction stream (especially log buffer writes). For EMC, they only ship entire tracks, so this really slows down log writes as you end up shipping the same track over and over again synchrounously to the remote EMC boxes memory. Also, there are limits on the number of hops between the two locations and transport delay (speed of light is a factor). About the only way it makes sense is if you can pull dark fiber between the two sites. If you can afford to lose some transactions, then you can use a split mirror approach (EMC has another product called timefinder which is useful here). This approach does not impact your online transaction stream and is less demanding from a network perspecive. Both of these solutions are cool black box solutions that a DBA doesn't need to worry about. My own opinion is after reality sets in and you realize that the synchronous approach will not work, why not just go with DataGuard. Same bennefit at a fraction of the cost. Bill --- Mandar A. Ghosalkar [EMAIL PROTECTED] wrote: Hello Guys, any guys here who have SAN. We are inviting a SAN vendor for possible solutions for our enterprise. i am unaware about how SAN would affect me as DBA. Also we are thinking about how we can use OS level block replication between two database servers located in different cities(SF and LA). any suggestion about pitfalls? TIA Mandar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Pass INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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).
Any Good Tool for Entity Relationship Diagram
Hi, One of our databases is custom based application. Is there any good tool I can use for ER Diagram. Thank your! Muqthar Ahmed DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: Wait Event Calculation
As I mentioned a few weeks ago, IMHO, singling out events to ignore in a system-wide or even session-wide data collection is the wrong thing to do. But you must ignore some events if you first make what I consider to be errors in how you collect your data. If you collect data for only the problem program during only the problem duration, then you should ignore *none* of the events that you see. If you collect the data this way, then *everything* you see will be a component of end-user response time. Any other data collection method is misleading (and time-wasting) in many cases; one example of such a case is the rather longish example I described. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: 2003 Hotsos Symposium on Oracle® System Performance, February 912 Dallas Hotsos Clinic, July 911 New York City Hotsos Clinic, July 2325 Chicago -Original Message- Williams Sent: Friday, June 14, 2002 11:38 AM To: Multiple recipients of list ORACLE-L I am trying to break the response time of my system into the wait and service times. I am able to determine the service time by the CPU used by this session line in the statspack report. The wait time I am having trouble with. I am working from the 'Yet Another Performance Profiling Method' document. The document lists a number of events that should not be included in the calculation because they are caused by background process waits. I am tuning an 8.1.6 databases and want to be sure I am only counting the appropriate events in this calculation. How can I get the list of events to include for my version of the database (the doc is quite old)? Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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 Good Tool for Entity Relationship Diagram
How about ERwin by CA? We use a lot. -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/14/02 3:13 PM Hi, One of our databases is custom based application. Is there any good tool I can use for ER Diagram. Thank your! Muqthar Ahmed DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: Free Buffer Waits/CNTD......
Pretty interesting. Maybe it's possible, but a simpler explanation is that something about your workload either during or maybe immediately before your batch job was different. The most common case in which I've seen 'free buffer waits' waits is when all the forces of nature combine to make DBWR's job really difficult for some critical period. There are several ways for that to happen. Most that I've seen involve either bad SQL that does a lot of reads that compete with DBWR's writes to the same devices. I'm not sure it's relevant in your case, but use of RAID level 5 disk arrays increase the odds of having symptoms like you've seen. RAID level 5 implementations convert each DBWR single-block write into four distinct I/O calls, which of course might be more I/O calls than your array was designed to handle. Also, in periods of partial outage (when the array is reconstructing itself to recover from a single disk outage), one would likely notice this same type of performance problem you've noticed. There are lots of ways it could have happened... Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: 2003 Hotsos Symposium on Oracle® System Performance, February 912 Dallas Hotsos Clinic, July 911 New York City Hotsos Clinic, July 2325 Chicago -Original Message- Zanen Sent: Friday, June 14, 2002 2:23 AM To: Multiple recipients of list ORACLE-L Hi All, As mysteriously as it took over 6 hours to run yesterday, it was back at 35 minutes today. Free buffer waits dropped out of the top 10 again as well. My question now is: If nothing changed to the database (we did not modify anything because we could not find the source of all evil) and there are no different processes running (it's the same batch job every day) and there are no users connected (listener.ora file), could it be that for some reason my DBWR processes weren't able to write to disk and Oracle did not report an error on it Jack Cary Millsap cary.millsap@hotTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] sos.com cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: RE: Free Buffer Waits [EMAIL PROTECTED] 13-06-2002 19:08 Please respond to ORACLE-L free buffer waits waits indicate that your DBWR can't keep up with its workload. Often caused by inefficient SQL competing with DBWR for an I/O device. Cary Millsap Hotsos Enterprises, Ltd. [EMAIL PROTECTED] http://www.hotsos.com -Original Message- Zanen Sent: Thursday, June 13, 2002 4:04 AM To: Multiple recipients of list ORACLE-L Hi All, We have a production database that has a batch job running on it for months now. Last night one part of the batch job that normally takes between 20-30 minutes took well over 6 hours. The only difference I can see between today other days is that the Free Buffer Wait event was the top wait event, which it not normally is (not even top 10) This database goes down every night for backup and this is the timings I got. Total waits:22055 Total timeouts:22052 Time waited: 2225285 (is this ms or cs?) Avg.wait:100.8971 This whole thing puzzles me a bit since nothing changed to the database and nothing was in the Alert log. Also system was virtually idle during the 6 hours (no activity according to UNIX boys) I was sound asleep when this happened so I don't have much more than this info. Can anybody explain why this could have happened or point me to some documents that can. Standard answer you'll find that your DBWR can't keep up, but I have 4 of them and the sytem was idle. THX === De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is
RE: Any Good Tool for Entity Relationship Diagram
Muqthar - ErWin is always a safe choice. Does the schema have relationships defined? If not, you're just going to end up with a bunch of disconnected boxes. Dennis Williams DBA, 20% OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, June 14, 2002 5:13 PM To: Multiple recipients of list ORACLE-L Hi, One of our databases is custom based application. Is there any good tool I can use for ER Diagram. Thank your! Muqthar Ahmed DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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: Custom Reports from Aspect System
Title: RE: Custom Reports from Aspect System Could you try to connect internal on the server and create another user with DBA privileges? -Original Message- From: Rodd Holman [mailto:[EMAIL PROTECTED]] Are any of you using an Aspect phone system. This system maintains a small Oracle database on the switching equipment. Our telcom techs want to generate some custom reports out of this system, but I'm having problems getting in. They use some standard userids, but the passwords are encrypted in the compiled apps they sell as part of the system. Have any of you worked with this, and how did you get around the access issues?
Re: Oracle DB2 DBA Needed in Nebraska (near Colorado border)
This has been open for a while - I first saw a posting for this opening in January or so. It is Cabela's. From what I hear, it is an outstanding place to work. Sidney is a long ways from anything though. As for 2 hours from Denver ..., well -- MapQuest says 168.51 miles with 3 hours, 20 minutes estimated driving time. I don't think you can normally average 85 MPH for the entire trip with the the likes of CO-113, US-138, *Chestnut St*, and I-25 into Denver! If I were interested and qualified (DB2 experience? No.), I would go direct at http://www.cabelas.com/ - bottom left side, under About Us - Careers - DB2/Oracle DBA ... or: http://www.cabelas.com/cabelas/en/templates/community/aboutus/career-details .jhtml?contentId=MIS_DB2_Oracle_DBAhierarchyId=10708 Don Granaman [OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 12, 2002 3:13 PM Company in Sidney, Nebraska has an Oracle /DB2 DBA position opening on its IT staff. Sidney is a small town, 2 hours from Denver.. 30 mins from Sterling, CO so it's very close to the CO/NE border. The area has a very, very low cost of living, so renting or buying a house is tremendously low compared to most other areas of the country. An excellent Relocation Package is offered. Description: The selected candidate will perform typical DBA tasks to ensure reliable and scheduled availability of multiple development and production databases. This position will be responsible for monitoring and tuning databases for optimum performance, working with application developers during all phases of the application development life cycle, designing and implementing physical database design, influencing all aspects of application architecture and design, and assisting in troubleshooting application problems. PLEASE Do Not send your resume for this position UNLESS you have the qualifications for this position. Please Do Not send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. No H-1B candidates please. Requirements: -4+ years of Oracle database administration experience on HP, SUN, or NT platforms (version 8.x or higher) -Solid DB2 database administration experience on AS400, HP, SUN, or NT platforms. -4+ years of experience writing and tuning complex SQL. -Experience in logical and physical relational database design and data modeling -Good communication skills, ability to work well with others and multi-task. -U.S. citizens or permanent residency The base salary range depends on experience...range is up to 85K..and possible bonus. They also offer a comprehensive benefits package, including generous product discounts, profit sharing, 401K savings plan, and Health and Dental coverage. For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please use job code: One/Sidney/Oracle/DB2/KW ph: 1-800 -549-8502 All Submissions are handled in confidence. *We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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).
Extremely slow query
* Solaris 2.6 * Oracle RDBMS v8.0.5.2.1 List: We are (still) having difficult with a production database. (Users experiencing severe slowness at times.) I'm constructing a series of queries to run at intervals to check the health/status of the system. I'm attempting to run the query below. (Got it from Metalink.) This script takes 3 to 4 minutes to run (regardless of whether it returns any rows). The same script runs in less than 1 second on the test database on the same box, as well as other databases on different Solaris and VMS databases. This is particularly curious. Thought I'd run an explain plan for grins. The explain plan is identical on this database as on the others. However, there's a 3 to 4 minute wait before the explain plan shows up. (It's instantaneous on other databases.) In other words, if I type in set autotrace traceonly explain and then @find_locks, the explain plan does not appear for several minutes. I'm not sure where to start looking. My other health/status scripts run in normal amounts of time. It's only this 1 script that's a difficulty. Any ideas? I'm not sure where to start looking. I'm certainly curious to know if this is in any way related to other problems we're having with this database, but I don't see the connection. Thanks for any help. Barb SET ECHO off REM NAME: TFSLKILL.SQL REM USAGE:@path/tfslkill set linesize 132 pagesize 66 break on Kill on username on terminal column Kill heading 'Kill|String' format a9 column res heading 'Resource Type' format 999 column id1 format 990 column id2 format 990 column lmode heading 'Lock Held' format a20 column request heading 'Lock|Requested' format a10 column serial# format 9 column username format a8 heading Username column terminal heading Term format a7 column tab format a21 heading Table Name column owner format a9 column Address format a18 select nvl(S.USERNAME,'Internal') username, nvl(S.TERMINAL,'None') terminal, L.SID||','||S.SERIAL# Kill, U1.NAME||'.'||substr(T1.NAME,1,20) tab, decode(L.LMODE,1,'No Lock', 2,'Row Share', 3,'Row Exclusive', 4,'Share', 5,'Share Row Exclusive', 6,'Exclusive',null) lmode, decode(L.REQUEST,1,'No Lock', 2,'Row Share', 3,'Row Exclusive', 4,'Share', 5,'Share Row Exclusive', 6,'Exclusive',null) request fromV$LOCK L, V$SESSION S, SYS.USER$ U1, SYS.OBJ$ T1 where L.SID = S.SID and T1.OBJ# = decode(L.ID2,0,L.ID1,L.ID2) and U1.USER# = T1.OWNER# and S.TYPE != 'BACKGROUND' order by 1,2,5 ; Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=154 Card=6698 Bytes= 1024794) 10 SORT (ORDER BY) (Cost=154 Card=6698 Bytes=1024794) 21 NESTED LOOPS (Cost=1 Card=6698 Bytes=1024794) 32 NESTED LOOPS (Cost=1 Card=82 Bytes=10086) 43 NESTED LOOPS (Cost=7 Card=1 Bytes=80) 54 NESTED LOOPS (Cost=6 Card=1 Bytes=60) 65 NESTED LOOPS (Cost=2 Card=1 Bytes=40) 76 FIXED TABLE (FULL) OF 'X$KSUSE' (Cost=1 Card=1 Bytes=20) 86 FIXED TABLE (FIXED INDEX #1) OF 'X$KSUSE' (Cost=1 Card=1 Bytes=20) 95 VIEW OF 'GV$_LOCK' 109 UNION-ALL 11 10 VIEW OF 'GV$_LOCK1' (Cost=2 Card=2 Bytes=40) 12 11 UNION-ALL 13 12 FIXED TABLE (FULL) OF 'X$KDNSSF' (Cost=1 Card=1 Bytes=20) 14 12 FIXED TABLE (FULL) OF 'X$KSQEQ' (Cost=1 Card=1 Bytes=20) 15 10 FIXED TABLE (FULL) OF 'X$KTADM' (Cost=1 Card=1 Bytes=20) 16 10 FIXED TABLE (FULL) OF 'X$KTCXB' (Cost=1 Card=1 Bytes=20) 174 FIXED TABLE (FIXED INDEX #1) OF 'X$KSQRS' (Cost=1 Card=100 Bytes=2000) 183 TABLE ACCESS (BY INDEX ROWID) OF 'OBJ$' (Cost=1 Card=8168 Bytes=351224) 19 18 INDEX (UNIQUE SCAN) OF 'I_OBJ1' (UNIQUE) 202 TABLE ACCESS (CLUSTER) OF 'USER$' (Cost=1 Card=8168 Bytes=245040) 21 20 INDEX (UNIQUE SCAN) OF 'I_USER#' (CLUSTER) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from 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
