Re: database hang on, no responsing
in server manager as sysdba SVRMGR archive log list enter is the database running in ARCHIVELOG mode ? is the parameter log_archive_start = TRUE ? is the log_archive_dest full ? hth, Paul Wendy Y wrote: Hi Guy: We have a database running. Everybody can log into, do select, desc etc. But can't insert into... When someone is trying to insert, the database just hang on, no responsing at all and no error messages. have to restart database to make it work again. Is there best way to find application or transaction against some tables and lock those tables. Or any way to release those lock (like killing the user sql session, or better way) without restarting database. Is there any performance problem. How could I find the problem soon and fix it? Thank you so much. Wendy. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: query fails when run using microsoft odbc driver
Hi, I think the problem arise may be due to this (select GetUTCDate() now from dual) as now is the reserve key word used by microsoft as sysdate in oracle. Try it. Its just a thought. Ketan. Harvinder Singh wrote: Hi, We have a query which runs fine from sqlplus but return following error when runs from appliction using MICROSOFT ODBC Driver: ora-00904 INVALID COLUMN NAME Code of query is: it seems like specification of table template_po_map is creating problem... how to fix it . select DISTINCT(t_po.id_po), t_po.id_eff_date, t_po.id_avail, t_po.b_user_subscribe, t_po.b_user_unsubscribe, t_base_props.n_name, t_base_props.n_desc, t_base_props.n_display_name, t_base_props.nm_name, t_base_props.nm_desc, t_base_props.nm_display_name, te.n_begintype as te_n_begintype, te.dt_start as te_dt_start, te.n_beginoffset as te_n_beginoffset, te.n_endtype as te_n_endtype, te.dt_end as te_dt_end, te.n_endoffset as te_n_endoffset, ta.n_begintype as ta_n_begintype, ta.dt_start as ta_dt_start, ta.n_beginoffset as ta_n_beginoffset, ta.n_endtype as ta_n_endtype, ta.dt_end as ta_dt_end, ta.n_endoffset as ta_n_endoffset ,template_po_map.b_RecurringCharge ,t_ep_po.c_boris t_ep_po_c_boris,t_ep_po.c_ExternalInformationURL t_ep__c_ExternalInformationURL,t_ep_po.c_glcode t_ep_po_c_glcode,t_ep_po.c_InternalInformationURL t_ep__c_InternalInformationURL from (select GetUTCDate() now from dual) cdate, t_po,t_ep_po, t_effectivedate te, t_effectivedate ta, t_base_props, (SELECT id_po, decode(MAX(YesNo),1,'Y','N') b_RecurringCharge FROM (SELECT t_pl_map.id_po, decode(tb.n_kind,20,decode(sign(count(*)),1,1,0),0) YesNo FROM t_av_internal tav, t_pricelist, t_base_props tb, t_pl_map, t_recur, t_discount, t_aggregate WHERE -- Check currency t_recur.id_prop(+) = t_pl_map.id_pi_template and t_discount.id_prop(+) = t_pl_map.id_pi_template and t_aggregate.id_prop(+) = t_pl_map.id_pi_template and tav.id_acc = 134 AND t_pricelist.id_pricelist = t_pl_map.id_pricelist AND tav.c_currency = t_pricelist.nm_currency_code AND -- Check cycle type (t_recur.id_cycle_type is null or t_recur.id_cycle_type = (select id_cycle_type from t_acc_usage_cycle, t_usage_cycle where t_acc_usage_cycle.id_acc = 134 AND t_usage_cycle.id_usage_cycle = t_acc_usage_cycle.id_usage_cycle)) AND (t_discount.id_cycle_type is null or t_discount.id_cycle_type = (select id_cycle_type from t_acc_usage_cycle, t_usage_cycle where t_acc_usage_cycle.id_acc = 134
impressed with OUI/dbca 2.0 security features
Hi. I noticed when using the dbca included with OUI 2.0 as part of the 9.0.1.1 release for Win32 that there is a password editing screen that actually locks the oracle app_owner schemas such as CTXSYS, MDSYS, ORDSYS, and gives the user a very convenient way to change the privileged account passwords during the install. I'd just like to say that this is the same mentality that had made OpenBSD a great distribution for building bastion hosts/firewalls - secure by default - at installation time. Someone at Oracle deserves kudos for locking those accounts that used to be granted DBA and left with an account the same as the username. Back to my network intrusion book ... Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Determine number of times a datafile has extended
Is it possible to determine how many times a file has extended? I know that v$datafile.CREATE_BYTES will show what size the file was initially created at. And dba_data_files.INCREMENT_BY shows how much each datafile is currently set to extend by (number of database blocks). But, given that we can manually resize a file and that we can alter the value of next for a datafile, does Oracle store how many times each file has extended? Why is this of interest - this number can be related to / help explain the degree of OS fragmentation for the datafile. Thanks, Bruce Reardon -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-04031
need to see a trace file for more info... -Original Message- From: Eca Eca [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 7:35 PM To: Multiple recipients of list ORACLE-L Subject: ORA-04031 Friends : I am using 9i and receiving : ORA-04031: unable to allocate 8704 bytes of shared memory (large pool,unknown object,hash-join subh,kllcqas:kllsltba) I have 2gb of memory In init.ora i have large values for pool parameters ... What is happening ? Any idea ? The db_cache_size is around 932 mb shared_pool is around 369 mb Regards Eriovaldo _ Chegou o novo MSN Explorer. Instale já. É gratuito! http://explorer.msn.com.br -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: BELOV INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORACLE VS. SYBASE
See below a mail I received from Sybase oriented person :) Please argue it maybe very interesting (original mail was Sybase vs Oracle:Why to go to Sybase?) /Maya - Sybase... - 11.9.2 is beating Oracle's database in Tpc tests. See the TPC-C tests at www.tpc.org and sort by Hardware Vendor. A recent TPC-C benchmark of Sybase ASE 12.0..0.2 on Sun E-1 beat Oracle on the same platform by 36%. (Cost per transaction (156,873 tpmC) was $48.81 vs. Oracle's (115,395 tpmC) of $105.63). This is the fastest TPC benchmark ever recorded (as of 12/2000) for a SMP environment. - Sybase is far less Expensive than Oracle. Arbitrarily, Oracle charges per megahertz on the CPU, a Universal Power Unit. UPU=number of processors multiplied by processor speed, multiplied by $100 (the current price per UPU). This has problems two ways; a PC chip works at far higher megahertz speeds than a Sun Ultrachip, meaning a far more powerful server costs far less than a PC-based server. Secondly, users are charged for capacity over an entire server, even if Oracle is not the only software running. Additional features are always additional cost in Oracle; Sybase builds in all features to its entine. - Oracle's Tech support is inferior compared to Sybase's. Online case management and updating, instant reponse times. - Sybase is cheaper to administer, from a DBA standpoint. Mgrs report that one Sybase DBA can do what 2-3 Oracle DBA's do. - Sybase's Customization and Tuning is simple (one text file contains hundreds of database server options) compared to tuning Oracle. It is far easier to administer, install, operate Sybase. Very easy to create databases versus instances. - requires fewer system resources; Sybase's code runs within one operating system process, not dozens like Oracle. Sybase manages memory better. - more efficient use of tempdb. Oracle has a temporary workspace but does not clean itself up afterward like Sybase's tempdb. - has far better documentation. Sybooks is nicely organized and searchable. Oracle's is a nightmare. - Ease of data migrations both in and out of Sybase. Oracle has no tools to export data out of its Databases (except in native format). - Disaster Recovery; with inline backup utilities, Sybase can back itself up on the fly w/o taking tablespaces offline. Replication server creates a warm standby for 100% uptime. Oracle can do neither. - Reliability/Stability; Banks, Financial institutions, NYSE, Nasdaq, Amex all run Sybase. Sybase owns 90% of the financial industry. Oracle has a directory (/admin/cdumps) specifically made to collect core files! - Use of Transaction logs: Sybase has rollback and recovery transaction log features built into the same construct; each transaction only needs to be written to one place. Oracle must write transactions twice (once to the Rollback segment, once to the Redo log) because the recovery feature was never built into the main engine. Configuration is thus more difficult. I/O increases. - Backup capabilities; Sybase has builtin backup tools; Oracle depends on file system/3rd party backup solutions (a very difficult endeavor when your data devices are on raw disks; dependency on dd commands to do backups). In Sybase its one command; in Oracle its a three-day class. Hot Backup capability requires additional I/O overhead. Oracle backups work best doing cold backups (i.e., shutting down the server...how feasable is that in today's computing environment??). - SQL limitations: You cannot mix DDL inline with an if statement in Oracle. You cannot truncate a table in Oracle w/o removing its constraints. Data types not being IEEE compliant (causing cpu overhead as regular numbers are passed in and converted on the fly constantly). Every select statement is am implicit cursor in Oracle. - Engine limitations; one instance, one database. One client, one process. One sql*plus client can only take one batch of sql at a time. Everything in Oracle is single-threaded, not multi-threaded like Sybase. - Similarity to Microsoft SQL Server: relatively easy to transfer data from one to another (on account of their past shared code base). Also relatively straightforward to re-train MS Sql server admins for Sybase and vice versa. - Features in Oracle not in Sybase and rebuttals - Automatic database segment growth; I would argue that this is incredibly dangerous to allow to occur. Its easy to extend databases, not so much to fail them back. Now many Unix SA's would like an automatic disk growth feature for their users? - Minus clause to detect table differences. Re-writable with a simple not exists clause of a select statement. - Decode statement; previously emulated with complicated abs functions, but now (12.0+) easily emulated with case and coalesce statements. - larger varchar() capabilities (beyond 255 characters):
Alert log from Remote client
Hi guru's Suppose that, i'm managing serveral database from a single client. In that case, how can i find out the alert log/trace files from the client. Any ideas pls. Regards, Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Does start with/connect by uses full table scan?
According to this page, you would use concatenated indexes: http://www.arsdigita.com/books/sql/trees.html Hmmm. g -Original Message- Sent: Monday, September 24, 2001 7:36 PM To: Multiple recipients of list ORACLE-L List, Does Oracle go for full table scan or does it use indexes when we use start with/connect by clause? Thanks, Rao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to Identify the BG processes?
List, In multiple database instances, how can i find the background processes of appropriate instances?.. reGARDS, nIRMAL. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Maxbytes - 7.3.3
however, if no datafile has ever been put into autoextend mode, the table sys.filext$ will not exist --- Jacques Kilchoer [EMAIL PROTECTED] wrote: -Original Message- From: O'Neill, Sean [mailto:[EMAIL PROTECTED]] Can anyone tell me please what view(s) on Oracle 7.3.3 I can use to identify the equivalent MAXBYTES (datafile size set to umlimited) as per DBA_DATA_FILES on 8i? Join sys.file$ to sys.filext$ Look at columns sys.filext$.inc (0 or null means autoextend = 'NO') and sys.filext$.maxextend __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
unable to tune free buffer waits
list, picking up the thread from my previous post..(7.3.2 on AIX) ** doing a select count(*) on a 5 million table is taking 5-6 hours !! ** multiblock_read_count is 16 (max for the platform) db_writers = 4 (async_Io is false) db buffers are 80MB i have checked the statistics by using event 10046 and also by looking at session_event both show free buffer waits and the table is being read SEQUENTIALLY many times !! (FTS should be done using SCATTERED READS ) even when doing scattered reads, the blocks read are 4 or 5 at a time...(not 16) other issues - i did a count(*) on ANOTHER table (right after importing 4 million rows) and all was ok - this table is heayly inserted into and i did the count(*) AFTER the insertion was finished. - alter system checkpoint takes 40 min. !! what's going on ?? TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
changing the internal password
Hello, I am trying to log in the sqlplus (from command line) as the internal user but I can´t remember its password. Is there any way to change it? TIA begin:vcard n:Jimenez;Beatriz Martinez x-mozilla-html:FALSE org:Fundación CIDAUT;Departamento de Informática adr:;;Parque Tecnológico de Boecillo p.209;Boecillo;Valladolid;47151;Spain version:2.1 email;internet:[EMAIL PROTECTED] title:Ingeniera Informática fn:Beatriz Martínez Jiménez end:vcard
RE: Any experience with Lecco Sql Expert Pro?
We've had it for a year. Works fine for simple queries, but don't expect too much for complex queries ... one big disadvantage is that it only converts SQL into different SQL statements, while sometimes a lot can be gained from exploring other options like pl/sql or operating system functions or whatever. At least that was true for the version we had ... version 2.1.0. If you have a choice, go for qualified developers instead of tools ! HTH, Remco -Oorspronkelijk bericht- Van: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]] Verzonden: maandag 24 september 2001 23:05 Aan: Multiple recipients of list ORACLE-L Onderwerp: Any experience with Lecco Sql Expert Pro? Hi all, Anyone has any experience with this product? Would you share your thoughts? I am looking at this product right now, so just asking for your views. Thanks 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 ! *1 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daemen, Remco INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
need insights :where to go 3 tierd or client server
gurus, Need your advice. i'm trying to migrate our system to oracle using 3 tierd. but we're experiencing a very slow response time 2 sec calling the form + 2sec itspopulating the queries = 4sec (total) compared to our original system w/c is less than a second . many network problems also arises w/c we didn't encounter before. is it wise to go 3 tierd or client server? what are the advantanges and disadvantages of going 3 tierd or client server? Oracle eats lot of resources and very expensive. It seems that going oracle is wrong choice. wat kind of network/resources does oracle need? is netscape a better choice than internet explorer when using oracle? thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: grace INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORACLE VS. SYBASE
Maya, I'd be interested in seeing the rest of this mail (if there is more?). See below, it looks like the tail of the message was cut off or corrupted? Cheers Mark P.S. - Great post - I'm sure it will start some flames :P -Original Message- Sent: Tuesday, September 25, 2001 10:15 To: Multiple recipients of list ORACLE-L See below a mail I received from Sybase oriented person :) Please argue it maybe very interesting (original mail was Sybase vs Oracle:Why to go to Sybase?) /Maya - - Synonyms: - Time datatype: Oracle seperates Time from Date. Sybase's datetime datatype has both included in one, plus a whole suite of display styles that can show the date/time in a multitude of formats.W±ëzØ¡÷r9,B¶Ã§©Ê뢳ɢw Ѭ éz»zf¢a´(È×ÂIêÇóßÎçQ_ÎçÓjpz jX¢¹hû'×ëqdzóX¸¶ÄDCTLº»÷¢kÉXX¶Çu©1¨ëj ¸¬´k«¹ör+rr§¢×\ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: changing the internal password
Hi , Use the Orapwd80.exe utility ..U can find it under the Oracle Home Regards Gholam -Original Message- From: Beatriz Martínez Jiménez [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 2:15 PM To: Multiple recipients of list ORACLE-L Subject: changing the internal password Hello, I am trying to log in the sqlplus (from command line) as the internal user but I can´t remember its password. Is there any way to change it? TIA File: Card for Beatriz Martínez Jiménez -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ahmed Gholam Hussain INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: changing the internal password
ALTER USER sys IDENTIFIED BY the password ; -Message d'origine- De : Beatriz Martínez Jiménez [mailto:[EMAIL PROTECTED]] Envoyé : mardi 25 septembre 2001 12:45 À : Multiple recipients of list ORACLE-L Objet : changing the internal password Hello, I am trying to log in the sqlplus (from command line) as the internal user but I can´t remember its password. Is there any way to change it? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ALEMU Abiy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: changing the internal password
You can use the orapwd utility to recreate the password file. Rick -Original Message- Sent: Tuesday, September 25, 2001 6:45 AM To: Multiple recipients of list ORACLE-L Hello, I am trying to log in the sqlplus (from command line) as the internal user but I can´t remember its password. Is there any way to change it? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORACLE VS. SYBASE
Hmm, quite a bit of this is factually incorrect, and may be based on a comparison between the latest Sybase and an older Oracle. Firstly, yes, Oracle is way more expensive than Sybase. Funnily enough, this means that Oracle Corporation are financially rock-solid, and Sybase are on the verge of collapse. A database is for life, not just for Christmas. Oracle tech support is at least as good as Sybase's, but that depends on the level of support you are willing to pay for. I once worked for a client who reported a bug and had a new build of Oracle delivered to them on a gold CD the next morning. Oracle does have online case management and updating, via MetaLink. Sybase cheaper to administer? Yes, you just need to hire someone to run dbcc every couple of hours :0) You have to compare like with like: one man can row a boat across a lake, but the USS Nimitz has a crew of 6000. And if you want one text file containing hundreds of options, well we have init.ora for that. A Sybase database is not the same thing as an Oracle database, it's more like a schema, with a Sybase server being like an instance. There's one user database per server, and users are assigned to databases, just like the way we grant roles to users. This may make administration easier, but it also means you can't have multiple database instances tuned for different applications on the same hardware. The fact that Sybase runs threaded and Oracle runs as processes is neither here nor there. And Sybase manages memory better, what does that mean? Quicker, uses less, can handle more, what? I don't understand the point about Oracle not cleaning up its temporary segments, of course it does. And Sybase shares its tempdb between all databases on the machine, whereas Oracle has one per instance. again making tuning and segregation of different applications impossible. Far better documentation? Yes, Sybooks was good in its day, but MetaLink/TechNet have caught up now. I guess it's a good thing that it's easy to unload data from Sybase, in the same way that it's easy to dump a CSV file from MS Access. The comment on disaster recovery is utter rubbish, of course Oracle can be backed up while fully online and handling transactions. You can use export, hot backup or RMAN. Oracle has powerful replication also, or you can use dblinks and AQs to move data back and forth between instances under programmatic control. Sybase can't. And later on backups, Oracle has a range of options for backups, RMAN, Legato, hotbackup, whatever. And, of course, there's no equivalent of dbcc in Oracle, we don't need it, since datablock corruption is not a daily occurrence for us... Sybase still does have a good presence in financial services, but that's mainly a legacy thing, lots of T-SQL already written, just like there's lots of COBOL already written. This is something to boast about? I think not. T-SQL is a pretty limited language for stored procedures, it cannot compare to PL/SQL. Every SELECT in Oracle is an implicit cursor, true, but that's because Oracle knows how to run cursors efficiently. Sybase never could, this is why Sybase programmers never use cursors, not because they're inherently a bad idea. We are multi-threaded, it's called MTS. Next he'll be claiming that Oracle can only take one connected client at a time! And finally, the killer: Sybase is similar to MSSQL. Enough said! That's about all I can be bothered to type for now. In summary, I would like to say that Sybase is a fine product for your grandmother to store her recipes in :0) g -Original Message- Sent: Tuesday, September 25, 2001 10:15 AM To: Multiple recipients of list ORACLE-L See below a mail I received from Sybase oriented person :) Please argue it maybe very interesting (original mail was Sybase vs Oracle:Why to go to Sybase?) /Maya - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: changing the internal password
Beatriz, It is possible to change your internal password. At the command prompt (DOS) issue the command ORAPWD file=passwordfilepassword=newpasswordentrries=no. of DBAs e.g. ORAPWD file=ABCSPWD.ORA password=oracle entries=5 (where you expect up to 5 entries for Where ABCS = instance. Please give full path for password file. Moses MOya -Original Message- Sent: Tuesday, September 25, 2001 1:45 PM To: Multiple recipients of list ORACLE-L Hello, I am trying to log in the sqlplus (from command line) as the internal user but I can´t remember its password. Is there any way to change it? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Moses Ngati Moya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: changing the internal password
Use the utility ORADIM C:\ORADIM -EDIT -SID SID_NAME -INTPWD NEW_PWD rEGARDS, nIRMAL. -Original Message- From: Cale, Rick T (Richard) [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 2:21 PM To: Multiple recipients of list ORACLE-L Subject: RE: changing the internal password You can use the orapwd utility to recreate the password file. Rick -Original Message- Sent: Tuesday, September 25, 2001 6:45 AM To: Multiple recipients of list ORACLE-L Hello, I am trying to log in the sqlplus (from command line) as the internal user but I can´t remember its password. Is there any way to change it? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: changing the internal password
You probably are running sqlplus on NT. Therefore, try with sqlnet.authentication_services=(nts) in the sqlnet.ora and look in the groups of users of NT for the group ora_SID_NT. The Oracle NT user has to be member of this one. If you are running Oracle on Unix, you have to look in sqlnet.ora again. You probably have a line with sqlnet.authentication_services with a value different that none and you don't have Advance Security installed or you are not using it. Regards. --- Beatriz Martínez Jiménez [EMAIL PROTECTED] wrote: Hello, I am trying to log in the sqlplus (from command line) as the internal user but I can´t remember its password. Is there any way to change it? TIA begin:vcard n:Jimenez;Beatriz Martinez x-mozilla-html:FALSE org:Fundación CIDAUT;Departamento de Informática adr:;;Parque Tecnológico de Boecillo p.209;Boecillo;Valladolid;47151;Spain version:2.1 email;internet:[EMAIL PROTECTED] title:Ingeniera Informática fn:Beatriz Martínez Jiménez end:vcard = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: changing the internal password
Hi, - oracle_home\network\admin\sqlnet.ora # SQLNET.ORA Network Configuration File: D:\Oracle\Ora81\NETWORK\ADMIN\sqlnet.ora # Generated by Oracle configuration tools. NAMES.DEFAULT_DOMAIN = qtel.com.qa SQLNET.AUTHENTICATION_SERVICES= (NTS) SQLNET.CRYPTO_SEED = 4fhfguweotcadsfdsafjkdsfqp5f201p45mxskdlfdasf -- In this what type of modification i should do?... I had another doubt: Most of the times, oracle connects with internal without any password, may i know in which scanario, oracle will ask password for internal? Yearly of this year, from this list only i learned that we can change the internal password by 'ORADIM' utility. Now now i changed the internal password by using this utility. After that i tested with default password 'oracle' (???). it's going ... i surpriced... even more, if i put any characters instead of password, it's succeeded Can anyone please clear these issues. Thanks in adv. Regards, Nirmal. -Original Message- From: Christian Trassens [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 2:30 PM To: Multiple recipients of list ORACLE-L Subject: Re: changing the internal password You probably are running sqlplus on NT. Therefore, try with sqlnet.authentication_services=(nts) in the sqlnet.ora and look in the groups of users of NT for the group ora_SID_NT. The Oracle NT user has to be member of this one. If you are running Oracle on Unix, you have to look in sqlnet.ora again. You probably have a line with sqlnet.authentication_services with a value different that none and you don't have Advance Security installed or you are not using it. Regards. --- Beatriz Martínez Jiménez [EMAIL PROTECTED] wrote: Hello, I am trying to log in the sqlplus (from command line) as the internal user but I can´t remember its password. Is there any way to change it? TIA begin:vcard n:Jimenez;Beatriz Martinez x-mozilla-html:FALSE org:Fundación CIDAUT;Departamento de Informática adr:;;Parque Tecnológico de Boecillo p.209;Boecillo;Valladolid;47151;Spain version:2.1 email;internet:[EMAIL PROTECTED] title:Ingeniera Informática fn:Beatriz Martínez Jiménez end:vcard = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
free bufer waits - solved
list, finally i was able to solve the free buffer waits in my instance. These waits were saturating the db and the response time of a select count(*) on a 5 million rows was 7 hours !!! i altered the table to include PARALLE 3, and specified the min_parallel server = 3 bounced the db and voila !! all the waits vanished !! another problem was ... the scattered read of a FTS was NOT reaching multiblock_count after altering the tables... the FTS is also reading the required no. of blocks !! when i do a select count(*) with a NOPRALLEL hint it still makes free buffer waits and other problems... CONCLUSION i am not able to figure out why ??? TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-25138
Thanks Christian, But I haven't set that parameter. I just tried to add another logfile group. Ramon E. Estevez [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 809-565-3121 -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Christian Trassens Enviado el: Monday, 24 September, 2001 4:55 AM Para: Multiple recipients of list ORACLE-L Asunto: Re: ORA-25138 Look at the view v$obsolete_parameter. However and about that log_simultaneous_copies, since 8i it is an underscored one. Regards. --- Ramon Estevez [EMAIL PROTECTED] wrote: Hi friends, I just installed the 8.1.7 fine. Add one log member to each log group and all fine. Then added another logfile with 2 members and when I shutdown the database got an error ORA-25138 Log simultaneous copies initialization parameter had been made obsolete. Checked out in the init and I dont have that parameter. Help Gracias, Ramon E. Estevez [EMAIL PROTECTED] Dominican Republic 809-565-3121 = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-04031
Ok. I have solved this problem. I put the parameter large_pool_size with a large value (200mb) and now it is running right... I know that this value is too large, but it solved my problem... We are looking for it ... Regards ... rom: BELOV [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: ORA-04031 Date: Tue, 25 Sep 2001 00:30:21 -0800 need to see a trace file for more info... -Original Message- From: Eca Eca [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 7:35 PM To: Multiple recipients of list ORACLE-L Subject: ORA-04031 Friends : I am using 9i and receiving : ORA-04031: unable to allocate 8704 bytes of shared memory (large pool,unknown object,hash-join subh,kllcqas:kllsltba) I have 2gb of memory In init.ora i have large values for pool parameters ... What is happening ? Any idea ? The db_cache_size is around 932 mb shared_pool is around 369 mb Regards Eriovaldo _ Chegou o novo MSN Explorer. Instale já. É gratuito! http://explorer.msn.com.br -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: BELOV INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Chegou o novo MSN Explorer. Instale já. É gratuito! http://explorer.msn.com.br -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: coalesce tablespace
Thanks for your suggestion. Timing in my case is (for select * from dba_free_space_coalesced) 8 seconds for Win NT 2x400MHz PII 512 MB RAM, testing database 8.0.5 with 7 tablespaces each about 500 MB. 10 minutes 24 seconds for Open VMS 7.1 Alpha 2100 275 MHz, 512 MB RAM, testing database 8.0.5 with 17 tablespaces each about 100 MB. SQLPlus process which executes this select is consuming nearly 100% of cpu all the time. I am just wondering about the reason for such a big difference. Could it be caused by fragmentation? Is there useful script for determine fragmentation? I can exclude the bug while on production database (VMS on rather stronger machine) this select statement takes several seconds as on Win NT. Michal -Pùvodní zpráva- Od: Baker, Barbara [mailto:[EMAIL PROTECTED]] Odesláno: 25. záøí 2001 1:17 Komu: Multiple recipients of list ORACLE-L Pøedmìt: RE: coalesce tablespace Michal: You mention the select for the view dba_free_space_coalesced. I'm not sure what you're actually doing. However, if I set time on and issue the command select * from dba_free_space_coalesced here's elapsed time on my VMS system start: 16:07:44 end:16:07:59 here's elapsed time on my Solaris system start: 16:05:21 end 16:05:29 The 2 databases are sized comparably. (The Solaris box has more power) Just selecting from the view should be almost instantaneous. Sounds like something else is going on on the VMS box. HTH. Barb -- From: Mohammad Rafiq[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Monday, September 24, 2001 4:07 PM To: Multiple recipients of list ORACLE-L Subject: RE: coalesce tablespace Is it working or not? Have you done coalesing or not? As regard timings, it depends on system and number of objects on a database? Regards MOHAMMAD RAFIQ Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Mon, 24 Sep 2001 06:35:26 -0800 Hi, how is defined view dba_free_space_coalesced? What reason can be, that SELECT response on this view takes me in databese on Win NT several seconds while in database on OpenVMS it takes several minutes (databases are similar). Thanks for suggestions Michal -Puvodní zpráva- Od: Mohammad Rafiq [mailto:[EMAIL PROTECTED]] Odesláno: 20. zárí 2001 22:51 Komu: Multiple recipients of list ORACLE-L Predmet: RE: coalesce tablespace Following script may be used to check whether coalesing is required or not. If lasr column not 100% then coalesce that tbs select substr(tablespace_name,1,10)TS_NAME,total_extents Total_Extnts,extents_coalesced,round(percent_extents_coalesced,0) from dba_free_space_coalesced / MOHAMMAD RAFIQ Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 20 Sep 2001 12:21:21 -0800 It would take contiguous free extents and make them larger extents, which would be more likely to reuse. Especially if there are many smaller ones, this moot if using LMT. It is a very quick procedure and good to do occasional, you can check in dba_data_files_coalesced to see if the number is far from 100%, if it is less than 75% or so, just throw a coalesce on the tablespace. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Thursday, September 20, 2001 3:40 PM To: Multiple recipients of list ORACLE-L We have tablespaces in acceptance and production that are being resized for growth. Pctincrease is set at 0. Would it also help to coalesce the tablespace? What are the benefits of this command? Thanks, Sandi -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself
RE: dbsnmp
Sandi, The log files associated with the dbsnmp(Intelligent Agent) processes are nmiconf.log, dbsnmpc.log, and dbsnmpw.log. They get written to each time the dbsnmp process is stopped or started. If the Intelligent agent is being restarted a lot on that server, that could be one of the reasons why the files are growing more than the others. Traci L. Rebman Database Administrator DE Communications, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Traci Rebman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: free bufer waits - solved
I think that is because if you use parallel option oracle read in direct I/O mode. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 25, 2001 2:01 PM list, finally i was able to solve the free buffer waits in my instance. These waits were saturating the db and the response time of a select count(*) on a 5 million rows was 7 hours !!! i altered the table to include PARALLE 3, and specified the min_parallel server = 3 bounced the db and voila !! all the waits vanished !! another problem was ... the scattered read of a FTS was NOT reaching multiblock_count after altering the tables... the FTS is also reading the required no. of blocks !! when i do a select count(*) with a NOPRALLEL hint it still makes free buffer waits and other problems... CONCLUSION i am not able to figure out why ??? TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: claudio cutelli INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Installing 8.1.7
I got a theory question.. Just because I'm not going to be putting it in to practice myself really :0) When using all of the below (LMT UNIFORM EXTENTS, with the default recommended extent sizes): How do you determine the max size a table should be for a particular extent size? Do any of you adopt a method of saying: Right, once a table reaches 500 extents, then it should be moved to a larger extent TS? Mark -Original Message- WILLIAMS Sent: Friday, September 21, 2001 21:11 To: Multiple recipients of list ORACLE-L Ron - Sorry I wasn't clear. There are two alternatives for LMTs, automatic and uniform. You are entirely correct that there are many possibilities. Then I discovered the paper: How to Stop Defragmenting and Start Living: The Definitive Word on Fragmentation http://metalink.oracle.com/cgi-bin/cr/getfile_cr.cgi?239049 This certainly sounded GREAT to me (I found it through the Gennick paper you reference). That mentions that Oracle has slightly different recommendations for Oracle8i. I found an Oracle paper Fragmentation and Data Reorganization http://otn.oracle.com/deploy/availability/htdocs/fragment.html, which contains the following statements: Oracle has a number of recommendations: First, set all the extents in a tablespace to the same size (to me that says Uniform). Second, . . . Choose tablespaces for segments based on three recommended extent sizes, 128k, 4MB, or 128MB. I believe that both papers are based on the same philosophy. At this point I am basing my physical layouts based on these two papers, believing that this represents the direction that Oracle is going. If you or anyone else has more information to contribute, I am eager to listen. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, September 21, 2001 2:10 PM To: Multiple recipients of list ORACLE-L Dennis, I know that Oracle lists 3 sizes for the LMTbut you can specify any size extent if you do not use the auto feature. I have created a lot of different LMT extent sizes for tables that are like in size and activity. That way I have a better handle on the resources especually when the disks are a premium. Why put an active table initial 50 K next 50 K in a 128K tablespace. Why not manage the tablespace and make the extents 100 K? From the ORAMAG article:The Autuallocate option allows Oracle to take control of the extent allocation. Oracle will use extent sizes of 64KB, 1MB, 8MB, and 64MB to manage space in the tablespace. The table created in the tablespace will adapt the auto extent policy of the tablespace and use increasingly larger extents as the table grows in size. Locally Managed Tablespaces by Jonathan Gennick. located at http://www.oracle.com/oramag/oracle/00-nov/o60o8i.html Just a thought. ROR mª¿ªm [EMAIL PROTECTED] 09/21/01 12:00PM Ramon - 1) How to find the ideal size of the extent for a locally managed tablespace uniform size ? Oracle is recommending only three extent sizes: 128k, 4m, and 128m. See white papers at technet.oracle.com for further details on the new philosophy. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, September 21, 2001 10:40 AM To: Multiple recipients of list ORACLE-L Hi folks, Actually I have 8.0.5 and will install 8.1.7 in the weekend, and would like to have somethings clear. Actually I have just 2 tablespaces, but planning to make one for each application system, will be like 7. Of course will make all kind of backups, cold, hot including redo logs, password files, parameter files and archives. What I am planning to do is make an export of the user owner of the all objects and make and import in the new DB. 1) How to find the ideal size of the extent for a locally managed tablespace uniform size ? 2) As far as I know, not much, the import will create the same tablespaces where the objects exists in the old DB in the new DB. Now, if I use an alter table move tablespace to move the tables to the new LMT tablespace, will it use the extent size of the new TBS or will remain with the old one ? 3) I'm considering to recreate all the indexes. 4) Is it a good idea to have an TBS for each APP system ? 5) What are the consequences of having all of them with different extent size ? 6) If by any chance some of them are going to have the same extent size wouldn't be better to put them in one TBS ? 6) Any tips for sizing of the SGA, shared pool, log_buffers, sort_area_size ? 7) Planning make db_block_size 8k 8) My second step will be implement Forms Server, anything to include in the installation of have in mind from now ? My DB is transactional, not that heavily, like 40 users, but like 12 of them are remote. Hardware Compaq 2 Pentium III processor 800 mhz 6 Hard Drive 9.1 GB - raid 5 1 GB Memory Win 2000 server Thanks in advance and sure that your help will be very, very useful. Ramon E.
Re: Undo x Rollback Segments in 9i
Humm, it will take a long time ... :) and my database is installed and almost ready to start ... I have to take decision fast ... But all kinds of help are good ... Regards Eriovaldo From: JOE TESTA [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Undo x Rollback Segments in 9i Date: Mon, 24 Sep 2001 06:00:22 -0800 I'm testing it for potential demo at ioug 2002, since i've got a abstract in for undo management and flashback query. does that help any? joe [EMAIL PROTECTED] 09/24/01 09:15AM Thursday, September 20, 2001, 9:40:17 PM, you wrote: EE does anyone use it or know how to use Automatic Undo ? EE What is the best option : I don't know which is best. I did recently notice that the default database you get when you install Oracle9i uses automatic undo. I also discovered that if you want to use the new flashback query features, that you must be using automatic undo management. I like the simplified approach of just create a bunch of undo space and let Oracle worry about it. But it is a new feature, it may take some time to work the kinks out, and I'm not sure I'd rush to convert all my databases to it. By the way, is anyone doing anything with flashback query yet? Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Chegou o novo MSN Explorer. Instale já. É gratuito! http://explorer.msn.com.br -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: changing the internal password
A lot of thanks for all of you!!!. Moses Ngati Moya wrote: Beatriz, It is possible to change your internal password. At the command prompt (DOS) issue the command ORAPWD file=passwordfilepassword=newpasswordentrries=no. of DBAs e.g. ORAPWD file=ABCSPWD.ORA password=oracle entries=5 (where you expect up to 5 entries for Where ABCS = instance. Please give full path for password file. Moses MOya -Original Message- Sent: Tuesday, September 25, 2001 1:45 PM To: Multiple recipients of list ORACLE-L Hello, I am trying to log in the sqlplus (from command line) as the internal user but I can´t remember its password. Is there any way to change it? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Moses Ngati Moya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). begin:vcard n:Jimenez;Beatriz Martinez x-mozilla-html:FALSE org:Fundación CIDAUT;Departamento de Informática adr:;;Parque Tecnológico de Boecillo p.209;Boecillo;Valladolid;47151;Spain version:2.1 email;internet:[EMAIL PROTECTED] title:Ingeniera Informática fn:Beatriz Martínez Jiménez end:vcard
RE: To Users of 9i
We are testing it on AIX (64bit), some good luck, some bad luck when running RAC. 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 ! *1 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: looking for a parsing script
Title: RE: looking for a parsing script Actually, what I've got is a table with a varchar2(4000) column holding statements pulled from various databases (all kinds of statments, not just selects). What I'm writing is a pl/sql routine to parse through all these statments and generate a list of the tables, views and synonyms that are referenced. I was hoping someone might already have such a script. -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 2:30 AM To: Multiple recipients of list ORACLE-L Subject: Re: looking for a parsing script Matt, What kind of file will the SQL be in? Do you have a sample? Jared On Monday 24 September 2001 07:15, Adams, Matthew (GEA, 088130) wrote: Before I go out an re-invent the wheel (again), I wanted to ask if anyone has a script (preferably pl/sql) for parsing out table references from an SQL statement. Matt Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl) Content-Type: text/html; charset=iso-8859-1; name=Attachment: 1 Content-Transfer-Encoding: 7bit Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: file changed during tape backup ???
Do they shut down the Oracle instances before they do the backups? I had an SA once who wouldn't and it consistently produced corrupt control files. Had to do a recovery every Monday morning. I finally educated him. Janet Linsy janetlinsy To: Multiple recipients of list ORACLE-L @yahoo.com [EMAIL PROTECTED] Sent by: rootcc: Subject: file changed during tape backup ??? 09/24/2001 07:45 PM Please respond to ORACLE-L Hi all, I got the following from our Unix admin. Looks like control files for some database on many boxes got changed when being backed up on tape. (I suppose the backup on tape happened during mid-night) Does anybody know what the reason is, and why this only happened to control files? Thank you. -- Janet Following are Oracle warnings during the nightly tape backup: SNOW: snow:/orafs/ora1 save: Warning - `/orafs/ora1/oradata/GOLD404/control01.ctl' changed during save * snow:/orafs/ora1 save: Warning - `/orafs/ora1/oradata/AMY40/control01.ctl' changed during save SLEET: sleet:/orafs/ora1 save: Warning - `/orafs/ora1/oradata/oradata/TEST/control01.ctl' changed during save ICE: ice:/orafs/ora1 save: Warning - `/orafs/ora1/oradata/CP40TD/control01.ctl' changed during save TSUNAMI: * tsunami:/orafs save: Warning - `/orafs/ora1/oradata/AB406CNV/control01.ctl' changed during save * tsunami:/orafs save: Warning - `/orafs/ora2/oradata/AU406CNV/control02.ctl' changed during save * tsunami:/orafs save: Warning - `/orafs/ora3/oradata/AU406CNV/control03.ctl' changed during save __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janet Linsy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: need insights :where to go 3 tierd or client server
Let me try and give some ideas Firstly 3-tier is very good if you take the time to firstly understand what it is about and why you use it. On the server with the db you have all of the constraint logic to manage the data integrity On the middle tier you have all business logic for the system and on the third tier or client you have the simple data logic like checking that you only enter a date in a date field on the form. Also if you app has not been designed to be like the above then you need to go back and redesign or you wont gain anything out of 3-tier You probably want to have a network health check to find out what other traffic is on your network. If previously you had only host connections then you almost certainly have a network issue. You might need to have a look at the performance of both the app server and the db server to see what performance figures you have. HTH Peter At 08:25 PM 25/09/2001, you wrote: gurus, Need your advice. i'm trying to migrate our system to oracle using 3 tierd. but we're experiencing a very slow response time 2 sec calling the form + 2sec itspopulating the queries = 4sec (total) compared to our original system w/c is less than a second . many network problems also arises w/c we didn't encounter before. is it wise to go 3 tierd or client server? what are the advantanges and disadvantages of going 3 tierd or client server? Oracle eats lot of resources and very expensive. It seems that going oracle is wrong choice. wat kind of network/resources does oracle need? is netscape a better choice than internet explorer when using oracle? thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: grace INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter McLarty INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA-04020
Hi list, Scenario 8.1.7 when execute a procedure I get the error ORA-04020. Suggestions ?? Thanks Ramon E. Estevez [EMAIL PROTECTED] Dominican Republic 809-565-3121
Physical access to servers for maintenance
Our hardware people are cracking sown on access to the computer room. They have decided the DBA group can do all their work without going to the server itself. This includes Unix and NT server running both Oracle and SQL Server. We would have to use VNC Viewer and PC Anywhere. I am trying to put together a list of things we might need to do that would make remote admin difficult as well as taking longer. If you have any ideas I would appreciate it. Ron Smith Database Administrator [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Datatype
Is there an Oracle datatype of DATETIME? I can only find DATE in my documentation. Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient Systems, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: ORACLE VS. SYBASE
First off, some one PLEASE trash that TPC-C stuff. I never believe any of that from any vendor since it's so easy to make your case very impressive, and that includes Oracle. As far as SQL, Sybase I see is not as ANSI compliant as Oracle with the SQL-92 standard, check out their literature. Oh, BTW varchar2's were 2000 characters some time ago in Oracle where as Sybase waited till 12.0. OH, I still do not see a 'drop column' command in Sybase, but 9i does. I think most of the worry about having the CPU convert data was more wrapped around duhveleper and stupid user tricks than anything else. Ever see a column that's a varchar2 with only numbers therein and a user hand Oracle 'where column_name = 995;'? That actually translates into 'where to_number(column_name) = 995;'. Oh Boy does that cause the CPU some work!! And last from the 'main Oracle bigot' of the list, If Sybase is such a great dbms, why did PeopleSoft drop it? Of the three main 'not only Oracle' ERP vendors (SAP, BAAN, and PeopleSoft) not one supports Sybase. Dick Goulet PS: Mladen, Please pull up your collar, your 'Red Neck' is showing! :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Datatype
Hi Ken Is there an Oracle datatype of DATETIME? I can only find DATE in my documentation. Oracle DATE datatypes have the time in them as well. Probably it is not being displayed by default on a SELECT because the NLS_DATE_FORMAT in your initSID.ora is set to the default. To get times in and out of DATE datatypes investigate the TO_CHAR and TO_DATE SQL functions. It should be in Chapter 4 or so of the Oracle 8.1.6 SQL reference manual. (see http://www.oradoc.com/ora816/server.816/a76989/toc.htm) other Oracle versions may vary slightly. Here's an example: select to_char(sysdate,'DY DD MONTH HH24:MI:SS') from dual; Regards Dale -- DataBee - Oracle DataBase Subsets Create small training and development databases the easy way. http://www.databee.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dale Edgar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Datatype
Title: RE: Datatype Hi Ken, Date is the name of the datatype. It can be formatted in many different ways. Like this, formatted into date and time. (VIKING-SYSTEM)select to_char(sysdate,'dd-mon- hh24:Mi:ss') from dual; TO_CHAR(SYSDATE,'DD- 25-sep-2001 09:37:04 (VIKING-SYSTEM) Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Ken Janusz [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 10:05 AM To: Multiple recipients of list ORACLE-L Subject: Datatype Is there an Oracle datatype of DATETIME? I can only find DATE in my documentation. Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient Systems, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Datatype
Ken, The date datatype includes time, down to the second. Ken Janusz wrote: Is there an Oracle datatype of DATETIME? I can only find DATE in my documentation. Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient Systems, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Scott Canaan ([EMAIL PROTECTED]) (716) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Does start with/connect by uses full table scan?
Thanks a lot Guy. Very good link with lot of examples. Rao -Original Message- Sent: Tuesday, September 25, 2001 6:30 AM To: Multiple recipients of list ORACLE-L According to this page, you would use concatenated indexes: http://www.arsdigita.com/books/sql/trees.html Hmmm. g -Original Message- Sent: Monday, September 24, 2001 7:36 PM To: Multiple recipients of list ORACLE-L List, Does Oracle go for full table scan or does it use indexes when we use start with/connect by clause? Thanks, Rao -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Using the DBCA with response file for creating a new database
Title: Using the DBCA with response file for creating a new database I want to create a database with dbassist in silent mode. I found an example of response file to use with dbassist. Anyone know where i can find a list of all valid parameter for a response file? Thanks, Nicola.
RE: Installing 8.1.7
Thanks for your help, Mark and Dennis tks Ramon E. Estevez [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 809-565-3121 -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Mark Leith Enviado el: Tuesday, 25 September, 2001 8:20 AM Para: Multiple recipients of list ORACLE-L Asunto: RE: Installing 8.1.7 I got a theory question.. Just because I'm not going to be putting it in to practice myself really :0) When using all of the below (LMT UNIFORM EXTENTS, with the default recommended extent sizes): How do you determine the max size a table should be for a particular extent size? Do any of you adopt a method of saying: Right, once a table reaches 500 extents, then it should be moved to a larger extent TS? Mark -Original Message- WILLIAMS Sent: Friday, September 21, 2001 21:11 To: Multiple recipients of list ORACLE-L Ron - Sorry I wasn't clear. There are two alternatives for LMTs, automatic and uniform. You are entirely correct that there are many possibilities. Then I discovered the paper: How to Stop Defragmenting and Start Living: The Definitive Word on Fragmentation http://metalink.oracle.com/cgi-bin/cr/getfile_cr.cgi?239049 This certainly sounded GREAT to me (I found it through the Gennick paper you reference). That mentions that Oracle has slightly different recommendations for Oracle8i. I found an Oracle paper Fragmentation and Data Reorganization http://otn.oracle.com/deploy/availability/htdocs/fragment.html, which contains the following statements: Oracle has a number of recommendations: First, set all the extents in a tablespace to the same size (to me that says Uniform). Second, . . . Choose tablespaces for segments based on three recommended extent sizes, 128k, 4MB, or 128MB. I believe that both papers are based on the same philosophy. At this point I am basing my physical layouts based on these two papers, believing that this represents the direction that Oracle is going. If you or anyone else has more information to contribute, I am eager to listen. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, September 21, 2001 2:10 PM To: Multiple recipients of list ORACLE-L Dennis, I know that Oracle lists 3 sizes for the LMTbut you can specify any size extent if you do not use the auto feature. I have created a lot of different LMT extent sizes for tables that are like in size and activity. That way I have a better handle on the resources especually when the disks are a premium. Why put an active table initial 50 K next 50 K in a 128K tablespace. Why not manage the tablespace and make the extents 100 K? From the ORAMAG article:The Autuallocate option allows Oracle to take control of the extent allocation. Oracle will use extent sizes of 64KB, 1MB, 8MB, and 64MB to manage space in the tablespace. The table created in the tablespace will adapt the auto extent policy of the tablespace and use increasingly larger extents as the table grows in size. Locally Managed Tablespaces by Jonathan Gennick. located at http://www.oracle.com/oramag/oracle/00-nov/o60o8i.html Just a thought. ROR mª¿ªm [EMAIL PROTECTED] 09/21/01 12:00PM Ramon - 1) How to find the ideal size of the extent for a locally managed tablespace uniform size ? Oracle is recommending only three extent sizes: 128k, 4m, and 128m. See white papers at technet.oracle.com for further details on the new philosophy. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, September 21, 2001 10:40 AM To: Multiple recipients of list ORACLE-L Hi folks, Actually I have 8.0.5 and will install 8.1.7 in the weekend, and would like to have somethings clear. Actually I have just 2 tablespaces, but planning to make one for each application system, will be like 7. Of course will make all kind of backups, cold, hot including redo logs, password files, parameter files and archives. What I am planning to do is make an export of the user owner of the all objects and make and import in the new DB. 1) How to find the ideal size of the extent for a locally managed tablespace uniform size ? 2) As far as I know, not much, the import will create the same tablespaces where the objects exists in the old DB in the new DB. Now, if I use an alter table move tablespace to move the tables to the new LMT tablespace, will it use the extent size of the new TBS or will remain with the old one ? 3) I'm considering to recreate all the indexes. 4) Is it a good idea to have an TBS for each APP system ? 5) What are the consequences of having all of them with different extent size ? 6) If by any chance some of them are going to have the same extent size wouldn't be better to put them in one TBS ? 6) Any tips for sizing of the SGA, shared pool, log_buffers, sort_area_size ? 7) Planning make db_block_size 8k 8) My second step will be implement Forms Server, anything
RE: ORACLE VS. SYBASE
-- Guy Hammond [EMAIL PROTECTED] That's about all I can be bothered to type for now. In summary, I would like to say that Sybase is a fine product for your grandmother to store her recipes in :0) Interesting to note that a good number of financial companies -- who make a living off of fast, stable databases -- use Sybase. They tend to prefer it for its combination of speed and cost of operation. None of them store recipies on it that I know of, nor do they allow their grandmothers access to the systems. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Physical access to servers for maintenance
-- Smith, Ron L. [EMAIL PROTECTED] Our hardware people are cracking sown on access to the computer room. They have decided the DBA group can do all their work without going to the server itself. This includes Unix and NT server running both Oracle and SQL Server. We would have to use VNC Viewer and PC Anywhere. I am trying to put together a list of things we might need to do that would make remote admin difficult as well as taking longer. If you have any ideas I would appreciate it. How about Your Work? Last time I looked it's rather hard to run svrmgrl without access to the command line. So long as you don't want to start or stop the database this probably won't have any effect. Checking free disk space is also simpler with df. You can, perhaps, memorize the nubmber of blocks on every device and compare them to the free space reported by Oracle each morning. Simplest method would be to say no we don't need it now, what is the pager number of someone we can use if we do need things done? Make a point of paging them every time you need something from the shell, day or night. That person will, I'm sure, be happy to compile a list of the trivial things they've been forced to do that the DBA should have done for themselves at 3am... -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: looking for a parsing script
-- Adams, Matthew (GEA, 088130) [EMAIL PROTECTED] Actually, what I've got is a table with a varchar2(4000) column holding statements pulled from various databases (all kinds of statments, not just selects). What I'm writing is a pl/sql routine to parse through all these statments and generate a list of the tables, views and synonyms that are referenced. I was hoping someone might already have such a script. DBI might prove simpler for this via regexen or Parse::RecDescent. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: To Users of 9i
We've been using 9i in production since August 20, 2001 on *one* of our databases. So far, we are happy with it and haven't had any recurring problems. However, that database doesn't require many of the new 9i features that could be bug-prone, so we have the advantage of gradual implementation of new features as they are time-tested. Here are my recommendations based on our short experience: 1. Be prepared to read several pounds of documentation, most importantly the Migration Guide. 2. Research the known 9i bugs and issues on MetaLink and the Oracle-L list: a. Be sure to read the MetaLink doc on the upgrade/install bug. You have to set a parameter in init.ora before installation and then remove it afterwards. b. We decided not to use the new Undo Tablespace feature of 9i based on a posting on this list in which someone encountered a corrupted Undo tablespace and had serious problems. Still using Rollback Segments until the Undo TS is more robust. c. Someone reported corruption during export of a tablespace that used Label Security. 3. Say goodbye to Server Manager, say hello to logging in as USER as sysdba instead. 4. The 8.1.7 version of OEM that runs on Windows doesn't work with 9i databases, although the new OEM for Windows release is scheduled for today (25-SEP-01) according to Oracle. Apparently, this is not an issue for OEM running on Solaris. Anyone else have anything to contribute to this list of 9i problems? david David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0755 Email mailto:[EMAIL PROTECTED] Web http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, 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 the sender at (919) 941-4645 and delete this e-mail message from your computer. Thank you. -Original Message- Sent: Monday, September 24, 2001 7:45 PM To: Multiple recipients of list ORACLE-L Friends : Does anyone use the 9i database ? Are you happy using it ? Is it running ok ? What kind of problem does it have ? Bugs ? What do you think putting it in production environment ? Regards Eriovaldo _ Chegou o novo MSN Explorer. Instale já. É gratuito! http://explorer.msn.com.br -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Wagoner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Dates from the v$sqlarea
Beatriz, Take a look at the column FIRST_LOAD_TIME in the V$SQLAREA view.. HTH Mark -Original Message- Martinez Jimenez Sent: Tuesday, September 25, 2001 16:05 To: Multiple recipients of list ORACLE-L Hello, Is there any way to see the dates in which the 'sql' statements from v$sqlarea view have been inserted? A lot of thanks, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Datatype
Ken, The date datatype includes time up to seconds. The time is usually not displayed because of the way that you have your default date NLS_ variables formatted. If you want to display the time, you can. Cherie Machler Oracle DBA Gelco Information Network Ken Janusz ken.janusz@su To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fsys.comcc: Sent by: Subject: Datatype [EMAIL PROTECTED] om 09/25/01 09:05 AM Please respond to ORACLE-L Is there an Oracle datatype of DATETIME? I can only find DATE in my documentation. Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient Systems, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Physical access to servers for maintenance
Make that cracking down. Ron -Original Message- Sent: Tuesday, September 25, 2001 9:00 AM To: Multiple recipients of list ORACLE-L Our hardware people are cracking sown on access to the computer room. They have decided the DBA group can do all their work without going to the server itself. This includes Unix and NT server running both Oracle and SQL Server. We would have to use VNC Viewer and PC Anywhere. I am trying to put together a list of things we might need to do that would make remote admin difficult as well as taking longer. If you have any ideas I would appreciate it. Ron Smith Database Administrator [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: interesting floating point problem with oracle
Not for me SQL select 62.323/62.323 from dual; 62.323/62.323 - 1 SQL exit Disconnected from Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production With the Partitioning option JServer Release 8.1.6.1.0 - Production __ 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 ! *1 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: changing the internal password
Obsviously you are using NT and probable 8i. In this case, only with renmark the line: SQLNET.AUTHENTICATION_SERVICES= (NTS), Oracle will prompt you to enter a password. That it'll be the one created with oradim or if you use password file: orapwd, that one. Therefore, you won't succed if you enter any character as you are succeding now. You must enter the correct password. There are several scenarios in Unix that Oracle asks you for a password. However, the most frequent one is when you have the sqlnet.authentication_services without none or without renmark and you didn't install Advance Security Option. Other one is when you set TWO_TASK env. Regards. --- Nirmal Kumar Muthu Kumaran [EMAIL PROTECTED] wrote: Hi, - oracle_home\network\admin\sqlnet.ora # SQLNET.ORA Network Configuration File: D:\Oracle\Ora81\NETWORK\ADMIN\sqlnet.ora # Generated by Oracle configuration tools. NAMES.DEFAULT_DOMAIN = qtel.com.qa SQLNET.AUTHENTICATION_SERVICES= (NTS) SQLNET.CRYPTO_SEED = 4fhfguweotcadsfdsafjkdsfqp5f201p45mxskdlfdasf -- In this what type of modification i should do?... I had another doubt: Most of the times, oracle connects with internal without any password, may i know in which scanario, oracle will ask password for internal? Yearly of this year, from this list only i learned that we can change the internal password by 'ORADIM' utility. Now now i changed the internal password by using this utility. After that i tested with default password 'oracle' (???). it's going ... i surpriced... even more, if i put any characters instead of password, it's succeeded Can anyone please clear these issues. Thanks in adv. Regards, Nirmal. -Original Message- From: Christian Trassens [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 2:30 PM To: Multiple recipients of list ORACLE-L Subject:Re: changing the internal password You probably are running sqlplus on NT. Therefore, try with sqlnet.authentication_services=(nts) in the sqlnet.ora and look in the groups of users of NT for the group ora_SID_NT. The Oracle NT user has to be member of this one. If you are running Oracle on Unix, you have to look in sqlnet.ora again. You probably have a line with sqlnet.authentication_services with a value different that none and you don't have Advance Security installed or you are not using it. Regards. --- Beatriz Martínez Jiménez [EMAIL PROTECTED] wrote: Hello, I am trying to log in the sqlplus (from command line) as the internal user but I can´t remember its password. Is there any way to change it? TIA begin:vcard n:Jimenez;Beatriz Martinez x-mozilla-html:FALSE org:Fundación CIDAUT;Departamento de Informática adr:;;Parque Tecnológico de Boecillo p.209;Boecillo;Valladolid;47151;Spain version:2.1 email;internet:[EMAIL PROTECTED] title:Ingeniera Informática fn:Beatriz Martínez Jiménez end:vcard = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo!
RE: ORACLE VS. SYBASE
Keep in mind when you say cost of operation that also means the cost of making a change including rewriting most of your custom code. I'm not privy to the decision making in financial companies but I assume a decision based on 'if it ain't broke don't fix it' would be different from one based on 'if we were starting fresh today'. Henry -Original Message- Sent: Tuesday, September 25, 2001 9:40 AM To: Multiple recipients of list ORACLE-L -- Guy Hammond [EMAIL PROTECTED] That's about all I can be bothered to type for now. In summary, I would like to say that Sybase is a fine product for your grandmother to store her recipes in :0) Interesting to note that a good number of financial companies -- who make a living off of fast, stable databases -- use Sybase. They tend to prefer it for its combination of speed and cost of operation. None of them store recipies on it that I know of, nor do they allow their grandmothers access to the systems. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Physical access to servers for maintenance
Only thing we are having is installing the software, like Oracle8i, it not only needs mount the CD, also needs change the CD in the middle. If you only have the PC, I don't know how you can install Oracle on UNIX without access the UNIX box. Maybe SA will take care all the software installation. Jun -Original Message- Sent: Tuesday, September 25, 2001 10:00 AM To: Multiple recipients of list ORACLE-L Our hardware people are cracking sown on access to the computer room. They have decided the DBA group can do all their work without going to the server itself. This includes Unix and NT server running both Oracle and SQL Server. We would have to use VNC Viewer and PC Anywhere. I am trying to put together a list of things we might need to do that would make remote admin difficult as well as taking longer. If you have any ideas I would appreciate it. Ron Smith Database Administrator [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Feng, Jun INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Physical access to servers for maintenance
Ron, The only problem I see is when you need to physically touch the box - like load a CD for installation of new Oracle tools, mount/dismount a tape, or you need to physically re-boot the machine. I don't have physical access to my NT servers (they are 5 miles away) and it is no big deal. Ask them if they will be responsible for mounting physical devices for you - like tapes, cd's etc. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, September 25, 2001 10:10 AM To: Multiple recipients of list ORACLE-L Make that cracking down. Ron -Original Message- Sent: Tuesday, September 25, 2001 9:00 AM To: Multiple recipients of list ORACLE-L Our hardware people are cracking sown on access to the computer room. They have decided the DBA group can do all their work without going to the server itself. This includes Unix and NT server running both Oracle and SQL Server. We would have to use VNC Viewer and PC Anywhere. I am trying to put together a list of things we might need to do that would make remote admin difficult as well as taking longer. If you have any ideas I would appreciate it. Ron Smith Database Administrator [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
my.oracle.com login error
I just got this: Proxy log On failed. Please verify that you have specified correct connectivity information i.e. username, password connect-string in the DAD Error-Code:12541 Error TimeStamp:Tue, 25 Sep 2001 14:55:30 GMT Database Log In Failed TNS is unable to connect to destination. Invalid TNS address supplied or destination is not listening. This error can also occur because of underlying network transport problems. Verify that the TNS name in the connectstring entry of the DAD for this URL is valid and the database listener is run I entered the correct information, their server must be down. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:Datatype
Oracle's date datatype includes time by default. Seems you've got to double check you column definitions in Sybase. Dick Goulet Reply Separator Author: Ken Janusz [EMAIL PROTECTED] Date: 9/25/2001 6:05 AM Is there an Oracle datatype of DATETIME? I can only find DATE in my documentation. Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient Systems, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
interesting floating point problem with oracle
Title: interesting floating point problem with oracle ran across something interesting on metalink. from Doc ID: Note:1012478.7 Problem Description === Doing floating point arithmetic involving multiplication and division causes unpredictable results. For example, if you issue the following select statement from a SQL*Plus session, the result would be ~ which is incorrect. select 62.323/62.323 from dual; Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl)
Re: Datatype
Oracle's DATE stores both: Date and Time. Igor Neyman, OCP DBA Perceptron, Inc. (734)414-4627 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 25, 2001 10:05 AM Is there an Oracle datatype of DATETIME? I can only find DATE in my documentation. Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient Systems, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Physical access to servers for maintenance
Steven, although you need all that you say we need you sure don't need access to the server room for that. At the very least there is telnet, which is what I use from home. Then there are things like Exceed and Xterms, which is what I use at work. By no means do you need access to the server itself to do the day to day stuff. -Original Message- Sent: Tuesday, September 25, 2001 8:20 AM To: Multiple recipients of list ORACLE-L -- Smith, Ron L. [EMAIL PROTECTED] Our hardware people are cracking sown on access to the computer room. They have decided the DBA group can do all their work without going to the server itself. This includes Unix and NT server running both Oracle and SQL Server. We would have to use VNC Viewer and PC Anywhere. I am trying to put together a list of things we might need to do that would make remote admin difficult as well as taking longer. If you have any ideas I would appreciate it. How about Your Work? Last time I looked it's rather hard to run svrmgrl without access to the command line. So long as you don't want to start or stop the database this probably won't have any effect. Checking free disk space is also simpler with df. You can, perhaps, memorize the nubmber of blocks on every device and compare them to the free space reported by Oracle each morning. Simplest method would be to say no we don't need it now, what is the pager number of someone we can use if we do need things done? Make a point of paging them every time you need something from the shell, day or night. That person will, I'm sure, be happy to compile a list of the trivial things they've been forced to do that the DBA should have done for themselves at 3am... -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Alert log from Remote client
Title: RE: Alert log from Remote client Check out AlertView from http://www.zephyrus.com/html/products.html. It's a java utility that provides a GUI interface to remote alert.log files. I think it's still free. Tony -Original Message- From: Nirmal Kumar Muthu Kumaran [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 6:15 AM To: Multiple recipients of list ORACLE-L Subject: Alert log from Remote client Hi guru's Suppose that, i'm managing serveral database from a single client. In that case, how can i find out the alert log/trace files from the client. Any ideas pls. Regards, Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Installing 8.1.7
Title: RE: Installing 8.1.7 -Original Message- From: Mark Leith [mailto:[EMAIL PROTECTED]] I got a theory question.. Just because I'm not going to be putting it in to practice myself really :0) When using all of the below (LMT UNIFORM EXTENTS, with the default recommended extent sizes): How do you determine the max size a table should be for a particular extent size? Do any of you adopt a method of saying: Right, once a table reaches 500 extents, then it should be moved to a larger extent TS? Steve Adams has written an interesting article on the subject: Planning Extents http://www.ixora.com.au/tips/creation/extents.htm ...For this reason, we recommend that the number of extents per segment in locally managed tablespaces be limited to the number of rows that can be accommodated in the extent map within the segment header block - that is, approximately (db_block_size / 16) - 7. I personally move a table when it approaches 1000 extents, out of habit more than anything else.
Re:Physical access to servers for maintenance
Ron, Installs could become a real pain if you do not have access to the cdrom drive. I use VNC and other's here use PC Anywhere routinely so that we don't have to go into the computer room, which in one case is 8 miles away and in another 3000 miles away. But in all cases everyone in IS has access to the computer rooms. It's a matter of having lots of available man/woman power available when trouble strikes. Also helps if you have to do a 'forklift' upgrade!! Dick Goulet Reply Separator Author: Smith; Ron L. [EMAIL PROTECTED] Date: 9/25/2001 6:00 AM Our hardware people are cracking sown on access to the computer room. They have decided the DBA group can do all their work without going to the server itself. This includes Unix and NT server running both Oracle and SQL Server. We would have to use VNC Viewer and PC Anywhere. I am trying to put together a list of things we might need to do that would make remote admin difficult as well as taking longer. If you have any ideas I would appreciate it. Ron Smith Database Administrator [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Physical access to servers for maintenance
Just remember that whatever reasons you give for needing access to the physical machines can also work against you if you ever want to permanently telecommute. Or if the company decides to move your entire computer room (which I've personally been through), the same reasons can be used as an arugment for you to move across the country. Personally, we have found that we need very little access to our equipment. I don't even know where most of our boxes are on the computer floor! Just another way to look at it. --Michael -Original Message- Sent: Tuesday, September 25, 2001 10:10 AM To: Multiple recipients of list ORACLE-L Make that cracking down. Ron -Original Message- Sent: Tuesday, September 25, 2001 9:00 AM To: Multiple recipients of list ORACLE-L Our hardware people are cracking sown on access to the computer room. They have decided the DBA group can do all their work without going to the server itself. This includes Unix and NT server running both Oracle and SQL Server. We would have to use VNC Viewer and PC Anywhere. I am trying to put together a list of things we might need to do that would make remote admin difficult as well as taking longer. If you have any ideas I would appreciate it. Ron Smith Database Administrator [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenkins, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: interesting floating point problem with oracle
Title: RE: interesting floating point problem with oracle I tried to find that document on Metalink and was unsuccessful. Can you suggest any search times that would return it? Do they mention any OS/RDBMS versions where you can duplicate the problem? I tried that query on several versions of Oracle (7.3.4, 8.0.6, 8.1.5, 8.1.6, 8.1.7) on Windows NT, Windows 2000, SunOS and always got back a result of 1. -Original Message- From: Adams, Matthew (GEA, 088130) [mailto:[EMAIL PROTECTED]] ran across something interesting on metalink. from Doc ID: Note:1012478.7 Problem Description === Doing floating point arithmetic involving multiplication and division causes unpredictable results. For example, if you issue the following select statement from a SQL*Plus session, the result would be ~ which is incorrect. select 62.323/62.323 from dual;
RE: interesting floating point problem with oracle
Hmm, I get 1! -Original Message- Sent: 25 September 2001 16:35 To: Multiple recipients of list ORACLE-L ran across something interesting on metalink. from Doc ID: Note:1012478.7 Problem Description === Doing floating point arithmetic involving multiplication and division causes unpredictable results. For example, if you issue the following select statement from a SQL*Plus session, the result would be ~ which is incorrect. select 62.323/62.323 from dual; Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Physical access to servers for maintenance
Title: RE: Physical access to servers for maintenance What's wrong with telnetting in? -Original Message- From: Steven Lembark [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 11:20 AM To: Multiple recipients of list ORACLE-L Subject: Re: Physical access to servers for maintenance -- Smith, Ron L. [EMAIL PROTECTED] Our hardware people are cracking sown on access to the computer room. They have decided the DBA group can do all their work without going to the server itself. This includes Unix and NT server running both Oracle and SQL Server. We would have to use VNC Viewer and PC Anywhere. I am trying to put together a list of things we might need to do that would make remote admin difficult as well as taking longer. If you have any ideas I would appreciate it. How about Your Work? Last time I looked it's rather hard to run svrmgrl without access to the command line. So long as you don't want to start or stop the database this probably won't have any effect. Checking free disk space is also simpler with df. You can, perhaps, memorize the nubmber of blocks on every device and compare them to the free space reported by Oracle each morning. Simplest method would be to say no we don't need it now, what is the pager number of someone we can use if we do need things done? Make a point of paging them every time you need something from the shell, day or night. That person will, I'm sure, be happy to compile a list of the trivial things they've been forced to do that the DBA should have done for themselves at 3am... -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-04020
It is a library cache object deadlock. I've heard of problems on 8i with refreshing snapshots that could give you a 4020 error. During a creation of a view, I've suffered one. Also installing Application 11i, I've had many. If it occurs frequently, you should call to Support. During that if it happens to be always with the same package or code piece, take a look of the size of the object, their dependencies, etcMaybe it is a heavy loaded package or code piece If it is a procedure, try change it into a package, reduce its size, reduce its dependencies, etc. If it occured only oncemaybe it was a grant when many users were using it.If it is a view, redefine it. Wellif you are using Applications and the error appears frequently...call support too. Regards. --- Ramon Estevez [EMAIL PROTECTED] wrote: Hi list, Scenario 8.1.7 when execute a procedure I get the error ORA-04020. Suggestions ?? Thanks Ramon E. Estevez [EMAIL PROTECTED] Dominican Republic 809-565-3121 = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Installing 8.1.7
The conventional wisdom is to use sizes around 128K, 4M, 128M. If you do the math each is 32 times larger than the previous. This means that an object that starts with a single 128K extent will have 32 extents when it reaches 4MB. From my perspective, it seems reasonable to migrate this object when the number of it extents is 17 - 48; which is NO where near 500. The same factors are involved for an object that starts as a single 4MB extent. Of course you can wait until an object is comprised of hundreds of extents likely will not have any negative impact on database response time or performance. HTH YMMV! Mark Leith wrote: I got a theory question.. Just because I'm not going to be putting it in to practice myself really :0) When using all of the below (LMT UNIFORM EXTENTS, with the default recommended extent sizes): How do you determine the max size a table should be for a particular extent size? Do any of you adopt a method of saying: Right, once a table reaches 500 extents, then it should be moved to a larger extent TS? Mark -Original Message- WILLIAMS Sent: Friday, September 21, 2001 21:11 To: Multiple recipients of list ORACLE-L Ron - Sorry I wasn't clear. There are two alternatives for LMTs, automatic and uniform. You are entirely correct that there are many possibilities. Then I discovered the paper: How to Stop Defragmenting and Start Living: The Definitive Word on Fragmentation http://metalink.oracle.com/cgi-bin/cr/getfile_cr.cgi?239049 This certainly sounded GREAT to me (I found it through the Gennick paper you reference). That mentions that Oracle has slightly different recommendations for Oracle8i. I found an Oracle paper Fragmentation and Data Reorganization http://otn.oracle.com/deploy/availability/htdocs/fragment.html, which contains the following statements: Oracle has a number of recommendations: First, set all the extents in a tablespace to the same size (to me that says Uniform). Second, . . . Choose tablespaces for segments based on three recommended extent sizes, 128k, 4MB, or 128MB. I believe that both papers are based on the same philosophy. At this point I am basing my physical layouts based on these two papers, believing that this represents the direction that Oracle is going. If you or anyone else has more information to contribute, I am eager to listen. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, September 21, 2001 2:10 PM To: Multiple recipients of list ORACLE-L Dennis, I know that Oracle lists 3 sizes for the LMTbut you can specify any size extent if you do not use the auto feature. I have created a lot of different LMT extent sizes for tables that are like in size and activity. That way I have a better handle on the resources especually when the disks are a premium. Why put an active table initial 50 K next 50 K in a 128K tablespace. Why not manage the tablespace and make the extents 100 K? From the ORAMAG article:The Autuallocate option allows Oracle to take control of the extent allocation. Oracle will use extent sizes of 64KB, 1MB, 8MB, and 64MB to manage space in the tablespace. The table created in the tablespace will adapt the auto extent policy of the tablespace and use increasingly larger extents as the table grows in size. Locally Managed Tablespaces by Jonathan Gennick. located at http://www.oracle.com/oramag/oracle/00-nov/o60o8i.html Just a thought. ROR mª¿ªm [EMAIL PROTECTED] 09/21/01 12:00PM Ramon - 1) How to find the ideal size of the extent for a locally managed tablespace uniform size ? Oracle is recommending only three extent sizes: 128k, 4m, and 128m. See white papers at technet.oracle.com for further details on the new philosophy. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, September 21, 2001 10:40 AM To: Multiple recipients of list ORACLE-L Hi folks, Actually I have 8.0.5 and will install 8.1.7 in the weekend, and would like to have somethings clear. Actually I have just 2 tablespaces, but planning to make one for each application system, will be like 7. Of course will make all kind of backups, cold, hot including redo logs, password files, parameter files and archives. What I am planning to do is make an export of the user owner of the all objects and make and import in the new DB. 1) How to find the ideal size of the extent for a locally managed tablespace uniform size ? 2) As far as I know, not much, the import will create the same tablespaces where the objects exists in the old DB in the new DB. Now, if I use an alter table move tablespace to move the tables to the new LMT tablespace, will it use the extent size of the new TBS or will remain with the old one ? 3) I'm considering to recreate all the indexes. 4) Is it a good idea to have an
Re: ORACLE VS. SYBASE
On Tuesday 25 September 2001 02:15, Maya Kenner wrote: Sybase... - 11.9.2 is beating Oracle's database in Tpc tests. See the TPC-C tests at www.tpc.org and sort by Hardware Vendor. A recent TPC-C benchmark of Sybase ASE 12.0..0.2 on Sun E-1 beat Oracle on the same platform by 36%. (Cost per transaction (156,873 tpmC) was $48.81 vs. Oracle's (115,395 tpmC) of $105.63). This is the fastest TPC benchmark ever recorded (as of 12/2000) for a SMP environment. TPC is not useful for comparing database vendors. So what if database X is faster than database Y in some specialized configuration? Very few customers will ever try to push the database that hard. We're all familiar with the phrase 'with flexibility comes complexity'. Well, Oracle is a very complex beast, capable of doing just about anything you wish it to do. It might be a little slower, it might be a little faster, who cares. As far as the $$ per transaction, the only possible purpose that serves is to catch the attention of bean counters. It's a phony number. $$ per transaction is as dependent on your organization as it is on the HW and SW. - Sybase is far less Expensive than Oracle. Arbitrarily, Oracle charges per megahertz on the CPU, a Universal Power Unit. UPU=number of processors multiplied by processor speed, multiplied by $100 (the current price per UPU). This has problems two ways; a PC chip works at far higher megahertz speeds than a Sun Ultrachip, meaning a far more powerful server costs far less than a PC-based server. Secondly, users are charged for capacity over an entire server, even if Oracle is not the only software running. Additional features are always additional cost in Oracle; Sybase builds in all features to its entine. Sure it is. The Sybase feature set is nowhere near as rich as Oracle's. - Oracle's Tech support is inferior compared to Sybase's. Online case management and updating, instant reponse times. Actually, I've usually had pretty good success with Oracle Support. It's been a *long* time since I've actually had to open a TAR. - Sybase is cheaper to administer, from a DBA standpoint. Mgrs report that one Sybase DBA can do what 2-3 Oracle DBA's do. That's a crock. I've taken the Sybase classes. There just isn't as much to do, because it does less. Does spending all your time running dbcc count? - Sybase's Customization and Tuning is simple (one text file contains hundreds of database server options) compared to tuning Oracle. It is far easier to administer, install, operate Sybase. Very easy to create databases versus instances. Not true. Oracle is easier. Been there, done it. - Disaster Recovery; with inline backup utilities, Sybase can back itself up on the fly w/o taking tablespaces offline. Replication server creates a warm standby for 100% uptime. Oracle can do neither. Replication Server is indeed very powerful. However, you *will* need a consultant to set it up. Trust me, if you don't have a lot of experience with it, you'll make a mess. OK, out of time. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
TEMP Tablespace
TEMP tablespace is not listed when I query dba_segments. However, it does show up in OEM and through OEM it does appear to be online. Yesterday, I briefly took the TEMP tablespace offline and then back online again to make sure it was completely cleared out (did not appear to be any active sessions in the database at the time). Have also bounced the database. Any ideas on why it still would not be showing up when querying dba_segments? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Connie Milliken INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: interesting floating point problem with oracle
Title: RE: interesting floating point problem with oracle Well... not on 8.1.7. It's fine here. (VIKING-SYSTEM)select 62.323/62.323 from dual; 62.323/62.323 - 1 Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Adams, Matthew (GEA, 088130) [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 11:35 AM To: Multiple recipients of list ORACLE-L Subject: interesting floating point problem with oracle ran across something interesting on metalink. from Doc ID: Note:1012478.7 Problem Description === Doing floating point arithmetic involving multiplication and division causes unpredictable results. For example, if you issue the following select statement from a SQL*Plus session, the result would be ~ which is incorrect. select 62.323/62.323 from dual; Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl)
RE: Physical access to servers for maintenance
Title: RE: Physical access to servers for maintenance Honestly Ron, installs are the only thing I can think of. We had our prod servers at a different location and believe me I avoided going up there whenever possible. Install was the only thing I had to go up there for. I've been able to successfully do my job without physically having to be at the console. But then again I haven't worked anyplace where the network has completely crapped out. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 10:00 AM To: Multiple recipients of list ORACLE-L Subject: Physical access to servers for maintenance Our hardware people are cracking sown on access to the computer room. They have decided the DBA group can do all their work without going to the server itself. This includes Unix and NT server running both Oracle and SQL Server. We would have to use VNC Viewer and PC Anywhere. I am trying to put together a list of things we might need to do that would make remote admin difficult as well as taking longer. If you have any ideas I would appreciate it. Ron Smith Database Administrator [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Datatype
Cherie: I am familiar with the DATE datatype. I am doing a database conversion from IMS to Oracle and have been given a spreadsheet of the tables/columns. Some of the columns are typed as DATETIME. It appears that these were not updated for Oracle from a previous conversion to SQL Server. Thanks, Ken Janusz Database Conversion Lead Sufficient Systems, Inc. Minneapolis, MN -Original Message- Sent: Tuesday, September 25, 2001 10:30 AM To: Multiple recipients of list ORACLE-L Ken, The date datatype includes time up to seconds. The time is usually not displayed because of the way that you have your default date NLS_ variables formatted. If you want to display the time, you can. Cherie Machler Oracle DBA Gelco Information Network Ken Janusz ken.janusz@su To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fsys.comcc: Sent by: Subject: Datatype [EMAIL PROTECTED] om 09/25/01 09:05 AM Please respond to ORACLE-L Is there an Oracle datatype of DATETIME? I can only find DATE in my documentation. Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient Systems, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: changing the internal password
Title: RE: changing the internal password -Original Message- From: Nirmal Kumar Muthu Kumaran [mailto:[EMAIL PROTECTED]] ... I had another doubt: Most of the times, oracle connects with internal without any password, may i know in which scanario, oracle will ask password for internal? ... I assume you have access to Oracle's support site, Metalink. There you can find several documents on that issue. Examples: WINNT: ORA-01017 When Connecting as Internal Doc ID: 114399.1 Modified Date: 14-SEP-2001 Checklist for Resolving CONNECT INTERNAL PASSWORD Issues Doc ID: 69642.1 Modified Date: 19-AUG-2001 Connect Internal Privilege on Oracle7 Doc ID: 18089.1 Modified Date: 30-APR-2001 WINNT: Password File and Password of Internal Issues Doc ID: 114384.1 Modified Date: 09-MAR-2001 Those documents probably refer to other documents of interest.
Re: Datatype
-- Ken Janusz [EMAIL PROTECTED] Is there an Oracle datatype of DATETIME? I can only find DATE in my documentation. Yes, we have no bannanas: You get to split fields into Date and Time components in Oracle. Alternative is to use time_t and num(10). -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: TEMP Tablespace
Wouldn't it need to have something in it? -Original Message- Sent: 25 September 2001 16:10 To: Multiple recipients of list ORACLE-L TEMP tablespace is not listed when I query dba_segments. However, it does show up in OEM and through OEM it does appear to be online. Yesterday, I briefly took the TEMP tablespace offline and then back online again to make sure it was completely cleared out (did not appear to be any active sessions in the database at the time). Have also bounced the database. Any ideas on why it still would not be showing up when querying dba_segments? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Connie Milliken INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nicoll, Iain (Calanais) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re[2]: Network Appliance Options
That's why you use multiple connections (switched or direct with crossover cables) and balance them. That way you change your mount points to isolate certain types of traffic or limit saturation. We have 3 mount points for a NetApp, each on a different 100BaseT named like /mnt_n1e0, /mnt_n1e1, etc. Datafiles are separated into an OFA like directory structure that isolates certain types of behavior. For example, large indexes for database TEST might be in the directory /u09/oradata/TEST. We use symbolic links at this level, like: ln -s /mnt_n1e1/home/u09/oradata/TEST /u09/oradata/TEST If we wanted to isolate that to a different ethernet link, we shutdown the database and rm /u09/oradata/TEST ln -s /mnt_n1e2/home/u09/oradata/TEST /u09/oradata/TEST And start the database. In a few seconds we've moved the datafiles in that directory to a different NFS link without Oracle even knowing it. There are plenty of games to play if you stocked your equipment with plenty of ethernet ports. (One word of warning, on some of the quad ethernet cards on the Sun, I'm told that the overall throughput is far less than 4x a solo card. Be sure and check that out...) -rje D Kathy - We have used them for supplemental storage on our test/development D system (Compaq Tru64, Oracle 8.1.6). The limitation seems to be the NFS D connection is slower than your conventional or real disks. For some D tasks this isn't a problem, but it is easy to start several large tasks that D saturate the NFS connection. For example, when I have to build several large D indexes, I copy the underlying tables to the real disk, and build the D indexes one at a time. I won't deny that I may be overreacting to some D problems. Other than that, it seems to work fine for our test/development D system where it generally receives sporadic and light use. I am told that it D cost much less than conventional disks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-12514
Hi Brian , U need to define the service name in your TNSNAMES.ORA file ...Or use NET8 Easy Config define to define that .. U can find the TNSNAMES.ORA under Oracle home It looks like the following : Service Name .WORLD = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(Host = Server IP Address)(Port = 1521)) ) (CONNECT_DATA = (SID = Service Name )) ) Substitute the values of Service Name , Server IP Address as required Regards -Original Message- From: Brian King [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 7:50 PM To: Multiple recipients of list ORACLE-L Subject: ORA-12514 Hi all, I am new to Oracle and am having problems getting started. I have installed Oracle (8.1.7) on a Windows 2000 Server and have no problems connecting on that machine (without specifying a host string). However, when I try to connect to it remotely (on a different domain) I get and error (ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor). I tested the listener and it is running. I have searched all over for help and cannot find any. I am simply tryin to connect remotely in order to begin developing VB apps in the future. Thanks for any input... Brian King mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian King INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ahmed Gholam Hussain INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORACLE VS. SYBASE
arghh it's not the first time a mail I sent is being truncated or translated in funny characters , it was the end of the mail. I posted this not in the view to start flames (even if ...:) , but I found out that people in this list have a long DB experience across several platform (contrary to me poor little rookie) and I thought it could be really interesting to have their point of view . /Maya - -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mark Leith Sent: Tuesday, September 25, 2001 12:45 PM To: Multiple recipients of list ORACLE-L Subject: RE: ORACLE VS. SYBASE Maya, I'd be interested in seeing the rest of this mail (if there is more?). See below, it looks like the tail of the message was cut off or corrupted? Cheers Mark P.S. - Great post - I'm sure it will start some flames :P -Original Message- Sent: Tuesday, September 25, 2001 10:15 To: Multiple recipients of list ORACLE-L See below a mail I received from Sybase oriented person :) Please argue it maybe very interesting (original mail was Sybase vs Oracle:Why to go to Sybase?) /Maya - - Synonyms: - Time datatype: Oracle seperates Time from Date. Sybase's datetime datatype has both included in one, plus a whole suite of display styles that can show the date/time in a multitude of formats.W±ëzØ¡÷r9,B¶Ã§©Ê뢳ɢw Ѭ éz»zf¢a´(È×ÂIêÇóßÎçQ_ÎçÓjpz jX¢¹hû'×ëqdzóX¸¶ÄDCTLº»÷¢kÉXX¶Çu©1¨ëj ¸¬´k«¹ör+rr§¢×\ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).åy«±ç ê~'jS Ä,PÛiÿü0ÂÚ}ª¢`.¶+1¬)éçz² 9É©w«¶·¦iÊ«BÜzÜ(®D®øzÏ9óüçNuüçÎwó9Õ§' ¥ú+¹¹bpíz¹Þµ§zË?1¨¥xËlND0åDÊ«±é_~º¶¬¨¥x%ËlzwZCY²Æ zÚËFº»j×·'(z-xEÀ ;)zYb .+-êîjwbØ^ë,j86Énuæ¥w¢{Zx§CRP Ä.í éÚꨥx%Ër¢ìÛhmêÞÞuúè.¬Ê,zwm áÄ,÷(f§uú+¢Ø^®)ߢ¹¶*')²æìr¸x
Re: interesting floating point problem with oracle
At 11:35 AM 9/25/2001, Adams, Matthew (GEA, 088130) wrote: ran across something interesting on metalink. from Doc ID: Note:1012478.7 Problem Description === Doing floating point arithmetic involving multiplication and division causes unpredictable results. For example, if you issue the following select statement from a SQL*Plus session, the result would be ~ which is incorrect. select 62.323/62.323 from dual; hm... i get 1 on 7.3.4, 8.1.5, 8.1.6 and 8.1.7. guess i must be lucky, huh?;-) maybe that's why i survive the 300 person lay off yesterday.;-) -- Bill Shrek Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. The attention span of a computer is only as long as its power cord. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Physical access to servers for maintenance
At 10:00 AM 9/25/2001, Smith, Ron L. wrote: Our hardware people are cracking sown on access to the computer room. They have decided the DBA group can do all their work without going to the server itself. This includes Unix and NT server running both Oracle and SQL Server. We would have to use VNC Viewer and PC Anywhere. I am trying to put together a list of things we might need to do that would make remote admin difficult as well as taking longer. If you have any ideas I would appreciate it. Ron Smith Database Administrator [EMAIL PROTECTED] are they going to swap the CDs for you on an install? if the server crashes and you have to restart the DB without VNC or PC Anywhere running, how do you do that? -- Bill Shrek Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. The attention span of a computer is only as long as its power cord. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re[2]: ORACLE VS. SYBASE
Tuesday, September 25, 2001, 5:15:17 AM, you wrote: MK - Reliability/Stability; Banks, Financial institutions, NYSE, Nasdaq, MK Amex all run Sybase. I always chuckle at statements like this. Given any large corp that's been around for awhile, and they probably use a plethora of databases. Banks probably use Microsoft Access too. Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Alert log from Remote client
There is a product (free) called AlertView. It is from zephyrus software (zephyrus.com). It runs on a pc and can monitor as many alert.logs as you have. Take a look! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 25, 2001 6:15 AM Hi guru's Suppose that, i'm managing serveral database from a single client. In that case, how can i find out the alert log/trace files from the client. Any ideas pls. Regards, Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORACLE VS. SYBASE
I second that. The Financial community is owned by Sybase. Oracle is scoffed at...too slow...too pricey...too much fluff. Oh, and apparently, the DBAs have attitude, and you need to buy too many of them to keep the rusty garbage scow running. ;-) -Original Message- Sent: Tuesday, September 25, 2001 9:40 AM To: Multiple recipients of list ORACLE-L -- Guy Hammond [EMAIL PROTECTED] That's about all I can be bothered to type for now. In summary, I would like to say that Sybase is a fine product for your grandmother to store her recipes in :0) Interesting to note that a good number of financial companies -- who make a living off of fast, stable databases -- use Sybase. They tend to prefer it for its combination of speed and cost of operation. None of them store recipies on it that I know of, nor do they allow their grandmothers access to the systems. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORACLE VS. SYBASE
Can you please list those companies? I may need to move some money around. [EMAIL PROTECTED] 09/25/01 09:40AM -- Guy Hammond [EMAIL PROTECTED] That's about all I can be bothered to type for now. In summary, I would like to say that Sybase is a fine product for your grandmother to store her recipes in :0) Interesting to note that a good number of financial companies -- who make a living off of fast, stable databases -- use Sybase. They tend to prefer it for its combination of speed and cost of operation. None of them store recipies on it that I know of, nor do they allow their grandmothers access to the systems. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:interesting floating point problem with oracle
Just tried that against three of my DB's, every time it came back with 1. Reply Separator Author: Adams; Matthew (GEA; 088130) [EMAIL PROTECTED] Date: 9/25/2001 7:35 AM ran across something interesting on metalink. from Doc ID: Note:1012478.7 Problem Description === Doing floating point arithmetic involving multiplication and division causes unpredictable results. For example, if you issue the following select statement from a SQL*Plus session, the result would be ~ which is incorrect. select 62.323/62.323 from dual; Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl) !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN HTML HEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=iso-8859-1 META NAME=Generator CONTENT=MS Exchange Server version 5.5.2654.19 TITLEinteresting floating point problem with oracle/TITLE /HEAD BODY PFONT SIZE=2ran across something interesting on metalink./FONT /P BR PFONT SIZE=2from/FONT BRFONT SIZE=2Doc ID:nbsp; Note:1012478.7 /FONT /P BR PFONT SIZE=2Problem Description/FONT BRFONT SIZE=2===/FONT /P PFONT SIZE=2Doing floating point arithmetic involving multiplication and division/FONT BRFONT SIZE=2causes unpredictable results.nbsp; For example, if you issue the following/FONT BRFONT SIZE=2select statement from a SQL*Plus session, the result would be quot;~quot; which/FONT BRFONT SIZE=2is incorrect./FONT /P PFONT SIZE=2select 62.323/62.323 from dual;/FONT /P PFONT SIZE=2/FONT BRFONT SIZE=2Matt Adams - GE Appliances - [EMAIL PROTECTED]/FONT BRFONT SIZE=2quot;Doing linear scans over an associative array is like/FONT BRFONT SIZE=2trying to club someone to death with a loaded Uzi.quot;/FONT BRFONT SIZE=2nbsp;nbsp;nbsp; - Larry Wall (creator of Perl) /FONT /P /BODY /HTML -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: interesting floating point problem with oracle
Title: interesting floating point problem with oracle I got a big fat 1 from 8.1.7. Guess I'll check the doc for affected version. -Original Message-From: Adams, Matthew (GEA, 088130) [mailto:[EMAIL PROTECTED]]Sent: Tuesday, September 25, 2001 11:35 AMTo: Multiple recipients of list ORACLE-LSubject: interesting floating point problem with oracle ran across something interesting on metalink. from Doc ID: Note:1012478.7 Problem Description === Doing floating point arithmetic involving multiplication and division causes unpredictable results. For example, if you issue the following select statement from a SQL*Plus session, the result would be "~" which is incorrect. select 62.323/62.323 from dual; Matt Adams - GE Appliances - [EMAIL PROTECTED] "Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi." - Larry Wall (creator of Perl)
RE: coalesce tablespace
Michal: Something is really wacky here . . . It should not take 10+ minutes just to select rows from dba_free_space_coalesced. I kinda doubt that it's a fragmentation problem, but I'm not sure what it might be. Does this slowness occur with any other selects?? Here's a table fragmentation script. You can run it and see what kind of fragmentation you have . . . HTH Barb (this script is looking for extents within a range of maxextents, i.e., am I about to run out of extents. You might want to change it a bit for your needs.) column owner format a8 column segment_typeformat a6heading Seg|Type column ext format 9,999 heading Ext|Used column maxext format heading Max|Ext COLUMN REMAINING FORMAT HEADING Ext|Left column tablespace_name format a8heading Tblspace|Name ttitle Center 'Segments With Extents Used Within 1 Extents of Maximum' skip 2 SELECT owner, segment_name, segment_type, tablespace_name, sum(extents) ext, SUM(MAX_EXTENTS) maxext, SUM(MAX_EXTENTS) - SUM(EXTENTS) REMAINING, bytes/1024 k FROMdba_segments WHERE segment_type IN ('TABLE','INDEX') GROUP BYowner, segment_type, tablespace_name, segment_name, bytes/1024 HAVING (SUM(MAX_EXTENTS) - SUM(EXTENTS)) 1 / -- From: Skurský Michal[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Tuesday, September 25, 2001 6:40 AM To: Multiple recipients of list ORACLE-L Subject: RE: coalesce tablespace Thanks for your suggestion. Timing in my case is (for select * from dba_free_space_coalesced) 8 seconds for Win NT 2x400MHz PII 512 MB RAM, testing database 8.0.5 with 7 tablespaces each about 500 MB. 10 minutes 24 seconds for Open VMS 7.1 Alpha 2100 275 MHz, 512 MB RAM, testing database 8.0.5 with 17 tablespaces each about 100 MB. SQLPlus process which executes this select is consuming nearly 100% of cpu all the time. I am just wondering about the reason for such a big difference. Could it be caused by fragmentation? Is there useful script for determine fragmentation? I can exclude the bug while on production database (VMS on rather stronger machine) this select statement takes several seconds as on Win NT. Michal -Pùvodní zpráva- Od: Baker, Barbara [mailto:[EMAIL PROTECTED]] Odesláno: 25. záøí 2001 1:17 Komu: Multiple recipients of list ORACLE-L Pøedmìt: RE: coalesce tablespace Michal: You mention the select for the view dba_free_space_coalesced. I'm not sure what you're actually doing. However, if I set time on and issue the command select * from dba_free_space_coalesced here's elapsed time on my VMS system start: 16:07:44 end:16:07:59 here's elapsed time on my Solaris system start: 16:05:21 end 16:05:29 The 2 databases are sized comparably. (The Solaris box has more power) Just selecting from the view should be almost instantaneous. Sounds like something else is going on on the VMS box. HTH. Barb -- From: Mohammad Rafiq[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Monday, September 24, 2001 4:07 PM To: Multiple recipients of list ORACLE-L Subject:RE: coalesce tablespace Is it working or not? Have you done coalesing or not? As regard timings, it depends on system and number of objects on a database? Regards MOHAMMAD RAFIQ Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Mon, 24 Sep 2001 06:35:26 -0800 Hi, how is defined view dba_free_space_coalesced? What reason can be, that SELECT response on this view takes me in databese on Win NT several seconds while in database on OpenVMS it takes several minutes (databases are similar). Thanks for suggestions Michal -Puvodní zpráva- Od: Mohammad Rafiq [mailto:[EMAIL PROTECTED]] Odesláno: 20. zárí 2001 22:51 Komu: Multiple recipients of list ORACLE-L Predmet: RE: coalesce tablespace Following script may be used to check whether coalesing is required or not. If lasr column not 100% then coalesce that tbs select substr(tablespace_name,1,10)TS_NAME,total_extents Total_Extnts,extents_coalesced,round(percent_extents_coalesced,0) from dba_free_space_coalesced / MOHAMMAD RAFIQ Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 20 Sep 2001 12:21:21 -0800 It would take contiguous free extents and make them larger extents, which would be more likely to reuse. Especially if there are many smaller ones, this moot if using LMT. It is a very quick procedure
Re: interesting floating point problem with oracle
Hi ! Neither for me ... Jamadagni, Rajendra wrote: Not for me SQL select 62.323/62.323 from dual; 62.323/62.323 - 1 SQL exit Disconnected from Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production With the Partitioning option JServer Release 8.1.6.1.0 - Production __ 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 ! *1 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dias Costa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: interesting floating point problem with oracle
Title: interesting floating point problem with oracle me either... SQL*Plus: Release 8.1.6.0.0 - Production on Tue Sep 25 11:00:24 2001 (c) Copyright 1999 Oracle Corporation. All rights reserved. Connected to:Oracle8i Enterprise Edition Release 8.1.7.1.1 - ProductionWith the Partitioning optionJServer Release 8.1.7.1.1 - Production 11:00:27 WTWD select 62.323/62.323 from dual; 62.323/62.323- 1 11:00:33 WTWD Tom Mercadante Oracle Certified Professional -Original Message-From: Adams, Matthew (GEA, 088130) [mailto:[EMAIL PROTECTED]]Sent: Tuesday, September 25, 2001 11:35 AMTo: Multiple recipients of list ORACLE-LSubject: interesting floating point problem with oracle ran across something interesting on metalink. from Doc ID: Note:1012478.7 Problem Description === Doing floating point arithmetic involving multiplication and division causes unpredictable results. For example, if you issue the following select statement from a SQL*Plus session, the result would be "~" which is incorrect. select 62.323/62.323 from dual; Matt Adams - GE Appliances - [EMAIL PROTECTED] "Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi." - Larry Wall (creator of Perl)
RE: ORA-04020
Problem solved. Just recompile all the procedures and packages. Ramon E. Estevez [EMAIL PROTECTED] Dominican Republic 809-565-3121 -Mensaje original-De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Ramon EstevezEnviado el: Tuesday, 25 September, 2001 9:05 AMPara: Multiple recipients of list ORACLE-LAsunto: ORA-04020 Hi list, Scenario 8.1.7 when execute a procedure I get the error ORA-04020. Suggestions ?? Thanks Ramon E. Estevez [EMAIL PROTECTED] Dominican Republic 809-565-3121
Re: ORA-04020
At 10:05 AM 9/25/2001, you wrote: Hi list, Scenario 8.1.7 when execute a procedure I get the error ORA-04020. Suggestions ?? well, that's a deadlock error on a library. the full text of the message might help, but i guess you need to find what's locking the library and get it to drop the lock. -- Bill Shrek Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. The attention span of a computer is only as long as its power cord. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Maxbytes - 7.3.3
Title: RE: Maxbytes - 7.3.3 -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] however, if no datafile has ever been put into autoextend mode, the table sys.filext$ will not exist I don't have any database example to check, however I seem to remember that sys.filext$ would automagically appear when you upgraded a 7.3 database from a version that didn't allow autoextend datafiles to a version that did allow autoextend datafiles.
Re: interesting floating point problem with oracle
In which version of Oracle srvr??? I'm running 8.1.7v3/Linux and get 1 as result. JP On Tue 25. September 2001 17:35, you wrote: ran across something interesting on metalink. from Doc ID: Note:1012478.7 Problem Description === Doing floating point arithmetic involving multiplication and division causes unpredictable results. For example, if you issue the following select statement from a SQL*Plus session, the result would be ~ which is incorrect. select 62.323/62.323 from dual; Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl) Content-Type: text/html; charset=iso-8859-1; name=Pøíloha: 1 Content-Transfer-Encoding: 7bit Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Physical access to servers for maintenance
Hell, I don't go to the computer room unless I need to find an administrator or put a cd in a drive. If I can force some sucker into making the walk for me I would be happy with that. It does seem like a silly restriction though. You are an administrator. At one point in time there was talk here about restricting our development team from the server room but what if the administrators are away and are trying to talk someone through some stuff and part of it includes physically shutting off the machine? It has happened. Still, its cold in there so I do avoid them. -Original Message- Sent: Tuesday, September 25, 2001 7:00 AM To: Multiple recipients of list ORACLE-L Our hardware people are cracking sown on access to the computer room. They have decided the DBA group can do all their work without going to the server itself. This includes Unix and NT server running both Oracle and SQL Server. We would have to use VNC Viewer and PC Anywhere. I am trying to put together a list of things we might need to do that would make remote admin difficult as well as taking longer. If you have any ideas I would appreciate it. Ron Smith Database Administrator [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Installing 8.1.7
Title: RE: Installing 8.1.7 So essentially this takes us back to the old 505 extents per segment rule when dealing with a db_block_size of 8192.. Cheers for the info.. Regards Mark -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]Sent: Tuesday, September 25, 2001 16:42To: '[EMAIL PROTECTED]'Cc: '[EMAIL PROTECTED]'Subject: RE: Installing 8.1.7 -Original Message- From: Mark Leith [mailto:[EMAIL PROTECTED]] I got a theory question.. Just because I'm not going to be putting it in to practice myself really :0) When using all of the below (LMT UNIFORM EXTENTS, with the default recommended extent sizes): How do you determine the max size a table should be for a particular extent size? Do any of you adopt a method of saying: Right, once a table reaches 500 extents, then it should be moved to a larger extent TS? Steve Adams has written an interesting article on the subject: Planning Extents http://www.ixora.com.au/tips/creation/extents.htm ...For this reason, we recommend that the number of extents per segment in locally managed tablespaces be limited to the number of rows that can be accommodated in the extent map within the segment header block - that is, approximately (db_block_size / 16) - 7. I personally move a table when it approaches 1000 extents, out of habit more than anything else.