blob deletion
hi gurus! can anyone answer this (maybe newb question:) i have a table with a BLOB column. this table is stored in a seperate tablespace, in which there are no other data than that of this very table. suppose now i have one row in this table. if i delete this row, the blob is also deleted and tablespace increases. on a different DB with the very same data, the DBA claims that deleting the row with the BLOB does delete the row from the table, but the BLOB remains in the tablespace and the diskspace he takes cannot be reused. if i create my tablespace (without auto-extend) sized 1 MB and i insert a row with one BLOB of size 800 KB, the next time i can't insert another row with a BLOB of that size. - fine. if i delete the row, i can insert another row, again! - fine. but the DBA of the other DB claims: if he deletes one row, he cannot insert another row, because the BLOB is not acutally deleted. ? ? ? thx daniel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daniel Wisser INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
UKOUG Meet.
Hi All, I remember that a number of people were all for getting together on the Monday night at the UKOUG. I *don't* remember us actually arranging a place/time.. ;) Is there any chance of another show of hands so that we can see if we'll need to book a table or not. And has *anybody* had any thoughts on a place at all? See you all soon! Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SLA Trigger/Procedure
Yup, got that covered :) If I may add another point. When dealing with SLA's, you not only have to show that the database has been servicing users that are connected (showing database uptime), but also that users can also *connect* to the database as well (the listener is servicing requests). If you were to go about this with a trigger/procedure that inserts in to a table, then this doesn't show that the database was available to everybody. Typically what we do with monitoring tools is a connect on ping, so when we are checking availability of a database we do a full connect, then select 'PING' from dual;. If there are any errors along the way we search for the error code, and deal with the appropriate alerts (TNS = Listener problem, ORA = Database problem). Of course, the problem with doing it this way, is that you are going to have to write platform dependant scripts (batches for NT, shell type scripts for Unix), and not have a one for all with a database based solution. Go buy a tool. Let it write to a table/file, alert you AND make the coffee for when you get there! ;) Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -Original Message- Richard Sent: 03 December 2002 02:14 To: Multiple recipients of list ORACLE-L Perhaps there is a poor mans way of doing this. The startup trigger could fire a procedure that inserts a row into a table and then sleeps for 1 minute before doing the same again. Effectively it would create a ping in the table, which you could then analyze / graph to display uptimes. The next logical step would be to increase the intelligence of the procedure. The table storing the statistic could consist of two columns - uptime and downtime. When the startup trigger fires it creates a new row in the table with both uptime and downtime set to sysdate. It then sleeps for a minute before updating downtime for the most recent record (either remember a primary key or search for max(uptime)). This would be much easier to understand when the database was stopped / started. Of course depending on your accuracy requirement, granularity could be changed to every 5 minutes, 10 minutes, whatever. Hopefully that gives some ideas though. Of course the 3rd party monitors that Jared mentions are worth considering if the database is considered critical. In that case the number one requirement is probably the ability to page / SMS / email when it sees the database is down. Regards, Mark. Jared.Still@ra disys.comTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: SLA Trigger/Procedure om 03/12/2002 12:13 Please respond to ORACLE-L Ethan, That records the startup times, but does not record the time that the database was unavailable. What's needed is a 3rd party monitor that is not dependent on the database being up to record metrics. Jared Post, Ethan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/02/2002 02:33 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:SLA Trigger/Procedure Just a thought here for a script I think would be handy but I haven't had time to write. It is would be a simple procedure you could call to get the service level for a particular database. I suppose you would have to have some sort of way of defining normal outage windows. Basically a startup trigger would log the times in a table. You should also check the startup time against the last startup time periodically to ensure the trigger always fires. Somehow a procedure/function should be able to use this information to report the service level for the database within the last (week/month/quarter/year). I suppose I will get around to it eventually but if anyone else wants to get started on it I won't mind! Thanks, Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information
RE: move some records of some tables
There are issues here. Will the table being copied to have the same constraints in place as those tables from which the data is being extracted? If so, resolves those, and get these reference tables in place first. Then simply use a database link to 'pull' the data from your source tables, eg insert into USERNAME.COPY_TABLE select * from USERNAME.SOURCE_TABLE@DATABASE_LINK where... ; Of course, make sure the owner of the copy tables has select on the source tables. peter edinburgh Hi, what's the best method to move some rows of some tables of a user from one database to another database on another server? I need a step by step document to achieve this. Thanks, Murat -- Bu e-posta sadece yukarida isimleri belirtilen kisiler arasinda ozel haberlesme amacini tasimaktadir. Size yanlislikla ulasmissa lutfen mesaji geri gonderiniz ve sisteminizden siliniz. Rt.Net Internet Hizmetleri Pazarlama ve Ticaret A.S. bu mesajin icerigi ile ilgili olarak hic bir hukuksal sorumlulugu kabul etmez. This e-mail communication is intended for the private use of the persons named above. If you received this message in error, please immediately notify the sender and delete it from your system. Rt.Net Internet Hizmetleri Pazarlama ve Ticaret A.S. does not accept legal responsibility for the contents of this message. -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MURAT BALKAS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: UKOUG Meet.
Hi All, I remember that a number of people were all for getting together on the Monday night at the UKOUG. I *don't* remember us actually arranging a place/time.. ;) Is there any chance of another show of hands so that we can see if we'll need to book a table or not. And has *anybody* had any thoughts on a place at all? See you all soon! Mark Count me in. Not familiar enough with Brum to suggest a place, though. Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
oracle precompiler in O 9.2
hello to everybody I'm desperately looking for precompiler e.g. proc in the installation of O 9.2. can't find libproc2.a is the message when I try do creat. doesn't seem to be an installation issue, because no kind of installation offers the(se) file(s). precompilers did exist in 9.0.1 - but they don't exist any more in 9.2.0 neither SunOS nor LINUX. has anybody any idea? thanks in advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 9i database create script - My, how things have changed
Some simple options: 1) The 9.x installer still gives the option of creating scripts in the old fashioned way. The key is not to choose a template database. A little scrubbing and they work fine...but man do they take a while to create a db nowadays. 2) My preferred option is to create a skeleton db with just system/undo/temp/pfile (using the installer or otherwise) and get everything just right. Then zip it up with the text of a create controlfile and voila! You have a db ready to go - whenever you need a new one, you just unzip, hack the controlfile to rename it and bingo...super quick and be definition, all your databases have the same basic starting point hth connor --- Jeremy Pulcifer [EMAIL PROTECTED] wrote: ...since 8.1.7. I've always ran the database creation utility, then swiped the scripts outta the admin\[sid]\create\ directory, scrubbed 'em a bit, and let er rip. My consultants create/install new db's quite frequently, and the 8.1.7 *.bat's work quite well for 'em. However, as I'm sure you've all figgered out already, this don't work no mo. I've taken some cursory rambles thru orafaq, but came out more confused than I came in. I don't want to rely on installing perl or Oracle DCA on each machine, as the consultants I'm supporting aren't going to be too keen on having to go from their current hit the .bat and wait til it says all done MO. So, I'm sure a solution or twenty has been put together for NT/Windows. Care to share? I'm sure I could re-invent this particular wheel, but my boss keeps hollering at me for stuff that I'm actually supposed to produce, so If'n I can turn this one around in a reasonable time, I'd be much abliged. = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
image storage confusion ??
Guys , i posted this already and this time my question is a bit different . I have to store 20,000,000 images of 5k each either in DB ( on win2k) or linux o/s file system. the images are to be displayed over mobile phones.so the time to retrieve the images should be minimum. for this to be achieved , i am confused , whether the images should be stored in o/s file system or in the DB ? --selecting a file from linux o/s file system --- or --querying it from oracle DB ( on win2k) --- which of the above will be faster ? all these will be done with java . this being condition , i would like to know ur suggestion guys. my DB is oracle 8.1.6 on Win2k. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: UKOUG Meet.
Count me in on this, Mark - As for a 'table' - presupposes a venue in which to find said article of furniture...(!) no idea on that, but there are places out the back of the ICC as I recall which might be suitable. peter edinburgh -Original Message- From: Mark Leith [mailto:[EMAIL PROTECTED]] Sent: 03 December 2002 09:59 To: Multiple recipients of list ORACLE-L Subject: UKOUG Meet. Hi All, I remember that a number of people were all for getting together on the Monday night at the UKOUG. I *don't* remember us actually arranging a place/time.. ;) Is there any chance of another show of hands so that we can see if we'll need to book a table or not. And has *anybody* had any thoughts on a place at all? See you all soon! Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: process memory utilization
chao_ping, It seems i am posting a too long question, so nobody is interested. I post the answer to my second question, to check the memory utilization in linux operation system. It is in /proc/spid/status file. Regards zhu chao Eachnet DBA 86-21-32174588-667 [EMAIL PROTECTED] www.cnoug.org(Chinese Oracle User Group) === 2002-12-02 08:34:00 ,you wrote£º=== Hi,dba friends: I am thinking of measure how much memory per connection used, from the os viewpoint and oracle viewpoint. And this is my result from my production server, and i have some questions below. 23:56:28 SQL select sum(value),sum(value)/count(distinct sid) average from v$sesstat where statistic#=15; --uga SUM(VALUE) AVERAGE 69,098,528 145,777 23:58:09 SQLselect sum(value),sum(value)/count(distinct sid),max(value) from v$sesstat where statistic#=20 --pga SUM(VALUE) SUM(VALUE)/COUNT(DISTINCTSID) MAX(VALUE) - 265,290,648559,684.9117,510,184 There is about my production server(oracle817+solaris7), and I also used pmap to trace some process and it look like: oracle@main-db1$pmap 11443 #some process id i which is choosed randomly via /usr/ucb/ps -aux. 11443: oraclebiddb (LOCAL=NO) 0001 29440K read/exec /export/home/oracle/app/product/8.1.7/bin/oracle 000101DBE000464K read/write/exec /export/home/oracle/app/product/8.1.7/bin/oracle 000101E32000 1440K read/write/exec [ heap ] 00038000 5685720K read/write/exec/shared [ shmid=0x65 ] 7D80 16K read/exec /usr/lib/sparcv9/libmp.so.2 7D902000 8K read/write/exec /usr/lib/sparcv9/libmp.so.2 7DA0 88K read/exec /usr/lib/sparcv9/libm.so.1 7DB14000 16K read/write/exec /usr/lib/sparcv9/libm.so.1 7DC0 8K read/exec /usr/lib/sparcv9/libkstat.so.1 7DD0 8K read/write/exec /usr/lib/sparcv9/libkstat.so.1 7DE0 32K read/exec /usr/lib/sparcv9/librt.so.1 7DF06000 8K read/write/exec /usr/lib/sparcv9/librt.so.1 7E00 24K read/exec /usr/lib/sparcv9/libaio.so.1 7E104000 16K read/write/exec /usr/lib/sparcv9/libaio.so.1 7E20704K read/exec /usr/lib/sparcv9/libc.so.1 7E3AE000 64K read/write/exec /usr/lib/sparcv9/libc.so.1 7E3BE000 8K read/write/exec [ anon ] 7E40 8K read/exec /usr/lib/sparcv9/libsched.so.1 7E50 8K read/write/exec /usr/lib/sparcv9/libsched.so.1 7E60 32K read/exec /usr/lib/sparcv9/libgen.so.1 7E706000 8K read/write/exec /usr/lib/sparcv9/libgen.so.1 7E80 40K read/exec /usr/lib/sparcv9/libsocket.so.1 7E908000 16K read/write/exec /usr/lib/sparcv9/libsocket.so.1 7EA0624K read/exec /usr/lib/sparcv9/libnsl.so.1 7EB9A000 64K read/write/exec /usr/lib/sparcv9/libnsl.so.1 7EBAA000 32K read/write/exec [ anon ] 7EC0 3896K read/exec /export/home/oracle/app/product/8.1.7/lib/libjox8.so 7F0CC000192K read/write/exec /export/home/oracle/app/product/8.1.7/lib/libjox8.so 7F0FC000 8K read/write/exec [ anon ] 7F30 40K read/exec /export/home/oracle/app/product/8.1.7/lib64/libdsbtsh8.so 7F408000 8K read/write/exec /export/home/oracle/app/product/8.1.7/lib64/libdsbtsh8.so 7F40A000 8K read/write/exec [ anon ] 7F50 8K read/exec /export/home/oracle/app/product/8.1.7/lib64/libskgxp8.so 7F60 8K read/write/exec /export/home/oracle/app/product/8.1.7/lib64/libskgxp8.so 7F68128K read/exec /usr/lib/sparcv9/ld.so.1 7F79 16K read/exec /usr/platform/sun4u/lib/sparcv9/libc_psr.so.1 7F79E000 8K read/write/exec /usr/lib/sparcv9/ld.so.1 7F7A 8K read/write/exec [ anon ] 7F7B 8K read/write/exec [ anon ] 7F7C 8K read/write/exec [ anon ] 7F7D 8K read/write/exec/shared [ anon ] 7F7E 8K read/write/exec [ anon ] 7F7F 8K read/exec /usr/lib/sparcv9/libdl.so.1 7FFEE000 72K read/write [ stack ] total 5723336K and i compared it with oracle statistics: 00:11:59 SQL @whoisit 00:12:02 SQL col machine format a30 00:12:02 SQL col program format a40 00:12:02 SQL set line 200 00:12:02 SQL select sid,serial# ,username,osuser,machine,program,process,to_char(logon_time,'/mm/dd hh24:mi:ss') 00:12:02 2 from v$session where paddr in( 00:12:02 3 select addr from v$process where spid in(spid)); Enter
OMF question
Hi ! I 've a question regarding OMF realted parameter CREATE_DB_ONLINE_LOG_N. Now y is'nt this parameter mentioned in the list of parameters in the Oracle Documenttion cd of 9i. Is it obsolete or oracle does not recommend it's use. regards Tc
RE: error 472
Ora-472 is a very non-specific PMON error. You've probably already worked
through this with support using a TAR, but if you still are having problems and
wanted to post the following it would help:
The stack trace from your pmon traces (they'll either be in bdump or udump, and by
stack trace I mean just the section of the trace near the beginning with lines like
this:
- Call Stack Trace -
calling call entryargument values in hex
location type point(? means dubious value)
ssexhd + 256 ksedst 1D15 ? 0 ? A ? 0 ?
ssexhd +8 ssexhd 7F7F8678 ? 4011CA78 ?
4011E170 ? 4011CAE8 ?
Adr: 0xC01D072C Adr: 0xC020FE10 7F7F82C0 ? 55 ? 400FE9A0 ?
400F4B38 ?
nioqrc + 596 Adr: 0xC01D072C 7F7F82C0 ? 55 ? 400FE9A0 ?
400F4B38 ?
nioqrc +8 nioqrc 400EF530 ? 47 ? 7F7F6B44 ?
The version of the RDBMS, OS, etc.
Regards,
Chris Gait
On 22 Nov 2002 at 10:19, April Wells wrote:
Date sent: Fri, 22 Nov 2002 10:19:18 -0800
To: Multiple recipients of list ORACLE-L ORACLE-
[EMAIL PROTECTED]
Send reply to: [EMAIL PROTECTED]
Organization: Fat City Network Services, San Diego, California
There is nothing vaguely resembling anything helpful in either the core dump
or the PMON file. That is where the boat load of metalink docs say to
start, but there is nothing in there that is in any way indicative of what
is going on.
Driving me nuts! There is no real commonality in when it crashes.
April Wells
Oracle DBA
Great spirits have always encountered violent opposition from mediocre minds
-- Albert Einstein
-Original Message-
Sent: Friday, November 22, 2002 11:59 AM
To: Multiple recipients of list ORACLE-L
Did you look in the PMON trace file? Does anything appear there that might
shed some light on the problem?
RF
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author of several Oracle books you can find on Amazon.com!
Londo Mollari: Ah, arrogance and stupidity all in the same package. How
efficient of you.
-Original Message-
Sent: Friday, November 22, 2002 11:59 AM
To: Multiple recipients of list ORACLE-L
I have cloned an 8.1.7.0 database from another instance (clone doc from
metalink for Apps) on AIX 4.3.3. I don't THINK this is connected to the
clone or (directly) to apps.
Since I brought the database back up after the clone successfully, it keeps
crashing with pick a process terminating instance due to error 472
It comes back when I start it.
The interval between startup and crash appears arbitrary.
What can be accomplished while the database is up is logical stuff... I can
run apps jobs, I can update and select from tables, I can do ddl, I can
manually log switch.
Metalink has BOAT LOADS of docs on this happening, but I haven't found
anything that I am permitted to see that has a resolution. I have an Itar,
but that is not yet yielding any information.
Has anyone seen similar problems, and (if so) IS there a resolution?
Thanks in advance for any advice
ajw
April Wells
Oracle DBA
Great spirits have always encountered violent opposition from mediocre minds
-- Albert Einstein
begin 666 InterScan_Disclaimer.txt
M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(-O;6UU;FEC871I
M;VXL(EN8VQU9EN9R!A='1A8VAM96YTRP@:7,@W1R:6-T;'D@8V]N9FED
M96YT:6%L(%N9!F;W(@=AE(EN=5N95D('5S92!O9B!T:4@861DF5S
MV5E(]N;'D[(ET(UA2!A;'-O(-O;G1A:6X@')O')I971AGDL('!R
M:6-E('-E;G-I=EV92P@;W(@;5G86QL2!PFEV:6QE9V5D(EN9F]R;6%T
M:6]N+B!.;W1I8V4@:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-U
MF4L(1IW1R:6)U=EO;BP@9ESV5M:6YA=EO;BP@=7-E+!OB!C;W!Y
M:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA;B!T
M:4@:6YT96YD960@F5C:7!I96YT(ES('-TFEC=QY('!R;VAI8FET960@
M86YD(UA2!B92!I;QE9V%L+B!)9B!Y;W4@:%V92!R96-E:79E9!T:ES
M(-O;6UU;FEC871I;VX@:6X@97)R;W(L('!L96%S92!N;W1I9GD@=AE('-E
M;F1EB!I;6UE9EA=5L2!B2!R97!L2!E+6UA:6PL(1E;5T92!T:ES
M(-O;6UU;FEC871I;VXL(%N9!D97-TF]Y(%L;!C;W!I97,N( T*#0I#
M;W)P;W)A=4@4WES=5MRP@26YC+B!H87,@=%K96X@F5AV]N86)L92!P
MF5C875T:6]NR!T;R!E;G-UF4@=AA=!A;GD@871T86-H;65N=!T;R!T
M:ES(4M;6%I;!H87,@8F5E;B!S=V5P=!F;W(@=FER=7-ERX@5V4@W!E
M8VEF:6-A;QY(1IV-L86EM(%L;!L:6%B:6QI='D@86YD('=I;P@86-C
M97!T(YO(')EW!O;G-I8FEL:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE
M9!AR!A(')EW5L=!O9B!S;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@
M6]U('1O(-AG)Y(]U=!Y;W5R(]W;B!V:7)UR!C:5C:W,@8F5F;W)E
M(]P96YI;F@86YY(%T=%C:UE;G0N#0H-E1H92!I;F9OFUA=EO;B!C
M;VYT86EN960@:6X@=AIR!C;VUM=6YI8V%T:6]N+!I;F-L=61I;F@871T
RE: UKOUG Meet.
Mark, yes, I'll be there and Monday night is fine. I don't know the area at all so can't suggest venues but I'm not choosy regarding food so anywhere should do for me. Cheers, Mike -Original Message- Sent: 03 December 2002 09:59 To: Multiple recipients of list ORACLE-L Hi All, I remember that a number of people were all for getting together on the Monday night at the UKOUG. I *don't* remember us actually arranging a place/time.. ;) Is there any chance of another show of hands so that we can see if we'll need to book a table or not. And has *anybody* had any thoughts on a place at all? See you all soon! Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE:
I don't know whether people do it on purpose or they are still unaware after so many similar postings of the same nature and replies of 'ARE YOU AN IDIOT', but it does result in a plethora of responses which create unnecessary hassles. Jared, why not parse messages for these commands and send the reply back to the postersimilar towhat is done with the vacation Auto-reply messages? Regards Naveen -Original Message-From: Tinu !@#!^% [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 03, 2002 4:59 PMTo: Multiple recipients of list ORACLE-LSubject: HELP
RE:
Must.. resist urge... -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tinu !@#!^%Sent: 03 December 2002 11:29To: Multiple recipients of list ORACLE-LSubject: HELP
[no subject]
HELP
RE: process memory utilization
I posted a similar question recently and whilst I received some answers I never did discover an exact way of matching oracle use of memory with unix use of memory. One issue is that when oracle releases memory the unix process does not automatically do the same until the memory is required. Therefore it is likely that there will always be a difference. Tim Gorman pointed me to a script oramem.sh (www.evdbt.com/tools.htm) which does what you are doing with a pmap function which is quite useful The discussion was around 4/10/02 and the thread title was How much memory is an oracle shadow process using John -Original Message- Sent: 03 December 2002 11:29 To: Multiple recipients of list ORACLE-L chao_ping, It seems i am posting a too long question, so nobody is interested. I post the answer to my second question, to check the memory utilization in linux operation system. It is in /proc/spid/status file. Regards zhu chao Eachnet DBA 86-21-32174588-667 [EMAIL PROTECTED] www.cnoug.org(Chinese Oracle User Group) === 2002-12-02 08:34:00 ,you wrote£º=== Hi,dba friends: I am thinking of measure how much memory per connection used, from the os viewpoint and oracle viewpoint. And this is my result from my production server, and i have some questions below. 23:56:28 SQL select sum(value),sum(value)/count(distinct sid) average from v$sesstat where statistic#=15; --uga SUM(VALUE) AVERAGE 69,098,528 145,777 23:58:09 SQLselect sum(value),sum(value)/count(distinct sid),max(value) from v$sesstat where statistic#=20 --pga SUM(VALUE) SUM(VALUE)/COUNT(DISTINCTSID) MAX(VALUE) - 265,290,648559,684.9117,510,184 There is about my production server(oracle817+solaris7), and I also used pmap to trace some process and it look like: oracle@main-db1$pmap 11443 #some process id i which is choosed randomly via /usr/ucb/ps -aux. 11443: oraclebiddb (LOCAL=NO) 0001 29440K read/exec /export/home/oracle/app/product/8.1.7/bin/oracle 000101DBE000464K read/write/exec /export/home/oracle/app/product/8.1.7/bin/oracle 000101E32000 1440K read/write/exec [ heap ] 00038000 5685720K read/write/exec/shared [ shmid=0x65 ] 7D80 16K read/exec /usr/lib/sparcv9/libmp.so.2 7D902000 8K read/write/exec /usr/lib/sparcv9/libmp.so.2 7DA0 88K read/exec /usr/lib/sparcv9/libm.so.1 7DB14000 16K read/write/exec /usr/lib/sparcv9/libm.so.1 7DC0 8K read/exec /usr/lib/sparcv9/libkstat.so.1 7DD0 8K read/write/exec /usr/lib/sparcv9/libkstat.so.1 7DE0 32K read/exec /usr/lib/sparcv9/librt.so.1 7DF06000 8K read/write/exec /usr/lib/sparcv9/librt.so.1 7E00 24K read/exec /usr/lib/sparcv9/libaio.so.1 7E104000 16K read/write/exec /usr/lib/sparcv9/libaio.so.1 7E20704K read/exec /usr/lib/sparcv9/libc.so.1 7E3AE000 64K read/write/exec /usr/lib/sparcv9/libc.so.1 7E3BE000 8K read/write/exec [ anon ] 7E40 8K read/exec /usr/lib/sparcv9/libsched.so.1 7E50 8K read/write/exec /usr/lib/sparcv9/libsched.so.1 7E60 32K read/exec /usr/lib/sparcv9/libgen.so.1 7E706000 8K read/write/exec /usr/lib/sparcv9/libgen.so.1 7E80 40K read/exec /usr/lib/sparcv9/libsocket.so.1 7E908000 16K read/write/exec /usr/lib/sparcv9/libsocket.so.1 7EA0624K read/exec /usr/lib/sparcv9/libnsl.so.1 7EB9A000 64K read/write/exec /usr/lib/sparcv9/libnsl.so.1 7EBAA000 32K read/write/exec [ anon ] 7EC0 3896K read/exec /export/home/oracle/app/product/8.1.7/lib/libjox8.so 7F0CC000192K read/write/exec /export/home/oracle/app/product/8.1.7/lib/libjox8.so 7F0FC000 8K read/write/exec [ anon ] 7F30 40K read/exec /export/home/oracle/app/product/8.1.7/lib64/libdsbtsh8.so 7F408000 8K read/write/exec /export/home/oracle/app/product/8.1.7/lib64/libdsbtsh8.so 7F40A000 8K read/write/exec [ anon ] 7F50 8K read/exec /export/home/oracle/app/product/8.1.7/lib64/libskgxp8.so 7F60 8K read/write/exec /export/home/oracle/app/product/8.1.7/lib64/libskgxp8.so 7F68128K read/exec /usr/lib/sparcv9/ld.so.1 7F79 16K read/exec /usr/platform/sun4u/lib/sparcv9/libc_psr.so.1 7F79E000 8K read/write/exec /usr/lib/sparcv9/ld.so.1 7F7A 8K read/write/exec [ anon ] 7F7B 8K read/write/exec [ anon ] 7F7C 8K read/write/exec [ anon ] 7F7D
RE: OMF question
There is a OMF related parameter called db_create_online_log_dest_n. This defines where the online redo logs are created. The value n can vary from 1 to 5 and it allows for upto 5 multiplexed copies opf each redo log group member. HTH John -Original Message- Sent: 03 December 2002 11:29 To: Multiple recipients of list ORACLE-L Hi ! I 've a question regarding OMF realted parameter CREATE_DB_ONLINE_LOG_N. Now y is'nt this parameter mentioned in the list of parameters in the Oracle Documenttion cd of 9i. Is it obsolete or oracle does not recommend it's use. regards Tc -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: image storage confusion ??
Managing 20mil of anything (images/text/etc) in a file system isn't a nice proposition. Go with the database hth connor --- oraora oraora [EMAIL PROTECTED] wrote: Guys , i posted this already and this time my question is a bit different . I have to store 20,000,000 images of 5k each either in DB ( on win2k) or linux o/s file system. the images are to be displayed over mobile phones.so the time to retrieve the images should be minimum. for this to be achieved , i am confused , whether the images should be stored in o/s file system or in the DB ? --selecting a file from linux o/s file system --- or --querying it from oracle DB ( on win2k) --- which of the above will be faster ? all these will be done with java . this being condition , i would like to know ur suggestion guys. my DB is oracle 8.1.6 on Win2k. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OMF question
Its in the 9.2 doco hth connor --- Tinu !@#!^% [EMAIL PROTECTED] wrote: Hi ! I 've a question regarding OMF realted parameter CREATE_DB_ONLINE_LOG_N. Now y is'nt this parameter mentioned in the list of parameters in the Oracle Documenttion cd of 9i. Is it obsolete or oracle does not recommend it's use. regards Tc = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OMF question
John , I meant the same param.apologies ,i misplaced db and create. Is this parameter obsolete (with 9i) coz its not mentioned in the Documentation (9i) list of initialization parameters. Only db_create_file_dest is present in the doc. Thanx ! best regards Tc On Tue, 3 Dec 2002 [EMAIL PROTECTED] wrote: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Apps 11i on Red Hat 8.0
installed O92010 on rh 8.0. went fine so far until I tried to connect via oemapp console - whatever connectdescripter I chose in resulted in the error string not properly terminated. same connect descriptors in the CLI worked fine - made them available in the oemapp console and got the error message. didn't investigate any further into this - experienced it twice on two different machines. changed back to rh7.2 and things were fine again. thats all I can contribute. kr [EMAIL PROTECTED] 12/02/02 21:16 PM Anyone care to share any experiences installing Apps 11i release 7 on RH 8.0? I'm about to give it a go in the next couple of days - and would appreciate hearing about your experiences. I note that SUSE 7.1 seems to be the only officially certified distro. H. Oracle Trivia Question: If you order the Oracle Apps 11i Release 7 suite from Oracle how many CD's do you get? Answer: 54 (yes thats right, fifty four CD's) - the mind boggles. No wonder they don't let you download the thing :-) Regards Dale Edgar Net 2000 Ltd. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
which bind variable value causes ora-1722
Hi, all, My developer continually got ora-1722 when he was installing a new billing system. I used 10046 event to get trace file, but i could not figure out which bind variable value causes the error, here is the part of trace: PARSING IN CURSOR #1 len=229 dep=0 uid=62 oct=2 lid=62 tim=807252370 hv=4084410285 ad='9f31e880' insert into fold_bal_impacts_t ( element_id, fixed_operand, flags, free_quantity, gl_id, scaled_operand, rec_id, obj_id0 ) values ( :element_id, :fixed_operand, :flags, :free_quantity, :gl_id, :scaled_operand, :rec_id, :obj_id0 ) END OF STMT PARSE #1:c=0,e=1,p=0,cr=1,cu=0,mis=1,r=0,dep=0,og=0,tim=807252370 BINDS #1: bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=01 oacfl2=0 size=224 offset=0 bfp=018bacd0 bln=22 avl=03 flg=05 value=250 bind 1: dty=1 mxl=32(01) mal=00 scl=00 pre=00 oacflg=01 oacfl2=10 size=0 offset=24 bfp=018bace8 bln=32 avl=01 flg=01 value=0 bind 2: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=01 oacfl2=0 size=0 offset=56 bfp=018bad08 bln=22 avl=01 flg=01 value=0 bind 3: dty=1 mxl=32(01) mal=00 scl=00 pre=00 oacflg=01 oacfl2=10 size=0 offset=80 bfp=018bad20 bln=32 avl=01 flg=01 value=0 bind 4: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=01 oacfl2=0 size=0 offset=112 bfp=018bad40 bln=22 avl=01 flg=01 value=0 bind 5: dty=1 mxl=32(07) mal=00 scl=00 pre=00 oacflg=01 oacfl2=10 size=0 offset=136 bfp=018bad58 bln=32 avl=07 flg=01 value=6.55802 bind 6: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=01 oacfl2=0 size=0 offset=168 bfp=018bad78 bln=22 avl=01 flg=01 value=0 bind 7: dty=1 mxl=32(05) mal=00 scl=00 pre=00 oacflg=01 oacfl2=10 size=0 offset=192 bfp=018bad90 bln=32 avl=05 flg=01 value=10382 EXEC #1:c=0,e=0,p=0,cr=0,cu=2,mis=0,r=0,dep=0,og=3,tim=807252370 ERROR #1:err=1722 tim=807252370 And here is the table: SQLdesc fold_bal_impacts_t NameNull?Type --- OBJ_ID0 NUMBER(38) REC_ID NUMBER(38) ELEMENT_ID NUMBER(38) FIXED_OPERANDNUMBER FLAGSNUMBER(38) FREE_QUANTITYNUMBER GL_IDNUMBER(38) SCALED_OPERAND NUMBER And there is no any constraints on this table. Please help, thanks. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mike ding INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-1653: unable to extend table - Why?
Ron, Good idea, but DEGREE=1 There are two indexes, but they are in a different tablespace (which has plenty of free space available and did not give an error). Next extent size is 25M but, as mentioned, it shouldn't have needed a new extent. I'm still at a loss... Jay -Original Message- Sent: Monday, December 02, 2002 6:14 PM To: Multiple recipients of list ORACLE-L One thing I haven't seen mentioned yet is what degree of parallelism is defined for the table? What is the next extent size set to? If the table is paralleled, EACH parallel worker will grab a next extent sized segment. (Been bit by this a few times...) How many indexes and are they in the same tablespace? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan JayMiller@TDWater house.comTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: ORA-1653: unable to extend table - Why? 12/02/2002 02:04 PM Please respond to ORACLE-L Yep, I agree that coalescing is irrelevant in my current situation. In any event there was no free space until I added the additional datafile but there was the 8gig of space on the freelists. Jay -Original Message- Sent: Friday, November 29, 2002 8:54 PM To: Multiple recipients of list ORACLE-L Richard, if pctincrease is zero, and there are a large number of contiguous smaller extents, SMON will not automatically coalesce the tablespace. However, whether or not SMON does an automatic coalesce, if you need an extent that is larger than any of the small ones, Oracle will coalesce those smaller extents to make the one you need. so Jay would not have needed to add a datafile no matter what, if he was not doing a direct path insert. As for meeting in person there is a user group meeting on Dec 12 (check www.nyoug.org for details). You can meet me, and more importantly you can meet Tim Gorman, Dan Fink, Arup Nanda and Anita Bardeen, also of this list. They are all presenting :) I saw Priscilla about a month ago, haven't talked with her since. Rachel --- Richard Ji [EMAIL PROTECTED] wrote: Rachel, What I mean to say is when there are a lot of contiguous smaller free extents. Then coalesce will produce a larger free extent so Jay wouldn't have to add a datafile for his table to grow. On the automatically coalescing part, I believe SMON will only coalesce when pctincrease != 0, or has that changed? My understand could be outdated. With LMT one doesn't have to worry about it. Have a Happy Thanksgiving. PS, I am in New York too, would love to meet you in person some time. Have you talked to Priscilla lately? Richard Ji -Original Message- Sent: Friday, November 29, 2002 5:29 PM To: Multiple recipients of list ORACLE-L how would coalescing help even if there were a lot of smaller free extents? Oracle would do the coalesce automatically, there would be no difference between manually coalescing or allowing Oracle to do it when a new extent was needed. --- Richard Ji [EMAIL PROTECTED] wrote: Coalescing might help if there are many smaller free extents that can be coalesced. But that still doesn't solve Jay's problem. Because he doesn't want the table to extent at all since he just deleted 2 million rows so there are plenty of space within the segment itself. Those free blocks should be used, unless he is doing a direct path insert which will only use space above the HWM. Richard Ji -Original Message- Sent: Friday, November 29, 2002 2:05 PM To: Multiple recipients of list ORACLE-L did u coalesced the tablespaces? -Original Message- Sent: sexta-feira, 29 de Novembro de 2002 17:59 To: Multiple recipients of list ORACLE-L Okay, I can't figure this one out. Earlier this week I got an ORA-1653: unable to extend table on a really big table. However this was just after I had deleted over 2 million rows in the table and we were only inserting 30,000. After reanalyzing the table I saw the following stats in DBA_TABLES: num_freelist_blocks: 2266966 avg_space_freelist_blocks: 3895 Unless I'm misreading this I should have had over 8Gig available for inserts. We tried the insert again and got the same error so I added a datafile and it went through (using about 40Meg of space in the new datafile). Why isn't it making use of the existing blocks on the freelist? Oracle 8.1.7.2 Solaris 2.6 PCTFREE = 10 PCTUSED = 75 Block Size = 4K Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051
Re: image storage confusion ??
Connor, I seem to think otherwise. Storing 100 GB of image is not necessarily a pretty proposition either when you consider hot backups and archived log generation, etc. I presume you are concerned about the management of the image files considering the sheer volume of it. But that's precisely what BFILE is expected to help with. The images are in a file ssytem and the pointers are in the database and that's managed pretty well. However I do concede tht this might pose a problem on two fronts - (1) Security - beign on filesystem anyone can potentially see these. However this is not necesarily a concern at all sites. Good OS security can prevent this. (2) Backup - the ssy admin has to explicitly backup all these files. This, again, may not be that bad when you store your files on a single filesystem and a backup software can be easily programmed to check only the changed files, based on timestamp. Just my two cents. Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 03, 2002 7:39 AM Managing 20mil of anything (images/text/etc) in a file system isn't a nice proposition. Go with the database hth connor --- oraora oraora [EMAIL PROTECTED] wrote: Guys , i posted this already and this time my question is a bit different . I have to store 20,000,000 images of 5k each either in DB ( on win2k) or linux o/s file system. the images are to be displayed over mobile phones.so the time to retrieve the images should be minimum. for this to be achieved , i am confused , whether the images should be stored in o/s file system or in the DB ? --selecting a file from linux o/s file system --- or --querying it from oracle DB ( on win2k) --- which of the above will be faster ? all these will be done with java . this being condition , i would like to know ur suggestion guys. my DB is oracle 8.1.6 on Win2k. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle precompiler in O 9.2
If PreCompilers were installed, check in $ORACLE_HOME/precomp/lib* directories. Also, check your path, ld library path. Here's what I get (9iR2 on HP-UX). /u01/home/oracle/product/9.2.0 hp102 [KED9]: find . -name libproc2.a -print ./precomp/lib32/libproc2.a ./precomp/lib/libproc2.a - Kirti -Original Message- Sent: Tuesday, December 03, 2002 4:44 AM To: Multiple recipients of list ORACLE-L hello to everybody I'm desperately looking for precompiler e.g. proc in the installation of O 9.2. can't find libproc2.a is the message when I try do creat. doesn't seem to be an installation issue, because no kind of installation offers the(se) file(s). precompilers did exist in 9.0.1 - but they don't exist any more in 9.2.0 neither SunOS nor LINUX. has anybody any idea? thanks in advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle precompiler in O 9.2
Title: RE: oracle precompiler in O 9.2 SQL exit Disconnected from Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options JServer Release 9.2.0.2.0 - Production oraclei@elara-ABC1 oraclei@elara-ABC1 which proc /usr/opt/oracle/current/bin/proc 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- From: Markus Reger [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 5:44 AM To: Multiple recipients of list ORACLE-L Subject: oracle precompiler in O 9.2 hello to everybody I'm desperately looking for precompiler e.g. proc in the installation of O 9.2. can't find libproc2.a is the message when I try do creat. doesn't seem to be an installation issue, because no kind of installation offers the(se) file(s). precompilers did exist in 9.0.1 - but they don't exist any more in 9.2.0 neither SunOS nor LINUX. has anybody any idea? thanks in advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
RE: SLA Trigger/Procedure
For reasons too long to go in to, go buy a tool is not a good option for my purposes. Besides, why buy what I can build? These are exactly the sort of challenges that make my job worth coming to. Thanks, Ethan -Original Message- Sent: Tuesday, December 03, 2002 4:14 AM To: Multiple recipients of list ORACLE-L Yup, got that covered :) If I may add another point. When dealing with SLA's, you not only have to show that the database has been servicing users that are connected (showing database uptime), but also that users can also *connect* to the database as well (the listener is servicing requests). If you were to go about this with a trigger/procedure that inserts in to a table, then this doesn't show that the database was available to everybody. Typically what we do with monitoring tools is a connect on ping, so when we are checking availability of a database we do a full connect, then select 'PING' from dual;. If there are any errors along the way we search for the error code, and deal with the appropriate alerts (TNS = Listener problem, ORA = Database problem). Of course, the problem with doing it this way, is that you are going to have to write platform dependant scripts (batches for NT, shell type scripts for Unix), and not have a one for all with a database based solution. Go buy a tool. Let it write to a table/file, alert you AND make the coffee for when you get there! ;) Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance the message BODY, include a line containing: UNSUB ORACLE-L (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: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SLA Trigger/Procedure
Title: RE: SLA Trigger/Procedure Go buy a tool? Here is an idea instead ... Write a small Perl (pick your favorite language here) script that looks at /etc/oratab followed by a check to see if each of the instances listed in /etc/oratab is up on the side where it is checking. It then log in as a schema (we call it) called heartbeat, insert a row into a table with sysdate. Wait 3 seconds, retrieve the row and checks the time difference. If it is more than 5 seconds, you have a potential delay somewhere and have it alert appropriate people. (If it is night, page your VP with This is your heartbeat calling ... we have a problem ...) Life is great with cron ... HTH 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! 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 database create script - My, how things have changed
Title: 9i database create script - My, how things have changed I followed the same procedure as 8.1.7 to make the scripts and modified them What part does not work, no mo ? -Original Message-From: Jeremy Pulcifer [mailto:[EMAIL PROTECTED]]Sent: Monday, December 02, 2002 15:54To: Multiple recipients of list ORACLE-LSubject: 9i database create script - My, how things have changed ...since 8.1.7. I've always ran the database creation utility, then swiped the scripts outta the admin\[sid]\create\ directory, scrubbed 'em a bit, and let er rip. My consultants create/install new db's quite frequently, and the 8.1.7 *.bat's work quite well for 'em. However, as I'm sure you've all figgered out already, this don't work no mo. I've taken some cursory rambles thru orafaq, but came out more confused than I came in. I don't want to rely on installing perl or Oracle DCA on each machine, as the consultants I'm supporting aren't going to be too keen on having to go from their current "hit the .bat and wait til it says all done" MO. So, I'm sure a solution or twenty has been put together for NT/Windows. Care to share? I'm sure I could re-invent this particular wheel, but my boss keeps hollering at me for stuff that I'm actually supposed to produce, so If'n I can turn this one around in a reasonable time, I'd be much abliged.
RE: oracle precompiler in O 9.2
The ORACLE_HOME is /usr/opt/oracle/current ? I have read of /usr/opt being used, [although I generally use /u0x/app or /oracle/app or /orasys/app depending on the standard' at the site] but not current -- I generally still use [the OFA standard] ./product/Version.Release.MaintenanceRelease Hemant At 06:32 AM 03-12-02 -0800, you wrote: SQL exit Disconnected from Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options JServer Release 9.2.0.2.0 - Production oraclei@elara-ABC1 oraclei@elara-ABC1 which proc /usr/opt/oracle/current/bin/proc 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- From: Markus Reger [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 5:44 AM To: Multiple recipients of list ORACLE-L Subject: oracle precompiler in O 9.2 hello to everybody I'm desperately looking for precompiler e.g. proc in the installation of O 9.2. can't find libproc2.a is the message when I try do creat. doesn't seem to be an installation issue, because no kind of installation offers the(se) file(s). precompilers did exist in 9.0.1 - but they don't exist any more in 9.2.0 neither SunOS nor LINUX. has anybody any idea? thanks in advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
FW: UKOUG Meet.
Hi all, After with some deliberation with Peter Robson, we've come to a decision (I think!) ;) Please see below (a cba to type it all again ;P). Basics, meet up at around 7 (which is when the reception *starts* to see if we can all get together for the party as well. If we can't all get in, the non-attendees will go to a pub behind the ICC (first on the right at the top of the stairs over the canal bridge), and wait for the rest to arrive later. What'ya think? Ta Mark -Original Message- Sent: 03 December 2002 14:59 To: '[EMAIL PROTECTED]' Mark - That looks good to me ... Quick points Hi Peter, Sounds good to me. If we say in the foyer, where registrations take place (at the top of the escalators), and just look for the ever growing group of shifty characters :) Looking at the Conference Agenda that's been sent through, it says that the Welcome Drinks Reception and Party starts at 18:55 - Late. Gerry and I are only attending the conference on Monday, so are going on the Free conference pass as well. Not sure whether this means they will dole Yes, my position too. Do you have a stand here this year? If so, obviously you get in during the evening. If not, then we may have to blag our way. Which could be difficult for 250 people... ! the booze out to us either (we can always *try* ;P). It may be the case that those that aren't on a full pass go over first to get on their merry way, and the ones attending the welcome party join after a while.. I guess that will have to be an on-site decision. For a place, as you suggested the best area is probably behind the ICC at one of the bar/cafes there. I'm thinking the one at the top of the steps from the bridge, on the right hand side (a bar that has some good sized wooden tables, for a group to sit around. I can't for the life of me remember the name of it at the moment though.. Then it is indeed the very place I recall from two years ago, and ideal with those big tables. Yes, lets go there. So, meet at 7:00pm at the conference registration area. Bar over the canal at the top of the steps on the right, meeting times through the evening if need be, though we may all be able to wing it in to the main hall for a while in the evening.. Shall we copy this in to the list? Yes, good idea Mark - lets go with that. Would you like to circulate? peter ps - if I recall conversations with Gerry, you are son-of, yes? And were responsible for your Cool web site, yes? I thought it was pretty good - I'm going to get some hints from you when we meet up...! Am running two myself, but strictly no frills. Both database. If so, you can just send a copy of mine out if you like. Cheers Mark -Original Message- From: Robson, Peter [mailto:[EMAIL PROTECTED]] Sent: 03 December 2002 13:13 To: '[EMAIL PROTECTED]' Subject: RE: UKOUG Meet. Mark - We need a meeting-point, Why don't you suggest to readers that we meet at 'x' location at 'y' time? No strong feelings myself, but as an exhibitor-attendee only, not sure if I will get access to the floor in the evening. What about x = adjacent to registration desks letter 'X'?! 'y' to be determined... peter edinburgh -Original Message- From: Mark Leith [mailto:[EMAIL PROTECTED]] Sent: 03 December 2002 09:59 To: Multiple recipients of list ORACLE-L Subject: UKOUG Meet. Hi All, I remember that a number of people were all for getting together on the Monday night at the UKOUG. I *don't* remember us actually arranging a place/time.. ;) Is there any chance of another show of hands so that we can see if we'll need to book a table or not. And has *anybody* had any thoughts on a place at all? See you all soon! Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * This e-mail message, and any files transmitted with it, are confidential and intended
RE: SLA Trigger/Procedure
and that select 'PING' from dual is very costly. I believe Gaja, Cary, Anjo, and a few others (who were nice enough to include me on the thread) determined that before 9i Oracle takes about 5 LIOs to do a select anything from dual. I think it went down to either 3 or 4 in 9i but that's still VERY costly. Dan Fink has that discussion summarized on his site: http://www.optimaldba.com/internals/oraint_dual.html Rachel --- Mark Leith [EMAIL PROTECTED] wrote: Yup, got that covered :) If I may add another point. When dealing with SLA's, you not only have to show that the database has been servicing users that are connected (showing database uptime), but also that users can also *connect* to the database as well (the listener is servicing requests). If you were to go about this with a trigger/procedure that inserts in to a table, then this doesn't show that the database was available to everybody. Typically what we do with monitoring tools is a connect on ping, so when we are checking availability of a database we do a full connect, then select 'PING' from dual;. If there are any errors along the way we search for the error code, and deal with the appropriate alerts (TNS = Listener problem, ORA = Database problem). Of course, the problem with doing it this way, is that you are going to have to write platform dependant scripts (batches for NT, shell type scripts for Unix), and not have a one for all with a database based solution. Go buy a tool. Let it write to a table/file, alert you AND make the coffee for when you get there! ;) Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -Original Message- Richard Sent: 03 December 2002 02:14 To: Multiple recipients of list ORACLE-L Perhaps there is a poor mans way of doing this. The startup trigger could fire a procedure that inserts a row into a table and then sleeps for 1 minute before doing the same again. Effectively it would create a ping in the table, which you could then analyze / graph to display uptimes. The next logical step would be to increase the intelligence of the procedure. The table storing the statistic could consist of two columns - uptime and downtime. When the startup trigger fires it creates a new row in the table with both uptime and downtime set to sysdate. It then sleeps for a minute before updating downtime for the most recent record (either remember a primary key or search for max(uptime)). This would be much easier to understand when the database was stopped / started. Of course depending on your accuracy requirement, granularity could be changed to every 5 minutes, 10 minutes, whatever. Hopefully that gives some ideas though. Of course the 3rd party monitors that Jared mentions are worth considering if the database is considered critical. In that case the number one requirement is probably the ability to page / SMS / email when it sees the database is down. Regards, Mark. Jared.Still@ra disys.comTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: SLA Trigger/Procedure om 03/12/2002 12:13 Please respond to ORACLE-L Ethan, That records the startup times, but does not record the time that the database was unavailable. What's needed is a 3rd party monitor that is not dependent on the database being up to record metrics. Jared Post, Ethan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/02/2002 02:33 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:SLA Trigger/Procedure Just a thought here for a script I think would be handy but I haven't had time to write. It is would be a simple procedure you could call to get the service level for a particular database. I suppose you would have to have some sort of way of defining normal outage windows. Basically a startup trigger would log the times in a table. You should also check the startup time against the last startup time periodically to ensure the trigger always fires. Somehow a procedure/function should be able to use this information to report the service level for the database within the last (week/month/quarter/year). I suppose I will get around to it eventually but if anyone else wants to get started on it I won't mind! Thanks, Ethan --
RE: UKOUG Meet.
a table presumes there will be only a few of you there by my count, which is admittedly low, you folk are already at 8 --- Robson, Peter [EMAIL PROTECTED] wrote: Count me in on this, Mark - As for a 'table' - presupposes a venue in which to find said article of furniture...(!) no idea on that, but there are places out the back of the ICC as I recall which might be suitable. peter edinburgh -Original Message- From: Mark Leith [mailto:[EMAIL PROTECTED]] Sent: 03 December 2002 09:59 To: Multiple recipients of list ORACLE-L Subject: UKOUG Meet. Hi All, I remember that a number of people were all for getting together on the Monday night at the UKOUG. I *don't* remember us actually arranging a place/time.. ;) Is there any chance of another show of hands so that we can see if we'll need to book a table or not. And has *anybody* had any thoughts on a place at all? See you all soon! Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
install of 64 and 32 bit
I am going to install 64 bit Oracle 8.1.7 on AIX 5L (5.1). There is already 32 bit Oracle on the box. Any suggestions or advice I would appreciate. thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SLA Trigger/Procedure
Title: RE: SLA Trigger/Procedure Dang, I just new that would cause a stir! ;P Mark Running away now Leith -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jamadagni, RajendraSent: 03 December 2002 14:32To: Multiple recipients of list ORACLE-LSubject: RE: SLA Trigger/Procedure Go buy a tool? Here is an idea instead ... Write a small Perl (pick your favorite language here) script that looks at /etc/oratab followed by a check to see if each of the instances listed in /etc/oratab is up on the side where it is checking. It then log in as a schema (we call it) called heartbeat, insert a row into a table with sysdate. Wait 3 seconds, retrieve the row and checks the time difference. If it is more than 5 seconds, you have a potential delay somewhere and have it alert appropriate people. (If it is night, page your VP with "This is your heartbeat calling ... we have a problem" ...) Life is great with "cron" ... HTH 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!
RE: image storage confusion ??
Excellent points all around. I am dealing with these issues currently. The original design was to use BFILE and external files. Now, they are leaning towards BLOBs. Here are some points to consider. If the system design calls for a standby or other backup site, you have to remember to replicate database and external changes. Recovery of the database may require restoration of external files. If you use BFILEs, are they on a dedicated drive or sharing space with other data/files? If you use BLOBs and they are not updated, set them in separate tablespaces and make the ts read only. Backup once and then take it out of the backup cycle, but make sure you save the backup for a good, long time! Dan Fink -Original Message- Sent: Tuesday, December 03, 2002 8:14 AM To: Multiple recipients of list ORACLE-L Connor, I seem to think otherwise. Storing 100 GB of image is not necessarily a pretty proposition either when you consider hot backups and archived log generation, etc. I presume you are concerned about the management of the image files considering the sheer volume of it. But that's precisely what BFILE is expected to help with. The images are in a file ssytem and the pointers are in the database and that's managed pretty well. However I do concede tht this might pose a problem on two fronts - (1) Security - beign on filesystem anyone can potentially see these. However this is not necesarily a concern at all sites. Good OS security can prevent this. (2) Backup - the ssy admin has to explicitly backup all these files. This, again, may not be that bad when you store your files on a single filesystem and a backup software can be easily programmed to check only the changed files, based on timestamp. Just my two cents. Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 03, 2002 7:39 AM Managing 20mil of anything (images/text/etc) in a file system isn't a nice proposition. Go with the database hth connor --- oraora oraora [EMAIL PROTECTED] wrote: Guys , i posted this already and this time my question is a bit different . I have to store 20,000,000 images of 5k each either in DB ( on win2k) or linux o/s file system. the images are to be displayed over mobile phones.so the time to retrieve the images should be minimum. for this to be achieved , i am confused , whether the images should be stored in o/s file system or in the DB ? --selecting a file from linux o/s file system --- or --querying it from oracle DB ( on win2k) --- which of the above will be faster ? all these will be done with java . this being condition , i would like to know ur suggestion guys. my DB is oracle 8.1.6 on Win2k. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to:
Re: image storage confusion ??
You should/must do a benchmark. If not, how can you justify your decision ? If your management do not ask for a benchmack then you have bad management (and that's no good for you either...) Anyway, in a previous life, we did a benchmarck with files of similar size and it was faster on the OS. The environment was Oracle 816/Sun with Vignette Story Server. HTH --- oraora oraora [EMAIL PROTECTED] a écrit : Guys , i posted this already and this time my question is a bit different . I have to store 20,000,000 images of 5k each either in DB ( on win2k) or linux o/s file system. the images are to be displayed over mobile phones.so the time to retrieve the images should be minimum. for this to be achieved , i am confused , whether the images should be stored in o/s file system or in the DB ? --selecting a file from linux o/s file system --- or --querying it from oracle DB ( on win2k) --- which of the above will be faster ? all these will be done with java . this being condition , i would like to know ur suggestion guys. my DB is oracle 8.1.6 on Win2k. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Stephane=20Paquette?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: image storage confusion ??
oraora I've provided a couple of thoughts before in response to this issue, but I think that the only way you will get a satisfactory answer is to code a simple test. I hope someone else has extensive experience with 5k images and will reply to you. However, I think the answer to your question will vary quite a bit, depending for example on image size. The experience of someone based on 50k images, for example might not give you a good result. The answer may also depend on the operating system itself. The fact that you are using Java for access may also make a difference compared other languages. I think that you are going to have to code it both ways and run a few tests. If performance is really, really important to your company, you are probably going to be testing quite a few programming alternatives. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 03, 2002 4:49 AM To: Multiple recipients of list ORACLE-L Guys , i posted this already and this time my question is a bit different . I have to store 20,000,000 images of 5k each either in DB ( on win2k) or linux o/s file system. the images are to be displayed over mobile phones.so the time to retrieve the images should be minimum. for this to be achieved , i am confused , whether the images should be stored in o/s file system or in the DB ? --selecting a file from linux o/s file system --- or --querying it from oracle DB ( on win2k) --- which of the above will be faster ? all these will be done with java . this being condition , i would like to know ur suggestion guys. my DB is oracle 8.1.6 on Win2k. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
hopefully this is not too old news
but i just logged in metalstink after a few weeks and noticed: Oracle announces the extension of Error Correction and Extended Maintenance Support for Oracle Database 9i Release 1 (9.0.1). Support Original Date Extended Date Error Correction Support (ECS) June 30, 2003 December 31, 2003 Extended Assistance Support (EAS) June 30, 2006 December 31, 2006 an extension till end of 2003 for ECS on 9ir1. joe
RE:
I don't manage the mail list software, Bruce Bergman does. Though these are a minor annoyance, I personally wouldn't bother writing code/rules to eliminate these. Just hit DELETE Jared Naveen Nahata [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/03/2002 03:58 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: I don't know whether people do it on purpose or they are still unaware after so many similar postings of the same nature and replies of 'ARE YOU AN IDIOT', but it does result in a plethora of responses which create unnecessary hassles. Jared, why not parse messages for these commands and send the reply back to the poster similar to what is done with the vacation Auto-reply messages? Regards Naveen -Original Message- Sent: Tuesday, December 03, 2002 4:59 PM To: Multiple recipients of list ORACLE-L HELP -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: image storage confusion ??
Arup, What Connor may have been referring to is the inefficiency of managing 20 million files in a filesystem. That's a lot of inodes ( assuming unix ). It's a bit much for a filesystem to deal with. Jared Arup Nanda [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/03/2002 07:14 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: image storage confusion ?? Connor, I seem to think otherwise. Storing 100 GB of image is not necessarily a pretty proposition either when you consider hot backups and archived log generation, etc. I presume you are concerned about the management of the image files considering the sheer volume of it. But that's precisely what BFILE is expected to help with. The images are in a file ssytem and the pointers are in the database and that's managed pretty well. However I do concede tht this might pose a problem on two fronts - (1) Security - beign on filesystem anyone can potentially see these. However this is not necesarily a concern at all sites. Good OS security can prevent this. (2) Backup - the ssy admin has to explicitly backup all these files. This, again, may not be that bad when you store your files on a single filesystem and a backup software can be easily programmed to check only the changed files, based on timestamp. Just my two cents. Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 03, 2002 7:39 AM Managing 20mil of anything (images/text/etc) in a file system isn't a nice proposition. Go with the database hth connor --- oraora oraora [EMAIL PROTECTED] wrote: Guys , i posted this already and this time my question is a bit different . I have to store 20,000,000 images of 5k each either in DB ( on win2k) or linux o/s file system. the images are to be displayed over mobile phones.so the time to retrieve the images should be minimum. for this to be achieved , i am confused , whether the images should be stored in o/s file system or in the DB ? --selecting a file from linux o/s file system --- or --querying it from oracle DB ( on win2k) --- which of the above will be faster ? all these will be done with java . this being condition , i would like to know ur suggestion guys. my DB is oracle 8.1.6 on Win2k. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL
Re: OMF question
And each of the threads can be defined as either mandatory (the archiving/copy has to succeed for the database to continue running) or not. Mogens [EMAIL PROTECTED] wrote: There is a OMF related parameter called db_create_online_log_dest_n. This defines where the online redo logs are created. The value n can vary from 1 to 5 and it allows for upto 5 multiplexed copies opf each redo log group member. HTH John -Original Message- Sent: 03 December 2002 11:29 To: Multiple recipients of list ORACLE-L Hi ! I 've a question regarding OMF realted parameter CREATE_DB_ONLINE_LOG_N. Now y is'nt this parameter mentioned in the list of parameters in the Oracle Documenttion cd of 9i. Is it obsolete or oracle does not recommend it's use. regards Tc -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SLA Trigger/Procedure
Ahem... OK, I can not resist any longer. The tools exist: http://www.amazon.com/exec/obidos/tg/detail/-/0596002106 The 'dbup' script logs all connections attempts. Use sed, perl, or whatever to parse the logfile, or modify to create logs more to your liking. Jared Jamadagni, Rajendra [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/03/2002 06:32 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: SLA Trigger/Procedure Go buy a tool? Here is an idea instead ... Write a small Perl (pick your favorite language here) script that looks at /etc/oratab followed by a check to see if each of the instances listed in /etc/oratab is up on the side where it is checking. It then log in as a schema (we call it) called heartbeat, insert a row into a table with sysdate. Wait 3 seconds, retrieve the row and checks the time difference. If it is more than 5 seconds, you have a potential delay somewhere and have it alert appropriate people. (If it is night, page your VP with This is your heartbeat calling ... we have a problem ...) Life is great with cron ... HTH 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! 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: UKOUG Meet.
Hear-hear. The OakTable Network has a couple of round tables near the bar area in the Exhibition Hall where we could meet, perhaps? Mogens Connor McDonald wrote: I'm up for a drink - I think we all deferred to your local knowledge. I say choose a pub and anyone thats want to be there simply rolls up when the free beer the exhibition hall dries up. (I'm guessing around 7pm) Cheers Connor --- Mark Leith [EMAIL PROTECTED] wrote: Hi All, I remember that a number of people were all for getting together on the Monday night at the UKOUG. I *don't* remember us actually arranging a place/time.. ;) Is there any chance of another show of hands so that we can see if we'll need to book a table or not. And has *anybody* had any thoughts on a place at all? See you all soon! Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __ 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
RE: ORA-1653: unable to extend table - Why?
I had one thought. The Freelist parameter for this table is only set to 1. Is it possible that if it gets tied up with contention for the freelist that it grabs a new extent? I see that some of these blocks are being written to, the num_freelist_blocks is now down to 2095705. But the new data file has grown to 600 Meg. I've opened a TAR to see what Oracle says but I'm not encouraged by the first question they sent me (which was asking to query dba_free_space). Jay -Original Message- Sent: Monday, December 02, 2002 6:14 PM To: Multiple recipients of list ORACLE-L One thing I haven't seen mentioned yet is what degree of parallelism is defined for the table? What is the next extent size set to? If the table is paralleled, EACH parallel worker will grab a next extent sized segment. (Been bit by this a few times...) How many indexes and are they in the same tablespace? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan JayMiller@TDWater house.comTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: ORA-1653: unable to extend table - Why? 12/02/2002 02:04 PM Please respond to ORACLE-L Yep, I agree that coalescing is irrelevant in my current situation. In any event there was no free space until I added the additional datafile but there was the 8gig of space on the freelists. Jay -Original Message- Sent: Friday, November 29, 2002 8:54 PM To: Multiple recipients of list ORACLE-L Richard, if pctincrease is zero, and there are a large number of contiguous smaller extents, SMON will not automatically coalesce the tablespace. However, whether or not SMON does an automatic coalesce, if you need an extent that is larger than any of the small ones, Oracle will coalesce those smaller extents to make the one you need. so Jay would not have needed to add a datafile no matter what, if he was not doing a direct path insert. As for meeting in person there is a user group meeting on Dec 12 (check www.nyoug.org for details). You can meet me, and more importantly you can meet Tim Gorman, Dan Fink, Arup Nanda and Anita Bardeen, also of this list. They are all presenting :) I saw Priscilla about a month ago, haven't talked with her since. Rachel --- Richard Ji [EMAIL PROTECTED] wrote: Rachel, What I mean to say is when there are a lot of contiguous smaller free extents. Then coalesce will produce a larger free extent so Jay wouldn't have to add a datafile for his table to grow. On the automatically coalescing part, I believe SMON will only coalesce when pctincrease != 0, or has that changed? My understand could be outdated. With LMT one doesn't have to worry about it. Have a Happy Thanksgiving. PS, I am in New York too, would love to meet you in person some time. Have you talked to Priscilla lately? Richard Ji -Original Message- Sent: Friday, November 29, 2002 5:29 PM To: Multiple recipients of list ORACLE-L how would coalescing help even if there were a lot of smaller free extents? Oracle would do the coalesce automatically, there would be no difference between manually coalescing or allowing Oracle to do it when a new extent was needed. --- Richard Ji [EMAIL PROTECTED] wrote: Coalescing might help if there are many smaller free extents that can be coalesced. But that still doesn't solve Jay's problem. Because he doesn't want the table to extent at all since he just deleted 2 million rows so there are plenty of space within the segment itself. Those free blocks should be used, unless he is doing a direct path insert which will only use space above the HWM. Richard Ji -Original Message- Sent: Friday, November 29, 2002 2:05 PM To: Multiple recipients of list ORACLE-L did u coalesced the tablespaces? -Original Message- Sent: sexta-feira, 29 de Novembro de 2002 17:59 To: Multiple recipients of list ORACLE-L Okay, I can't figure this one out. Earlier this week I got an ORA-1653: unable to extend table on a really big table. However this was just after I had deleted over 2 million rows in the table and we were only inserting 30,000. After reanalyzing the table I saw the following stats in DBA_TABLES: num_freelist_blocks: 2266966 avg_space_freelist_blocks: 3895 Unless I'm misreading this I should have had over 8Gig available for inserts. We tried the insert again and got the same error so I added a datafile and it went through (using about 40Meg of space in the new datafile). Why isn't it making use of the existing blocks on the freelist? Oracle 8.1.7.2 Solaris 2.6 PCTFREE = 10 PCTUSED = 75 Block Size = 4K
oracle temp files
Hi If I create a temporary tablespace using temp files, how is it possible to check the space usage of that tablespace. They do not show up in dba_free_space nor dba_data_files. DBA_TEMP_FILES gives me user_bytes and blocks. is this the opposite of the info in dba_free_space?? TIA Jack -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SLA Trigger/Procedure
Tool? I have a tool. Want to buy? ;) It's a simple script that connects (actually attempts to connect with a fake id/pw) to the target DB (on Windows, HP-Alpha/VMS, UNIX) over Oracle Net. Scans for the ORA- errors and we know if the DB is accessible or not, as well as if Listener is responding. No need for any 'special' ids to run 'select stuff from dual', which in itself can be expensive (depending on the DB version). I think I had posted this script a few times before. Here it is again. Customize it to suit you requirements to send page/emails/update table etc...: (btw -- Steve Adams has an elaborate version that checks for a few more things. Check his web site) #!/usr/bin/ksh # # dbcheck : Script to check if database is up and accessible # # Author : Kirti Deshpande #--- echo Enter Name of the Database SID to check if it is accessible read DB sqlplus -s EOF /tmp/$$.1 whenever sqlerror exit aaa/aaa@$DB exit; EOF egrep 'ORA-121|ORA-01034' /tmp/$$.1 /dev/null if [[ $? = 0 ]] then echo - '$DB' is _NOT_ Accessible\n else grep 'ORA-01017' /tmp/$$.1 /dev/null if [[ $? = 0 ]] then echo - '$DB' is UP and Accessible\n else echo - '$DB' is _NOT_ Accessible\n fi fi rm /tmp/$$.1 # --- End of File - Kirti -Original Message- Sent: Tuesday, December 03, 2002 4:14 AM To: Multiple recipients of list ORACLE-L Yup, got that covered :) If I may add another point. When dealing with SLA's, you not only have to show that the database has been servicing users that are connected (showing database uptime), but also that users can also *connect* to the database as well (the listener is servicing requests). If you were to go about this with a trigger/procedure that inserts in to a table, then this doesn't show that the database was available to everybody. Typically what we do with monitoring tools is a connect on ping, so when we are checking availability of a database we do a full connect, then select 'PING' from dual;. If there are any errors along the way we search for the error code, and deal with the appropriate alerts (TNS = Listener problem, ORA = Database problem). Of course, the problem with doing it this way, is that you are going to have to write platform dependant scripts (batches for NT, shell type scripts for Unix), and not have a one for all with a database based solution. Go buy a tool. Let it write to a table/file, alert you AND make the coffee for when you get there! ;) Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -Original Message- Richard Sent: 03 December 2002 02:14 To: Multiple recipients of list ORACLE-L Perhaps there is a poor mans way of doing this. The startup trigger could fire a procedure that inserts a row into a table and then sleeps for 1 minute before doing the same again. Effectively it would create a ping in the table, which you could then analyze / graph to display uptimes. The next logical step would be to increase the intelligence of the procedure. The table storing the statistic could consist of two columns - uptime and downtime. When the startup trigger fires it creates a new row in the table with both uptime and downtime set to sysdate. It then sleeps for a minute before updating downtime for the most recent record (either remember a primary key or search for max(uptime)). This would be much easier to understand when the database was stopped / started. Of course depending on your accuracy requirement, granularity could be changed to every 5 minutes, 10 minutes, whatever. Hopefully that gives some ideas though. Of course the 3rd party monitors that Jared mentions are worth considering if the database is considered critical. In that case the number one requirement is probably the ability to page / SMS / email when it sees the database is down. Regards, Mark. Jared.Still@ra disys.comTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: SLA Trigger/Procedure om 03/12/2002 12:13 Please respond to ORACLE-L Ethan, That records the startup times, but does not record the time that the database was unavailable. What's needed is a 3rd party monitor that is not dependent on the database being up to record metrics. Jared Post, Ethan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/02/2002 02:33 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L
RE: SLA Trigger/Procedure
To be fair, there is some disagreement about adding an index on DUAL. I have not duplicated the scenario that Cary presents and I have been too distracted (writing a paper/presentation for Rachel) to get back to my testing. So take with a small grain of salt. Dan -Original Message- Sent: Tuesday, December 03, 2002 7:32 AM To: Multiple recipients of list ORACLE-L and that select 'PING' from dual is very costly. I believe Gaja, Cary, Anjo, and a few others (who were nice enough to include me on the thread) determined that before 9i Oracle takes about 5 LIOs to do a select anything from dual. I think it went down to either 3 or 4 in 9i but that's still VERY costly. Dan Fink has that discussion summarized on his site: http://www.optimaldba.com/internals/oraint_dual.html Rachel --- Mark Leith [EMAIL PROTECTED] wrote: Yup, got that covered :) If I may add another point. When dealing with SLA's, you not only have to show that the database has been servicing users that are connected (showing database uptime), but also that users can also *connect* to the database as well (the listener is servicing requests). If you were to go about this with a trigger/procedure that inserts in to a table, then this doesn't show that the database was available to everybody. Typically what we do with monitoring tools is a connect on ping, so when we are checking availability of a database we do a full connect, then select 'PING' from dual;. If there are any errors along the way we search for the error code, and deal with the appropriate alerts (TNS = Listener problem, ORA = Database problem). Of course, the problem with doing it this way, is that you are going to have to write platform dependant scripts (batches for NT, shell type scripts for Unix), and not have a one for all with a database based solution. Go buy a tool. Let it write to a table/file, alert you AND make the coffee for when you get there! ;) Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -Original Message- Richard Sent: 03 December 2002 02:14 To: Multiple recipients of list ORACLE-L Perhaps there is a poor mans way of doing this. The startup trigger could fire a procedure that inserts a row into a table and then sleeps for 1 minute before doing the same again. Effectively it would create a ping in the table, which you could then analyze / graph to display uptimes. The next logical step would be to increase the intelligence of the procedure. The table storing the statistic could consist of two columns - uptime and downtime. When the startup trigger fires it creates a new row in the table with both uptime and downtime set to sysdate. It then sleeps for a minute before updating downtime for the most recent record (either remember a primary key or search for max(uptime)). This would be much easier to understand when the database was stopped / started. Of course depending on your accuracy requirement, granularity could be changed to every 5 minutes, 10 minutes, whatever. Hopefully that gives some ideas though. Of course the 3rd party monitors that Jared mentions are worth considering if the database is considered critical. In that case the number one requirement is probably the ability to page / SMS / email when it sees the database is down. Regards, Mark. Jared.Still@ra disys.comTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: SLA Trigger/Procedure om 03/12/2002 12:13 Please respond to ORACLE-L Ethan, That records the startup times, but does not record the time that the database was unavailable. What's needed is a 3rd party monitor that is not dependent on the database being up to record metrics. Jared Post, Ethan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/02/2002 02:33 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:SLA Trigger/Procedure Just a thought here for a script I think would be handy but I haven't had time to write. It is would be a simple procedure you could call to get the service level for a particular database. I suppose you would have to have some sort of way of defining normal outage windows. Basically a startup trigger would log the times in a table. You should also check the startup
RE: UKOUG Meet.
a table presumes there will be only a few of you there by my count, which is admittedly low, you folk are already at 8 You haven't seen the SIZE of these tables - they are bl massive! We take our communal beering seriously over here! peter --- Robson, Peter [EMAIL PROTECTED] wrote: Count me in on this, Mark - As for a 'table' - presupposes a venue in which to find said article of furniture...(!) no idea on that, but there are places out the back of the ICC as I recall which might be suitable. peter edinburgh -Original Message- From: Mark Leith [mailto:[EMAIL PROTECTED]] Sent: 03 December 2002 09:59 To: Multiple recipients of list ORACLE-L Subject: UKOUG Meet. Hi All, I remember that a number of people were all for getting together on the Monday night at the UKOUG. I *don't* remember us actually arranging a place/time.. ;) Is there any chance of another show of hands so that we can see if we'll need to book a table or not. And has *anybody* had any thoughts on a place at all? See you all soon! Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments. http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and
Re:
ELIZA And how may we help you? \ELIZA Tinu !@#!^% brain_damage Sent by: [EMAIL PROTECTED] 12/03/2002 03:28 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: HELP -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Help with Java
All,
I am beginning the journey into JAVA and have hit an odd behavior
(well, probably not, but I can't see any reason for it). I am
building a list of tablespaces and the datafiles that belong to them.
The open to the database is working fine. When I use:
ResultSet myTablespaces = myStatement.executeQuery(
SELECT tablespace_name +
FROM dba_tablespaces +
WHERE contents = 'PERMANENT'
);
while (myTablespaces.next()) {
// retrieve the user from the row in the ResultSet using the
// getString() method
ct = ct + 1;
String tablespace = myTablespaces.getString(1);
System.out.println(Tablespace + ct + is: + tablespace);
}
myTablespace.close();
I am generating a list of tablespaces and the output is as expected.
When I add a second result set, the first datafile of the first tablespace
returns and then the program completes:
ResultSet myTablespaces = myStatement.executeQuery(
SELECT tablespace_name +
FROM dba_tablespaces +
WHERE contents = 'PERMANENT'
);
while (myTablespaces.next()) {
// retrieve the user from the row in the ResultSet using the
// getString() method
ct = ct + 1;
String tablespace = myTablespaces.getString(1);
System.out.println(Tablespace + ct + is: + tablespace);
ResultSet myDataFiles = myStatement.executeQuery(
SELECT file_name +
FROM dba_data_files +
WHERE tablespace_name = ' + tablespace + '
);
while (myDataFiles.next()) {
String filename = myDataFiles.getString(1);
System.out.println( + filename);
}
myDataFiles.close();
}
myTablespaces.close();
Anybody with some Java experience have any insite?
As always, TIA,
John P Weatherman
Database Administrator
Replacements Ltd.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: UKOUG Meet.
I'll be there, with a special gift and greetings from the DBA Goddess... Dan Fink -Original Message- Sent: Tuesday, December 03, 2002 2:59 AM To: Multiple recipients of list ORACLE-L Hi All, I remember that a number of people were all for getting together on the Monday night at the UKOUG. I *don't* remember us actually arranging a place/time.. ;) Is there any chance of another show of hands so that we can see if we'll need to book a table or not. And has *anybody* had any thoughts on a place at all? See you all soon! Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SLA Trigger/Procedure
Yes, but can I get it signed... Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan Jared.Still@radis ys.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: SLA Trigger/Procedure 12/03/2002 10:34 AM Please respond to ORACLE-L Ahem... OK, I can not resist any longer. The tools exist: http://www.amazon.com/exec/obidos/tg/detail/-/0596002106 The 'dbup' script logs all connections attempts. Use sed, perl, or whatever to parse the logfile, or modify to create logs more to your liking. Jared Jamadagni, Rajendra [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/03/2002 06:32 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: SLA Trigger/Procedure Go buy a tool? Here is an idea instead ... Write a small Perl (pick your favorite language here) script that looks at /etc/oratab followed by a check to see if each of the instances listed in /etc/oratab is up on the side where it is checking. It then log in as a schema (we call it) called heartbeat, insert a row into a table with sysdate. Wait 3 seconds, retrieve the row and checks the time difference. If it is more than 5 seconds, you have a potential delay somewhere and have it alert appropriate people. (If it is night, page your VP with This is your heartbeat calling ... we have a problem ...) Life is great with cron ... HTH 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! (See attached file: ESPN_Disclaimer.txt) ESPN_Disclaimer.txt Description: Binary data
VXFS Parameter ?
As part of a Batch Processing Job Benchmark , the Veritas parameter vxdmp:dmp_patchswitch_blks_shift =15 set by the Sysadmin gave Good Performance / Elapsed Time benefits . Has any used this parameter ? Any recommendations ? Any cautions about the Same ? Anyplace i can get some info on this parameter ? Links , Docs ? Checked the Veritas site too but of no avail . Config :- Vertias File Systems Solaris 8 Oracle 8.1.7 Application Hybrid Machine SunFire 15K Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE:
and besides, it gives some of us a source of amusement - waiting for the first Are you and idiot? response. -Original Message- Sent: Tuesday, December 03, 2002 12:24 PM To: Multiple recipients of list ORACLE-L I don't manage the mail list software, Bruce Bergman does. Though these are a minor annoyance, I personally wouldn't bother writing code/rules to eliminate these. Just hit DELETE Jared Naveen Nahata [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/03/2002 03:58 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: I don't know whether people do it on purpose or they are still unaware after so many similar postings of the same nature and replies of 'ARE YOU AN IDIOT', but it does result in a plethora of responses which create unnecessary hassles. Jared, why not parse messages for these commands and send the reply back to the poster similar to what is done with the vacation Auto-reply messages? Regards Naveen -Original Message- Sent: Tuesday, December 03, 2002 4:59 PM To: Multiple recipients of list ORACLE-L HELP -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Best practice for backing out of Application Patches
Sorry, I forgot a Subject title! Gurus, I was just given a project to maintain a Computerized Maintenance Management System. When I asked the companies support staff how to roll back patches in the backend Oracle Database (Ver. 8174), they said that there was no way to do this. I'm guessing I could use logminer just incase a patch doesn't work. Would this be a good solution, or are there other (better) ways of safeguarding myself when it comes to patching? Obviously, I will be applying the patches to a test instance first, but I don't want to have to go back to restore from a backup if the patch causes unexpected issues. TIA! -Scott Stefick ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: oracle temp files
v$sort_usage perhaps? not sure what you're trying to determine. 'TEMPORARY' temp tablespaces provide space for sorting, and the kernel ( forget which process at the moment ) tends to hang on to them once allocated, and supply them to sessions as needed. This avoids contention on the ST enqueue. This causes TEMP to appear to be all used up after a while. Jared Jack van Zanen [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/03/2002 06:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:oracle temp files Hi If I create a temporary tablespace using temp files, how is it possible to check the space usage of that tablespace. They do not show up in dba_free_space nor dba_data_files. DBA_TEMP_FILES gives me user_bytes and blocks. is this the opposite of the info in dba_free_space?? TIA Jack -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: hopefully this is not too old news
And, if I'm not mistaken, 8.1.7's ECS date got pushed out as well, to 12/31/2003 (MetaLink doc ID 148054.1). I seem to remember being in a feverish panic because 95% of my databases would be out of ECS this year. Of course, those brain cells may have been long gone now... :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Tuesday, December 03, 2002 8:32 AM To: Multiple recipients of list ORACLE-L but i just logged in metalstink after a few weeks and noticed: Oracle announces the extension of Error Correction and Extended Maintenance Support for Oracle Database 9i Release 1 (9.0.1). SupportOriginal DateExtended Date Error Correction Support (ECS)June 30, 2003December 31, 2003 Extended Assistance Support (EAS)June 30, 2006December 31, 2006 an extension till end of 2003 for ECS on 9ir1. joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Apps 11i on Red Hat 8.0
Dale, I installed 11.5.5 on Suse 7.0 and it went absolutely fine. I went with that O/S because I'd heard it was the most trouble free combination. I believe that the 11.5.7 release is 11.5.5 plus extra CDs containg the 11.5.6 and 11.5.7 maintenance packs. I ran it as a single tier install and everything went just like it says on the box. This was in 500MB RAM / 800MB swap and (roughly) 45 GB of disk. A colleague installed it on RedHat 7.1 and it's working. I'm not sure how much tweaking it required to get there. Regards, Mike Hately [EMAIL PROTECTED] 12/02/02 21:16 PM Anyone care to share any experiences installing Apps 11i release 7 on RH 8.0? I'm about to give it a go in the next couple of days - and would appreciate hearing about your experiences. I note that SUSE 7.1 seems to be the only officially certified distro. H. Oracle Trivia Question: If you order the Oracle Apps 11i Release 7 suite from Oracle how many CD's do you get? Answer: 54 (yes thats right, fifty four CD's) - the mind boggles. No wonder they don't let you download the thing :-) Regards Dale Edgar Net 2000 Ltd. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: install of 64 and 32 bit
Title: RE: install of 64 and 32 bit According to Metalink, 8.1.7 64-bit is not certified for AIX 5.1. -Original Message- From: Ehresmann, David [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 11:09 AM To: Multiple recipients of list ORACLE-L Subject: install of 64 and 32 bit I am going to install 64 bit Oracle 8.1.7 on AIX 5L (5.1). There is already 32 bit Oracle on the box. Any suggestions or advice I would appreciate. thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Help with Java
John - your problem is that you are reusing the Statement named myStatement
within your while (myTablespaces.next()) loop. just declare and use a
second Statement and i suspect all will be well once again.
from http://java.sun.com/j2se/1.3/docs/api/index.html :
java.sql
Interface Statement
All Known Subinterfaces:
CallableStatement, PreparedStatement
public interface Statement
The object used for executing a static SQL statement and obtaining the
results produced by it.
Only one ResultSet object per Statement object can be open at any point in
time. Therefore, if the reading of one ResultSet object is interleaved with
the reading of another, each must have been generated by different Statement
objects. All statement execute methods implicitly close a statment's current
ResultSet object if an open one exists.
-Original Message-
Sent: Tuesday, December 03, 2002 12:25 PM
To: Multiple recipients of list ORACLE-L
All,
I am beginning the journey into JAVA and have hit an odd behavior
(well, probably not, but I can't see any reason for it). I am
building a list of tablespaces and the datafiles that belong to them.
The open to the database is working fine. When I use:
ResultSet myTablespaces = myStatement.executeQuery(
SELECT tablespace_name +
FROM dba_tablespaces +
WHERE contents = 'PERMANENT'
);
while (myTablespaces.next()) {
// retrieve the user from the row in the ResultSet using the
// getString() method
ct = ct + 1;
String tablespace = myTablespaces.getString(1);
System.out.println(Tablespace + ct + is: + tablespace);
}
myTablespace.close();
I am generating a list of tablespaces and the output is as expected.
When I add a second result set, the first datafile of the first tablespace
returns and then the program completes:
ResultSet myTablespaces = myStatement.executeQuery(
SELECT tablespace_name +
FROM dba_tablespaces +
WHERE contents = 'PERMANENT'
);
while (myTablespaces.next()) {
// retrieve the user from the row in the ResultSet using the
// getString() method
ct = ct + 1;
String tablespace = myTablespaces.getString(1);
System.out.println(Tablespace + ct + is: + tablespace);
ResultSet myDataFiles = myStatement.executeQuery(
SELECT file_name +
FROM dba_data_files +
WHERE tablespace_name = ' + tablespace + '
);
while (myDataFiles.next()) {
String filename = myDataFiles.getString(1);
System.out.println( + filename);
}
myDataFiles.close();
}
myTablespaces.close();
Anybody with some Java experience have any insite?
As always, TIA,
John P Weatherman
Database Administrator
Replacements Ltd.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: STEVE OLLIG
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
ORA-2083 DATABASE name has illegal character '-'
Hi,
Oracle 8.1.6.0.0 NT 4.0
I have the following logon trigger. It works fine as long I insert into
local table. If I try to insert into a table across a database link the
record get inserted but upon exiting the app whether it is
sqlplus,forms,etc I get ora-2083. I think it is probably a bug since I
have exact same environment and it works Ok. It fails
on 3 other identical environments. Anyone heard of any possible bugs using
database link in logon trigger? I search metalink and google but
no such reported error.
DROP PUBLIC DATABASE LINK utilities_a12345_dblink;
CREATE PUBLIC DATABASE LINK utilities_a12345_dblink CONNECT TO utilities
IDENTIFIED BY 123x456x USING 'a123456';
GRANT SELECT ON v_$session TO PUBLIC;
GRANT SELECT ON v_$instance TO PUBLIC;
DROP TRIGGER login_capture;
CREATE OR REPLACE TRIGGER login_capture AFTER LOGON ON DATABASE
DECLARE
CURSOR temp_rec IS
SELECT user AS user_name,
NVL(UPPER(SUBSTR(osuser,1,30)),'SERVER') AS os_user_name,
RTRIM(NVL(SUBSTR(machine,instr(machine,'\') +1,12),'SERVER'),CHR(0))
AS machine_name,
sid AS session_id,
serial# AS serial_no,
SYSDATE AS logon_time,
SYS_CONTEXT('userenv','ip_address') AS ip_address,
NVL(SUBSTR(program,1,64),'INTERNAL') AS program_name,
i.instance_name AS instance_name,
i.host_name AS host_name,
i.version AS version
FROM v$session s,v$instance i
WHERE s.username = user
AND s.logon_time = (SELECT MAX(x.logon_time)
FROM v$session x
WHERE x.username = user);
BEGIN
FOR rec IN temp_rec LOOP
INSERT INTO login_history@utilities_itport02_dblink
(user_name,
os_user_name,
machine_name,
session_id,
serial_no,
logon_time,
ip_address,
program_name,
instance_name,
host_name,
version)
VALUES (rec.user_name,
rec.os_user_name,
rec.machine_name,
rec.session_id,
rec.serial_no,
rec.logon_time,
rec.ip_address,
rec.program_name,
rec.instance_name,
rec.host_name,
rec.version);
END LOOP;
EXCEPTION
WHEN OTHERS THEN
NULL;
END;
/
ALTER TRIGGER login_capture ENABLE;
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: OMF question
It is documented in Oracle9i Database Reference Release 1 (9.0.1) Part Number A90190-02. Check it out at http://tahiti.oracle.com - Kirti -Original Message- Sent: Tuesday, December 03, 2002 8:49 AM To: Multiple recipients of list ORACLE-L John , I meant the same param.apologies ,i misplaced db and create. Is this parameter obsolete (with 9i) coz its not mentioned in the Documentation (9i) list of initialization parameters. Only db_create_file_dest is present in the doc. Thanx ! best regards Tc On Tue, 3 Dec 2002 [EMAIL PROTECTED] wrote: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: image storage confusion ??
Exactly. We had a system that used to drag emails (from qmail so each mail was a file) into clobs in the database. After a year or so we had about 15 million emails in the database - no problems at all. Then one day the some idiot (aka me) put a new version of the program in which successfully loaded the clob but (to cut a long story short) started replicating the email files left, right and centre...It took literally days to clean up millions of (zero byte size) files...after which point that file system needed to be rebuilt anyway, the directory structure was in such a mess Cheers Connor --- [EMAIL PROTECTED] wrote: Arup, What Connor may have been referring to is the inefficiency of managing 20 million files in a filesystem. That's a lot of inodes ( assuming unix ). It's a bit much for a filesystem to deal with. Jared Arup Nanda [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/03/2002 07:14 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: image storage confusion ?? Connor, I seem to think otherwise. Storing 100 GB of image is not necessarily a pretty proposition either when you consider hot backups and archived log generation, etc. I presume you are concerned about the management of the image files considering the sheer volume of it. But that's precisely what BFILE is expected to help with. The images are in a file ssytem and the pointers are in the database and that's managed pretty well. However I do concede tht this might pose a problem on two fronts - (1) Security - beign on filesystem anyone can potentially see these. However this is not necesarily a concern at all sites. Good OS security can prevent this. (2) Backup - the ssy admin has to explicitly backup all these files. This, again, may not be that bad when you store your files on a single filesystem and a backup software can be easily programmed to check only the changed files, based on timestamp. Just my two cents. Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 03, 2002 7:39 AM Managing 20mil of anything (images/text/etc) in a file system isn't a nice proposition. Go with the database hth connor --- oraora oraora [EMAIL PROTECTED] wrote: Guys , i posted this already and this time my question is a bit different . I have to store 20,000,000 images of 5k each either in DB ( on win2k) or linux o/s file system. the images are to be displayed over mobile phones.so the time to retrieve the images should be minimum. for this to be achieved , i am confused , whether the images should be stored in o/s file system or in the DB ? --selecting a file from linux o/s file system --- or --querying it from oracle DB ( on win2k) --- which of the above will be faster ? all these will be done with java . this being condition , i would like to know ur suggestion guys. my DB is oracle 8.1.6 on Win2k. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You
Extent sizes when using LMT with autoallocate clause
Title: Extent sizes when using LMT with autoallocate clause Hi! I was wondering what the allocated extent sizes for locally managed tablespaces with the autoallocate clause are? The first extents are 64k in size. How many 64k chunks are allocated? What are the next sizes? CREATE TABLESPACE local_auto DATAFILE '/u02/oradata/local_auto01.dbf' SIZE 1M reuse EXTENT MANAGEMENT LOCAL AUTOALLOCATE; This is 9.2.0.2 on Solaris. Thanks, Helmut
Re: SLA Trigger/Procedure
[EMAIL PROTECTED] wrote: Ethan, That records the startup times, but does not record the time that the database was unavailable. What's needed is a 3rd party monitor that is not dependent on the database being up to record metrics. Jared Jared, I am far from having given much thought to this interesting idea but you can possibly work around this by using utl_file to check background_dump_dest. If it's not recorded in the alert.log, you probably have a .trc file hanging around. This optimistically assumes of course that you do not let you alert.log file grow out of control, because the idea of reading with UTL_FILE a 300M+ text file is not properly exciting. In fact the solution might be some external procedure to do in C directory operations, stat() calls and the like. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SLA Trigger/Procedure
Title: RE: SLA Trigger/Procedure you still have to *buy* the tool right? 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- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 12:34 PM To: Multiple recipients of list ORACLE-L Subject: RE: SLA Trigger/Procedure Ahem... OK, I can not resist any longer. The tools exist: http://www.amazon.com/exec/obidos/tg/detail/-/0596002106 The 'dbup' script logs all connections attempts. Use sed, perl, or whatever to parse the logfile, or modify to create logs more to your liking. Jared Jamadagni, Rajendra [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/03/2002 06:32 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: RE: SLA Trigger/Procedure Go buy a tool? Here is an idea instead ... Write a small Perl (pick your favorite language here) script that looks at /etc/oratab followed by a check to see if each of the instances listed in /etc/oratab is up on the side where it is checking. It then log in as a schema (we call it) called heartbeat, insert a row into a table with sysdate. Wait 3 seconds, retrieve the row and checks the time difference. If it is more than 5 seconds, you have a potential delay somewhere and have it alert appropriate people. (If it is night, page your VP with This is your heartbeat calling ... we have a problem ...) Life is great with cron ... HTH 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! 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: image storage confusion ??
FWIW ... in my last job we stored 13 million CLOB documents (max size of 5KB, stored out-of-line in their own CLOB segments) in an 8.1.7.3 DB under Win2k (2 CPU HP NetServer with 4GB RAM and twenty-three 36GB drives; JBOD). The CLOB documents were all interMedia Text indexed. Contains queries returned results in a second or less, unless the query was not very specific and hit thousands of documents. Java processes loaded up to 250,000 new documents every night and the interMedia index was refreshed shortly thereafter - took up to a couple of hours. The front-end was Cold Fusion, so that's not applicable to your situation. This ~200GB database had a Standby DB on a sister machine. Everything worked very well. RMan level 0 backups took a couple of hours. I vote for out-of-line BLOBs in their own tablespace(s) on as many spindles as you can afford. Jack C. Applewhite Database Administrator Austin Independent School District Austin, Texas 512.414.9715 (wk) 512.935.5929 (pager) [EMAIL PROTECTED] Stephane Paquette stephane_paquette@ To: Multiple recipients of list ORACLE-L YAHOO.COM [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: image storage confusion ?? 12/03/2002 08:32 AM Please respond to ORACLE-L You should/must do a benchmark. If not, how can you justify your decision ? If your management do not ask for a benchmack then you have bad management (and that's no good for you either...) Anyway, in a previous life, we did a benchmarck with files of similar size and it was faster on the OS. The environment was Oracle 816/Sun with Vignette Story Server. HTH --- oraora oraora [EMAIL PROTECTED] a écrit : Guys , i posted this already and this time my question is a bit different . I have to store 20,000,000 images of 5k each either in DB ( on win2k) or linux o/s file system. the images are to be displayed over mobile phones.so the time to retrieve the images should be minimum. for this to be achieved , i am confused , whether the images should be stored in o/s file system or in the DB ? --selecting a file from linux o/s file system --- or --querying it from oracle DB ( on win2k) --- which of the above will be faster ? all these will be done with java . this being condition , i would like to know ur suggestion guys. my DB is oracle 8.1.6 on Win2k. TIA -- Author: oraora oraora INET: [EMAIL PROTECTED] = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] -- Author: =?iso-8859-1?q?Stephane=20Paquette?= INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle precompiler in O 9.2
actually we also have /usr/opt/oracle/92 which is linked to /usr/opt/oracle/current 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-From: Hemant K Chitale [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 03, 2002 11:19 AMTo: Multiple recipients of list ORACLE-LSubject: RE: oracle precompiler in O 9.2The ORACLE_HOME is "/usr/opt/oracle/current" ?I have read of "/usr/opt" being used, [although I generally use"/u0x/app" or "/oracle/app" or "/orasys/app" depending on the "standard'at the site] but not "current" -- I generally still use [the "OFA" standard"]./product/Version.Release.MaintenanceReleaseHemantAt 06:32 AM 03-12-02 -0800, you wrote: SQL exit Disconnected from Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options JServer Release 9.2.0.2.0 - Production oraclei@elara-ABC1 oraclei@elara-ABC1 which proc /usr/opt/oracle/current/bin/proc 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- From: Markus Reger [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 5:44 AM To: Multiple recipients of list ORACLE-L Subject: oracle precompiler in O 9.2 hello to everybody I'm desperately looking for precompiler e.g. proc in the installation of O 9.2. can't find libproc2.a is the message when I try do creat. doesn't seem to be an installation issue, because no kind of installation offers the(se) file(s). precompilers did exist in 9.0.1 - but they don't exist any more in 9.2.0 neither SunOS nor LINUX. has anybody any idea? thanks in advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K ChitaleMy web site page is : http://hkchital.tripod.com-- 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 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
Re: which bind variable value causes ora-1722
Mike, It is the value in the :gl_id string, which is 6.55802. The column GL_ID is defined as an integer of 38 digits (i.e. NUMBER(38) instead of NUMBER), so there is no room for digits to the right of the decimal... Hope this helps... -Tim Hi, all, My developer continually got ora-1722 when he was installing a new billing system. I used 10046 event to get trace file, but i could not figure out which bind variable value causes the error, here is the part of trace: PARSING IN CURSOR #1 len=229 dep=0 uid=62 oct=2 lid=62 tim=807252370 hv=4084410285 ad='9f31e880' insert into fold_bal_impacts_t ( element_id, fixed_operand, flags, free_quantity, gl_id, scaled_operand, rec_id, obj_id0 ) values ( :element_id, :fixed_operand, :flags, :free_quantity, :gl_id, :scaled_operand, :rec_id, :obj_id0 ) END OF STMT PARSE #1:c=0,e=1,p=0,cr=1,cu=0,mis=1,r=0,dep=0,og=0,tim=80725237 0 BINDS #1: bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=01 oacfl2=0 size=224 offset=0 bfp=018bacd0 bln=22 avl=03 flg=05 value=250 bind 1: dty=1 mxl=32(01) mal=00 scl=00 pre=00 oacflg=01 oacfl2=10 size=0 offset=24 bfp=018bace8 bln=32 avl=01 flg=01 value=0 bind 2: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=01 oacfl2=0 size=0 offset=56 bfp=018bad08 bln=22 avl=01 flg=01 value=0 bind 3: dty=1 mxl=32(01) mal=00 scl=00 pre=00 oacflg=01 oacfl2=10 size=0 offset=80 bfp=018bad20 bln=32 avl=01 flg=01 value=0 bind 4: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=01 oacfl2=0 size=0 offset=112 bfp=018bad40 bln=22 avl=01 flg=01 value=0 bind 5: dty=1 mxl=32(07) mal=00 scl=00 pre=00 oacflg=01 oacfl2=10 size=0 offset=136 bfp=018bad58 bln=32 avl=07 flg=01 value=6.55802 bind 6: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=01 oacfl2=0 size=0 offset=168 bfp=018bad78 bln=22 avl=01 flg=01 value=0 bind 7: dty=1 mxl=32(05) mal=00 scl=00 pre=00 oacflg=01 oacfl2=10 size=0 offset=192 bfp=018bad90 bln=32 avl=05 flg=01 value=10382 EXEC #1:c=0,e=0,p=0,cr=0,cu=2,mis=0,r=0,dep=0,og=3,tim=80725237 0 ERROR #1:err=1722 tim=807252370 And here is the table: SQLdesc fold_bal_impacts_t NameNull?Type --- OBJ_ID0 NUMBER(38) REC_ID NUMBER(38) ELEMENT_ID NUMBER(38) FIXED_OPERANDNUMBER FLAGSNUMBER(38) FREE_QUANTITYNUMBER GL_IDNUMBER(38) SCALED_OPERAND NUMBER And there is no any constraints on this table. Please help, thanks. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mike ding INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -- --- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-2083 DATABASE name has illegal character '-'
Rick - Have you tested the link itself?
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, December 03, 2002 1:10 PM
To: Multiple recipients of list ORACLE-L
Hi,
Oracle 8.1.6.0.0 NT 4.0
I have the following logon trigger. It works fine as long I insert into
local table. If I try to insert into a table across a database link the
record get inserted but upon exiting the app whether it is
sqlplus,forms,etc I get ora-2083. I think it is probably a bug since I
have exact same environment and it works Ok. It fails
on 3 other identical environments. Anyone heard of any possible bugs using
database link in logon trigger? I search metalink and google but
no such reported error.
DROP PUBLIC DATABASE LINK utilities_a12345_dblink;
CREATE PUBLIC DATABASE LINK utilities_a12345_dblink CONNECT TO utilities
IDENTIFIED BY 123x456x USING 'a123456';
GRANT SELECT ON v_$session TO PUBLIC;
GRANT SELECT ON v_$instance TO PUBLIC;
DROP TRIGGER login_capture;
CREATE OR REPLACE TRIGGER login_capture AFTER LOGON ON DATABASE
DECLARE
CURSOR temp_rec IS
SELECT user AS user_name,
NVL(UPPER(SUBSTR(osuser,1,30)),'SERVER') AS os_user_name,
RTRIM(NVL(SUBSTR(machine,instr(machine,'\') +1,12),'SERVER'),CHR(0))
AS machine_name,
sid AS session_id,
serial# AS serial_no,
SYSDATE AS logon_time,
SYS_CONTEXT('userenv','ip_address') AS ip_address,
NVL(SUBSTR(program,1,64),'INTERNAL') AS program_name,
i.instance_name AS instance_name,
i.host_name AS host_name,
i.version AS version
FROM v$session s,v$instance i
WHERE s.username = user
AND s.logon_time = (SELECT MAX(x.logon_time)
FROM v$session x
WHERE x.username = user);
BEGIN
FOR rec IN temp_rec LOOP
INSERT INTO login_history@utilities_itport02_dblink
(user_name,
os_user_name,
machine_name,
session_id,
serial_no,
logon_time,
ip_address,
program_name,
instance_name,
host_name,
version)
VALUES (rec.user_name,
rec.os_user_name,
rec.machine_name,
rec.session_id,
rec.serial_no,
rec.logon_time,
rec.ip_address,
rec.program_name,
rec.instance_name,
rec.host_name,
rec.version);
END LOOP;
EXCEPTION
WHEN OTHERS THEN
NULL;
END;
/
ALTER TRIGGER login_capture ENABLE;
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: SLA Trigger/Procedure
Mark - Well, speaking for myself, I appreciate your openness in pointing out the major issues one would have to deal with if they were going to write their own. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 03, 2002 10:34 AM To: Multiple recipients of list ORACLE-L Dang, I just new that would cause a stir! ;P Mark Running away now Leith -Original Message- Rajendra Sent: 03 December 2002 14:32 To: Multiple recipients of list ORACLE-L Go buy a tool? Here is an idea instead ... Write a small Perl (pick your favorite language here) script that looks at /etc/oratab followed by a check to see if each of the instances listed in /etc/oratab is up on the side where it is checking. It then log in as a schema (we call it) called heartbeat, insert a row into a table with sysdate. Wait 3 seconds, retrieve the row and checks the time difference. If it is more than 5 seconds, you have a potential delay somewhere and have it alert appropriate people. (If it is night, page your VP with This is your heartbeat calling ... we have a problem ...) Life is great with cron ... HTH 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! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-1653: unable to extend table - Why?
Hum. My last thought would are there triggers or snapshots defined on the table? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan JayMiller@TDWater house.comTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: ORA-1653: unable to extend table - Why? 12/03/2002 08:18 AM Please respond to ORACLE-L Ron, Good idea, but DEGREE=1 There are two indexes, but they are in a different tablespace (which has plenty of free space available and did not give an error). Next extent size is 25M but, as mentioned, it shouldn't have needed a new extent. I'm still at a loss... Jay -Original Message- Sent: Monday, December 02, 2002 6:14 PM To: Multiple recipients of list ORACLE-L One thing I haven't seen mentioned yet is what degree of parallelism is defined for the table? What is the next extent size set to? If the table is paralleled, EACH parallel worker will grab a next extent sized segment. (Been bit by this a few times...) How many indexes and are they in the same tablespace? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan JayMiller@TDWater house.comTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: ORA-1653: unable to extend table - Why? 12/02/2002 02:04 PM Please respond to ORACLE-L Yep, I agree that coalescing is irrelevant in my current situation. In any event there was no free space until I added the additional datafile but there was the 8gig of space on the freelists. Jay -Original Message- Sent: Friday, November 29, 2002 8:54 PM To: Multiple recipients of list ORACLE-L Richard, if pctincrease is zero, and there are a large number of contiguous smaller extents, SMON will not automatically coalesce the tablespace. However, whether or not SMON does an automatic coalesce, if you need an extent that is larger than any of the small ones, Oracle will coalesce those smaller extents to make the one you need. so Jay would not have needed to add a datafile no matter what, if he was not doing a direct path insert. As for meeting in person there is a user group meeting on Dec 12 (check www.nyoug.org for details). You can meet me, and more importantly you can meet Tim Gorman, Dan Fink, Arup Nanda and Anita Bardeen, also of this list. They are all presenting :) I saw Priscilla about a month ago, haven't talked with her since. Rachel --- Richard Ji [EMAIL PROTECTED] wrote: Rachel, What I mean to say is when there are a lot of contiguous smaller free extents. Then coalesce will produce a larger free extent so Jay wouldn't have to add a datafile for his table to grow. On the automatically coalescing part, I believe SMON will only coalesce when pctincrease != 0, or has that changed? My understand could be outdated. With LMT one doesn't have to worry about it. Have a Happy Thanksgiving. PS, I am in New York too, would love to meet you in
Re: Extent sizes when using LMT with autoallocate clause
case when initial_extent 1m then case when extents 16 then next = 64k, when extents 80 then next = 1m, when extents 200 then next = 8m, else next = 64m when initial_extent = 1m then case when extents 64 then next = 1m, when extents 184 then next = 8m, else next = 64m ) is a reasonable approximation of extent behaviour --- Daiminger, Helmut [EMAIL PROTECTED] wrote: Hi! I was wondering what the allocated extent sizes for locally managed tablespaces with the autoallocate clause are? The first extents are 64k in size. How many 64k chunks are allocated? What are the next sizes? CREATE TABLESPACE local_auto DATAFILE'/u02/oradata/local_auto01.dbf' SIZE 1M reuse EXTENT MANAGEMENT LOCAL AUTOALLOCATE; This is 9.2.0.2 on Solaris. Thanks, Helmut = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Help with Java
Steve,
This was it exactly. Thanks!
John P Weatherman
Database Administrator
Replacements Ltd.
-Original Message-
Sent: Tuesday, December 03, 2002 2:44 PM
To: Multiple recipients of list ORACLE-L
John - your problem is that you are reusing the Statement named myStatement
within your while (myTablespaces.next()) loop. just declare and use a
second Statement and i suspect all will be well once again.
from http://java.sun.com/j2se/1.3/docs/api/index.html :
java.sql
Interface Statement
All Known Subinterfaces:
CallableStatement, PreparedStatement
public interface Statement
The object used for executing a static SQL statement and obtaining the
results produced by it.
Only one ResultSet object per Statement object can be open at any point in
time. Therefore, if the reading of one ResultSet object is interleaved with
the reading of another, each must have been generated by different Statement
objects. All statement execute methods implicitly close a statment's current
ResultSet object if an open one exists.
-Original Message-
Sent: Tuesday, December 03, 2002 12:25 PM
To: Multiple recipients of list ORACLE-L
All,
I am beginning the journey into JAVA and have hit an odd behavior
(well, probably not, but I can't see any reason for it). I am
building a list of tablespaces and the datafiles that belong to them.
The open to the database is working fine. When I use:
ResultSet myTablespaces = myStatement.executeQuery(
SELECT tablespace_name +
FROM dba_tablespaces +
WHERE contents = 'PERMANENT'
);
while (myTablespaces.next()) {
// retrieve the user from the row in the ResultSet using the
// getString() method
ct = ct + 1;
String tablespace = myTablespaces.getString(1);
System.out.println(Tablespace + ct + is: + tablespace);
}
myTablespace.close();
I am generating a list of tablespaces and the output is as expected.
When I add a second result set, the first datafile of the first tablespace
returns and then the program completes:
ResultSet myTablespaces = myStatement.executeQuery(
SELECT tablespace_name +
FROM dba_tablespaces +
WHERE contents = 'PERMANENT'
);
while (myTablespaces.next()) {
// retrieve the user from the row in the ResultSet using the
// getString() method
ct = ct + 1;
String tablespace = myTablespaces.getString(1);
System.out.println(Tablespace + ct + is: + tablespace);
ResultSet myDataFiles = myStatement.executeQuery(
SELECT file_name +
FROM dba_data_files +
WHERE tablespace_name = ' + tablespace + '
);
while (myDataFiles.next()) {
String filename = myDataFiles.getString(1);
System.out.println( + filename);
}
myDataFiles.close();
}
myTablespaces.close();
Anybody with some Java experience have any insite?
As always, TIA,
John P Weatherman
Database Administrator
Replacements Ltd.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: STEVE OLLIG
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: Best practice for backing out of Application Patches
Scott, Of course, the answer is It depends. It all depends on the kind of software patches that are being applied. Are you talking about adding a column to a table that allows nulls? There might not be a need to back this patch out - the column might be able to stay depending on how it is used during an insert or select statment. If the application does not use the column, then removing it from the table might need to be done. On the other hand, if you are using version 8.1.7, you can always drop the column from the table. If your patches are just updates to schema views, you can always simply e-apply the prior version of the views to back the updates out of the database. see, it all depends on the kind of schema update that was performed. and it can get very complicated when you are talking about foreign keys - literally hundreds of tables could be involved - and you probably do not want to be trying to figure out what got touched by an update. probably the best answer is - to back all database changes out of a schema, perform a database point-in-time restore back to before you applied the patches. if I had your job, and this was a purchased application, this is what I would do. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, December 03, 2002 2:25 PM To: Multiple recipients of list ORACLE-L Sorry, I forgot a Subject title! Gurus, I was just given a project to maintain a Computerized Maintenance Management System. When I asked the companies support staff how to roll back patches in the backend Oracle Database (Ver. 8174), they said that there was no way to do this. I'm guessing I could use logminer just incase a patch doesn't work. Would this be a good solution, or are there other (better) ways of safeguarding myself when it comes to patching? Obviously, I will be applying the patches to a test instance first, but I don't want to have to go back to restore from a backup if the patch causes unexpected issues. TIA! -Scott Stefick ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
[no subject]
Gurus, I was just given a project to maintain a Computerized Maintenance Management System. When I asked the companies support staff how to roll back patches in the backend Oracle Database (Ver. 8174), they said that there was no way to do this. I'm guessing I could use logminer just incase a patch doesn't work. Would this be a good solution, or are there other (better) ways of safeguarding myself when it comes to patching? Obviously, I will be applying the patches to a test instance first, but I don't want to have to go back to restore from a backup if the patch causes unexpected issues. TIA! ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Help with Java
comment out
myDataFiles.close();
and see what happens.
On Tue, 3 Dec 2002, John Weatherman wrote:
All,
I am beginning the journey into JAVA and have hit an odd behavior
(well, probably not, but I can't see any reason for it). I am
building a list of tablespaces and the datafiles that belong to them.
The open to the database is working fine. When I use:
ResultSet myTablespaces = myStatement.executeQuery(
SELECT tablespace_name +
FROM dba_tablespaces +
WHERE contents = 'PERMANENT'
);
while (myTablespaces.next()) {
// retrieve the user from the row in the ResultSet using the
// getString() method
ct = ct + 1;
String tablespace = myTablespaces.getString(1);
System.out.println(Tablespace + ct + is: + tablespace);
}
myTablespace.close();
I am generating a list of tablespaces and the output is as expected.
When I add a second result set, the first datafile of the first tablespace
returns and then the program completes:
ResultSet myTablespaces = myStatement.executeQuery(
SELECT tablespace_name +
FROM dba_tablespaces +
WHERE contents = 'PERMANENT'
);
while (myTablespaces.next()) {
// retrieve the user from the row in the ResultSet using the
// getString() method
ct = ct + 1;
String tablespace = myTablespaces.getString(1);
System.out.println(Tablespace + ct + is: + tablespace);
ResultSet myDataFiles = myStatement.executeQuery(
SELECT file_name +
FROM dba_data_files +
WHERE tablespace_name = ' + tablespace + '
);
while (myDataFiles.next()) {
String filename = myDataFiles.getString(1);
System.out.println( + filename);
}
myDataFiles.close();
}
myTablespaces.close();
Anybody with some Java experience have any insite?
As always, TIA,
John P Weatherman
Database Administrator
Replacements Ltd.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alex
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: which bind variable value causes ora-1722
It looks like that is bind value 4(gl_id) = 0. How did you determine it is 6.55802? I certainly do not how to read this trace but looks like it is define correctly :element_id, bind 0 :fixed_operand,bind 1 :flags,bind 2 :free_quantity,bind 3 :gl_id,bind 4 value 0 :scaled_operand, bind 5 value 6.55802 :rec_id, :obj_id0 Rick tim@sagelogix. com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: which bind variable value causes ora-1722 om 12/03/2002 02:21 PM Please respond to ORACLE-L Mike, It is the value in the :gl_id string, which is 6.55802. The column GL_ID is defined as an integer of 38 digits (i.e. NUMBER(38) instead of NUMBER), so there is no room for digits to the right of the decimal... Hope this helps... -Tim Hi, all, My developer continually got ora-1722 when he was installing a new billing system. I used 10046 event to get trace file, but i could not figure out which bind variable value causes the error, here is the part of trace: PARSING IN CURSOR #1 len=229 dep=0 uid=62 oct=2 lid=62 tim=807252370 hv=4084410285 ad='9f31e880' insert into fold_bal_impacts_t ( element_id, fixed_operand, flags, free_quantity, gl_id, scaled_operand, rec_id, obj_id0 ) values ( :element_id, :fixed_operand, :flags, :free_quantity, :gl_id, :scaled_operand, :rec_id, :obj_id0 ) END OF STMT PARSE #1:c=0,e=1,p=0,cr=1,cu=0,mis=1,r=0,dep=0,og=0,tim=80725237 0 BINDS #1: bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=01 oacfl2=0 size=224 offset=0 bfp=018bacd0 bln=22 avl=03 flg=05 value=250 bind 1: dty=1 mxl=32(01) mal=00 scl=00 pre=00 oacflg=01 oacfl2=10 size=0 offset=24 bfp=018bace8 bln=32 avl=01 flg=01 value=0 bind 2: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=01 oacfl2=0 size=0 offset=56 bfp=018bad08 bln=22 avl=01 flg=01 value=0 bind 3: dty=1 mxl=32(01) mal=00 scl=00 pre=00 oacflg=01 oacfl2=10 size=0 offset=80 bfp=018bad20 bln=32 avl=01 flg=01 value=0 bind 4: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=01 oacfl2=0 size=0 offset=112 bfp=018bad40 bln=22 avl=01 flg=01 value=0 bind 5: dty=1 mxl=32(07) mal=00 scl=00 pre=00 oacflg=01 oacfl2=10 size=0 offset=136 bfp=018bad58 bln=32 avl=07 flg=01 value=6.55802 bind 6: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=01 oacfl2=0 size=0 offset=168 bfp=018bad78 bln=22 avl=01 flg=01 value=0 bind 7: dty=1 mxl=32(05) mal=00 scl=00 pre=00 oacflg=01 oacfl2=10 size=0 offset=192 bfp=018bad90 bln=32 avl=05 flg=01 value=10382 EXEC #1:c=0,e=0,p=0,cr=0,cu=2,mis=0,r=0,dep=0,og=3,tim=80725237 0 ERROR #1:err=1722 tim=807252370 And here is the table: SQLdesc fold_bal_impacts_t NameNull?Type --- OBJ_ID0 NUMBER(38) REC_ID NUMBER(38) ELEMENT_ID NUMBER(38) FIXED_OPERANDNUMBER FLAGSNUMBER(38) FREE_QUANTITYNUMBER GL_IDNUMBER(38) SCALED_OPERAND NUMBER And there is no any constraints on this table. Please help, thanks. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mike ding INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: oracle temp files
Check view V$TEMP_SPACE_HEADER. I suggest referring to Metalink Notes: 160426.1 and 188610.1 - Kirti -Original Message- Sent: Tuesday, December 03, 2002 8:44 AM To: Multiple recipients of list ORACLE-L Hi If I create a temporary tablespace using temp files, how is it possible to check the space usage of that tablespace. They do not show up in dba_free_space nor dba_data_files. DBA_TEMP_FILES gives me user_bytes and blocks. is this the opposite of the info in dba_free_space?? TIA Jack -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-1653: unable to extend table - Why?
Jay, Don't think it will bypass the freelist there. I don't think the freelist is the cause of the problem here. Richard -Original Message- Sent: Tuesday, December 03, 2002 11:54 AM To: Multiple recipients of list ORACLE-L I had one thought. The Freelist parameter for this table is only set to 1. Is it possible that if it gets tied up with contention for the freelist that it grabs a new extent? I see that some of these blocks are being written to, the num_freelist_blocks is now down to 2095705. But the new data file has grown to 600 Meg. I've opened a TAR to see what Oracle says but I'm not encouraged by the first question they sent me (which was asking to query dba_free_space). Jay -Original Message- Sent: Monday, December 02, 2002 6:14 PM To: Multiple recipients of list ORACLE-L One thing I haven't seen mentioned yet is what degree of parallelism is defined for the table? What is the next extent size set to? If the table is paralleled, EACH parallel worker will grab a next extent sized segment. (Been bit by this a few times...) How many indexes and are they in the same tablespace? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan JayMiller@TDWater house.comTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: ORA-1653: unable to extend table - Why? 12/02/2002 02:04 PM Please respond to ORACLE-L Yep, I agree that coalescing is irrelevant in my current situation. In any event there was no free space until I added the additional datafile but there was the 8gig of space on the freelists. Jay -Original Message- Sent: Friday, November 29, 2002 8:54 PM To: Multiple recipients of list ORACLE-L Richard, if pctincrease is zero, and there are a large number of contiguous smaller extents, SMON will not automatically coalesce the tablespace. However, whether or not SMON does an automatic coalesce, if you need an extent that is larger than any of the small ones, Oracle will coalesce those smaller extents to make the one you need. so Jay would not have needed to add a datafile no matter what, if he was not doing a direct path insert. As for meeting in person there is a user group meeting on Dec 12 (check www.nyoug.org for details). You can meet me, and more importantly you can meet Tim Gorman, Dan Fink, Arup Nanda and Anita Bardeen, also of this list. They are all presenting :) I saw Priscilla about a month ago, haven't talked with her since. Rachel --- Richard Ji [EMAIL PROTECTED] wrote: Rachel, What I mean to say is when there are a lot of contiguous smaller free extents. Then coalesce will produce a larger free extent so Jay wouldn't have to add a datafile for his table to grow. On the automatically coalescing part, I believe SMON will only coalesce when pctincrease != 0, or has that changed? My understand could be outdated. With LMT one doesn't have to worry about it. Have a Happy Thanksgiving. PS, I am in New York too, would love to meet you in person some time. Have you talked to Priscilla lately? Richard Ji -Original Message- Sent: Friday, November 29, 2002 5:29 PM To: Multiple recipients of list ORACLE-L how would coalescing help even if there were a lot of smaller free extents? Oracle would do the coalesce automatically, there would be no difference between manually coalescing or allowing Oracle to do it when a new extent was needed. --- Richard Ji [EMAIL PROTECTED] wrote: Coalescing might help if there are many smaller free extents that can be coalesced. But that still doesn't solve Jay's problem. Because he doesn't want the table to extent at all since he just deleted 2 million rows so there are plenty of space within the segment itself. Those free blocks should be used, unless he is doing a direct path insert which will only use space above the HWM. Richard Ji -Original Message- Sent: Friday, November 29, 2002 2:05 PM To: Multiple recipients of list ORACLE-L did u coalesced the tablespaces? -Original Message- Sent: sexta-feira, 29 de Novembro de 2002 17:59 To: Multiple recipients of list ORACLE-L Okay, I can't figure this one out. Earlier this week I got an ORA-1653: unable to extend table on a really big table. However this was just after I had deleted over 2 million rows in the table and we were only inserting 30,000. After reanalyzing the table I saw the following stats in DBA_TABLES: num_freelist_blocks: 2266966 avg_space_freelist_blocks: 3895 Unless I'm misreading this I should have had over 8Gig available for inserts. We tried the insert again and got the same error so I added a
RE: ORA-1653: unable to extend table - Why?
Just for grins, here's the level of support I'm getting on my Oracle TAR: -- You had stated earlier: 1/ After reanalyzing the table I saw the following stats in DBA_TABLES: num_freelist_blocks: 2266966 avg_space_freelist_blocks: 3895 Unless I'm misreading this I should have had over 8Gig available for inserts. 2/ I've had to add another data file and it has already grown to 600 Meg. If the table is only 600 mb, then there is no way that it can have 8 gb of free space. Since you have a lot of blocks with some free space, you may want to export and import the table back to re-org the table... -- Someone should inform these people that a table can consist of more than one datafile... -Original Message- Sent: Tuesday, December 03, 2002 11:54 AM To: Multiple recipients of list ORACLE-L I had one thought. The Freelist parameter for this table is only set to 1. Is it possible that if it gets tied up with contention for the freelist that it grabs a new extent? I see that some of these blocks are being written to, the num_freelist_blocks is now down to 2095705. But the new data file has grown to 600 Meg. I've opened a TAR to see what Oracle says but I'm not encouraged by the first question they sent me (which was asking to query dba_free_space). Jay -Original Message- Sent: Monday, December 02, 2002 6:14 PM To: Multiple recipients of list ORACLE-L One thing I haven't seen mentioned yet is what degree of parallelism is defined for the table? What is the next extent size set to? If the table is paralleled, EACH parallel worker will grab a next extent sized segment. (Been bit by this a few times...) How many indexes and are they in the same tablespace? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan JayMiller@TDWater house.comTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: ORA-1653: unable to extend table - Why? 12/02/2002 02:04 PM Please respond to ORACLE-L Yep, I agree that coalescing is irrelevant in my current situation. In any event there was no free space until I added the additional datafile but there was the 8gig of space on the freelists. Jay -Original Message- Sent: Friday, November 29, 2002 8:54 PM To: Multiple recipients of list ORACLE-L Richard, if pctincrease is zero, and there are a large number of contiguous smaller extents, SMON will not automatically coalesce the tablespace. However, whether or not SMON does an automatic coalesce, if you need an extent that is larger than any of the small ones, Oracle will coalesce those smaller extents to make the one you need. so Jay would not have needed to add a datafile no matter what, if he was not doing a direct path insert. As for meeting in person there is a user group meeting on Dec 12 (check www.nyoug.org for details). You can meet me, and more importantly you can meet Tim Gorman, Dan Fink, Arup Nanda and Anita Bardeen, also of this list. They are all presenting :) I saw Priscilla about a month ago, haven't talked with her since. Rachel --- Richard Ji [EMAIL PROTECTED] wrote: Rachel, What I mean to say is when there are a lot of contiguous smaller free extents. Then coalesce will produce a larger free extent so Jay wouldn't have to add a datafile for his table to grow. On the automatically coalescing part, I believe SMON will only coalesce when pctincrease != 0, or has that changed? My understand could be outdated. With LMT one doesn't have to worry about it. Have a Happy Thanksgiving. PS, I am in New York too, would love to meet you in person some time. Have you talked to Priscilla lately? Richard Ji -Original Message- Sent: Friday, November 29, 2002 5:29 PM To: Multiple recipients of list ORACLE-L how would coalescing help even if there were a lot of smaller free extents? Oracle would do the coalesce automatically, there would be no difference between manually coalescing or allowing Oracle to do it when a new extent was needed. --- Richard Ji [EMAIL PROTECTED] wrote: Coalescing might help if there are many smaller free extents that can be coalesced. But that still doesn't solve Jay's problem. Because he doesn't want the table to extent at all since he just deleted 2 million rows so there are plenty of space within the segment itself. Those free blocks should be used, unless he is doing a direct path insert which will only use space above the HWM. Richard Ji -Original Message- Sent: Friday, November 29, 2002 2:05 PM To: Multiple recipients of list ORACLE-L did u coalesced the tablespaces? -Original
Semi-OT: Pics from OracleWorld
Apologies for the delay (the digital camera died on the trip over) so apologies as well for the picture quality (all taken with a throwaway disposable camera). But, here they are... the rough bunch that is the Oracle Fatcity-L crew in San Francisco. http://www.oracledba.co.uk/sanfran.htm Cheers Connor = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Extent sizes when using LMT with autoallocate clause
Title: Extent sizes when using LMT with autoallocate clause From memory... 16 extents of 64K = 1 meg 63 extents of 1m = 63 meg (64 total) 120 extents of 8m = 960 meg (1024 meg or 1 gig total) Additional extents are 64m (I never found an upward bound in testing...) *This is undocumented by Oracle (last I checked) Dan Fink -Original Message-From: Daiminger, Helmut [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 03, 2002 9:04 AMTo: Multiple recipients of list ORACLE-LSubject: Extent sizes when using LMT with autoallocate clause Hi! I was wondering what the allocated extent sizes for locally managed tablespaces with the autoallocate clause are? The first extents are 64k in size. How many 64k chunks are allocated? What are the next sizes? CREATE TABLESPACE local_auto DATAFILE '/u02/oradata/local_auto01.dbf' SIZE 1M reuse EXTENT MANAGEMENT LOCAL AUTOALLOCATE; This is 9.2.0.2 on Solaris. Thanks, Helmut
RE: Help with Java
John - I forwarded your message to one of our newly-trained Java
programmers. He replied with:
The code is incomplete, how are they handling the connection.
Obviously the while loops are messing each other up.
There are multiple ways of handling this.
If I see the complete code I can be more specific.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, December 03, 2002 12:25 PM
To: Multiple recipients of list ORACLE-L
All,
I am beginning the journey into JAVA and have hit an odd behavior
(well, probably not, but I can't see any reason for it). I am
building a list of tablespaces and the datafiles that belong to them.
The open to the database is working fine. When I use:
ResultSet myTablespaces = myStatement.executeQuery(
SELECT tablespace_name +
FROM dba_tablespaces +
WHERE contents = 'PERMANENT'
);
while (myTablespaces.next()) {
// retrieve the user from the row in the ResultSet using the
// getString() method
ct = ct + 1;
String tablespace = myTablespaces.getString(1);
System.out.println(Tablespace + ct + is: + tablespace);
}
myTablespace.close();
I am generating a list of tablespaces and the output is as expected.
When I add a second result set, the first datafile of the first tablespace
returns and then the program completes:
ResultSet myTablespaces = myStatement.executeQuery(
SELECT tablespace_name +
FROM dba_tablespaces +
WHERE contents = 'PERMANENT'
);
while (myTablespaces.next()) {
// retrieve the user from the row in the ResultSet using the
// getString() method
ct = ct + 1;
String tablespace = myTablespaces.getString(1);
System.out.println(Tablespace + ct + is: + tablespace);
ResultSet myDataFiles = myStatement.executeQuery(
SELECT file_name +
FROM dba_data_files +
WHERE tablespace_name = ' + tablespace + '
);
while (myDataFiles.next()) {
String filename = myDataFiles.getString(1);
System.out.println( + filename);
}
myDataFiles.close();
}
myTablespaces.close();
Anybody with some Java experience have any insite?
As always, TIA,
John P Weatherman
Database Administrator
Replacements Ltd.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: install of 64 and 32 bit
Title: RE: install of 64 and 32 bit AIX 5.1 you can install only 9201 64 bit. 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! *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
Re: SLA Trigger/Procedure
Stephan, There will be no relevant info in the alert.log about the time when database was unavailable, if database was not shut down properly (let say, the plug was pulled). Or, may be I misunderstood you? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 03, 2002 2:10 PM [EMAIL PROTECTED] wrote: Ethan, That records the startup times, but does not record the time that the database was unavailable. What's needed is a 3rd party monitor that is not dependent on the database being up to record metrics. Jared Jared, I am far from having given much thought to this interesting idea but you can possibly work around this by using utl_file to check background_dump_dest. If it's not recorded in the alert.log, you probably have a .trc file hanging around. This optimistically assumes of course that you do not let you alert.log file grow out of control, because the idea of reading with UTL_FILE a 300M+ text file is not properly exciting. In fact the solution might be some external procedure to do in C directory operations, stat() calls and the like. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE:
On Unix, you can back up the installation directory. If you need to go back to the old version, put the old directory back. You can use tape, tar, cpio, cp, etc. to do this. Example 1 cd /path/here/product tar cvf /path/elsewhere/old817.tar 8.1.7 (assuming 8.1.7 is the directory to back up) If you want, you can compress the resulting tar file. Example 2 cd /path/here/product/8.1.7 find . -print | cpio -pvmud /path/elsewhere/8.1.7 If you find that you need to go back to the old version, just restore your backup. -Original Message- From: Scott Stefick [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 1:21 PM To: Multiple recipients of list ORACLE-L Subject: Gurus, I was just given a project to maintain a Computerized Maintenance Management System. When I asked the companies support staff how to roll back patches in the backend Oracle Database (Ver. 8174), they said that there was no way to do this. I'm guessing I could use logminer just incase a patch doesn't work. Would this be a good solution, or are there other (better) ways of safeguarding myself when it comes to patching? Obviously, I will be applying the patches to a test instance first, but I don't want to have to go back to restore from a backup if the patch causes unexpected issues. TIA! ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-2083 DATABASE name has illegal character '-'
Yes I have taken the insert statement out of the logon trigger and it works
fine. I think there may be a possible bug
with logon trigger using database links.
DENNIS WILLIAMS
DWILLIAMS@life To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
touch.comcc:
Sent by: Subject: RE: ORA-2083 DATABASE name has
illegal character '-'
[EMAIL PROTECTED]
m
12/03/2002
03:14 PM
Please respond
to ORACLE-L
Rick - Have you tested the link itself?
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, December 03, 2002 1:10 PM
To: Multiple recipients of list ORACLE-L
Hi,
Oracle 8.1.6.0.0 NT 4.0
I have the following logon trigger. It works fine as long I insert into
local table. If I try to insert into a table across a database link the
record get inserted but upon exiting the app whether it is
sqlplus,forms,etc I get ora-2083. I think it is probably a bug since I
have exact same environment and it works Ok. It fails
on 3 other identical environments. Anyone heard of any possible bugs using
database link in logon trigger? I search metalink and google but
no such reported error.
DROP PUBLIC DATABASE LINK utilities_a12345_dblink;
CREATE PUBLIC DATABASE LINK utilities_a12345_dblink CONNECT TO utilities
IDENTIFIED BY 123x456x USING 'a123456';
GRANT SELECT ON v_$session TO PUBLIC;
GRANT SELECT ON v_$instance TO PUBLIC;
DROP TRIGGER login_capture;
CREATE OR REPLACE TRIGGER login_capture AFTER LOGON ON DATABASE
DECLARE
CURSOR temp_rec IS
SELECT user AS user_name,
NVL(UPPER(SUBSTR(osuser,1,30)),'SERVER') AS os_user_name,
RTRIM(NVL(SUBSTR(machine,instr(machine,'\') +1,12),'SERVER'),CHR(0))
AS machine_name,
sid AS session_id,
serial# AS serial_no,
SYSDATE AS logon_time,
SYS_CONTEXT('userenv','ip_address') AS ip_address,
NVL(SUBSTR(program,1,64),'INTERNAL') AS program_name,
i.instance_name AS instance_name,
i.host_name AS host_name,
i.version AS version
FROM v$session s,v$instance i
WHERE s.username = user
AND s.logon_time = (SELECT MAX(x.logon_time)
FROM v$session x
WHERE x.username = user);
BEGIN
FOR rec IN temp_rec LOOP
INSERT INTO login_history@utilities_itport02_dblink
(user_name,
os_user_name,
machine_name,
session_id,
serial_no,
logon_time,
ip_address,
program_name,
instance_name,
host_name,
version)
VALUES (rec.user_name,
rec.os_user_name,
rec.machine_name,
rec.session_id,
rec.serial_no,
rec.logon_time,
rec.ip_address,
rec.program_name,
rec.instance_name,
rec.host_name,
rec.version);
END LOOP;
EXCEPTION
WHEN OTHERS THEN
NULL;
END;
/
ALTER TRIGGER login_capture ENABLE;
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services
RE: image storage confusion ??
I would test it on raw disk device because it avoids double buffering. -Original Message- Sent: Tuesday, December 03, 2002 2:49 AM To: Multiple recipients of list ORACLE-L Guys , i posted this already and this time my question is a bit different . I have to store 20,000,000 images of 5k each either in DB ( on win2k) or linux o/s file system. the images are to be displayed over mobile phones.so the time to retrieve the images should be minimum. for this to be achieved , i am confused , whether the images should be stored in o/s file system or in the DB ? --selecting a file from linux o/s file system --- or --querying it from oracle DB ( on win2k) --- which of the above will be faster ? all these will be done with java . this being condition , i would like to know ur suggestion guys. my DB is oracle 8.1.6 on Win2k. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SLA Trigger/Procedure
Kirti, Nice script for checking availability. May I remind everyone that you get an additional free check by running this on a different physical host - you are then checking physical host availability and at least some degree of network connectivity as well. I still think my original suggestion has some merit - Ethan was talking about some functionality to indicate service levels and track uptime/downtime, whereas we seem to have steered the discussion into a database availability monitoring tool. Still, it's been a good discussion with a lot of valid comments by everyone involved. Deshpande, Kirti kirti.deshpande@ve To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] rizon.comcc: Sent by: Subject: RE: SLA Trigger/Procedure [EMAIL PROTECTED] 04/12/2002 03:59 Please respond to ORACLE-L Tool? I have a tool. Want to buy? ;) It's a simple script that connects (actually attempts to connect with a fake id/pw) to the target DB (on Windows, HP-Alpha/VMS, UNIX) over Oracle Net. Scans for the ORA- errors and we know if the DB is accessible or not, as well as if Listener is responding. No need for any 'special' ids to run 'select stuff from dual', which in itself can be expensive (depending on the DB version). I think I had posted this script a few times before. Here it is again. Customize it to suit you requirements to send page/emails/update table etc...: (btw -- Steve Adams has an elaborate version that checks for a few more things. Check his web site) #!/usr/bin/ksh # # dbcheck : Script to check if database is up and accessible # # Author : Kirti Deshpande #--- echo Enter Name of the Database SID to check if it is accessible read DB sqlplus -s EOF /tmp/$$.1 whenever sqlerror exit aaa/aaa@$DB exit; EOF egrep 'ORA-121|ORA-01034' /tmp/$$.1 /dev/null if [[ $? = 0 ]] then echo - '$DB' is _NOT_ Accessible\n else grep 'ORA-01017' /tmp/$$.1 /dev/null if [[ $? = 0 ]] then echo - '$DB' is UP and Accessible\n else echo - '$DB' is _NOT_ Accessible\n fi fi rm /tmp/$$.1 # --- End of File - Kirti -Original Message- Sent: Tuesday, December 03, 2002 4:14 AM To: Multiple recipients of list ORACLE-L Yup, got that covered :) If I may add another point. When dealing with SLA's, you not only have to show that the database has been servicing users that are connected (showing database uptime), but also that users can also *connect* to the database as well (the listener is servicing requests). If you were to go about this with a trigger/procedure that inserts in to a table, then this doesn't show that the database was available to everybody. Typically what we do with monitoring tools is a connect on ping, so when we are checking availability of a database we do a full connect, then select 'PING' from dual;. If there are any errors along the way we search for the error code, and deal with the appropriate alerts (TNS = Listener problem, ORA = Database problem). Of course, the problem with doing it this way, is that you are going to have to write platform dependant scripts (batches for NT, shell type scripts for Unix), and not have a one for all with a database based solution. Go buy a tool. Let it write to a table/file, alert you AND make the coffee for when you get there! ;) Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk
[Q] ORACLE 9.2 SGA_MAX_size cause SUN server crash ????
We are doing ORACLE 9.2.0.2 Enterprise Edition testing on SUN server (Solaris 8). Currently one problem happen. If I put SGA_MAX_size entry on init.ora file and restart database, the SUN server will crash and following messages on /var/adm/message file: Dec 3 13:34:59 ISS unix: [ID 253085 kern.notice] NOTICE: hat_memload: unsupported flags 256 Dec 3 13:35:00 ISS unix: [ID 253085 kern.notice] NOTICE: hat_memload: unsupported flags 256 Dec 3 13:35:02 ISS last message repeated 9618 times Dec 3 13:35:03 ISS unix: [ID 836849 kern.notice] Dec 3 13:35:03 ISS ^Mpanic[cpu3]/thread=ffba0ac0: Dec 3 13:35:03 ISS unix: [ID 977504 kern.notice] invalid shared memory l1 ptp Dec 3 13:35:03 ISS unix: [ID 10 kern.notice] Dec 3 13:35:03 ISS genunix: [ID 872817 kern.notice] e166ba40 unix:srmmu_share+130 (0, 0, ff61af38, 0, 8, ff619c20) Dec 3 13:35:03 ISS genunix: [ID 645206 kern.notice] %l0-7: 0800 ff61a998 2100 0001 ffc77004 ff0982c0 ffc77484 01629b 31 Dec 3 13:35:03 ISS genunix: [ID 872817 kern.notice] e166bab0 genunix:as_dup+dc (0, ffba14a0, ff61a9b4, ffbe2c28, ffbe2c44, ff61a99 8) Dec 3 13:35:03 ISS genunix: [ID 645206 kern.notice] %l0-7: e00e94f0 ffc8f760 f0a2981c ff385908 e166bb7c ff385908 df13a0 00 Dec 3 13:35:03 ISS genunix: [ID 872817 kern.notice] e166bb10 genunix:cfork+10c (0, 0, ff876768, 1e, 0, 0) Dec 3 13:35:03 ISS genunix: [ID 645206 kern.notice] %l0-7: 40401085 df119740 df119744 e006 ffba0ac0 ff577c10 e166bb 80 Dec 3 13:35:03 ISS unix: [ID 10 kern.notice] Dec 3 13:35:03 ISS genunix: [ID 672855 kern.notice] syncing file systems... Dec 3 13:35:03 ISS genunix: [ID 733762 kern.notice] 2 Dec 3 13:35:03 ISS genunix: [ID 733762 kern.notice] 1 Dec 3 13:35:03 ISS last message repeated 19 times Dec 3 13:35:03 ISS genunix: [ID 616637 kern.notice] cannot sync -- giving up Dec 3 13:35:03 ISS genunix: [ID 353387 kern.notice] dumping to /dev/dsk/c0t0d0s1, offset 83886080 Dec 3 13:35:03 ISS genunix: [ID 409368 kern.notice] ^M100% done: 10698 pages dumped, compression ratio 2.95, Dec 3 13:35:03 ISS genunix: [ID 851671 kern.notice] dump succeeded If I take out SGA_MAX_size entry from init.ora, the database run correctly. Does anyone knoe why SUN server crash? Thanks. _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dist cash INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:
I would recommend a restore because you are going to backup for applying a patch anyway RIGHT? Logminer would do nothing as far as the OS files getting overwritten by applying the patch. Rick Scott Stefick sstefick@harper To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .cc.il.us cc: Sent by: Subject: [EMAIL PROTECTED] 12/03/2002 02:21 PM Please respond to ORACLE-L Gurus, I was just given a project to maintain a Computerized Maintenance Management System. When I asked the companies support staff how to roll back patches in the backend Oracle Database (Ver. 8174), they said that there was no way to do this. I'm guessing I could use logminer just incase a patch doesn't work. Would this be a good solution, or are there other (better) ways of safeguarding myself when it comes to patching? Obviously, I will be applying the patches to a test instance first, but I don't want to have to go back to restore from a backup if the patch causes unexpected issues. TIA! ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: which bind variable value causes ora-1722
Mike, If there a trigger on the table that does some DML with another table? You already got the sql statement. Why not run that in sql*plus the exact same way, after declaring the bind variables and assigning them the same values you found in the trace file and see what happens? From sql prompt variable element_id number variable... exec :element_id := 250 ... finally your query verbatim. HTH Arup - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 03, 2002 10:04 AM Hi, all, My developer continually got ora-1722 when he was installing a new billing system. I used 10046 event to get trace file, but i could not figure out which bind variable value causes the error, here is the part of trace: PARSING IN CURSOR #1 len=229 dep=0 uid=62 oct=2 lid=62 tim=807252370 hv=4084410285 ad='9f31e880' insert into fold_bal_impacts_t ( element_id, fixed_operand, flags, free_quantity, gl_id, scaled_operand, rec_id, obj_id0 ) values ( :element_id, :fixed_operand, :flags, :free_quantity, :gl_id, :scaled_operand, :rec_id, :obj_id0 ) END OF STMT PARSE #1:c=0,e=1,p=0,cr=1,cu=0,mis=1,r=0,dep=0,og=0,tim=807252370 BINDS #1: bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=01 oacfl2=0 size=224 offset=0 bfp=018bacd0 bln=22 avl=03 flg=05 value=250 bind 1: dty=1 mxl=32(01) mal=00 scl=00 pre=00 oacflg=01 oacfl2=10 size=0 offset=24 bfp=018bace8 bln=32 avl=01 flg=01 value=0 bind 2: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=01 oacfl2=0 size=0 offset=56 bfp=018bad08 bln=22 avl=01 flg=01 value=0 bind 3: dty=1 mxl=32(01) mal=00 scl=00 pre=00 oacflg=01 oacfl2=10 size=0 offset=80 bfp=018bad20 bln=32 avl=01 flg=01 value=0 bind 4: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=01 oacfl2=0 size=0 offset=112 bfp=018bad40 bln=22 avl=01 flg=01 value=0 bind 5: dty=1 mxl=32(07) mal=00 scl=00 pre=00 oacflg=01 oacfl2=10 size=0 offset=136 bfp=018bad58 bln=32 avl=07 flg=01 value=6.55802 bind 6: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=01 oacfl2=0 size=0 offset=168 bfp=018bad78 bln=22 avl=01 flg=01 value=0 bind 7: dty=1 mxl=32(05) mal=00 scl=00 pre=00 oacflg=01 oacfl2=10 size=0 offset=192 bfp=018bad90 bln=32 avl=05 flg=01 value=10382 EXEC #1:c=0,e=0,p=0,cr=0,cu=2,mis=0,r=0,dep=0,og=3,tim=807252370 ERROR #1:err=1722 tim=807252370 And here is the table: SQLdesc fold_bal_impacts_t NameNull?Type --- OBJ_ID0 NUMBER(38) REC_ID NUMBER(38) ELEMENT_ID NUMBER(38) FIXED_OPERANDNUMBER FLAGSNUMBER(38) FREE_QUANTITYNUMBER GL_IDNUMBER(38) SCALED_OPERAND NUMBER And there is no any constraints on this table. Please help, thanks. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mike ding INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
the issue solved Re: which bind variable value causes ora-1722
After spending hours debugging, we finally found the solution: NLS_LANG.
There is no problem if nls_lang is american_america.utf8; while ora-1722
occurs when nls_lang is set to american_canada.utf8. The culprit is 6.55802.
And when nls_lang is set to american_canada.utf8, the default decimal
separator is a comma! So Oracle failed to do implicit conversion
to_number('6.55208'), could only do to_number('6,55208').
Thanks.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December 03, 2002 2:21 PM
Mike,
It is the value in the :gl_id string, which is 6.55802.
The column GL_ID is defined as an integer of 38 digits (i.e.
NUMBER(38) instead of NUMBER), so there is no room for
digits to the right of the decimal...
Hope this helps...
-Tim
Hi, all,
My developer continually got ora-1722 when he was
installing a new billing system. I used 10046 event to get
trace file, but i could not figure out which bind variable
value causes the error, here is the part of trace:
PARSING IN CURSOR #1 len=229 dep=0 uid=62 oct=2 lid=62
tim=807252370 hv=4084410285 ad='9f31e880'
insert into fold_bal_impacts_t ( element_id,
fixed_operand, flags, free_quantity, gl_id,
scaled_operand, rec_id, obj_id0 ) values ( :element_id,
:fixed_operand, :flags, :free_quantity, :gl_id,
:scaled_operand, :rec_id, :obj_id0 ) END OF STMT
PARSE
#1:c=0,e=1,p=0,cr=1,cu=0,mis=1,r=0,dep=0,og=0,tim=80725237
0 BINDS #1:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=01
oacfl2=0 size=224 offset=0
bfp=018bacd0 bln=22 avl=03 flg=05
value=250
bind 1: dty=1 mxl=32(01) mal=00 scl=00 pre=00 oacflg=01
oacfl2=10 size=0 offset=24
bfp=018bace8 bln=32 avl=01 flg=01
value=0
bind 2: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=01
oacfl2=0 size=0 offset=56
bfp=018bad08 bln=22 avl=01 flg=01
value=0
bind 3: dty=1 mxl=32(01) mal=00 scl=00 pre=00 oacflg=01
oacfl2=10 size=0 offset=80
bfp=018bad20 bln=32 avl=01 flg=01
value=0
bind 4: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=01
oacfl2=0 size=0 offset=112
bfp=018bad40 bln=22 avl=01 flg=01
value=0
bind 5: dty=1 mxl=32(07) mal=00 scl=00 pre=00 oacflg=01
oacfl2=10 size=0 offset=136
bfp=018bad58 bln=32 avl=07 flg=01
value=6.55802
bind 6: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=01
oacfl2=0 size=0 offset=168
bfp=018bad78 bln=22 avl=01 flg=01
value=0
bind 7: dty=1 mxl=32(05) mal=00 scl=00 pre=00 oacflg=01
oacfl2=10 size=0 offset=192
bfp=018bad90 bln=32 avl=05 flg=01
value=10382
EXEC
#1:c=0,e=0,p=0,cr=0,cu=2,mis=0,r=0,dep=0,og=3,tim=80725237
0 ERROR #1:err=1722 tim=807252370
And here is the table:
SQLdesc fold_bal_impacts_t
NameNull?Type
---
OBJ_ID0 NUMBER(38)
REC_ID NUMBER(38)
ELEMENT_ID NUMBER(38)
FIXED_OPERANDNUMBER
FLAGSNUMBER(38)
FREE_QUANTITYNUMBER
GL_IDNUMBER(38)
SCALED_OPERAND NUMBER
And there is no any constraints on this table.
Please help, thanks.
Mike
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com --
Author: mike ding
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
http://www.fatcity.com San Diego, California--
Mailing list and web hosting services
--
--- To REMOVE yourself from this mailing list,
send an E-Mail message to: [EMAIL PROTECTED] (note
EXACT spelling of 'ListGuru') and in the message BODY,
include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from). You may also
send the HELP command for other information (like
subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: mike ding
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To
RE: SLA Trigger/Procedure
I agree what is needed is something very generic that could monitor the uptime of pretty much any process. After giving this more thought and always liking to keep things simple here is the direction I might eventually head. The logic below would result in a log file that shows all unscheduled outage periods. You would have to ensure it runs at regular intervals. (NOT VERY PRETTY, BUT SIMPLE ENOUGH) Files Required: * Control file that has crontab like entries which define periods that are either outages or times when database is expected to be running. Script Workings: * Run command/script which returns 0 or 1 (0=thingy not running, 1=thingy running) use separate command/script to log into database, grep for process etc... If (( 0 )) check control file to see if thingy should be running if suppose to be running store time trigger flag (cat time to flag file) if not suppose to be running if flag unscheduled outage was triggered but has rolled into an scheduled outage period log start and end time for outage reset flag fi fi else if flag thingy is back up log start and end time for outage reset flag fi fi -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Semi-OT: Pics from OracleWorld
Connor: Perfect pictures. Office looks cool. Perhaps Larry could sell Oracle in Linux there. Small platform, low cost. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Tuesday, December 03, 2002 3:35 PM To: Multiple recipients of list ORACLE-L Subject:Semi-OT: Pics from OracleWorld Apologies for the delay (the digital camera died on the trip over) so apologies as well for the picture quality (all taken with a throwaway disposable camera). But, here they are... the rough bunch that is the Oracle Fatcity-L crew in San Francisco. http://www.oracledba.co.uk/sanfran.htm Cheers Connor = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-2083 DATABASE name has illegal character '-'
Rick - Can you do that insert in SQL*Plus (outside the trigger)? I'm sure
you have, just my logical completeness tendency.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, December 03, 2002 3:09 PM
To: Multiple recipients of list ORACLE-L
Yes I have taken the insert statement out of the logon trigger and it works
fine. I think there may be a possible bug
with logon trigger using database links.
DENNIS WILLIAMS
DWILLIAMS@life To: Multiple recipients of
list ORACLE-L [EMAIL PROTECTED]
touch.comcc:
Sent by: Subject: RE: ORA-2083 DATABASE
name has illegal character '-'
[EMAIL PROTECTED]
m
12/03/2002
03:14 PM
Please respond
to ORACLE-L
Rick - Have you tested the link itself?
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, December 03, 2002 1:10 PM
To: Multiple recipients of list ORACLE-L
Hi,
Oracle 8.1.6.0.0 NT 4.0
I have the following logon trigger. It works fine as long I insert into
local table. If I try to insert into a table across a database link the
record get inserted but upon exiting the app whether it is
sqlplus,forms,etc I get ora-2083. I think it is probably a bug since I
have exact same environment and it works Ok. It fails
on 3 other identical environments. Anyone heard of any possible bugs using
database link in logon trigger? I search metalink and google but
no such reported error.
DROP PUBLIC DATABASE LINK utilities_a12345_dblink;
CREATE PUBLIC DATABASE LINK utilities_a12345_dblink CONNECT TO utilities
IDENTIFIED BY 123x456x USING 'a123456';
GRANT SELECT ON v_$session TO PUBLIC;
GRANT SELECT ON v_$instance TO PUBLIC;
DROP TRIGGER login_capture;
CREATE OR REPLACE TRIGGER login_capture AFTER LOGON ON DATABASE
DECLARE
CURSOR temp_rec IS
SELECT user AS user_name,
NVL(UPPER(SUBSTR(osuser,1,30)),'SERVER') AS os_user_name,
RTRIM(NVL(SUBSTR(machine,instr(machine,'\') +1,12),'SERVER'),CHR(0))
AS machine_name,
sid AS session_id,
serial# AS serial_no,
SYSDATE AS logon_time,
SYS_CONTEXT('userenv','ip_address') AS ip_address,
NVL(SUBSTR(program,1,64),'INTERNAL') AS program_name,
i.instance_name AS instance_name,
i.host_name AS host_name,
i.version AS version
FROM v$session s,v$instance i
WHERE s.username = user
AND s.logon_time = (SELECT MAX(x.logon_time)
FROM v$session x
WHERE x.username = user);
BEGIN
FOR rec IN temp_rec LOOP
INSERT INTO login_history@utilities_itport02_dblink
(user_name,
os_user_name,
machine_name,
session_id,
serial_no,
logon_time,
ip_address,
program_name,
instance_name,
host_name,
version)
VALUES (rec.user_name,
rec.os_user_name,
rec.machine_name,
rec.session_id,
rec.serial_no,
rec.logon_time,
rec.ip_address,
rec.program_name,
rec.instance_name,
rec.host_name,
rec.version);
END LOOP;
EXCEPTION
WHEN OTHERS THEN
NULL;
END;
/
ALTER TRIGGER login_capture ENABLE;
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL
RE: [Q] ORACLE 9.2 SGA_MAX_size cause SUN server crash ????
Dist - It sounds like you are setting SGA_MAX_SIZE too large for the server kernel. Try setting it smaller and see if the server is okay with that. If this is true, then you may need to adjust some Solaris kernel parameters. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 03, 2002 3:20 PM To: Multiple recipients of list ORACLE-L We are doing ORACLE 9.2.0.2 Enterprise Edition testing on SUN server (Solaris 8). Currently one problem happen. If I put SGA_MAX_size entry on init.ora file and restart database, the SUN server will crash and following messages on /var/adm/message file: Dec 3 13:34:59 ISS unix: [ID 253085 kern.notice] NOTICE: hat_memload: unsupported flags 256 Dec 3 13:35:00 ISS unix: [ID 253085 kern.notice] NOTICE: hat_memload: unsupported flags 256 Dec 3 13:35:02 ISS last message repeated 9618 times Dec 3 13:35:03 ISS unix: [ID 836849 kern.notice] Dec 3 13:35:03 ISS ^Mpanic[cpu3]/thread=ffba0ac0: Dec 3 13:35:03 ISS unix: [ID 977504 kern.notice] invalid shared memory l1 ptp Dec 3 13:35:03 ISS unix: [ID 10 kern.notice] Dec 3 13:35:03 ISS genunix: [ID 872817 kern.notice] e166ba40 unix:srmmu_share+130 (0, 0, ff61af38, 0, 8, ff619c20) Dec 3 13:35:03 ISS genunix: [ID 645206 kern.notice] %l0-7: 0800 ff61a998 2100 0001 ffc77004 ff0982c0 ffc77484 01629b 31 Dec 3 13:35:03 ISS genunix: [ID 872817 kern.notice] e166bab0 genunix:as_dup+dc (0, ffba14a0, ff61a9b4, ffbe2c28, ffbe2c44, ff61a99 8) Dec 3 13:35:03 ISS genunix: [ID 645206 kern.notice] %l0-7: e00e94f0 ffc8f760 f0a2981c ff385908 e166bb7c ff385908 df13a0 00 Dec 3 13:35:03 ISS genunix: [ID 872817 kern.notice] e166bb10 genunix:cfork+10c (0, 0, ff876768, 1e, 0, 0) Dec 3 13:35:03 ISS genunix: [ID 645206 kern.notice] %l0-7: 40401085 df119740 df119744 e006 ffba0ac0 ff577c10 e166bb 80 Dec 3 13:35:03 ISS unix: [ID 10 kern.notice] Dec 3 13:35:03 ISS genunix: [ID 672855 kern.notice] syncing file systems... Dec 3 13:35:03 ISS genunix: [ID 733762 kern.notice] 2 Dec 3 13:35:03 ISS genunix: [ID 733762 kern.notice] 1 Dec 3 13:35:03 ISS last message repeated 19 times Dec 3 13:35:03 ISS genunix: [ID 616637 kern.notice] cannot sync -- giving up Dec 3 13:35:03 ISS genunix: [ID 353387 kern.notice] dumping to /dev/dsk/c0t0d0s1, offset 83886080 Dec 3 13:35:03 ISS genunix: [ID 409368 kern.notice] ^M100% done: 10698 pages dumped, compression ratio 2.95, Dec 3 13:35:03 ISS genunix: [ID 851671 kern.notice] dump succeeded If I take out SGA_MAX_size entry from init.ora, the database run correctly. Does anyone knoe why SUN server crash? Thanks. _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dist cash INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
