Scritp to Generate Create Table ??
Guys, I would to generate Create Table .. script for a schema WITHOUT storage parameters. Can someone share a script for the same ?! ENV is 8.1.6/Win2K. TIA. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE: Scritp to Generate Create Table ??
Thanx Ganesh. triedEXP/IMP/Databee. thought of avoiding file copy -- which consumes more time. .a script would be more handy , isn't it ?! Regards, Jp. 20-06-2003 15:09:33, [EMAIL PROTECTED] wrote: Oracle is ready to share it with u ;) Use exp and then Imp into a Index file or use the DataBee Tool .. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Recent oracle white papers in PDF files
Dear Friends, Any idea where latest Oracle white papers in PDF files will be available ? example Export/ Import Faq. Only notes are displayed in metalink. Your responce is appreciated. Thanks Rajuveera ** This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Veeraraju_Mareddi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Scritp to Generate Create Table ??
Thanx a lot Sanjiv Ganesh. Got the script from Mudhalvan. Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Migration to 9.2.0.3.0 (64 Bit) on Solaris 8 issues
After Migrating a production Database from 8.1.7.4 to 9.2.0.3.0 (64 Bit) on Solaris 8 following NON-Documented parameters were set by Oracle Corp _shared_pool_reserved_min_alloc=16384 This was done to take care of the ORA-4031 errors. This caused shared pool erros to STOP Occuring though at the Cost of increasing the shared_pool_size to 637MB shared_pool_reserved_size to 131 MB Such values seem very high to us . 04031, 0, unable to allocate %s bytes of shared memory (\%s\,\%s\,\%s\,\%s\) // *Cause: More shared memory is needed than was allocated in the shared pool. _library_cache_advice=false This parameter takes care of library cache pin problem _optim_enhance_nnull_detection=false SELECT COUNT(*) GIVES WRONG RESULT with null values ( BUG:- 2920925 ) _multi_join_key_table_lookup=false (BUG:- 2446423) Details:- QUERY RETURNS WRONG ANSWER WITH ORDER BY CLAUSE _predicate_elimination_enabled=false BUG:- 2257439 Details:- NULL VALUE IN PARTITION RETURNED IF PARTITION BOUND VALUE IS IN WHERE CONDITION M/c = SF15K Database using Shared Servers (MTS) Database Size = 250 GB Hybrid Banking Application using Bind variables mostly though some amount of Literal SQLs also run cursor_sharing = EXACT We are considering trying out cursor_sharing = FORCE gradually checking if shared_pool_size shared_pool_reserved_size values can be reduced . Any Else experienced such issues ? Any Advise ? We are considering Migrating another 1000 GB Production database also to 9i setting Similar parameters . Following is a STATSPACK report of the Production Database already at 9i having the above NON-Documented parameters already set . DB Name DB IdInstance Inst Num Release Cluster Host --- --- --- TBASUN1820705732 tbasun 1 9.2.0.3.0 NO IB15KDB Snap Id Snap Time Sessions Curs/Sess Comment --- -- - --- Begin Snap:1437 18-Jun-03 11:00:032,686 49.2 End Snap:1446 18-Jun-03 12:00:052,936 51.0 Elapsed: 60.03 (mins) Load Profile Per Second Per Transaction --- --- Redo size:265,713.47 1,165.59 Logical reads: 24,199.94106.16 Block changes: 1,275.65 5.60 Physical reads: 1,293.29 5.67 Physical writes:108.35 0.48 User calls: 7,869.31 34.52 Parses:348.92 1.53 Hard parses: 19.96 0.09 Sorts:243.00 1.07 Logons: 8.93 0.04 Executes: 4,874.94 21.38 Transactions:227.97 % Blocks changed per Read:5.27Recursive Call %:12.26 Rollback per transaction %: 68.52 Rows per Sort: 335.11 Avg Total Wait waitWaits Event Waits Timeouts Time (s) (ms) /txn -- -- -- latch free 1,386,411 72,966 14,913 11 1.7 db file sequential read 3,606,772 0 5,690 2 4.4 log file sync 327,290273 4,104 13 0.4 log file parallel write 240,139236,242245 1 0.3 PctAvg Wait Pct Get Get Slps Time NoWait NoWait Latch Requests Miss /Miss(s) Requests Miss -- -- -- -- -- library cache52,729,8761.70.4 5393 248,744 11.0 Get PctPinPct Invali- Namespace Requests Miss Requests Miss Reloads dations --- -- -- -- -- BODY 2,7150.1 2,7150.2 10 CLUSTER 2070.03100.0 00 INDEX 9,4310.4 9,4310.4 00 SQL AREA 1,137,4675.8 21,417,4020.3 5,4630 TABLE/PROCEDURE 353,6980.2717,1640.7
RE: RE: Scritp to Generate Create Table ??
Jp, I'll jump in here.. You say you tried the DataBee DBATool? Or did you? It's available here if not: http://www.cool-tools.co.uk/Products/dbatool.html To use DBATool, you need to take a full export from the database, with the "rows=n" option set - just grab all the DDL structures in other words, and no data. DBATool will then read this export file, and extract all of the DLL from it, putting it in to readable format for you. Navigate to the schema owner that you want to change in the left navigation pane, find the table in the right pane, and double click it. This will show you the full DDL for that table, with a number of buttons on the right hand side - one of these buttons is "Quick Strip", that will strip all storage clauses from the DDL. You can either use this, for a single DDL statement, or you can "Add/Update a Rule" from the bottom, which will actually allow you to strip storage clauses for "All Appropriate Objects" (all tables within the schema) if you wish. If you have any specific questions, give me a shout. I know of no *easier* way than pointing and clicking and having everything done for you ;) And I know of no other tool that can juggle DDL like DBATool.. :) HTH Mark -Original Message- Khanna J Sent: 20 June 2003 08:24 To: Multiple recipients of list ORACLE-L Thanx Ganesh. triedEXP/IMP/Databee. thought of avoiding file copy -- which consumes more time. .a script would be more handy , isn't it ?! Regards, Jp. 20-06-2003 15:09:33, [EMAIL PROTECTED] wrote: Oracle is ready to share it with u ;) Use exp and then Imp into a Index file or use the DataBee Tool .. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.491 / Virus Database: 290 - Release Date: 18/06/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.491 / Virus Database: 290 - Release Date: 18/06/2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: oracle authentication from windows
Hi Arup, Remote OS authentication whether with OPS$ or not is still a risk. You are intimating that SYSTEM is the only risky account involved here. What if any of the newly created OPS$ accounts have useful privileges. I have seen a similar application to the one described recently. There were forms within the application for administration and user management (in oracle, not the application) and the users who had access to these were assigned the DBA role and were of course external accounts. I think what you should add to your comment is that the issue is overrated is that any OPS$ / external accounts should not have any dangerous privileges granted and certainly not DBA. If you can guess the name of an admin account even if its OPS$ then the issue is still severe. cheers Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Read SQL Server from Oracle
Try to oracle gateway product http://www.oracle.com/gateways/gateway_bundles/index.html?faq.html -Original Message- Sent: Thursday, June 19, 2003 10:27 PM To: Multiple recipients of list ORACLE-L I need to be able to read SQL Server tables from an Oracle procedure. Can anyone point me in the right direction for info? Ron Smith If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Migration to 9.2.0.3.0 (64 Bit) on Solaris 8 issues
Looks like a whole set of bugs we haven't come across YET -Original Message- Sent: 20 June 2003 10:14 To: Multiple recipients of list ORACLE-L After Migrating a production Database from 8.1.7.4 to 9.2.0.3.0 (64 Bit) on Solaris 8 following NON-Documented parameters were set by Oracle Corp _shared_pool_reserved_min_alloc=16384 This was done to take care of the ORA-4031 errors. This caused shared pool erros to STOP Occuring though at the Cost of increasing the shared_pool_size to 637MB shared_pool_reserved_size to 131 MB Such values seem very high to us . 04031, 0, unable to allocate %s bytes of shared memory (\%s\,\%s\,\%s\,\%s\) // *Cause: More shared memory is needed than was allocated in the shared pool. _library_cache_advice=false This parameter takes care of library cache pin problem _optim_enhance_nnull_detection=false SELECT COUNT(*) GIVES WRONG RESULT with null values ( BUG:- 2920925 ) _multi_join_key_table_lookup=false (BUG:- 2446423) Details:- QUERY RETURNS WRONG ANSWER WITH ORDER BY CLAUSE _predicate_elimination_enabled=false BUG:- 2257439 Details:- NULL VALUE IN PARTITION RETURNED IF PARTITION BOUND VALUE IS IN WHERE CONDITION M/c = SF15K Database using Shared Servers (MTS) Database Size = 250 GB Hybrid Banking Application using Bind variables mostly though some amount of Literal SQLs also run cursor_sharing = EXACT We are considering trying out cursor_sharing = FORCE gradually checking if shared_pool_size shared_pool_reserved_size values can be reduced . Any Else experienced such issues ? Any Advise ? We are considering Migrating another 1000 GB Production database also to 9i setting Similar parameters . Following is a STATSPACK report of the Production Database already at 9i having the above NON-Documented parameters already set . DB Name DB IdInstance Inst Num Release Cluster Host --- --- --- TBASUN1820705732 tbasun 1 9.2.0.3.0 NO IB15KDB Snap Id Snap Time Sessions Curs/Sess Comment --- -- - --- Begin Snap:1437 18-Jun-03 11:00:032,686 49.2 End Snap:1446 18-Jun-03 12:00:052,936 51.0 Elapsed: 60.03 (mins) Load Profile Per Second Per Transaction --- --- Redo size:265,713.47 1,165.59 Logical reads: 24,199.94106.16 Block changes: 1,275.65 5.60 Physical reads: 1,293.29 5.67 Physical writes:108.35 0.48 User calls: 7,869.31 34.52 Parses:348.92 1.53 Hard parses: 19.96 0.09 Sorts:243.00 1.07 Logons: 8.93 0.04 Executes: 4,874.94 21.38 Transactions:227.97 % Blocks changed per Read:5.27Recursive Call %:12.26 Rollback per transaction %: 68.52 Rows per Sort: 335.11 Avg Total Wait waitWaits Event Waits Timeouts Time (s) (ms) /txn -- -- -- latch free 1,386,411 72,966 14,913 11 1.7 db file sequential read 3,606,772 0 5,690 2 4.4 log file sync 327,290273 4,104 13 0.4 log file parallel write 240,139236,242245 1 0.3 PctAvg Wait Pct Get Get Slps Time NoWait NoWait Latch Requests Miss /Miss(s) Requests Miss -- -- -- -- -- library cache52,729,8761.70.4 5393 248,744 11.0 Get PctPinPct Invali- Namespace Requests Miss Requests Miss Reloads dations --- -- -- -- -- BODY 2,7150.1 2,7150.2 10 CLUSTER 2070.03100.0 00 INDEX 9,4310.4 9,4310.4
Thanks -- RE: Scritp to Generate Create Table ??
Thanks a lot Mark. Jp. 20-06-2003 18:54:18, "Mark Leith" [EMAIL PROTECTED] wrote: Jp, I'll jump in here.. You say you tried the DataBee DBATool? Or did you? It's available here if not: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
[Q] Script to generate grant privilege on a table?
Does anyone has script which can check grant privilege on a table and generate output for future usage? Thanks. __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: mike mon INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Development projects: Multiple databases v/s multiple schemas
Hi, For multiple projects we are planning to have a centralized server(as opposed to multiple servers, to improve managability) which all the development teams will use for their backend work. Now there are 2 ways in which to provide them access. 1. Have only 1 database for each version of Oracle Server installed and create schemas for individual teams for their development work. 2. Create a separate DB for each project team. I want to know the pros and cons for both the approaches. Any ideas and suggestions are most welcome. Regards Naveen DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT: SQL Server Q?
Title: OT: SQL Server Q? Hi All I'm mainly into Oracle but in a SQLserver database we encountered this error maximum number of DBPROCESSes already exist In oracle I would look at the processes parameter but what would I be looking at in SQL server??? TIA Jacob A. van Zanen
RE: OEM question
Stephen Lee scribbled on the wall in glitter crayon: No No. THOSE guys did replication. Then the worst of the bunch worked in conjunction with the authors of graduate Math texts to come up with Advanced Queuing. somehow this makes me glad i work for cheap places that don't use any of that.;-) as for OEM, i always use it stand alone... but that's mostly because i'm too dense to get it configured right to do anything else with it.;-) -- Bill Shrek ThaterOracle DBA BAARF Party member #25 [EMAIL PROTECTED] -- If the earth were flat one could equally well say that the apple fell on Newton's head beacuse of gravity or that Newton's head hit the apple because he and the surface of the earth were accelerating upward. - Albert Einstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Development projects: Multiple databases v/s multiple schemas
if you create separete databases , you can monitor statistics of each of them indivudually. Otherwiese database statistics will be affected from multiple projects . -Original Message- Sent: Friday, June 20, 2003 2:19 PM To: Multiple recipients of list ORACLE-L Hi, For multiple projects we are planning to have a centralized server(as opposed to multiple servers, to improve managability) which all the development teams will use for their backend work. Now there are 2 ways in which to provide them access. 1. Have only 1 database for each version of Oracle Server installed and create schemas for individual teams for their development work. 2. Create a separate DB for each project team. I want to know the pros and cons for both the approaches. Any ideas and suggestions are most welcome. Regards Naveen DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Book Recommendation for Apache
Ron Rogers scribbled on the wall in glitter crayon: Drums along the mohawk. sorry dude, no Apaches in that one. just 5 nations.;-) -- Bill Shrek ThaterOracle DBA BAARF Party member #25 [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. -- Bill Thater -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Thanks -- RE: Scritp to Generate Create Table ??
Of course, there is always dbms_metadata, so that you don't have to use any utilities. On 2003.06.20 08:11, Prem Khanna J wrote: Thanks a lot Mark. Jp. 20-06-2003 18:54:18, Mark Leith [EMAIL PROTECTED] wrote: Jp, I'll jump in here.. You say you tried the DataBee DBATool? Or did you? It's available here if not: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle authentication from windows
This is an interesting one. I am currently going through (tortured) another system audit. One of the many questions the auditors (I am being attacked from all sides) had about the Oracle configuration was Can remote authenticated network users connect to the database?. If auditors know this is a weakness, maybe it would be a good idea to avoid its use. btw I do use O/S authenticated userids but remote authentication has been disabled (deliberately). We are running Oracle on Unix so our batch jobs use O/S authenticated ids. From: Gogala, Mladen [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: oracle authentication from windows Date: Thu, 19 Jun 2003 12:19:59 -0800 That, of course, will render your database totally insecure and open to anybody who can bring in a WinXP laptop, change the windoze username and log in as he pleases. DBA that sets his production parameters the way Arup described deserves to be publicly tortured by Bill O'Reilly in the no spin zone. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Thursday, June 19, 2003 3:46 PM To: Multiple recipients of list ORACLE-L Sure. Just declare these in your init.ora os_authent_prefix=OPS$ remote_os_authent=TRUE bounce the database, add a user called OPS$the Windows username, e.g. OPS$AK if your Windows login id is AK as create user ops$ak identified externally From windows connect as /@servicename, e.g. sqlplus /@service1 If it doesn't work, the OS user may be different. Use this query while connected to the database from Windows cleint. SQL select sys_context('USERENV','OS_USER') from dual; See what OS username comes up; use that instead. HTH. Arup Nanda www.proligence.com - Original Message - To: Multiple mailto:[EMAIL PROTECTED] recipients of list ORACLE-L Sent: Thursday, June 19, 2003 1:10 PM We want our client users ( forms user ) to just enter windows password and then automatically able to get in to oracle .Is there a way oracle can authenticate from windows ( or active directory ) . enbadding password in runform.exe not an option . thanks, -ak _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL Server Q?
Title: OT: SQL Server Q? sp configure 'user connections' This is an advanced option (believe it or not), so you may have to do "sp configure 'show advanced options', 1" before you do "sp configure 'user connections'". Alternatively you can just run SELECT @@MAX CONNECTIONS Returns something like this name minimum maximum config value run value --- --- --- --- user connections 0 32767 0 0 Run value is what's configured at present. To change "sp configure 'user connections', 1000" (or whatever) You will need to stop/start the database to make the change take affect. Ade -Original Message-From: Jack van Zanen [mailto:[EMAIL PROTECTED]Sent: 20 June 2003 13:45To: Multiple recipients of list ORACLE-LSubject: OT: SQL Server Q? Hi All I'm mainly into Oracle but in a SQLserver database we encountered this error "maximum number of DBPROCESSes already exist" In oracle I would look at the processes parameter but what would I be looking at in SQL server??? TIA Jacob A. van Zanen -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. ==
VLDB (oltp) and RMAN
Hi Listers, I've just finished a sizing exercise for a Production OLTP. At the one-year mark, it should be approximately 4.5 Terabytes in size. Yikes !! I have a RAID5 array that I'll be using for all of the data files (except the typical System, Rbs, etc which are going to be on RAID 0+1). I plan on using RMAN to do backups, naturally, however, I'm wondering whether anyone has run into any size limitations (from an RMAN perspective) when attempting to backup database files that are over 100Gig in size. (I have the situation where I expect a single table tol be over 100Gig in size). I'm aware of the fact that I may bump into hardware limitations, and I'm going to discuss the hardware and tape limitations (if there are any) with my Sun server sys admin. Thanks in advance, Carol Legros
RE: Development projects: Multiple databases v/s multiple schemas
Title: RE: Development projects: Multiple databases v/s multiple schemas if your schema will be cross-referencing, I vote for ONE db with multiple schema. This way, any changes in one schema immediately affect others and can be controlled. If you _know_ (guaranteed by management) that the schema will _never_ cross reference, then I'd still go for single DB, unless there is a proven need for separate database. I know developers like to have a whole database for themselves, but unfortunately all schema co-exist in the database, so should developers in one DB. A. Bahar, I didn't understand your point, so pardon me. What statistics are we talking here? You mean if ytou have on database per schema, table stats will be different than having all schema in one DB ?? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, June 20, 2003 9:19 AM To: Multiple recipients of list ORACLE-L Subject: RE: Development projects: Multiple databases v/s multiple schemas if you create separete databases , you can monitor statistics of each of them indivudually. Otherwiese database statistics will be affected from multiple projects . -Original Message- Sent: Friday, June 20, 2003 2:19 PM To: Multiple recipients of list ORACLE-L Hi, For multiple projects we are planning to have a centralized server(as opposed to multiple servers, to improve managability) which all the development teams will use for their backend work. Now there are 2 ways in which to provide them access. 1. Have only 1 database for each version of Oracle Server installed and create schemas for individual teams for their development work. 2. Create a separate DB for each project team. I want to know the pros and cons for both the approaches. Any ideas and suggestions are most welcome. Regards Naveen DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
RE: oracle authentication from windows
I disagree. Remote OS authentication is not inherently insecure in Windows like it is in Unix. If you prefix the account names with the domain name, a user would not only have to spoof the username, he would have to spoof the domain name too. At that point, you probably have bigger problems than access to your database. Also, in that situation, only the security token is going over the network, not your password in clear text. The caveat is that you should be using the *domain name* as the prefix, not OPS$. -Original Message- Sent: Friday, June 20, 2003 6:20 AM To: Multiple recipients of list ORACLE-L Hi Arup, Remote OS authentication whether with OPS$ or not is still a risk. You are intimating that SYSTEM is the only risky account involved here. What if any of the newly created OPS$ accounts have useful privileges. I have seen a similar application to the one described recently. There were forms within the application for administration and user management (in oracle, not the application) and the users who had access to these were assigned the DBA role and were of course external accounts. I think what you should add to your comment is that the issue is overrated is that any OPS$ / external accounts should not have any dangerous privileges granted and certainly not DBA. If you can guess the name of an admin account even if its OPS$ then the issue is still severe. cheers Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: [Q] Script to generate grant privilege on a table?
Hi Mike, I've spoken about DBATool to one person on the list today already, so another won't hurt too much I hope ;) DBATool will do what you want. It will even let you create a nice HTML set of documentation (you say future reference), the pages will show you the DDL of that table, and all it's grants, comments, constraints etc. Here's a sample: http://www.cool-tools.co.uk/Products/DDL/db=TEST+sc=DT_TEST+tb=DEPT161.htm (may be wrapped) Here's the index of the HTML documentation: http://www.cool-tools.co.uk/Products/DDL/db=TEST.htm PUBLIC holds all the tablespace, user, role, profile etc. creation statements.. Simply load an export taken with rows=n (most people have these handy anyway - or should!), and then click one of the output buttons (All DDL, DDL for User, All Object_Type for User), and choose the HTML format.. You can just as easily output the same to SQL creation scripts as well though.. I would personally do both. :) The tool is free. You can get it here: http://www.cool-tools.co.uk/Products/dbatool.html HTH Mark -Original Message- mike mon Sent: 20 June 2003 13:45 To: Multiple recipients of list ORACLE-L Does anyone has script which can check grant privilege on a table and generate output for future usage? Thanks. __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: mike mon INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.491 / Virus Database: 290 - Release Date: 18/06/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.491 / Virus Database: 290 - Release Date: 18/06/2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Migration to 9.2.0.3.0 (64 Bit
*** Comments by BECKER, BILL Fri Jun 20, 2003 -- 08:09:59 AM We upgraded to 64-bit 9.2.0.3.0 on Solaris 9 a few weeks ago, and are currently experiencing ORA-01733 virtual column not allowed here errors - bug 2884797. This is a star transformation bug, and you are likely to hit it if you are a datawarehouse with star_transformation=true and cursor_sharing=exact. You can only get a patch for this by filing a tar; we could not find any information on this from a Metalink search. We are also experiencing various errors from parallel server processes, and it's not clear if the patch will fix these. Oh yeah, support first had us download the 32-bit patch, which didn't work; they are not sure if a 64-bit patch exists, and we are currently waiting on this. version 8.1.6 - star_transformation bug crashes database version 8.1.7 - star_transformation bug fixed; new bug (excuse me, feature) ORA-00164 autonomous transaction disallowed within distributed transaction version 9.2.0.3 - ORA-00164 fixed; new star transformation bug ORA-01733 new versions, new bugs. *** Original message by VIVEK_SHARMA [EMAIL PROTECTED] After Migrating a production Database from 8.1.7.4 to 9.2.0.3.0 (64 Bit) on Solaris 8 following NON-Documented parameters were set by Oracle Corp _shared_pool_reserved_min_alloc=16384 This was done to take care of the ORA-4031 errors. This caused shared pool erros to STOP Occuring though at the Cost of increasing the shared_pool_size to 637MB shared_pool_reserved_size to 131 MB Such values seem very high to us . 04031, 0, unable to allocate %s bytes of shared memory (\%s\,\%s\,\%s\,\%s\) // *Cause: More shared memory is needed than was allocated in the shared pool. _library_cache_advice=false This parameter takes care of library cache pin problem _optim_enhance_nnull_detection=false SELECT COUNT(*) GIVES WRONG RESULT with null values ( BUG:- 2920925 ) _multi_join_key_table_lookup=false (BUG:- 2446423) Details:- QUERY RETURNS WRONG ANSWER WITH ORDER BY CLAUSE _predicate_elimination_enabled=false BUG:- 2257439 Details:- NULL VALUE IN PARTITION RETURNED IF PARTITION BOUND VALUE IS IN WHERE CONDITION M/c = SF15K Database using Shared Servers (MTS) Database Size = 250 GB Hybrid Banking Application using Bind variables mostly though some amount of Literal SQLs also run cursor_sharing = EXACT We are considering trying out cursor_sharing = FORCE gradually checking if shared_pool_size shared_pool_reserved_size values can be reduced . Any Else experienced such issues ? Any Advise ? We are considering Migrating another 1000 GB Production database also to 9i setting Similar parameters . Following is a STATSPACK report of the Production Database already at 9i having the above NON-Documented parameters already set . DB Name DB IdInstance Inst Num Release Cluster Host --- --- --- TBASUN1820705732 tbasun 1 9.2.0.3.0 NO IB15KDB Snap Id Snap Time Sessions Curs/Sess Comment --- -- - --- Begin Snap:1437 18-Jun-03 11:00:032,686 49.2 End Snap:1446 18-Jun-03 12:00:052,936 51.0 Elapsed: 60.03 (mins) Load Profile Per Second Per Transaction --- --- Redo size:265,713.47 1,165.59 Logical reads: 24,199.94106.16 Block changes: 1,275.65 5.60 Physical reads: 1,293.29 5.67 Physical writes:108.35 0.48 User calls: 7,869.31 34.52 Parses:348.92 1.53 Hard parses: 19.96 0.09 Sorts:243.00 1.07 Logons: 8.93 0.04 Executes: 4,874.94 21.38 Transactions:227.97 % Blocks changed per Read:5.27Recursive Call %:12.26 Rollback per transaction %: 68.52 Rows per Sort: 335.11 Avg Total Wait waitWaits Event Waits Timeouts Time (s) (ms) /txn -- -- -- latch free 1,386,411 72,966 14,913 11 1.7 db file sequential read
RE: [Q] Script to generate grant privilege on a table?
/[EMAIL PROTECTED]:\scripts\createinsert.sql drop user SOMEONE; create user SOMEONE identified by lgt5666 default tablespace tables temporary tablespace temp; grant connect to SOMEONE; */ spool D:\scripts\insertperm.sql select 'GRANT INSERT ON SCHEMA.'||'' || table_name ||' TO SOMEONE' ||';' from sys.all_tables where owner = 'SCHEMA'; select 'GRANT SELECT ON SCHEMA.'||'' || table_name ||' TO SOMEONE' ||';' from sys.all_tables where owner = 'SCHEMA'; select 'GRANT UPDATE ON SCHEMA.'||'' || table_name ||' TO SOMEONE' ||';' from sys.all_tables where owner = 'SCHEMA'; select 'GRANT DELETE ON SCHEMA.'||'' || table_name ||' TO SOMEONE' ||';' from sys.all_tables where owner = 'SCHEMA'; select 'GRANT EXECUTE ON SCHEMA.'||'' || object_name ||' TO SOMEONE' ||';' from all_objects where object_type = 'PACKAGE' and owner = 'SCHEMA' and object_name like 'SOMETHING%'; spool off; start D:\scripts\insertperm.sql -- exit ; Does anyone has script which can check grant privilege on a table and generate output for future usage? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Migration to 9.2.0.3.0 (64 Bit) on Solaris 8 issues
I don't think the cursor sharing will help. We've been going 'round and 'round with the shared pool fragmentation problem and the 4031 errors. Flushing the shared pool might or might not work; sometimes it cleans things up; sometimes it doesn't do anything (as far as I can tell). About all you can do is follow Oracle's recommendations on sizing and cross your fingers. You might have to schedule a periodic restart of the database -- sort of like Windows 3.1 huh? And ... Oracle is still trying to figure out why index create/rebuild online on a busy table can lock things up. Other people have brought it to their attention, but we (apparently) are the first site that could make it happen at will. I guess there are times when those fat pig applications are useful for something. By the way, we are on Tru64, so I don't think the problems are platform specific. -Original Message- After Migrating a production Database from 8.1.7.4 to 9.2.0.3.0 (64 Bit) on Solaris 8 following NON-Documented parameters were set by Oracle Corp _shared_pool_reserved_min_alloc=16384 This was done to take care of the ORA-4031 errors. This caused shared pool erros to STOP Occuring though at the Cost of increasing the shared_pool_size to 637MB shared_pool_reserved_size to 131 MB Such values seem very high to us . 04031, 0, unable to allocate %s bytes of shared memory (\%s\,\%s\,\%s\,\%s\) // *Cause: More shared memory is needed than was allocated in the shared pool. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: [Q] Script to generate grant privilege on a table?
Look into DBMS_METADATA examples in the oracle 9.2 technical documentation. That is precisely the example they gave. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Friday, June 20, 2003 8:45 AM To: Multiple recipients of list ORACLE-L Does anyone has script which can check grant privilege on a table and generate output for future usage? Thanks. __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: mike mon INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Development projects: Multiple databases v/s multiple schemas
Hi, We end up doing it both ways at the same time. We have multiple development instances and multiple schemas in each instance. We do this because we are running a large ERP system and each test instance has specific testing requirements so we end up replicating multiple instances on the same machine. Beyond that, all the add-on products that we have either developed or purchased lives in each instance under it's own schema. If I had my choice, I would run one database instance with multiple schemas. This way the resources are only consumed by one instance and your not try to juggle system resources between multiple instances. That can be a problem if your box is already maxed out as one of our development boxes is. Hope that helped, -- Joe Frohne Rawson Oaks Consulting http://www.rawsonoaks.com [EMAIL PROTECTED] or [EMAIL PROTECTED] Hi, For multiple projects we are planning to have a centralized server(as opposed to multiple servers, to improve managability) which all the development teams will use for their backend work. Now there are 2 ways in which to provide them access. 1. Have only 1 database for each version of Oracle Server installed and create schemas for individual teams for their development work. 2. Create a separate DB for each project team. I want to know the pros and cons for both the approaches. Any ideas and suggestions are most welcome. Regards Naveen DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Frohne INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Book Recommendation for Apache
O'Reilly is good. Also, get yourself comanche (http://www.comanche.org). That is a gooey tool for setting up Apache. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Sam Bootsma [mailto:[EMAIL PROTECTED]Sent: Thursday, June 19, 2003 4:44 PMTo: Multiple recipients of list ORACLE-LSubject: Book Recommendation for Apache Hi, Any recommendations on good Apache books? We will be bringing in Oracle 9iAS shortly. Third party application constraints require the use of Forms 6i, which in turn requires that we stay with 9iAS Release 1 (version 1.0.2.x.x). We are currently running Oracle Application Server. I want to understand how 9iAS works. For me, the steps to understanding this are something like: 1) Understand HTTP 2) Understand Apache 3) Understand 9iAS I have found useful information on the Internet describing the HTTP protocol, and I am comfortable I understand that well enough to move on. Now I want to get a handle on the Apache Server. I have had a brief look at a book from Oreilly called Apache, The Definitive Guide. This looks like a good book. Thanks, Sam p.s. A few months, I read on the List that the Publisher of Tom Kytes book "Expert One-On-One Oracle" has gone bankrupt. Can anybody confirm if this is true?
RE: OEM question
The old simple snapshot replication is OK. It's just that some of this later stuff makes you think they rounded up all the guys who have tape on their glasses and wear suspenders with their pants that are too short, gave them a drug to put them in an *extra* geeky mood, gave them unlimited amounts of Mountain Dew soda and whatever quantities of Jolt Cola that still existed, then turned them loose on replication and Advanced Queuing. -Original Message- No No. THOSE guys did replication. Then the worst of the bunch worked in conjunction with the authors of graduate Math texts to come up with Advanced Queuing. somehow this makes me glad i work for cheap places that don't use any of that.;-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Upgrading from 8.1.7 32 bit to 9.2.0.3 64 bit
Hi all, Has anyone done the upgrade from 8.1.7 32 bit to 9.2.0.3 64 bit? I'm trying to determine whether it's necessary to perform any other steps than the regular upgrade process. Note 62290.1 seems to imply that no other steps are required, but this is contradicted elsewhere and it's proving almost impossible to get a straight answer from Oracle. There's one hilarious Forum exchange on metalink (search on 32 bit Sahoo) where the tech manages to avoid saying anything other than read the documentation. So, any advice, experience, or pointers to other articles out there? Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Development projects: Multiple databases v/s multiple schemas
Title: RE: Development projects: Multiple databases v/s multiple schemas Thanx Raj and Bahar, Raj I think you misunderstood my question. Or I might be misunderstanding a part of your reply :-) I'll try to makemyquestionclearer All the developers of a project work on the same DB(developers don't have individual DBs, project teams have).Different projects have individual servers running separate DBs on separate machines. This causes maintenance problems since currently project teams are responsible for their respective servers and they don't have the required expertize to do it. We are planning to centralize the same andhave one high-end machine running different versions of Oracle. My question is, for multiple projects which plan development on the same version of oracle, should I have 1 DB per project or within one DB multiple schemas for different projects? The project teams want separate DBs because they think they can shutdown and startup the DB as per their wish. For them if something gets stuck, the best way is to restart the DB :-). But my point is that starting and shutting down a DB is not required at all, since most of the things can be dynamically changed. The only thing is thatcertain init.ora parameters which cannot be changed dynamically. But since there is not too much of benchmarking done by the project teams the need to change init.ora parameters is not there. If required this can be done in a separate test DB which will be allotted for testing and taken back once load testing/benchmarking is over. The only problemI envisage with having multiple schemas is the name conflict between applications(projects) (2 applications might want to have schema with the same name). I think the "stats" referred by Bahar are system level statistics like CPU utilization, waits etc. which I think are most relevant when doing tuning during load testing / benchmarking which as mentioned above can be done on a separate test DB specifically allotted for the same on a short term basis. Regards Naveen -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Friday, June 20, 2003 7:35 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Development projects: Multiple databases v/s multiple schemas if your schema will be cross-referencing, I vote for ONE db with multiple schema. This way, any changes in one schema immediately affect others and can be controlled. If you _know_ (guaranteed by management) that the schema will _never_ cross reference, then I'd still go for single DB, unless there is a proven need for separate database. I know developers like to have a whole database for themselves, but unfortunately all schema co-exist in the database, so should developers in one DB. A. Bahar, I didn't understand your point, so pardon me. What statistics are we talking here? You mean if ytou have on database per schema, table stats will be different than having all schema in one DB ?? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! DISCLAIMER:This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission.
RE: OEM question
Stephen Lee scribbled on the wall in glitter crayon: The old simple snapshot replication is OK. It's just that some of this later stuff makes you think they rounded up all the guys who have tape on their glasses and wear suspenders with their pants that are too short, gave them a drug to put them in an *extra* geeky mood, gave them unlimited amounts of Mountain Dew soda and whatever quantities of Jolt Cola that still existed, then turned them loose on replication and Advanced Queuing. hey! i resemble that remark!;-) OK well, i don't have tape on the glasses.;-) as for the Jolt all the sugar and twice the caffeine cola, it's still made down the road in Rochester, NY. and yes i still drink it.;-) -- Bill Shrek ThaterOracle DBA BAARF Party member #25 [EMAIL PROTECTED] -- 10 out of 5 doctors think it's OK to be schizofrenic. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Upgrading from 8.1.7 32 bit to 9.2.0.3 64 bit
Sorry, should have mentioned that I'm on Solaris 2.8. Thanks, Jay -Original Message- Sent: Friday, June 20, 2003 10:19 AM To: '[EMAIL PROTECTED]' Cc: Miller, Jay Jay, Just make sure that ur OS is 64-bit as well and go ahead as per the documentation. If ur OS is HP-UX, do not forget to set ur SHLIB_PATH and CLASSPATH as well. Cheers Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 20 June 2003 15:50 To: Multiple recipients of list ORACLE-L Hi all, Has anyone done the upgrade from 8.1.7 32 bit to 9.2.0.3 64 bit? I'm trying to determine whether it's necessary to perform any other steps than the regular upgrade process. Note 62290.1 seems to imply that no other steps are required, but this is contradicted elsewhere and it's proving almost impossible to get a straight answer from Oracle. There's one hilarious Forum exchange on metalink (search on 32 bit Sahoo) where the tech manages to avoid saying anything other than read the documentation. So, any advice, experience, or pointers to other articles out there? Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Upgrading from 8.1.7 32 bit to 9.2.0.3 64 bit
Jay, Just make sure that ur OS is 64-bit as well and go ahead as per the documentation. If ur OS is HP-UX, do not forget to set ur SHLIB_PATH and CLASSPATH as well. Cheers Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 20 June 2003 15:50 To: Multiple recipients of list ORACLE-L Hi all, Has anyone done the upgrade from 8.1.7 32 bit to 9.2.0.3 64 bit? I'm trying to determine whether it's necessary to perform any other steps than the regular upgrade process. Note 62290.1 seems to imply that no other steps are required, but this is contradicted elsewhere and it's proving almost impossible to get a straight answer from Oracle. There's one hilarious Forum exchange on metalink (search on 32 bit Sahoo) where the tech manages to avoid saying anything other than read the documentation. So, any advice, experience, or pointers to other articles out there? Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
got EXP-00091 warning
Greetings, When I export schema containing some tables, I got EXP-00091 warnings. The log is saying: .. JServer Release 9.2.0.1.0 - Production Export done in US7ASCII character set and AL16UTF16 NCHAR character set server uses WE8ISO8859P1 character set (possible charset conversion) . exporting pre-schema procedural objects and actions . exporting foreign function library names for user XXX . exporting PUBLIC type synonyms . exporting private type synonyms . exporting object type definitions for user XXX About to export XXX's objects ... . exporting database links . exporting sequence numbers . exporting cluster definitions . about to export XXX's tables via Conventional Path ... . . exporting table CHEMISTRY 0 rows exported EXP-00091: Exporting questionable statistics. . . exporting tableCHEMISTRY_ALIAS 0 rows exported EXP-00091: Exporting questionable statistics. . . exporting table DESTINATION_PLATE_WELL 0 rows exported EXP-00091: Exporting questionable statistics. ... I check oracle document and it says: EXP-00091 Exporting questionable statistics Cause: Export was able to export statistics, but the statistics may not be useable. The statistics are questionable because one or more of the following happened during export: a row error occurred, client character set or NCHARSET does not match with the server, a query clause was specified on export, only certain partitions or subpartitions were exported, or a fatal error occurred while processing a table. Action: To export non-questionable statistics, change the client character set or NCHARSET to match the server, export with no query clause, or export complete tables. If desired, import parameters can be supplied so that only non-questionable statistics will be imported, and all questionable statistics will be recalculated. So I think the problem is chararter set not matching. So how can I change client character set? Thanks, Jin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: [Q] Script to generate grant privilege on a table?
select 'grant '||privilege||' to '|| grantee ||' on '||table_name||';' from dba_tab_privs where owner = 'BUBBA'; Note that this will get everything owned by BUBBA: tables, procedures, packages, views, sequences. -Original Message- Does anyone has script which can check grant privilege on a table and generate output for future usage? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Development projects: Multiple databases v/s multiple schemas
Naveen, It depends on the deployment method to be used. In general I try to limit the number of instances. Sure not having each project in it's own instance diminishes some of the capabilities that you have to monitor how they perform, but all of those instances are competing on the server for the same resources (CPU, memory, and IO). Have one badly performing application and one instance will cause a pile of problems that may not be easy to figure out. Also it depends on how much these applications are dependent on each other for data. I try, although I don't succeed, to minimize inter instance communication. SQL*Net is not very efficient. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, June 20, 2003 8:19 AM To: Multiple recipients of list ORACLE-L Hi, For multiple projects we are planning to have a centralized server(as opposed to multiple servers, to improve managability) which all the development teams will use for their backend work. Now there are 2 ways in which to provide them access. 1. Have only 1 database for each version of Oracle Server installed and create schemas for individual teams for their development work. 2. Create a separate DB for each project team. I want to know the pros and cons for both the approaches. Any ideas and suggestions are most welcome. Regards Naveen DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: oracle authentication from windows
AK, The issue is not creating an id called OPS$ SYSTEM on XP, but on the database. Say, you created a user called OPS$SYSTEM as create user ops$system identified externally; The XP user should be SYSTEM, not OPS$SYSTEM, to log on to this account. Now suppose, your os_authent_prefix is set to "" (null), then the Oracle user SYSTEM, not OPS$SYSTEMis authenticated externally. If someone creates a user in XP called SYSTEM, she can call sqlplus /@service1 The OS user is SYSTEM, os_authent_prefix is null, so Oracle will let the user be logged on as oracle user SYSTEM! Therefore, always have a not null value in os_authent_prefix, e.g. OPS$. If the XP user is OPS$SYSTEM, the oracle user should be OPS$OPS$SYSTEM, not OPS$SYSTEM. I hope you see the difference. HTH. Arup - Original Message - From: AK To: Arup Nanda Sent: Friday, June 20, 2003 10:46 AM Subject: Re: oracle authentication from windows Arup, why someone can't create account like ops$system on xp and get in . If they can create system then y not ops$system . Secondly OS authentication means operating system is going to take care of auth. rite ? . It's up to OS not allow the users to change their ids. -ak - Original Message - From: Arup Nanda To: Multiple recipients of list ORACLE-L Sent: Thursday, June 19, 2003 3:34 PM Subject: Re: oracle authentication from windows Mladen, This is precisely the content I have gone in depth in my upcoming book where this practice of OPS$ accounts have been discussed. The security hole in OPS$ accounts is a bit overrated. Chagnign username in Windows XP alone does not allow logging in to the database directly if OPS$ accounts are used. What you are referring to is setting the ORA_DBA group in Windows. Here is an excerpt from the book: "If OPS$ accounts must be used, make sure that init.ora parameter os_authent_prefix is set to OPS$ or some other value, not NULL. If it is null, as shown by an empty string "", the security is severely threatened. Any one can create a userid called SYSTEM in the OS and then logon without a password as the Oracle user SYSTEM. If the os_authent_prefix is set to OPS$, then the corresponding user id in Oracle will be OPS$SYSTEM, not SYSTEM. they are different users." As you might notice, OPS$ accounts are somehow insecure, and I personally eschew them; but let's face it, in some situations, like in the case AK mentioned, the use is required. When the DBAs can do is to take some precautions to ensure security. HTH. Arup - Original Message - From: Gogala, Mladen To: Multiple recipients of list ORACLE-L Sent: Thursday, June 19, 2003 4:19 PM Subject: RE: oracle authentication from windows That, of course, will render your database totally insecure and open to anybody who can bring in a WinXP laptop, change the windoze username and log in as he pleases. DBA that sets his production parameters the way Arup described deserves to be publicly tortured by Bill O'Reilly in the "no spin zone". Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Arup Nanda [mailto:[EMAIL PROTECTED]Sent: Thursday, June 19, 2003 3:46 PMTo: Multiple recipients of list ORACLE-LSubject: Re: oracle authentication from windows Sure. Just declare these in your init.ora os_authent_prefix=OPS$remote_os_authent=TRUE bounce the database, add a user called OPS$the Windows username, e.g. OPS$AK if your Windows login id is AK as create user ops$ak identified externally From windows connect as "/@servicename", e.g. sqlplus /@service1 If it doesn't work, the OS user may be different. Use this query while connected to the database from Windows cleint. SQL select sys_context('USERENV','OS_USER') from dual; See what OS username comes up; use that instead. HTH. Arup Nanda www.proligence.com - Original Message - From: AK To: Multiple recipients of list ORACLE-L Sent: Thursday, June 19, 2003 1:10 PM Subject: oracle authentication from windows We want our client users ( forms user ) to just enter windows password and then automatically able to get in to oracle .Is there a way oracle
RE: AQ, RAC and delay
Since I really don't have any performance issues [2 Nodes, 2CPUs each @1GHz, 2GB, ES45 Tru64Cluster], I haven't been runnning StatsPack. However I just ran two snapshots and didn't see such a wait event. I'm sure that other people have also implemented mcpd=0 successfuly [my 9iRAC is an Export-Import upgrade from an 8.1.5 OPS environment, where, too, the earlier DBA had set mcpd=0, with some additional parameters because of a bug in 8.1.5OPS]. Hemant At 08:24 AM 19-06-03 -0800, you wrote: With MPCD=0, Is your primary wait event shown as on-going reading of SCN to complete in the statspack reports? Oracle Support insisted we set it to 7 coz of this. Raj K Gopalakrishnan To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: [EMAIL PROTECTED] Subject: RE: AQ, RAC and delay o.com Sent by: [EMAIL PROTECTED] ity.com 06/19/2003 10:29 AM Please respond to ORACLE-L Hemant: You are right. 7 seconds is the MAX difference, but the control files are synced every 3 seconds during the 'split brain' check. So most of the cases, it is 3 seconds with the maximum of 7 seconds subject to the MCPD settings. KG Best Regards, K Gopalakrishnan -Original Message- Hemant K Chitale Sent: Thursday, June 19, 2003 5:38 AM To: Multiple recipients of list ORACLE-L Although MCPD may default to 700centiseconds [although I have seen a much lower value on 9.2 on Tru64], in most cases, delays of 7seconds don't occur [and shouldn't be acceptable ?!]. I do have a 9iRAC environment but am comfortably using mcpd=0. And I have AQ in an 8.1.7 single-instance environment. So I can't make any statements about AQ in OPS/RAC ! Hemant At 07:05 AM 17-06-03 -0800, you wrote: A colleague casually mentioned that in RAC, the test to de-queue an AQ set-up from BOTH instances didn't succeed. The side where we were enqueuing was able to see queued messages faster than the 'other' side. About 7-8 seconds ... that got me thinking ... is this an effect of MCPD which defaults to like 7 seconds? Do you use AQ in RAC and enqueue/dequeue on both nodes? What is your experience? ps: mcpd - max commit propagation delay TIA Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! Hemant K Chitale -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Upgrading from 8.1.7 32 bit to 9.2.0.3 64 bit
I have not done this yet, but I did look into it. There is one thread in the Metalink forum that I printed the number is 337111.99 (I am not sure if that is the whole number or not, it looks cutoff on the printout). It also references doc 169426.1, which has some good info in it. The basic idea is this: - Take backup of 8.1.7 32 bit DB on AIX 4.3.3 - Upgrade OS to 5L - Boot OS in 32 bit mode (even thought the hardware is 64 bit capable) - You can run 8.1.7 in 32 bit mode like this. to upgrade to 64bit 9i: - Backup DB and OS - Install 9i 64bit - Upgrade 8i 32 bit to 9i rel 2 64 bit using the installer I'm not too sure on this one: - Reboot OS in 64 bit mode? Also try this doc 159657.1 it has a pretty detailed checkllist for the upgrade. If you aren't running AIX, go to the top tech docs section of Metalink, choose the upgrade and migration link, then you can choose from the database versions below or choose platform information and choose your OS. HTH Mike [EMAIL PROTECTED] house.comTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: Upgrading from 8.1.7 32 bit to 9.2.0.3 64 bit .com 06/20/2003 10:49 AM Please respond to ORACLE-L Hi all, Has anyone done the upgrade from 8.1.7 32 bit to 9.2.0.3 64 bit? I'm trying to determine whether it's necessary to perform any other steps than the regular upgrade process. Note 62290.1 seems to imply that no other steps are required, but this is contradicted elsewhere and it's proving almost impossible to get a straight answer from Oracle. There's one hilarious Forum exchange on metalink (search on 32 bit Sahoo) where the tech manages to avoid saying anything other than read the documentation. So, any advice, experience, or pointers to other articles out there? Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Boligan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: [Q] Script to generate grant privilege on a table?
I might have gotten something bass-ackwards here. Please correct as needed. Testing?! We don't need no stinkin' testing. -Original Message- select 'grant '||privilege||' to '|| grantee ||' on '||table_name||';' from dba_tab_privs where owner = 'BUBBA'; -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Development projects: Multiple databases v/s multiple schemas
Title: RE: Development projects: Multiple databases v/s multiple schemas Hi Rajendra ... For Example , There is one instance and two project on this instance. ProjectA and ProjectB. beetween 10:00 am and 11:30 am ,ProjectA realized via numerious sessions 30 timeswait for event of "free buffer inspected" 1000 block "consistent get" 2000 block "buffer get" 100 block "physical read" beetween 09:30 am and 11:30 am , ProjectB realized via numerious sessions 240 times wait for event of "free buffer inspected" 500 block "consistent get" 500 block "buffer get" 5100 block "physical read" And you take a performance report for beetween 09:00 and 12:00 , And values are 270 timeswait for event of "free buffer inspected" 1500 block "consistent get" 2500 block "buffer get" 5200 block "physical read" cahce hit ratio 1-(1500+2500)/5200 =0.23 Question : which project cause to these figurs. -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Friday, June 20, 2003 4:05 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Development projects: Multiple databases v/s multiple schemas if your schema will be cross-referencing, I vote for ONE db with multiple schema. This way, any changes in one schema immediately affect others and can be controlled. If you _know_ (guaranteed by management) that the schema will _never_ cross reference, then I'd still go for single DB, unless there is a proven need for separate database. I know developers like to have a whole database for themselves, but unfortunately all schema co-exist in the database, so should developers in one DB. A. Bahar, I didn't understand your point, so pardon me. What statistics are we talking here? You mean if ytou have on database per schema, table stats will be different than having all schema in one DB ?? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, June 20, 2003 9:19 AM To: Multiple recipients of list ORACLE-L Subject: RE: Development projects: Multiple databases v/s multiple schemas if you create separete databases , you can monitor statistics of each of them indivudually. Otherwiese database statistics will be affected from multiple projects . -Original Message- Sent: Friday, June 20, 2003 2:19 PM To: Multiple recipients of list ORACLE-L Hi, For multiple projects we are planning to have a centralized server(as opposed to multiple servers, to improve managability) which all the development teams will use for their backend work. Now there are 2 ways in which to provide them access. 1. Have only 1 database for each version of Oracle Server installed and create schemas for individual teams for their development work. 2. Create a separate DB for each project team. I want to know the pros and cons for both the approaches. Any ideas and suggestions are most welcome. Regards Naveen DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services
how to handle client installs w/o admin privs
We have users who need to install the oracle 9i client on their PCs but who aren't administrators on their machines. How do people handle this situation? Thanks. Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Armstrong-Champ INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
oracle docs do say # of extents effect performance
I just read a .pdf by a couple of people at oracle called Stop Fragmenting and start living where it says not worry about the number of extents in a tablespace. However in the administrators doc it says the following: Estimate Table Size and Set Storage Parameters Estimating the sizes of tables before creating them is useful for the following reasons: You can use the combined estimated size of tables, along with estimates for indexes, rollback segments, and redo log files, to determine the amount of disk space that is required to hold an intended database. From these estimates, you can make correct hardware purchases and other decisions. You can use the estimated size of an individual table to better manage the disk space that the table will use. When a table is created, you can set appropriate storage parameters and improve I/O performance of applications that use the table. For example, assume that you estimate the maximum size of a table before creating it. If you then set the storage parameters when you create the table, fewer extents will be allocated for the table's data segment, and all of the table's data will be stored in a relatively contiguous section of disk space. This decreases the time necessary for disk I/O operations involving this table. this is at the following link: http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76956/tables.htm#208 am I reading this wrong or is Oracle stating that you should have less extents in a table? I know several people on here have posted that the number of extents used by an object is almost irrelevant. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Development projects: Multiple databases v/s multiple schemas
Title: RE: Development projects: Multiple databases v/s multiple schemas I understand now, but in development?? I have 13 schema that form an application, the development is an exact replica of production RAC instance and no one in Devl complains (well most of the times). Raj --- Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Friday, June 20, 2003 12:05 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Development projects: Multiple databases v/s multiple schemas Hi Rajendra ... For Example , There is one instance and two project on this instance. ProjectA and ProjectB. beetween 10:00 am and 11:30 am ,ProjectA realized via numerious sessions 30 timeswait for event of "free buffer inspected" 1000 block "consistent get" 2000 block "buffer get" 100 block "physical read" beetween 09:30 am and 11:30 am , ProjectB realized via numerious sessions 240 times wait for event of "free buffer inspected" 500 block "consistent get" 500 block "buffer get" 5100 block "physical read" And you take a performance report for beetween 09:00 and 12:00 , And values are 270 timeswait for event of "free buffer inspected" 1500 block "consistent get" 2500 block "buffer get" 5200 block "physical read" cahce hit ratio 1-(1500+2500)/5200 =0.23 Question : which project cause to these figurs. -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Friday, June 20, 2003 4:05 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Development projects: Multiple databases v/s multiple schemas if your schema will be cross-referencing, I vote for ONE db with multiple schema. This way, any changes in one schema immediately affect others and can be controlled. If you _know_ (guaranteed by management) that the schema will _never_ cross reference, then I'd still go for single DB, unless there is a proven need for separate database. I know developers like to have a whole database for themselves, but unfortunately all schema co-exist in the database, so should developers in one DB. A. Bahar, I didn't understand your point, so pardon me. What statistics are we talking here? You mean if ytou have on database per schema, table stats will be different than having all schema in one DB ?? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, June 20, 2003 9:19 AM To: Multiple recipients of list ORACLE-L Subject: RE: Development projects: Multiple databases v/s multiple schemas if you create separete databases , you can monitor statistics of each of them indivudually. Otherwiese database statistics will be affected from multiple projects . -Original Message- Sent: Friday, June 20, 2003 2:19 PM To: Multiple recipients of list ORACLE-L Hi, For multiple projects we are planning to have a centralized server(as opposed to multiple servers, to improve managability) which all the development teams will use for their backend work. Now there are 2 ways in which to provide them access. 1. Have only 1 database for each version of Oracle Server installed and create schemas for individual teams for their development work. 2. Create a separate DB for each project team. I want to know the pros and cons for both the approaches. Any ideas and suggestions are most welcome. Regards Naveen DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official
RE: Upgrading from 8.1.7 32 bit to 9.2.0.3 64 bit
I know we had to run utlirp.sql when moving from 32 to 64. Not sure if this is covered by running catproc as part of the migration. -Original Message- Sent: 20 June 2003 15:50 To: Multiple recipients of list ORACLE-L Hi all, Has anyone done the upgrade from 8.1.7 32 bit to 9.2.0.3 64 bit? I'm trying to determine whether it's necessary to perform any other steps than the regular upgrade process. Note 62290.1 seems to imply that no other steps are required, but this is contradicted elsewhere and it's proving almost impossible to get a straight answer from Oracle. There's one hilarious Forum exchange on metalink (search on 32 bit Sahoo) where the tech manages to avoid saying anything other than read the documentation. So, any advice, experience, or pointers to other articles out there? Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Adrian Roe INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: oracle authentication from windows
Got it . Thanks Arup . -ak - Original Message - From: Arup Nanda To: Multiple recipients of list ORACLE-L Sent: Friday, June 20, 2003 8:54 AM Subject: Re: oracle authentication from windows AK, The issue is not creating an id called OPS$ SYSTEM on XP, but on the database. Say, you created a user called OPS$SYSTEM as create user ops$system identified externally; The XP user should be SYSTEM, not OPS$SYSTEM, to log on to this account. Now suppose, your os_authent_prefix is set to "" (null), then the Oracle user SYSTEM, not OPS$SYSTEMis authenticated externally. If someone creates a user in XP called SYSTEM, she can call sqlplus /@service1 The OS user is SYSTEM, os_authent_prefix is null, so Oracle will let the user be logged on as oracle user SYSTEM! Therefore, always have a not null value in os_authent_prefix, e.g. OPS$. If the XP user is OPS$SYSTEM, the oracle user should be OPS$OPS$SYSTEM, not OPS$SYSTEM. I hope you see the difference. HTH. Arup - Original Message - From: AK To: Arup Nanda Sent: Friday, June 20, 2003 10:46 AM Subject: Re: oracle authentication from windows Arup, why someone can't create account like ops$system on xp and get in . If they can create system then y not ops$system . Secondly OS authentication means operating system is going to take care of auth. rite ? . It's up to OS not allow the users to change their ids. -ak - Original Message - From: Arup Nanda To: Multiple recipients of list ORACLE-L Sent: Thursday, June 19, 2003 3:34 PM Subject: Re: oracle authentication from windows Mladen, This is precisely the content I have gone in depth in my upcoming book where this practice of OPS$ accounts have been discussed. The security hole in OPS$ accounts is a bit overrated. Chagnign username in Windows XP alone does not allow logging in to the database directly if OPS$ accounts are used. What you are referring to is setting the ORA_DBA group in Windows. Here is an excerpt from the book: "If OPS$ accounts must be used, make sure that init.ora parameter os_authent_prefix is set to OPS$ or some other value, not NULL. If it is null, as shown by an empty string "", the security is severely threatened. Any one can create a userid called SYSTEM in the OS and then logon without a password as the Oracle user SYSTEM. If the os_authent_prefix is set to OPS$, then the corresponding user id in Oracle will be OPS$SYSTEM, not SYSTEM. they are different users." As you might notice, OPS$ accounts are somehow insecure, and I personally eschew them; but let's face it, in some situations, like in the case AK mentioned, the use is required. When the DBAs can do is to take some precautions to ensure security. HTH. Arup - Original Message - From: Gogala, Mladen To: Multiple recipients of list ORACLE-L Sent: Thursday, June 19, 2003 4:19 PM Subject: RE: oracle authentication from windows That, of course, will render your database totally insecure and open to anybody who can bring in a WinXP laptop, change the windoze username and log in as he pleases. DBA that sets his production parameters the way Arup described deserves to be publicly tortured by Bill O'Reilly in the "no spin zone". Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Arup Nanda [mailto:[EMAIL PROTECTED]Sent: Thursday, June 19, 2003 3:46 PMTo: Multiple recipients of list ORACLE-LSubject: Re: oracle authentication from windows Sure. Just declare these in your init.ora os_authent_prefix=OPS$remote_os_authent=TRUE bounce the database, add a user called OPS$the Windows username, e.g. OPS$AK if your Windows login id is AK as create user ops$ak identified externally From windows connect as "/@servicename", e.g. sqlplus /@service1 If it doesn't work, the OS user may be different. Use this query while connected to the database from Windows cleint. SQL select sys_context('USERENV','OS_USER') from dual; See what OS username comes up; use that instead.
RE: oracle docs do say # of extents effect performance
It is the old argument that was made to justify one or only a few extents. Empirically the idea does not hold up. This idea is now classified as a myth but the Oracle docs have not caught up yet. Allan -Original Message- Sent: Friday, June 20, 2003 11:20 AM To: Multiple recipients of list ORACLE-L I just read a .pdf by a couple of people at oracle called Stop Fragmenting and start living where it says not worry about the number of extents in a tablespace. However in the administrators doc it says the following: Estimate Table Size and Set Storage Parameters Estimating the sizes of tables before creating them is useful for the following reasons: You can use the combined estimated size of tables, along with estimates for indexes, rollback segments, and redo log files, to determine the amount of disk space that is required to hold an intended database. From these estimates, you can make correct hardware purchases and other decisions. You can use the estimated size of an individual table to better manage the disk space that the table will use. When a table is created, you can set appropriate storage parameters and improve I/O performance of applications that use the table. For example, assume that you estimate the maximum size of a table before creating it. If you then set the storage parameters when you create the table, fewer extents will be allocated for the table's data segment, and all of the table's data will be stored in a relatively contiguous section of disk space. This decreases the time necessary for disk I/O operations involving this table. this is at the following link: http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76956/ tables.htm#208 am I reading this wrong or is Oracle stating that you should have less extents in a table? I know several people on here have posted that the number of extents used by an object is almost irrelevant. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Partition
Hey, Can anyone say if there is a way to breakup an existing partition into subpartitons. The partition contains data. Thx Ishwar. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ishwar Tewari INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: What can cause boost in LIO/PIO?
What was this 5am job? It wasn't an analyze was it? RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/20/2003 11:29 AM Hey all, I'm testing out the max I/O thruput of an IBM FastT900 using a dual 2.4GHz w/1GB RAM on Win2K server (not my choice but it's just for testing) running Oracle 8.1.7. For one of my tests, I created the following heirarchical query: SELECT * FROM MYBIGTABLE GL1 START WITH GL1.TIME_STAMP LIKE '%40%' CONNECT BY PRIOR REFERENCENO = WORKORDERNO; Here's the explain plan as TOAD sees it (mangled by e-mail): Operation Object Name RowsBytes Cost SELECT STATEMENT Optimizer Mode=CHOOSE 95 K36477 CONNECT BY INDEX FAST FULL SCANMBT_TRANSTYPE 477 K 8 M 13165 TABLE ACCESS BY USER ROWID MYBIGTABLE ROWID ROW L PARTITION RANGE ALL 1 8 TABLE ACCESS FULL MYBIGTABLE 95 K9 M 36477 1 8 The CONNECT BY was purposely done against non-indexed columns so as to have the query consume more IO. Also, the instance was detuned to only have less than 8MB of buffer cache. And I had started a full direct export of the DB in an attempt to flush the SAN's 2GB shared cache. I want to see how much real physical IO this puppy can produce. I know, I know, there are several other factors involved. I don't have the SAN available to me for long for testing, so it's the best I could think of on short notice. Anyway... I ran several of these concurrently, staggering the start of each randomly by up to a minute. After introducing other loads in order to max out the SAN and after the full export of the 30GB DB completed, I started killing of the queries one-by-one, noticing the change in activity on the DB for each kill. I left four queries running when I left last night to see how long they'd take (no real purpose, just for kicks). One of the tools I'm using to monitor is Quest's Spotlight on Oracle. When I got in this AM, I noticed in SoO that the four queries were still running. I think I maxed out the SAN. System-wide event waits were over 3000ms/s. OK, to my question (finally!): The wierd thing is that after a 5:00ish AM DBMS_JOB completed, the LIOs and PIOs for the same four queries jumped dramatically. Why would this happen? CPU usage was fairly constant and there were no other processes active. I'm guessing this is an Oracle thing and not a SAN issue since the LIOs also jumped dramatically, but I could be wrong. Since I can't describe this very well, I've put an annotated screenshot of the Spotlight screen at http://society.servebeer.com/SANTA_19.png The image is about 130K. Be kind to my li'l server, I've only got a 128Kb pipe up (768Kb down). :) Any ideas? Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: MySQL in the future?
Okay, I figured the time had come to stop speculating about MySQL's licensing policy and get the answer straight from the horse's mouth, as it were. So I contacted MySQL and posed a couple of scenarios to them. Here's my questions and their responses (my stuff is the quoted part): in all of these examples, a non-GPLed application is being described: 1) A web-based application for an internal or external audience running with mysql as the backend only? If it is a web-based application that will be created and distributed, a license is required. If it is an internally built and internally used application running on one server, a commercial license is not required (more then one installation requires a license for each - it will be considered internal distribution). 2) A compiled win32 application installed on employee desktops that connects to a centralized mysql database for running queries? As long as the database is not installed on each individual machine, only one license is required (unless it is an internally built application running on one server - it could be used for free). 3) A compiled win32 application that installs mysql locally on the user's machine? A license would be required for each installation, it would be considered internal distribution. 4) A web-based application where mysql has been distributed to a number of database servers and is running on those database servers? The confusion seems to center around the word distribute. What constitutes distribution of MySQL? Thanks very much for your help. Distribution for MySQL would mean more than one copy installed in a production environment, either internally or externally. Also note that if an end user used MySQL with a 3rd party commercial application, a non-GPL commercial license of MySQL is required. So, that clears some things up for me, but this licensing policy does seem unnecessarily confusing. Thanks, Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jacques Kilchoer Sent: Wednesday, June 18, 2003 10:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: MySQL in the future? I'm glad I'm not a lawyer. What does distribute internally mean? I work for company X and write an application to use a MySQL database. I take the zip file I downloaded from MySQL and install it to another server, and now two sets of people are using the database on different machines with the same application. Does that mean I distributed it internally? -Original Message- From: Matthew Zito [mailto:[EMAIL PROTECTED] But its not that clear, though - look at this part: As long as you never distribute (internally or externally) the MySQL Software in any way, you are free to use it for powering your application, irrespective of whether your application is under GPL or other OSI approved license or not. So, I would interpret that as saying that if you wrote a web application or a win32 application that just connects to a centrally located mysql database and runs queries, no need to GPL your software. If your app comes with an installer that installs the app as well as mysql, its gotta be GPL or you have to purchase a commercial license. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Matthew Zito INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: oracle docs do say # of extents effect performance
Two reasons: a) if you go into extent map blocks then you will suffer an overhead of at least 1 billionth of a percent :-) b) more seriously, its generally easier to pick up a rogue table if its run into thousands of extents and you had not intended it to. Its not a performance problem per se, but its indicative that its a segment thats doing something that was unforseen in the design phase.. hth connor --- [EMAIL PROTECTED] wrote: I just read a .pdf by a couple of people at oracle called Stop Fragmenting and start living where it says not worry about the number of extents in a tablespace. However in the administrators doc it says the following: Estimate Table Size and Set Storage Parameters Estimating the sizes of tables before creating them is useful for the following reasons: You can use the combined estimated size of tables, along with estimates for indexes, rollback segments, and redo log files, to determine the amount of disk space that is required to hold an intended database. From these estimates, you can make correct hardware purchases and other decisions. You can use the estimated size of an individual table to better manage the disk space that the table will use. When a table is created, you can set appropriate storage parameters and improve I/O performance of applications that use the table. For example, assume that you estimate the maximum size of a table before creating it. If you then set the storage parameters when you create the table, fewer extents will be allocated for the table's data segment, and all of the table's data will be stored in a relatively contiguous section of disk space. This decreases the time necessary for disk I/O operations involving this table. this is at the following link: http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76956/tables.htm#208 am I reading this wrong or is Oracle stating that you should have less extents in a table? I know several people on here have posted that the number of extents used by an object is almost irrelevant. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: oracle docs do say # of extents effect performance
My favorite part is and all of the table's data will be stored in a relatively contiguous section of disk space. Is this even reasonable to believe, especially with any kind of striping implemented? [EMAIL PROTECTED] 06/20/03 12:00PM Two reasons: a) if you go into extent map blocks then you will suffer an overhead of at least 1 billionth of a percent :-) b) more seriously, its generally easier to pick up a rogue table if its run into thousands of extents and you had not intended it to. Its not a performance problem per se, but its indicative that its a segment thats doing something that was unforseen in the design phase.. hth connor --- [EMAIL PROTECTED] wrote: I just read a .pdf by a couple of people at oracle called Stop Fragmenting and start living where it says not worry about the number of extents in a tablespace. However in the administrators doc it says the following: Estimate Table Size and Set Storage Parameters Estimating the sizes of tables before creating them is useful for the following reasons: You can use the combined estimated size of tables, along with estimates for indexes, rollback segments, and redo log files, to determine the amount of disk space that is required to hold an intended database. From these estimates, you can make correct hardware purchases and other decisions. You can use the estimated size of an individual table to better manage the disk space that the table will use. When a table is created, you can set appropriate storage parameters and improve I/O performance of applications that use the table. For example, assume that you estimate the maximum size of a table before creating it. If you then set the storage parameters when you create the table, fewer extents will be allocated for the table's data segment, and all of the table's data will be stored in a relatively contiguous section of disk space. This decreases the time necessary for disk I/O operations involving this table. this is at the following link: http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76956/tables.htm#208 am I reading this wrong or is Oracle stating that you should have less extents in a table? I know several people on here have posted that the number of extents used by an object is almost irrelevant. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Darrell Landrum INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
set oracle-l nomail
Title: Message SET ORACLE-L NOMAIL
Re: controlfile backup obsolete
Rafiq that is a good point , but I have set my control_file_record_keep_time=7 (which is also the default , I think ) and recovery window is 4 days Anything else to check ? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 20, 2003 08:14 : Is your control_file_record_keep_time database parameter value is less than : the time set for retention policy? : I am not using rman but in Robert Freeman's 9i new features book I saw : aboves point. : : It might help or Robert may see your message and suggest some solution. : : Regards : Rafiq : : : : : Reply-To: [EMAIL PROTECTED] : To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] : Date: Thu, 19 Jun 2003 18:09:18 -0800 : : Hello List, sorry about posting this again but , no one responded and : I am really stuck : I am using Oracle 9i release 2 enterprise edition on win32 : : After connecting thru rman , I made sure that I did not have any : backupsets by running : delete backup ; : and then checked with list backup ; : : I have set a recovery window of 4 days with : : CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 4 DAYS; : : And enabled autobackup of controlfiles and spfiles : : CONFIGURE CONTROLFILE AUTOBACKUP ON; : CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO : 'D:\%F'; : : Then I created a backup of the entire database : : backup database ; : (This created a separate backup piece : D:\C-2202427048-20030619-05) : : This is the only backup of the control file I have. I checked with : RMAN LIST BACKUP OF CONTROLFILE; : : List of Backup Sets : === : : BS Key Type LV Size Device Type Elapsed Time Completion Time : : --- -- -- --- -- : -- : 60 Full672K DISK00:00:02 19-Jun-2003 08:04: : 42 : BP Key: 60 Status: AVAILABLE Tag: : Piece Name: D:\C-2202427048-20030619-05 :Controlfile Included: Ckp SCN: 190854 Ckp time: 19-Jun-2003 : 08:04:40 : : Now when I run report obsolete ; : Its gives me the following o/p : : RMAN retention policy will be applied to the command : RMAN retention policy is set to recovery window of 4 days : Report of obsolete backups and copies : Type KeyCompletion TimeFilename/Handle : -- -- : Backup Set 60 19-Jun-2003 08:04:42 : Backup Piece 60 19-Jun-2003 08:04:42 : D:\C-2202427048-20030619-05 : : Why is this sole backup of the controlfile , obsolete ? : If someone runs a delete obselete; they will delete this backup. : : -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: controlfile backup obsolete
Mladen , I do not get a problem if I use : configure retention policy to redundancy n ; (n= integer) However I am having my controlfile backup reported as obsolete when : configure retention policy to recovery window of n days ; (n=integer , I use 4) and my control_file_record_keep_time=7 Please advise ... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 20, 2003 08:09 : Obsolescence of a backup is defined by existance of other, redundant backups. : Give a redundant option to your backup command and RMAN will wait for 30 : backups before declaring the current one obsolete. : : On 2003.06.19 22:09, [EMAIL PROTECTED] wrote: : Hello List, sorry about posting this again but , no one responded and : I am really stuck : I am using Oracle 9i release 2 enterprise edition on win32 : : After connecting thru rman , I made sure that I did not have any : backupsets by running : delete backup ; : and then checked with list backup ; : : I have set a recovery window of 4 days with : : CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 4 DAYS; : : And enabled autobackup of controlfiles and spfiles : : CONFIGURE CONTROLFILE AUTOBACKUP ON; : CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO : 'D:\%F'; : : Then I created a backup of the entire database : : backup database ; : (This created a separate backup piece : D:\C-2202427048-20030619-05) : : This is the only backup of the control file I have. I checked with : RMAN LIST BACKUP OF CONTROLFILE; : : List of Backup Sets : === : : BS Key Type LV Size Device Type Elapsed Time Completion Time : : --- -- -- --- -- : -- : 60 Full672K DISK00:00:02 19-Jun-2003 08:04: : 42 : BP Key: 60 Status: AVAILABLE Tag: : Piece Name: D:\C-2202427048-20030619-05 :Controlfile Included: Ckp SCN: 190854 Ckp time: 19-Jun-2003 : 08:04:40 : : Now when I run report obsolete ; : Its gives me the following o/p : : RMAN retention policy will be applied to the command : RMAN retention policy is set to recovery window of 4 days : Report of obsolete backups and copies : Type KeyCompletion TimeFilename/Handle : -- -- : Backup Set 60 19-Jun-2003 08:04:42 : Backup Piece 60 19-Jun-2003 08:04:42 : D:\C-2202427048-20030619-05 : : Why is this sole backup of the controlfile , obsolete ? : If someone runs a delete obselete; they will delete this backup. : : -- : Please see the official ORACLE-L FAQ: http://www.orafaq.net : -- : Author: [EMAIL PROTECTED] :INET: [EMAIL PROTECTED] : : Fat City Network Services-- 858-538-5051 http://www.fatcity.com : San Diego, California-- Mailing list and web hosting services : - : To REMOVE yourself from this mailing list, send an E-Mail message : to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in : the message BODY, include a line containing: UNSUB ORACLE-L : (or the name of mailing list you want to be removed from). You may : also send the HELP command for other information (like subscribing). : : : -- : Mladen Gogala : Oracle DBA : -- : Please see the official ORACLE-L FAQ: http://www.orafaq.net : -- : Author: Mladen Gogala : INET: [EMAIL PROTECTED] : : Fat City Network Services-- 858-538-5051 http://www.fatcity.com : San Diego, California-- Mailing list and web hosting services : - : To REMOVE yourself from this mailing list, send an E-Mail message : to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in : the message BODY, include a line containing: UNSUB ORACLE-L : (or the name of mailing list you want to be removed from). You may : also send the HELP command for other information (like subscribing). : -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: MySQL in the future?
Thanks for the clearing that up. Did you happen to get a qoute as well? :) Just curious, does MySQL also uses CPU based and named users license? or it is just per server? -Original Message- Sent: Friday, June 20, 2003 1:12 PM To: Multiple recipients of list ORACLE-L Okay, I figured the time had come to stop speculating about MySQL's licensing policy and get the answer straight from the horse's mouth, as it were. So I contacted MySQL and posed a couple of scenarios to them. Here's my questions and their responses (my stuff is the quoted part): in all of these examples, a non-GPLed application is being described: 1) A web-based application for an internal or external audience running with mysql as the backend only? If it is a web-based application that will be created and distributed, a license is required. If it is an internally built and internally used application running on one server, a commercial license is not required (more then one installation requires a license for each - it will be considered internal distribution). 2) A compiled win32 application installed on employee desktops that connects to a centralized mysql database for running queries? As long as the database is not installed on each individual machine, only one license is required (unless it is an internally built application running on one server - it could be used for free). 3) A compiled win32 application that installs mysql locally on the user's machine? A license would be required for each installation, it would be considered internal distribution. 4) A web-based application where mysql has been distributed to a number of database servers and is running on those database servers? The confusion seems to center around the word distribute. What constitutes distribution of MySQL? Thanks very much for your help. Distribution for MySQL would mean more than one copy installed in a production environment, either internally or externally. Also note that if an end user used MySQL with a 3rd party commercial application, a non-GPL commercial license of MySQL is required. So, that clears some things up for me, but this licensing policy does seem unnecessarily confusing. Thanks, Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jacques Kilchoer Sent: Wednesday, June 18, 2003 10:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: MySQL in the future? I'm glad I'm not a lawyer. What does distribute internally mean? I work for company X and write an application to use a MySQL database. I take the zip file I downloaded from MySQL and install it to another server, and now two sets of people are using the database on different machines with the same application. Does that mean I distributed it internally? -Original Message- From: Matthew Zito [mailto:[EMAIL PROTECTED] But its not that clear, though - look at this part: As long as you never distribute (internally or externally) the MySQL Software in any way, you are free to use it for powering your application, irrespective of whether your application is under GPL or other OSI approved license or not. So, I would interpret that as saying that if you wrote a web application or a win32 application that just connects to a centrally located mysql database and runs queries, no need to GPL your software. If your app comes with an installer that installs the app as well as mysql, its gotta be GPL or you have to purchase a commercial license. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Matthew Zito INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing
RE: oracle docs do say # of extents effect performance
Even without stripping you can't gaurantee it will be a contiguous section of disk space. The file could be scattered across the file system. Richard Ji -Original Message- Sent: Friday, June 20, 2003 1:12 PM To: Multiple recipients of list ORACLE-L My favorite part is and all of the table's data will be stored in a relatively contiguous section of disk space. Is this even reasonable to believe, especially with any kind of striping implemented? [EMAIL PROTECTED] 06/20/03 12:00PM Two reasons: a) if you go into extent map blocks then you will suffer an overhead of at least 1 billionth of a percent :-) b) more seriously, its generally easier to pick up a rogue table if its run into thousands of extents and you had not intended it to. Its not a performance problem per se, but its indicative that its a segment thats doing something that was unforseen in the design phase.. hth connor --- [EMAIL PROTECTED] wrote: I just read a .pdf by a couple of people at oracle called Stop Fragmenting and start living where it says not worry about the number of extents in a tablespace. However in the administrators doc it says the following: Estimate Table Size and Set Storage Parameters Estimating the sizes of tables before creating them is useful for the following reasons: You can use the combined estimated size of tables, along with estimates for indexes, rollback segments, and redo log files, to determine the amount of disk space that is required to hold an intended database. From these estimates, you can make correct hardware purchases and other decisions. You can use the estimated size of an individual table to better manage the disk space that the table will use. When a table is created, you can set appropriate storage parameters and improve I/O performance of applications that use the table. For example, assume that you estimate the maximum size of a table before creating it. If you then set the storage parameters when you create the table, fewer extents will be allocated for the table's data segment, and all of the table's data will be stored in a relatively contiguous section of disk space. This decreases the time necessary for disk I/O operations involving this table. this is at the following link: http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76956/tables.htm#208 am I reading this wrong or is Oracle stating that you should have less extents in a table? I know several people on here have posted that the number of extents used by an object is almost irrelevant. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Darrell Landrum INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other
Look's like Larry's at it again...
Oracle Makes Bid to Buy State of Delaware Software giant willing to assume state's $225 million deficit in exchange for legislative control, naming rights Wilmington, DE - Oracle CEO Larry Ellison today announced his intention to purchase the state of Delaware for $300 million in cash and Oracle stock. The move comes on the heels of Oracle's bid for rival software firm PeopleSoft, and is the first time that an offer has been made to buy a U.S. territory. Delaware governor Ruth Ann Minner responded to the bid with shock and seemed certain that the hostile takeover could be avoided. Oracle's bid comes as a big surprise to the government and people of Delaware, said Minner at a press conference. At this point, we are checking into whether or not a company, such as Oracle, can buy a state, and whether or not Delaware is actually for sale. Oracle's announcement sent shockwaves through the political and economic landscape. Oracle shares dropped 8% immediately following the announcement, only to rebound and break even for the day, with heavy volume being traded. Meanwhile, government officials in Washington scrambled to look into the legality of such a purchase, and who actually currently owns Delaware. In an afternoon press conference, Ellison seemed certain that Oracle would own Delaware in the near future. The fact is that the state of Delaware is in a budget crisis that it can not resolve. Oracle's bid will immediately pump $300 million into the state budget, and (Oracle) will also be assuming all current Delaware debt. Call this a 'hostile takeover' if you must, but the people of this great state deserve a better future, and I will be able to give them just that. President Bush, who was giving a speech to coal miners in Kentucky, called the Oracle bid interesting and added that 49 states would be easier for me to handle than 50. Ellison rival Tom Siebel called the move typical, and added Larry thinks he can take over the world, and I guess he thinks this is a good place to start. I personally would have targeted Vermont. Ellison defended his decision, citing fourteen state parks, a minor league baseball franchise, an annual Nascar race in Dover, and the annual Great Delaware Kite Festival as reasons that Delaware is primed for success. Delaware is a state rich in tradition and excitement. None of the existing festivals or events will be changed. I mean, who doesn't love minor league baseball and kites? If the takeover bid is successful, Ellison plans to place several Oracle executives in key state government positions, and is considering re-naming the state either New Ellison or OracleLand. [Couldn't resist, Jared! Hope it's not too OT!] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Development projects: Multiple databases v/s multiple schemas
Title: RE: Development projects: Multiple databases v/s multiple schemas That's why my question ... do schema cross-reference ...? If you have schema that don't need to talk to each other, one DB is still good. If you have enough resources, then give every team on db. But that is costly in terms of administration from DBA angle. Do developers/teams startup/shutdown databases? Not here ... Agreed, testing should be on a separate box or instance at-least. Testing in development instance is like shooting a moving target. Rarely works as advertised. So, it boils down you your resources, if you have, go with multiple DB, or else one DB should be fine. We have one dev/acpt/qa/release_test/dayold database per production instance. Because the codebase is different and there is some customization that really matters. But on our development RAC we have 22 (devl/acpt/qa) instances for various groups on each machine. Production it is only 5 instances per box. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: Naveen Nahata [mailto:[EMAIL PROTECTED]Sent: Friday, June 20, 2003 11:15 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Development projects: Multiple databases v/s multiple schemas Thanx Raj and Bahar, Raj I think you misunderstood my question. Or I might be misunderstanding a part of your reply :-) I'll try to makemyquestionclearer All the developers of a project work on the same DB(developers don't have individual DBs, project teams have).Different projects have individual servers running separate DBs on separate machines. This causes maintenance problems since currently project teams are responsible for their respective servers and they don't have the required expertize to do it. We are planning to centralize the same andhave one high-end machine running different versions of Oracle. My question is, for multiple projects which plan development on the same version of oracle, should I have 1 DB per project or within one DB multiple schemas for different projects? The project teams want separate DBs because they think they can shutdown and startup the DB as per their wish. For them if something gets stuck, the best way is to restart the DB :-). But my point is that starting and shutting down a DB is not required at all, since most of the things can be dynamically changed. The only thing is thatcertain init.ora parameters which cannot be changed dynamically. But since there is not too much of benchmarking done by the project teams the need to change init.ora parameters is not there. If required this can be done in a separate test DB which will be allotted for testing and taken back once load testing/benchmarking is over. The only problemI envisage with having multiple schemas is the name conflict between applications(projects) (2 applications might want to have schema with the same name). I think the "stats" referred by Bahar are system level statistics like CPU utilization, waits etc. which I think are most relevant when doing tuning during load testing / benchmarking which as mentioned above can be done on a separate test DB specifically allotted for the same on a short term basis. Regards Naveen This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
RE: oracle docs do say # of extents effect performance
Does this mean that if I dd the file onto a raw partition, it will be scattered around the raw partition? Even though the dd-ing process is unaware of the characteristics of the raw partition? -Original Message- Even without stripping you can't gaurantee it will be a contiguous section of disk space. The file could be scattered across the file system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: What can cause boost in LIO/PIO?
Only in part. It's an hourly complete rebuild of a mini-warehouse table (don't ask -- not my idea). It does do a few index creates and accompanying analyzes of those indexes and their table at the end of the procedure. I think this accounts for the very high PIO spikes at the end of every DBMS_JOB cycle, but I'm still not sure how it affected the other queries. Thx! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Freeman Robert - IL [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2003 11:06 AM To: Jesse, Rich; 'Multiple recipients of list ORACLE-L ' Subject: RE: What can cause boost in LIO/PIO? What was this 5am job? It wasn't an analyze was it? RF -Original Message- From: Jesse, Rich To: Multiple recipients of list ORACLE-L Sent: 6/20/2003 11:29 AM Subject: What can cause boost in LIO/PIO? Hey all, I'm testing out the max I/O thruput of an IBM FastT900 using a dual 2.4GHz w/1GB RAM on Win2K server (not my choice but it's just for testing) running Oracle 8.1.7. For one of my tests, I created the following heirarchical query: [yadda yadda yadda] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle JMS--Lost all my Emaisl...Pls resend if any reply was post
Hi All, I need some help in setting up ORACLE JMS to post and read messages from queue.I am a newbie in this and I ave gone through the Oracle application developers guide for Advanced queuing document but it is too exhaustive. Does anyone have any examples,web links to get started with Oracle JMS. Appreciate any help. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Basavaraja, Ravindra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: oracle docs do say # of extents effect performance
or reasonable to WANT? if I'm running a data warehouse, maybe. If an OLTP system, orders and customers etc then I'm not likely to WANT the next block of data on disk for my transaction --- Darrell Landrum [EMAIL PROTECTED] wrote: My favorite part is and all of the table's data will be stored in a relatively contiguous section of disk space. Is this even reasonable to believe, especially with any kind of striping implemented? [EMAIL PROTECTED] 06/20/03 12:00PM Two reasons: a) if you go into extent map blocks then you will suffer an overhead of at least 1 billionth of a percent :-) b) more seriously, its generally easier to pick up a rogue table if its run into thousands of extents and you had not intended it to. Its not a performance problem per se, but its indicative that its a segment thats doing something that was unforseen in the design phase.. hth connor --- [EMAIL PROTECTED] wrote: I just read a .pdf by a couple of people at oracle called Stop Fragmenting and start living where it says not worry about the number of extents in a tablespace. However in the administrators doc it says the following: Estimate Table Size and Set Storage Parameters Estimating the sizes of tables before creating them is useful for the following reasons: You can use the combined estimated size of tables, along with estimates for indexes, rollback segments, and redo log files, to determine the amount of disk space that is required to hold an intended database. From these estimates, you can make correct hardware purchases and other decisions. You can use the estimated size of an individual table to better manage the disk space that the table will use. When a table is created, you can set appropriate storage parameters and improve I/O performance of applications that use the table. For example, assume that you estimate the maximum size of a table before creating it. If you then set the storage parameters when you create the table, fewer extents will be allocated for the table's data segment, and all of the table's data will be stored in a relatively contiguous section of disk space. This decreases the time necessary for disk I/O operations involving this table. this is at the following link: http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76956/tables.htm#208 am I reading this wrong or is Oracle stating that you should have less extents in a table? I know several people on here have posted that the number of extents used by an object is almost irrelevant. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Darrell Landrum INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or
RE: What can cause boost in LIO/PIO?
[deft backpedaling] OK, now I think it IS the SAN. The S/A handling the SAN is helping us with our backup scenario so he's reorganizing some drives on the SAN. At about the same time he started the reorg (highly drive-intensive), my aggregate PIO rate dropped from almost 10K/s to less than 2K/s. And the LIOs dropped similarly, while the event waits increased. I'm thinking that the impact of the reorg on the SAN caused the wait events for the PIOs to grow (from 3.5K/s to 4.7K/s). This longer wait in turn caused a decrease in LIOs because the processes are too busy waiting to generate the IO requests. This explains everything except that the lack of contention to cause the IOs to boost in the first place happened at the same time as the first run of the DBMS_JOB at 5:00 AM. Coincidence? How's that sound? Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Jesse, Rich Sent: Friday, June 20, 2003 12:32 PM To: 'Freeman Robert - IL'; 'Multiple recipients of list ORACLE-L ' Subject: RE: What can cause boost in LIO/PIO? Only in part. It's an hourly complete rebuild of a mini-warehouse table (don't ask -- not my idea). It does do a few index creates and accompanying analyzes of those indexes and their table at the end of the procedure. I think this accounts for the very high PIO spikes at the end of every DBMS_JOB cycle, but I'm still not sure how it affected the other queries. Thx! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Freeman Robert - IL [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2003 11:06 AM To: Jesse, Rich; 'Multiple recipients of list ORACLE-L ' Subject: RE: What can cause boost in LIO/PIO? What was this 5am job? It wasn't an analyze was it? RF -Original Message- From: Jesse, Rich To: Multiple recipients of list ORACLE-L Sent: 6/20/2003 11:29 AM Subject: What can cause boost in LIO/PIO? Hey all, I'm testing out the max I/O thruput of an IBM FastT900 using a dual 2.4GHz w/1GB RAM on Win2K server (not my choice but it's just for testing) running Oracle 8.1.7. For one of my tests, I created the following heirarchical query: [yadda yadda yadda] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Look's like Larry's at it again...
Cool. State of Connecticut also has a budget crisis.. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Friday, June 20, 2003 2:20 PM To: Multiple recipients of list ORACLE-L Oracle Makes Bid to Buy State of Delaware Software giant willing to assume state's $225 million deficit in exchange for legislative control, naming rights Wilmington, DE - Oracle CEO Larry Ellison today announced his intention to purchase the state of Delaware for $300 million in cash and Oracle stock. The move comes on the heels of Oracle's bid for rival software firm PeopleSoft, and is the first time that an offer has been made to buy a U.S. territory. Delaware governor Ruth Ann Minner responded to the bid with shock and seemed certain that the hostile takeover could be avoided. Oracle's bid comes as a big surprise to the government and people of Delaware, said Minner at a press conference. At this point, we are checking into whether or not a company, such as Oracle, can buy a state, and whether or not Delaware is actually for sale. Oracle's announcement sent shockwaves through the political and economic landscape. Oracle shares dropped 8% immediately following the announcement, only to rebound and break even for the day, with heavy volume being traded. Meanwhile, government officials in Washington scrambled to look into the legality of such a purchase, and who actually currently owns Delaware. In an afternoon press conference, Ellison seemed certain that Oracle would own Delaware in the near future. The fact is that the state of Delaware is in a budget crisis that it can not resolve. Oracle's bid will immediately pump $300 million into the state budget, and (Oracle) will also be assuming all current Delaware debt. Call this a 'hostile takeover' if you must, but the people of this great state deserve a better future, and I will be able to give them just that. President Bush, who was giving a speech to coal miners in Kentucky, called the Oracle bid interesting and added that 49 states would be easier for me to handle than 50. Ellison rival Tom Siebel called the move typical, and added Larry thinks he can take over the world, and I guess he thinks this is a good place to start. I personally would have targeted Vermont. Ellison defended his decision, citing fourteen state parks, a minor league baseball franchise, an annual Nascar race in Dover, and the annual Great Delaware Kite Festival as reasons that Delaware is primed for success. Delaware is a state rich in tradition and excitement. None of the existing festivals or events will be changed. I mean, who doesn't love minor league baseball and kites? If the takeover bid is successful, Ellison plans to place several Oracle executives in key state government positions, and is considering re-naming the state either New Ellison or OracleLand. [Couldn't resist, Jared! Hope it's not too OT!] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: What can cause boost in LIO/PIO?
makes sence to me... I've seen an analyze, if it takes a long time to run, cause odd things to happen to SQL that starts running in the middle of the analyze process. The SAN rebuild certainly sounds like a likley suspect. RF -Original Message- To: Jesse, Rich; Freeman Robert - IL; 'Multiple recipients of list ORACLE-L ' Sent: 6/20/2003 12:52 PM [deft backpedaling] OK, now I think it IS the SAN. The S/A handling the SAN is helping us with our backup scenario so he's reorganizing some drives on the SAN. At about the same time he started the reorg (highly drive-intensive), my aggregate PIO rate dropped from almost 10K/s to less than 2K/s. And the LIOs dropped similarly, while the event waits increased. I'm thinking that the impact of the reorg on the SAN caused the wait events for the PIOs to grow (from 3.5K/s to 4.7K/s). This longer wait in turn caused a decrease in LIOs because the processes are too busy waiting to generate the IO requests. This explains everything except that the lack of contention to cause the IOs to boost in the first place happened at the same time as the first run of the DBMS_JOB at 5:00 AM. Coincidence? How's that sound? Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Jesse, Rich Sent: Friday, June 20, 2003 12:32 PM To: 'Freeman Robert - IL'; 'Multiple recipients of list ORACLE-L ' Subject: RE: What can cause boost in LIO/PIO? Only in part. It's an hourly complete rebuild of a mini-warehouse table (don't ask -- not my idea). It does do a few index creates and accompanying analyzes of those indexes and their table at the end of the procedure. I think this accounts for the very high PIO spikes at the end of every DBMS_JOB cycle, but I'm still not sure how it affected the other queries. Thx! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Freeman Robert - IL [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2003 11:06 AM To: Jesse, Rich; 'Multiple recipients of list ORACLE-L ' Subject: RE: What can cause boost in LIO/PIO? What was this 5am job? It wasn't an analyze was it? RF -Original Message- From: Jesse, Rich To: Multiple recipients of list ORACLE-L Sent: 6/20/2003 11:29 AM Subject: What can cause boost in LIO/PIO? Hey all, I'm testing out the max I/O thruput of an IBM FastT900 using a dual 2.4GHz w/1GB RAM on Win2K server (not my choice but it's just for testing) running Oracle 8.1.7. For one of my tests, I created the following heirarchical query: [yadda yadda yadda] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE: oracle docs do say # of extents effect performance
i understand, but alot of people have posted here that its ok to have smaller extents anyway. who is correct? or am i missing something? From: Richard Ji [EMAIL PROTECTED] Date: 2003/06/20 Fri PM 02:00:11 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: oracle docs do say # of extents effect performance Even without stripping you can't gaurantee it will be a contiguous section of disk space. The file could be scattered across the file system. Richard Ji -Original Message- Sent: Friday, June 20, 2003 1:12 PM To: Multiple recipients of list ORACLE-L My favorite part is and all of the table's data will be stored in a relatively contiguous section of disk space. Is this even reasonable to believe, especially with any kind of striping implemented? [EMAIL PROTECTED] 06/20/03 12:00PM Two reasons: a) if you go into extent map blocks then you will suffer an overhead of at least 1 billionth of a percent :-) b) more seriously, its generally easier to pick up a rogue table if its run into thousands of extents and you had not intended it to. Its not a performance problem per se, but its indicative that its a segment thats doing something that was unforseen in the design phase.. hth connor --- [EMAIL PROTECTED] wrote: I just read a .pdf by a couple of people at oracle called Stop Fragmenting and start living where it says not worry about the number of extents in a tablespace. However in the administrators doc it says the following: Estimate Table Size and Set Storage Parameters Estimating the sizes of tables before creating them is useful for the following reasons: You can use the combined estimated size of tables, along with estimates for indexes, rollback segments, and redo log files, to determine the amount of disk space that is required to hold an intended database. From these estimates, you can make correct hardware purchases and other decisions. You can use the estimated size of an individual table to better manage the disk space that the table will use. When a table is created, you can set appropriate storage parameters and improve I/O performance of applications that use the table. For example, assume that you estimate the maximum size of a table before creating it. If you then set the storage parameters when you create the table, fewer extents will be allocated for the table's data segment, and all of the table's data will be stored in a relatively contiguous section of disk space. This decreases the time necessary for disk I/O operations involving this table. this is at the following link: http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76956/tables.htm#208 am I reading this wrong or is Oracle stating that you should have less extents in a table? I know several people on here have posted that the number of extents used by an object is almost irrelevant. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Darrell Landrum INET: [EMAIL PROTECTED] Fat City Network Services
RE: Development projects: Multiple databases v/s multiple schemas
Naveen Advantages of single instance - Easier to administer. I have multiple test instances and often have to go around getting permission to bounce instances to re-jigger the memory when one project needs more memory for some test. - Easier to share data among projects. Advantages of multiple instances - Can bring instances up/down independently - Can tune instance independently - If a project requires a different Oracle version because of another constraint, like a front-end tool, different projects can have different Oracle versions. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, June 20, 2003 7:19 AM To: Multiple recipients of list ORACLE-L Hi, For multiple projects we are planning to have a centralized server(as opposed to multiple servers, to improve managability) which all the development teams will use for their backend work. Now there are 2 ways in which to provide them access. 1. Have only 1 database for each version of Oracle Server installed and create schemas for individual teams for their development work. 2. Create a separate DB for each project team. I want to know the pros and cons for both the approaches. Any ideas and suggestions are most welcome. Regards Naveen DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Partition
Ishwar - What Oracle version. Just off the top of my head, I think that 8i only allows the subpartition to be hashed. What is your goal? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, June 20, 2003 12:00 PM To: Multiple recipients of list ORACLE-L Hey, Can anyone say if there is a way to breakup an existing partition into subpartitons. The partition contains data. Thx Ishwar. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ishwar Tewari INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: got EXP-00091 warning
Jin I cured this one with STATISTICS=NONE. Inelegant, but effective nonetheless. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, June 20, 2003 10:21 AM To: Multiple recipients of list ORACLE-L Greetings, When I export schema containing some tables, I got EXP-00091 warnings. The log is saying: .. JServer Release 9.2.0.1.0 - Production Export done in US7ASCII character set and AL16UTF16 NCHAR character set server uses WE8ISO8859P1 character set (possible charset conversion) . exporting pre-schema procedural objects and actions . exporting foreign function library names for user XXX . exporting PUBLIC type synonyms . exporting private type synonyms . exporting object type definitions for user XXX About to export XXX's objects ... . exporting database links . exporting sequence numbers . exporting cluster definitions . about to export XXX's tables via Conventional Path ... . . exporting table CHEMISTRY 0 rows exported EXP-00091: Exporting questionable statistics. . . exporting tableCHEMISTRY_ALIAS 0 rows exported EXP-00091: Exporting questionable statistics. . . exporting table DESTINATION_PLATE_WELL 0 rows exported EXP-00091: Exporting questionable statistics. ... I check oracle document and it says: EXP-00091 Exporting questionable statistics Cause: Export was able to export statistics, but the statistics may not be useable. The statistics are questionable because one or more of the following happened during export: a row error occurred, client character set or NCHARSET does not match with the server, a query clause was specified on export, only certain partitions or subpartitions were exported, or a fatal error occurred while processing a table. Action: To export non-questionable statistics, change the client character set or NCHARSET to match the server, export with no query clause, or export complete tables. If desired, import parameters can be supplied so that only non-questionable statistics will be imported, and all questionable statistics will be recalculated. So I think the problem is chararter set not matching. So how can I change client character set? Thanks, Jin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Look's like Larry's at it again...
Title: RE: Look's like Larry's at it again... Yeah ... but they have money to sue everyone in sight. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Gogala, Mladen [mailto:[EMAIL PROTECTED]] Sent: Friday, June 20, 2003 3:00 PM To: Multiple recipients of list ORACLE-L Subject: RE: Look's like Larry's at it again... Cool. State of Connecticut also has a budget crisis.. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
Re: Re: oracle docs do say # of extents effect performance
ok, so should the number of extents in a table be considered in table design? there are alot of .pdfs and people on this listserv that say it is irrelevant? From: Rachel Carmichael [EMAIL PROTECTED] Date: 2003/06/20 Fri PM 02:44:52 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: oracle docs do say # of extents effect performance or reasonable to WANT? if I'm running a data warehouse, maybe. If an OLTP system, orders and customers etc then I'm not likely to WANT the next block of data on disk for my transaction --- Darrell Landrum [EMAIL PROTECTED] wrote: My favorite part is and all of the table's data will be stored in a relatively contiguous section of disk space. Is this even reasonable to believe, especially with any kind of striping implemented? [EMAIL PROTECTED] 06/20/03 12:00PM Two reasons: a) if you go into extent map blocks then you will suffer an overhead of at least 1 billionth of a percent :-) b) more seriously, its generally easier to pick up a rogue table if its run into thousands of extents and you had not intended it to. Its not a performance problem per se, but its indicative that its a segment thats doing something that was unforseen in the design phase.. hth connor --- [EMAIL PROTECTED] wrote: I just read a .pdf by a couple of people at oracle called Stop Fragmenting and start living where it says not worry about the number of extents in a tablespace. However in the administrators doc it says the following: Estimate Table Size and Set Storage Parameters Estimating the sizes of tables before creating them is useful for the following reasons: You can use the combined estimated size of tables, along with estimates for indexes, rollback segments, and redo log files, to determine the amount of disk space that is required to hold an intended database. From these estimates, you can make correct hardware purchases and other decisions. You can use the estimated size of an individual table to better manage the disk space that the table will use. When a table is created, you can set appropriate storage parameters and improve I/O performance of applications that use the table. For example, assume that you estimate the maximum size of a table before creating it. If you then set the storage parameters when you create the table, fewer extents will be allocated for the table's data segment, and all of the table's data will be stored in a relatively contiguous section of disk space. This decreases the time necessary for disk I/O operations involving this table. this is at the following link: http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76956/tables.htm#208 am I reading this wrong or is Oracle stating that you should have less extents in a table? I know several people on here have posted that the number of extents used by an object is almost irrelevant. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L
RE: how to handle client installs w/o admin privs
Joe If your administration group controls the machines to this extent, I would hand the administrators a CD with Oracle client on it and say go for it, your baby now. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, June 20, 2003 11:20 AM To: Multiple recipients of list ORACLE-L We have users who need to install the oracle 9i client on their PCs but who aren't administrators on their machines. How do people handle this situation? Thanks. Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Armstrong-Champ INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: oracle authentication from windows
- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 20, 2003 9:44 AM This is an interesting one. I am currently going through (tortured) another system audit. One of the many questions the auditors (I am being attacked from all sides) had about the Oracle configuration was Can remote authenticated network users connect to the database?. If auditors know this is a weakness, maybe it would be a good idea to avoid its use. btw I do use O/S authenticated userids but remote authentication has been disabled (deliberately). We are running Oracle on Unix so our batch jobs use O/S authenticated ids. From: Gogala, Mladen [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: oracle authentication from windows Date: Thu, 19 Jun 2003 12:19:59 -0800 That, of course, will render your database totally insecure and open to anybody who can bring in a WinXP laptop, change the windoze username and log in as he pleases. DBA that sets his production parameters the way Arup described deserves to be publicly tortured by Bill O'Reilly in the no spin zone. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Thursday, June 19, 2003 3:46 PM To: Multiple recipients of list ORACLE-L Sure. Just declare these in your init.ora os_authent_prefix=OPS$ remote_os_authent=TRUE bounce the database, add a user called OPS$the Windows username, e.g. OPS$AK if your Windows login id is AK as create user ops$ak identified externally From windows connect as /@servicename, e.g. sqlplus /@service1 If it doesn't work, the OS user may be different. Use this query while connected to the database from Windows cleint. SQL select sys_context('USERENV','OS_USER') from dual; See what OS username comes up; use that instead. HTH. Arup Nanda www.proligence.com - Original Message - To: Multiple mailto:[EMAIL PROTECTED] recipients of list ORACLE-L Sent: Thursday, June 19, 2003 1:10 PM We want our client users ( forms user ) to just enter windows password and then automatically able to get in to oracle .Is there a way oracle can authenticate from windows ( or active directory ) . enbadding password in runform.exe not an option . thanks, -ak _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: oracle authentication from windows
Pete, Apprciate your comments. You are right in stating that if the OPS$ accounts have special privs they might be abused. But how it is any different than any other user id with special privileges whose password is not guarded well? The security hole does not come from the fact that remote_os_authent is true, but due to lax security management. Removing OPS$ accounts will not help increase the security any more than simply evaluating who has what privileges. Instead of fighting the introduction of ops$ accounts, what I suggested was to have a safe practice of setting a prefix. Of course, the privileges of such accounts should be carefully monitored and accesses should be provided to the bare minimum; dba accounts are certainly a big no. In your example you specified, this is rather ridiculous to have a form for a dba user. Why not use OEM, for free? In my book I have addressed some of these issues and common misconceptions and tried to separate myths from facts. Thanks. Arup - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 20, 2003 6:19 AM Hi Arup, Remote OS authentication whether with OPS$ or not is still a risk. You are intimating that SYSTEM is the only risky account involved here. What if any of the newly created OPS$ accounts have useful privileges. I have seen a similar application to the one described recently. There were forms within the application for administration and user management (in oracle, not the application) and the users who had access to these were assigned the DBA role and were of course external accounts. I think what you should add to your comment is that the issue is overrated is that any OPS$ / external accounts should not have any dangerous privileges granted and certainly not DBA. If you can guess the name of an admin account even if its OPS$ then the issue is still severe. cheers Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Look's like Larry's at it again...
Excellent, but I really thought he meant to call it Larry Land! :) Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long term Oracle DBA. -Original Message- Jesse, Rich Sent: Friday, June 20, 2003 11:20 AM To: Multiple recipients of list ORACLE-L Oracle Makes Bid to Buy State of Delaware Software giant willing to assume state's $225 million deficit in exchange for legislative control, naming rights Wilmington, DE - Oracle CEO Larry Ellison today announced his intention to purchase the state of Delaware for $300 million in cash and Oracle stock. The move comes on the heels of Oracle's bid for rival software firm PeopleSoft, and is the first time that an offer has been made to buy a U.S. territory. Delaware governor Ruth Ann Minner responded to the bid with shock and seemed certain that the hostile takeover could be avoided. Oracle's bid comes as a big surprise to the government and people of Delaware, said Minner at a press conference. At this point, we are checking into whether or not a company, such as Oracle, can buy a state, and whether or not Delaware is actually for sale. Oracle's announcement sent shockwaves through the political and economic landscape. Oracle shares dropped 8% immediately following the announcement, only to rebound and break even for the day, with heavy volume being traded. Meanwhile, government officials in Washington scrambled to look into the legality of such a purchase, and who actually currently owns Delaware. In an afternoon press conference, Ellison seemed certain that Oracle would own Delaware in the near future. The fact is that the state of Delaware is in a budget crisis that it can not resolve. Oracle's bid will immediately pump $300 million into the state budget, and (Oracle) will also be assuming all current Delaware debt. Call this a 'hostile takeover' if you must, but the people of this great state deserve a better future, and I will be able to give them just that. President Bush, who was giving a speech to coal miners in Kentucky, called the Oracle bid interesting and added that 49 states would be easier for me to handle than 50. Ellison rival Tom Siebel called the move typical, and added Larry thinks he can take over the world, and I guess he thinks this is a good place to start. I personally would have targeted Vermont. Ellison defended his decision, citing fourteen state parks, a minor league baseball franchise, an annual Nascar race in Dover, and the annual Great Delaware Kite Festival as reasons that Delaware is primed for success. Delaware is a state rich in tradition and excitement. None of the existing festivals or events will be changed. I mean, who doesn't love minor league baseball and kites? If the takeover bid is successful, Ellison plans to place several Oracle executives in key state government positions, and is considering re-naming the state either New Ellison or OracleLand. [Couldn't resist, Jared! Hope it's not too OT!] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: What can cause boost in LIO/PIO?
I just got a call from the S/A that the copy completed. After looking back at Spotlight I asked At 1:00, right?. Sure enough. So at least that part's solved. As to why/how it started the same time as the DBMS_JOB? I'm willing to let that be a mystery pondered on over beers for years and years. Thx! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Freeman Robert - IL [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2003 12:58 PM To: Jesse, Rich; ''Multiple recipients of list ORACLE-L ' ' Subject: RE: What can cause boost in LIO/PIO? makes sence to me... I've seen an analyze, if it takes a long time to run, cause odd things to happen to SQL that starts running in the middle of the analyze process. The SAN rebuild certainly sounds like a likley suspect. RF -Original Message- From: Jesse, Rich To: Jesse, Rich; Freeman Robert - IL; 'Multiple recipients of list ORACLE-L ' Sent: 6/20/2003 12:52 PM Subject: RE: What can cause boost in LIO/PIO? [deft backpedaling] OK, now I think it IS the SAN. The S/A handling the SAN is helping us with our backup scenario so he's reorganizing some drives on the SAN. At about the same time he started the reorg (highly drive-intensive), my aggregate PIO rate dropped from almost 10K/s to less than 2K/s. And the LIOs dropped similarly, while the event waits increased. I'm thinking that the impact of the reorg on the SAN caused the wait events for the PIOs to grow (from 3.5K/s to 4.7K/s). This longer wait in turn caused a decrease in LIOs because the processes are too busy waiting to generate the IO requests. This explains everything except that the lack of contention to cause the IOs to boost in the first place happened at the same time as the first run of the DBMS_JOB at 5:00 AM. Coincidence? How's that sound? Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Jesse, Rich Sent: Friday, June 20, 2003 12:32 PM To: 'Freeman Robert - IL'; 'Multiple recipients of list ORACLE-L ' Subject: RE: What can cause boost in LIO/PIO? Only in part. It's an hourly complete rebuild of a mini-warehouse table (don't ask -- not my idea). It does do a few index creates and accompanying analyzes of those indexes and their table at the end of the procedure. I think this accounts for the very high PIO spikes at the end of every DBMS_JOB cycle, but I'm still not sure how it affected the other queries. Thx! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Freeman Robert - IL [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2003 11:06 AM To: Jesse, Rich; 'Multiple recipients of list ORACLE-L ' Subject: RE: What can cause boost in LIO/PIO? What was this 5am job? It wasn't an analyze was it? RF -Original Message- From: Jesse, Rich To: Multiple recipients of list ORACLE-L Sent: 6/20/2003 11:29 AM Subject: What can cause boost in LIO/PIO? Hey all, I'm testing out the max I/O thruput of an IBM FastT900 using a dual 2.4GHz w/1GB RAM on Win2K server (not my choice but it's just for testing) running Oracle 8.1.7. For one of my tests, I created the following heirarchical query: [yadda yadda yadda] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Look's like Larry's at it again...
Any plans for the crisis countries Larry :) -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 20, 2003 12:00 PM Cool. State of Connecticut also has a budget crisis.. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Friday, June 20, 2003 2:20 PM To: Multiple recipients of list ORACLE-L Oracle Makes Bid to Buy State of Delaware Software giant willing to assume state's $225 million deficit in exchange for legislative control, naming rights Wilmington, DE - Oracle CEO Larry Ellison today announced his intention to purchase the state of Delaware for $300 million in cash and Oracle stock. The move comes on the heels of Oracle's bid for rival software firm PeopleSoft, and is the first time that an offer has been made to buy a U.S. territory. Delaware governor Ruth Ann Minner responded to the bid with shock and seemed certain that the hostile takeover could be avoided. Oracle's bid comes as a big surprise to the government and people of Delaware, said Minner at a press conference. At this point, we are checking into whether or not a company, such as Oracle, can buy a state, and whether or not Delaware is actually for sale. Oracle's announcement sent shockwaves through the political and economic landscape. Oracle shares dropped 8% immediately following the announcement, only to rebound and break even for the day, with heavy volume being traded. Meanwhile, government officials in Washington scrambled to look into the legality of such a purchase, and who actually currently owns Delaware. In an afternoon press conference, Ellison seemed certain that Oracle would own Delaware in the near future. The fact is that the state of Delaware is in a budget crisis that it can not resolve. Oracle's bid will immediately pump $300 million into the state budget, and (Oracle) will also be assuming all current Delaware debt. Call this a 'hostile takeover' if you must, but the people of this great state deserve a better future, and I will be able to give them just that. President Bush, who was giving a speech to coal miners in Kentucky, called the Oracle bid interesting and added that 49 states would be easier for me to handle than 50. Ellison rival Tom Siebel called the move typical, and added Larry thinks he can take over the world, and I guess he thinks this is a good place to start. I personally would have targeted Vermont. Ellison defended his decision, citing fourteen state parks, a minor league baseball franchise, an annual Nascar race in Dover, and the annual Great Delaware Kite Festival as reasons that Delaware is primed for success. Delaware is a state rich in tradition and excitement. None of the existing festivals or events will be changed. I mean, who doesn't love minor league baseball and kites? If the takeover bid is successful, Ellison plans to place several Oracle executives in key state government positions, and is considering re-naming the state either New Ellison or OracleLand. [Couldn't resist, Jared! Hope it's not too OT!] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: AK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing:
RE: how to handle client installs w/o admin privs
that's how we do it here. there is a Lan Administration group responsible for installing software on all PC's. thank goodness they stay out of the DBA area. we do our own installs. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, June 20, 2003 3:16 PM To: Multiple recipients of list ORACLE-L Joe If your administration group controls the machines to this extent, I would hand the administrators a CD with Oracle client on it and say go for it, your baby now. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, June 20, 2003 11:20 AM To: Multiple recipients of list ORACLE-L We have users who need to install the oracle 9i client on their PCs but who aren't administrators on their machines. How do people handle this situation? Thanks. Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Armstrong-Champ INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
(OT) RE: Look's like Larry's at it again...
I hate to be a spoilsport, but some people unfamiliar with the USA might be taking this seriously. This is, of course, a humorous piece, in the same vein as the joke about Microsoft purchasing the Catholic Church http://www.spunk.org/library/humour/sp001526.html -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED] Oracle Makes Bid to Buy State of Delaware Software giant willing to assume state's $225 million deficit in exchange for legislative control, naming rights Wilmington, DE - Oracle CEO Larry Ellison today announced his intention to purchase the state of Delaware for $300 million in cash and Oracle stock. The move comes on the heels of Oracle's bid for rival software firm PeopleSoft, and is the first time that an offer has been made to buy a U.S. territory. Delaware governor Ruth Ann Minner responded to the bid with shock and seemed certain that the hostile takeover could be avoided. Oracle's bid comes as a big surprise to the government and people of Delaware, said Minner at a press conference. At this point, we are checking into whether or not a company, such as Oracle, can buy a state, and whether or not Delaware is actually for sale. Oracle's announcement sent shockwaves through the political and economic landscape. Oracle shares dropped 8% immediately following the announcement, only to rebound and break even for the day, with heavy volume being traded. Meanwhile, government officials in Washington scrambled to look into the legality of such a purchase, and who actually currently owns Delaware. In an afternoon press conference, Ellison seemed certain that Oracle would own Delaware in the near future. The fact is that the state of Delaware is in a budget crisis that it can not resolve. Oracle's bid will immediately pump $300 million into the state budget, and (Oracle) will also be assuming all current Delaware debt. Call this a 'hostile takeover' if you must, but the people of this great state deserve a better future, and I will be able to give them just that. President Bush, who was giving a speech to coal miners in Kentucky, called the Oracle bid interesting and added that 49 states would be easier for me to handle than 50. Ellison rival Tom Siebel called the move typical, and added Larry thinks he can take over the world, and I guess he thinks this is a good place to start. I personally would have targeted Vermont. Ellison defended his decision, citing fourteen state parks, a minor league baseball franchise, an annual Nascar race in Dover, and the annual Great Delaware Kite Festival as reasons that Delaware is primed for success. Delaware is a state rich in tradition and excitement. None of the existing festivals or events will be changed. I mean, who doesn't love minor league baseball and kites? If the takeover bid is successful, Ellison plans to place several Oracle executives in key state government positions, and is considering re-naming the state either New Ellison or OracleLand. [Couldn't resist, Jared! Hope it's not too OT!] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: oracle authentication from windows
David, I do feel your pain. Sometimes the auditors just go overboard looking over some set checklist and some items in their checklist just plain contradict each other. Take example I just went through recently. I am making the databases of a few healthcare companies HIPAA compliant. A recent audit made this point: The software owner account should be locked and be opened after a written memo to the sys admin. The fact that oracle account is not locked is a huge security hole. All right, that meant my oracle account is now locked. Jeez! Well, how do I start and stop the database? Auditor: the starting and stopping of the database has to be done from Oracle Enterprise Manager console, connected as SYSDBA. And, that is supposed to be more secure??! The point is, don't just assume that the auditors know the best. Some of the points could be good independently, for instance, in the above case, they are. But taken together they may not be practical. Of course, pick you battles. If they want to get rid of OPS$ accounts, let the developers fight over it; they will be most affected - passing user ids and passwords, etc. But in their zeal to seal the deal, make sure they are not hardcoding passwords in the applications, a common problem. HTH. Arup Nanda www.proligence.com - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 20, 2003 9:44 AM This is an interesting one. I am currently going through (tortured) another system audit. One of the many questions the auditors (I am being attacked from all sides) had about the Oracle configuration was Can remote authenticated network users connect to the database?. If auditors know this is a weakness, maybe it would be a good idea to avoid its use. btw I do use O/S authenticated userids but remote authentication has been disabled (deliberately). We are running Oracle on Unix so our batch jobs use O/S authenticated ids. From: Gogala, Mladen [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: oracle authentication from windows Date: Thu, 19 Jun 2003 12:19:59 -0800 That, of course, will render your database totally insecure and open to anybody who can bring in a WinXP laptop, change the windoze username and log in as he pleases. DBA that sets his production parameters the way Arup described deserves to be publicly tortured by Bill O'Reilly in the no spin zone. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Thursday, June 19, 2003 3:46 PM To: Multiple recipients of list ORACLE-L Sure. Just declare these in your init.ora os_authent_prefix=OPS$ remote_os_authent=TRUE bounce the database, add a user called OPS$the Windows username, e.g. OPS$AK if your Windows login id is AK as create user ops$ak identified externally From windows connect as /@servicename, e.g. sqlplus /@service1 If it doesn't work, the OS user may be different. Use this query while connected to the database from Windows cleint. SQL select sys_context('USERENV','OS_USER') from dual; See what OS username comes up; use that instead. HTH. Arup Nanda www.proligence.com - Original Message - To: Multiple mailto:[EMAIL PROTECTED] recipients of list ORACLE-L Sent: Thursday, June 19, 2003 1:10 PM We want our client users ( forms user ) to just enter windows password and then automatically able to get in to oracle .Is there a way oracle can authenticate from windows ( or active directory ) . enbadding password in runform.exe not an option . thanks, -ak _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY,
RE: (OT) RE: Look's like Larry's at it again...
Bummer! I've already started to hope that I'll soon be living in Connecticut ver 10i. Even Red Sox defeats would hurt less in the Oracleland. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Friday, June 20, 2003 3:30 PM To: Multiple recipients of list ORACLE-L I hate to be a spoilsport, but some people unfamiliar with the USA might be taking this seriously. This is, of course, a humorous piece, in the same vein as the joke about Microsoft purchasing the Catholic Church http://www.spunk.org/library/humour/sp001526.html -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED] Oracle Makes Bid to Buy State of Delaware Software giant willing to assume state's $225 million deficit in exchange for legislative control, naming rights Wilmington, DE - Oracle CEO Larry Ellison today announced his intention to purchase the state of Delaware for $300 million in cash and Oracle stock. The move comes on the heels of Oracle's bid for rival software firm PeopleSoft, and is the first time that an offer has been made to buy a U.S. territory. Delaware governor Ruth Ann Minner responded to the bid with shock and seemed certain that the hostile takeover could be avoided. Oracle's bid comes as a big surprise to the government and people of Delaware, said Minner at a press conference. At this point, we are checking into whether or not a company, such as Oracle, can buy a state, and whether or not Delaware is actually for sale. Oracle's announcement sent shockwaves through the political and economic landscape. Oracle shares dropped 8% immediately following the announcement, only to rebound and break even for the day, with heavy volume being traded. Meanwhile, government officials in Washington scrambled to look into the legality of such a purchase, and who actually currently owns Delaware. In an afternoon press conference, Ellison seemed certain that Oracle would own Delaware in the near future. The fact is that the state of Delaware is in a budget crisis that it can not resolve. Oracle's bid will immediately pump $300 million into the state budget, and (Oracle) will also be assuming all current Delaware debt. Call this a 'hostile takeover' if you must, but the people of this great state deserve a better future, and I will be able to give them just that. President Bush, who was giving a speech to coal miners in Kentucky, called the Oracle bid interesting and added that 49 states would be easier for me to handle than 50. Ellison rival Tom Siebel called the move typical, and added Larry thinks he can take over the world, and I guess he thinks this is a good place to start. I personally would have targeted Vermont. Ellison defended his decision, citing fourteen state parks, a minor league baseball franchise, an annual Nascar race in Dover, and the annual Great Delaware Kite Festival as reasons that Delaware is primed for success. Delaware is a state rich in tradition and excitement. None of the existing festivals or events will be changed. I mean, who doesn't love minor league baseball and kites? If the takeover bid is successful, Ellison plans to place several Oracle executives in key state government positions, and is considering re-naming the state either New Ellison or OracleLand. [Couldn't resist, Jared! Hope it's not too OT!] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: (OT) RE: Look's like Larry's at it again...
Jacques, Well I like both of them. Nothing like a good chuckle to brighten up a day. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, June 20, 2003 3:30 PM To: Multiple recipients of list ORACLE-L I hate to be a spoilsport, but some people unfamiliar with the USA might be taking this seriously. This is, of course, a humorous piece, in the same vein as the joke about Microsoft purchasing the Catholic Church http://www.spunk.org/library/humour/sp001526.html -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED] Oracle Makes Bid to Buy State of Delaware Software giant willing to assume state's $225 million deficit in exchange for legislative control, naming rights Wilmington, DE - Oracle CEO Larry Ellison today announced his intention to purchase the state of Delaware for $300 million in cash and Oracle stock. The move comes on the heels of Oracle's bid for rival software firm PeopleSoft, and is the first time that an offer has been made to buy a U.S. territory. Delaware governor Ruth Ann Minner responded to the bid with shock and seemed certain that the hostile takeover could be avoided. Oracle's bid comes as a big surprise to the government and people of Delaware, said Minner at a press conference. At this point, we are checking into whether or not a company, such as Oracle, can buy a state, and whether or not Delaware is actually for sale. Oracle's announcement sent shockwaves through the political and economic landscape. Oracle shares dropped 8% immediately following the announcement, only to rebound and break even for the day, with heavy volume being traded. Meanwhile, government officials in Washington scrambled to look into the legality of such a purchase, and who actually currently owns Delaware. In an afternoon press conference, Ellison seemed certain that Oracle would own Delaware in the near future. The fact is that the state of Delaware is in a budget crisis that it can not resolve. Oracle's bid will immediately pump $300 million into the state budget, and (Oracle) will also be assuming all current Delaware debt. Call this a 'hostile takeover' if you must, but the people of this great state deserve a better future, and I will be able to give them just that. President Bush, who was giving a speech to coal miners in Kentucky, called the Oracle bid interesting and added that 49 states would be easier for me to handle than 50. Ellison rival Tom Siebel called the move typical, and added Larry thinks he can take over the world, and I guess he thinks this is a good place to start. I personally would have targeted Vermont. Ellison defended his decision, citing fourteen state parks, a minor league baseball franchise, an annual Nascar race in Dover, and the annual Great Delaware Kite Festival as reasons that Delaware is primed for success. Delaware is a state rich in tradition and excitement. None of the existing festivals or events will be changed. I mean, who doesn't love minor league baseball and kites? If the takeover bid is successful, Ellison plans to place several Oracle executives in key state government positions, and is considering re-naming the state either New Ellison or OracleLand. [Couldn't resist, Jared! Hope it's not too OT!] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re: oracle docs do say # of extents effect performance
I think with LMT's now, it is irrelevant. I still think you need to know approx. how big the table is going to be, and place it in the correct LMT. By this I mean that you may have different LMT's with different uniform extent sizes. A very large table should be placed in the largest LMT tablespace. at least that's what I would do. the rest of the discussion is now moot - it just doesn't matter anymore. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, June 20, 2003 3:21 PM To: Multiple recipients of list ORACLE-L ok, so should the number of extents in a table be considered in table design? there are alot of .pdfs and people on this listserv that say it is irrelevant? From: Rachel Carmichael [EMAIL PROTECTED] Date: 2003/06/20 Fri PM 02:44:52 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: oracle docs do say # of extents effect performance or reasonable to WANT? if I'm running a data warehouse, maybe. If an OLTP system, orders and customers etc then I'm not likely to WANT the next block of data on disk for my transaction --- Darrell Landrum [EMAIL PROTECTED] wrote: My favorite part is and all of the table's data will be stored in a relatively contiguous section of disk space. Is this even reasonable to believe, especially with any kind of striping implemented? [EMAIL PROTECTED] 06/20/03 12:00PM Two reasons: a) if you go into extent map blocks then you will suffer an overhead of at least 1 billionth of a percent :-) b) more seriously, its generally easier to pick up a rogue table if its run into thousands of extents and you had not intended it to. Its not a performance problem per se, but its indicative that its a segment thats doing something that was unforseen in the design phase.. hth connor --- [EMAIL PROTECTED] wrote: I just read a .pdf by a couple of people at oracle called Stop Fragmenting and start living where it says not worry about the number of extents in a tablespace. However in the administrators doc it says the following: Estimate Table Size and Set Storage Parameters Estimating the sizes of tables before creating them is useful for the following reasons: You can use the combined estimated size of tables, along with estimates for indexes, rollback segments, and redo log files, to determine the amount of disk space that is required to hold an intended database. From these estimates, you can make correct hardware purchases and other decisions. You can use the estimated size of an individual table to better manage the disk space that the table will use. When a table is created, you can set appropriate storage parameters and improve I/O performance of applications that use the table. For example, assume that you estimate the maximum size of a table before creating it. If you then set the storage parameters when you create the table, fewer extents will be allocated for the table's data segment, and all of the table's data will be stored in a relatively contiguous section of disk space. This decreases the time necessary for disk I/O operations involving this table. this is at the following link: http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76956/tabl es.htm#208 am I reading this wrong or is Oracle stating that you should have less extents in a table? I know several people on here have posted that the number of extents used by an object is almost irrelevant. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services
RE: Look's like Larry's at it again...
I heard that Gates has a deal in the works with McDonalds to sell MS products there. He will rename his product suite to McWindows in honor of the agreement. Also heard that McWindows would now come with a free hard drive called the McDrive with two all silicone disk platters, special fire wire adapters, heads, power supply, scsi adapter, scsi cable, all in a nice titanium case. In a news conference Gates indicated that he hoped Microsoft would ..serve billions and billions -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/20/2003 2:25 PM Any plans for the crisis countries Larry :) -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 20, 2003 12:00 PM Cool. State of Connecticut also has a budget crisis.. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Friday, June 20, 2003 2:20 PM To: Multiple recipients of list ORACLE-L Oracle Makes Bid to Buy State of Delaware Software giant willing to assume state's $225 million deficit in exchange for legislative control, naming rights Wilmington, DE - Oracle CEO Larry Ellison today announced his intention to purchase the state of Delaware for $300 million in cash and Oracle stock. The move comes on the heels of Oracle's bid for rival software firm PeopleSoft, and is the first time that an offer has been made to buy a U.S. territory. Delaware governor Ruth Ann Minner responded to the bid with shock and seemed certain that the hostile takeover could be avoided. Oracle's bid comes as a big surprise to the government and people of Delaware, said Minner at a press conference. At this point, we are checking into whether or not a company, such as Oracle, can buy a state, and whether or not Delaware is actually for sale. Oracle's announcement sent shockwaves through the political and economic landscape. Oracle shares dropped 8% immediately following the announcement, only to rebound and break even for the day, with heavy volume being traded. Meanwhile, government officials in Washington scrambled to look into the legality of such a purchase, and who actually currently owns Delaware. In an afternoon press conference, Ellison seemed certain that Oracle would own Delaware in the near future. The fact is that the state of Delaware is in a budget crisis that it can not resolve. Oracle's bid will immediately pump $300 million into the state budget, and (Oracle) will also be assuming all current Delaware debt. Call this a 'hostile takeover' if you must, but the people of this great state deserve a better future, and I will be able to give them just that. President Bush, who was giving a speech to coal miners in Kentucky, called the Oracle bid interesting and added that 49 states would be easier for me to handle than 50. Ellison rival Tom Siebel called the move typical, and added Larry thinks he can take over the world, and I guess he thinks this is a good place to start. I personally would have targeted Vermont. Ellison defended his decision, citing fourteen state parks, a minor league baseball franchise, an annual Nascar race in Dover, and the annual Great Delaware Kite Festival as reasons that Delaware is primed for success. Delaware is a state rich in tradition and excitement. None of the existing festivals or events will be changed. I mean, who doesn't love minor league baseball and kites? If the takeover bid is successful, Ellison plans to place several Oracle executives in key state government positions, and is considering re-naming the state either New Ellison or OracleLand. [Couldn't resist, Jared! Hope it's not too OT!] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be
RE: oracle authentication from windows
(my question follows) -Original Message- From: Seefelt, Beth [mailto:[EMAIL PROTECTED] I disagree. Remote OS authentication is not inherently insecure in Windows like it is in Unix. If you prefix the account names with the domain name, a user would not only have to spoof the username, he would have to spoof the domain name too. At that point, you probably have bigger problems than access to your database. Also, in that situation, only the security token is going over the network, not your password in clear text. The caveat is that you should be using the *domain name* as the prefix, not OPS$. I don't understand how to accomplish this in practice. I currently sign on to the Windows Network for domain MYDOMAIN with userid JKILCHOE. By running the query suggested by Mr. Nanda I see that Oracle thinks my username is jkilchoe: SQL select sys_context ('userenv', 'os_user') from dual SYS_CONTEXT('USERENV','OS_USER') - jkilchoe If I set os_authent_prefix = MYDOMAIN and create an Oracle username MYDOMAINJKILCHOE how does that stop someone else from creating a local user JKILCHOE on their machine, signing on to their local machine as JKILCHOE, and then using SQL*Net to connect to the database as MYDOMAINJKILCHOE ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: oracle authentication from windows
Beth, You are right in stating that OPS$ accounts are not inherently insecure. How is teh inclusion of domain name any more secure than using OPS$? Granted, the hacker has to guess the domain name in addition to user name, but so is using any other prefix other than OPS$. Besides if the users are not static, the domain names will be different. How will you address that issue? For instance, you domina name is MYCODOMAIN1 and your windows userid is mycodomain1\bseefelt, so the Oracle userid, as you propose should be mydomain\bseeth. If you login to another domain, say, MYDOMAIN2, this account is no longer valid. So, I would say, mixing domains with username may not be a good idea, unless ofourse you have a single domain. Arup - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 20, 2003 10:10 AM I disagree. Remote OS authentication is not inherently insecure in Windows like it is in Unix. If you prefix the account names with the domain name, a user would not only have to spoof the username, he would have to spoof the domain name too. At that point, you probably have bigger problems than access to your database. Also, in that situation, only the security token is going over the network, not your password in clear text. The caveat is that you should be using the *domain name* as the prefix, not OPS$. -Original Message- Sent: Friday, June 20, 2003 6:20 AM To: Multiple recipients of list ORACLE-L Hi Arup, Remote OS authentication whether with OPS$ or not is still a risk. You are intimating that SYSTEM is the only risky account involved here. What if any of the newly created OPS$ accounts have useful privileges. I have seen a similar application to the one described recently. There were forms within the application for administration and user management (in oracle, not the application) and the users who had access to these were assigned the DBA role and were of course external accounts. I think what you should add to your comment is that the issue is overrated is that any OPS$ / external accounts should not have any dangerous privileges granted and certainly not DBA. If you can guess the name of an admin account even if its OPS$ then the issue is still severe. cheers Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Look's like Larry's at it again...
Nah. LarryWorld.. Will charge you to enter and exit the state. Will over count residents to get better tax subsidies and will never discount products to government agencies. Oh yes. Everyone must own an Armani Suit. Thank You Stephen P. Karniotis Strategic Alliance Manager Compuware Corporation Direct: (313) 227-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Friday, June 20, 2003 3:21 PM To: Multiple recipients of list ORACLE-L Subject:RE: Look's like Larry's at it again... Excellent, but I really thought he meant to call it Larry Land! :) Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long term Oracle DBA. -Original Message- Jesse, Rich Sent: Friday, June 20, 2003 11:20 AM To: Multiple recipients of list ORACLE-L Oracle Makes Bid to Buy State of Delaware Software giant willing to assume state's $225 million deficit in exchange for legislative control, naming rights Wilmington, DE - Oracle CEO Larry Ellison today announced his intention to purchase the state of Delaware for $300 million in cash and Oracle stock. The move comes on the heels of Oracle's bid for rival software firm PeopleSoft, and is the first time that an offer has been made to buy a U.S. territory. Delaware governor Ruth Ann Minner responded to the bid with shock and seemed certain that the hostile takeover could be avoided. Oracle's bid comes as a big surprise to the government and people of Delaware, said Minner at a press conference. At this point, we are checking into whether or not a company, such as Oracle, can buy a state, and whether or not Delaware is actually for sale. Oracle's announcement sent shockwaves through the political and economic landscape. Oracle shares dropped 8% immediately following the announcement, only to rebound and break even for the day, with heavy volume being traded. Meanwhile, government officials in Washington scrambled to look into the legality of such a purchase, and who actually currently owns Delaware. In an afternoon press conference, Ellison seemed certain that Oracle would own Delaware in the near future. The fact is that the state of Delaware is in a budget crisis that it can not resolve. Oracle's bid will immediately pump $300 million into the state budget, and (Oracle) will also be assuming all current Delaware debt. Call this a 'hostile takeover' if you must, but the people of this great state deserve a better future, and I will be able to give them just that. President Bush, who was giving a speech to coal miners in Kentucky, called the Oracle bid interesting and added that 49 states would be easier for me to handle than 50. Ellison rival Tom Siebel called the move typical, and added Larry thinks he can take over the world, and I guess he thinks this is a good place to start. I personally would have targeted Vermont. Ellison defended his decision, citing fourteen state parks, a minor league baseball franchise, an annual Nascar race in Dover, and the annual Great Delaware Kite Festival as reasons that Delaware is primed for success. Delaware is a state rich in tradition and excitement. None of the existing festivals or events will be changed. I mean, who doesn't love minor league baseball and kites? If the takeover bid is successful, Ellison plans to place several Oracle executives in key state government positions, and is considering re-naming the state either New Ellison or OracleLand. [Couldn't resist, Jared! Hope it's not too OT!] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The contents of this e-mail are intended for the
controlfile backup obsolete above 2 days
Hello list I was having problems with my controlfile backups being reported as obsolete ; I have narrowed down the problem to the number of days specified in the recovery window . 1. My control_file_record_keep_time=7 2. Suppose I start rman and there are no backups yet. (This is confirmed by the commands : delete noprompt force backup ; delete nopromt force copy ; list backup ; (This shows no o/p confirming that there are no backups ) list backup of controlfile ; (This shows no o/p confirming that there are no backups ) 3. All the rman configuration settings are at their default values . I did not modify any , and just to be sure I checked using 'show all ;' 4. Now I backup the database : backup database ; As expected it creates a single set with a single piece whose name is in the o/p: channel ORA_DISK_1: finished piece 1 at 21-Jun-2003 00:13:01 piece handle=D:\ORACLEXP\ORA92\DATABASE\03EQ6ARH_1_1 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:28 Finished backup at 21-Jun-2003 00:13:01 5. I confirm this by using 'list backup ;' and list backup of controlfile ; 6. NOW THE PROBLEM IS : RMAN report obsolete recovery window of 1 days ; no obsolete backups found RMAN report obsolete recovery window of 2 days ; no obsolete backups found RMAN report obsolete recovery window of 3 days ; Report of obsolete backups and copies Type KeyCompletion TimeFilename/Handle - -- -- Backup Set3 21-Jun-2003 00:12:52 Backup Piece 3 21-Jun-2003 00:12:52 D:\ORACLEXP\ORA92\DATABASE\03EQ6ARH_1_1 Why is this happening for all values above 2 days ? Please advise . -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle docs do say # of extents effect performance
No, I was talking about on file system only. -Original Message- Sent: Friday, June 20, 2003 2:20 PM To: Multiple recipients of list ORACLE-L Does this mean that if I dd the file onto a raw partition, it will be scattered around the raw partition? Even though the dd-ing process is unaware of the characteristics of the raw partition? -Original Message- Even without stripping you can't gaurantee it will be a contiguous section of disk space. The file could be scattered across the file system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Partition
Hey Dennis: I created a range partition table with the last high_value being maxvalue. The partition key is partner_id (an incremental sequence). Now pmax (the last partition) has become very big and gives snapshot too old.. while exporting. Ultimate Plan = I realize that the ultimate solution will be the split the partition pmax, into enough segments so that the new pmax has no data. Then at this point I will drop the pmax partition. Therefore when new partners come I will add partitions accordingly. Maybe = But I was thinking If I can make pmax into a hashed subpartition, it will also distribute the data reasonably. I dont have to have the segments separated by the partner_id because the data are not evenly distributed to the partners. partner_id , count(*) 1 4646545542 2 11164546466 ... and so on.. Thanks very much for your help. Ishwar -Original Message- DENNIS WILLIAMS Sent: Friday, June 20, 2003 3:10 PM To: Multiple recipients of list ORACLE-L Ishwar - What Oracle version. Just off the top of my head, I think that 8i only allows the subpartition to be hashed. What is your goal? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, June 20, 2003 12:00 PM To: Multiple recipients of list ORACLE-L Hey, Can anyone say if there is a way to breakup an existing partition into subpartitons. The partition contains data. Thx Ishwar. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ishwar Tewari INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ishwar Tewari INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: VLDB (oltp) and RMAN
Carol, We use a 7.1 Terabytes (double Yikes!) database - Sun 15K server, Hitachi Storage Array, RAID-5 (all except redo logs which are RADI 0+1), 8.1.74. Some of thetables are more than 100 GB in size. However, the datafiles are smaller, just 4 GB each. This is done to facilitate the recovery process if a datablock is corrupted. It's esier to rcover 4G than 100G. We use RMAN to back up to tape using Tivoli Storage Manager. No problems there. Backs up in 8 hours (full), with 16 channels. If it may help - we have a standby database; the backups go from standby, not primary - to conserve the CPU cycles. and it certainly helps. HTH. Arup Nanda www.proligence.com - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Friday, June 20, 2003 9:54 AM Subject: VLDB (oltp) and RMAN Hi Listers, I've just finished a sizing exercise for a Production OLTP. At the one-year mark, it should be approximately 4.5 Terabytes in size. Yikes !! I have a RAID5 array that I'll be using for all of the data files (except the typical System, Rbs, etc which are going to be on RAID 0+1). I plan on using RMAN to do backups, naturally, however, I'm wondering whether anyone has run into any size limitations (from an RMAN perspective) when attempting to backup database files that are over 100Gig in size. (I have the situation where I expect a single table tol be over 100Gig in size). I'm aware of the fact that I may bump into hardware limitations, and I'm going to discuss the hardware and tape limitations (if there are any) with my Sun server sys admin. Thanks in advance, Carol Legros
RE: (OT) RE: Look's like Larry's at it again...
-Original Message- From: Goulet, Dick [mailto:[EMAIL PROTECTED] Well I like both of them. Nothing like a good chuckle to brighten up a day. Yes, I thought it was funny, but especially with these official sounding articles you never know if it will end up being spread over the internet with people swearing it's true. I remember a woman I know who received an e-mail that said something like This e-mail has infected your computer with the Polish-Duh Virus. To repair please immediately erase all files on your hard disk. Do not do a backup because this will infect all your other backup disks. and the lady asked me should I really erase my hard drive? Does anyone else remember the oldie about Larry Ellison (supposedly) telling Ivy Leaguers to drop out of school? http://www.satirewire.com/news/0006/satire-ellison.shtml Graduates of Yale University, I apologize if you have endured this type of prologue before, but I want you to do something for me. Please, take a good look around you. Look at the classmate on your left. Look at the classmate on your right. Now, consider this: five years from now, 10 years from now, even 30 thirty years from now, odds are the person on your left is going to be a loser. The person on your right, meanwhile, will also be a loser. And you, in the middle? What can you expect? Loser. Loserhood. Loser Cum Laude. In fact, as I look out before me today, I don't see a thousand hopes for a bright tomorrow. I don't see a thousand future leaders in a thousand industries. I see a thousand losers. You're upset. That's understandable. After all, how can I, Lawrence 'Larry' Ellison, college dropout, have the audacity to spout such heresy to the graduating class of one of the nation's most prestigious institutions? I'll tell you why. Because I, Lawrence 'Larry' Ellison, second richest man on the planet, am a college dropout, and you are not. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Partition
The version is 9i. -Original Message- DENNIS WILLIAMS Sent: Friday, June 20, 2003 3:10 PM To: Multiple recipients of list ORACLE-L Ishwar - What Oracle version. Just off the top of my head, I think that 8i only allows the subpartition to be hashed. What is your goal? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, June 20, 2003 12:00 PM To: Multiple recipients of list ORACLE-L Hey, Can anyone say if there is a way to breakup an existing partition into subpartitons. The partition contains data. Thx Ishwar. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ishwar Tewari INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ishwar Tewari INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Partition
When you say 9i, do you mean 9.0.1 or 9.2.0? In 9.2.0 You can have list subpartitions. http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_73a.htm#2153058 -Original Message- From: Ishwar Tewari [mailto:[EMAIL PROTECTED] I created a range partition table with the last high_value being maxvalue. The partition key is partner_id (an incremental sequence). Now pmax (the last partition) has become very big and gives snapshot too old.. while exporting. Ultimate Plan = I realize that the ultimate solution will be the split the partition pmax, into enough segments so that the new pmax has no data. Then at this point I will drop the pmax partition. Therefore when new partners come I will add partitions accordingly. Maybe = But I was thinking If I can make pmax into a hashed subpartition, it will also distribute the data reasonably. I dont have to have the segments separated by the partner_id because the data are not evenly distributed to the partners. partner_id , count(*) 1 4646545542 2 11164546466 ... and so on.. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: MySQL in the future?
Thank you for the research. When they say Distribution for MySQL would mean more than one copy installed in a production environment, by production environment, they must mean a business. For example I can use MySQL on my home computer to keep track of my record collection, and I can also recreate the same database on my wife's computer so that she can keep track of her CDs, all for free. (I don't expect you to answer that! If I want to know for sure I can always ask MYSQL.) -Original Message- From: Matthew Zito [mailto:[EMAIL PROTECTED] I figured the time had come to stop speculating about MySQL's licensing policy and get the answer straight from the horse's mouth, as it were. So I contacted MySQL and posed a couple of scenarios to them. Here's my questions and their responses (my stuff is the quoted part): in all of these examples, a non-GPLed application is being described: 1) A web-based application for an internal or external audience running with mysql as the backend only? If it is a web-based application that will be created and distributed, a license is required. If it is an internally built and internally used application running on one server, a commercial license is not required (more then one installation requires a license for each - it will be considered internal distribution). 2) A compiled win32 application installed on employee desktops that connects to a centralized mysql database for running queries? As long as the database is not installed on each individual machine, only one license is required (unless it is an internally built application running on one server - it could be used for free). 3) A compiled win32 application that installs mysql locally on the user's machine? A license would be required for each installation, it would be considered internal distribution. 4) A web-based application where mysql has been distributed to a number of database servers and is running on those database servers? The confusion seems to center around the word distribute. What constitutes distribution of MySQL? Thanks very much for your help. Distribution for MySQL would mean more than one copy installed in a production environment, either internally or externally. Also note that if an end user used MySQL with a 3rd party commercial application, a non-GPL commercial license of MySQL is required. So, that clears some things up for me, but this licensing policy does seem unnecessarily confusing. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Partition
Ishwar I am fairly new to partitions myself and must relearn the commands each time I need to work with the partitions. So I will speak more to the philosophy of a DBA that doesn't like to end up in a jam. I get a bad feeling about hashing to get around an immediate problem. I also question the value of an export this large. Have you timed the re-import? It might take so long as to not be of practical value. My approach in this situation would be to first design how I want my system to be. Lay out the partitions I would like to have, etc. Then create a plan to get to the situation I want. Conduct tests to see what changes can be made in a reasonable time. First create a new partition that will take the newly arriving data so your problem doesn't continue to get worse. Then aim at creating new partitions one at a time that will split the existing too-large partition into smaller partitions in a manageable effort per partition. You may end up creating one each weekend for awhile. My theory is being DBA of a really large database is similar to being captain of a supertanker. You can't turn a large ship or a large database quickly. You must anticipate problems a long distance off. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, June 20, 2003 2:50 PM To: Multiple recipients of list ORACLE-L Hey Dennis: I created a range partition table with the last high_value being maxvalue. The partition key is partner_id (an incremental sequence). Now pmax (the last partition) has become very big and gives snapshot too old.. while exporting. Ultimate Plan = I realize that the ultimate solution will be the split the partition pmax, into enough segments so that the new pmax has no data. Then at this point I will drop the pmax partition. Therefore when new partners come I will add partitions accordingly. Maybe = But I was thinking If I can make pmax into a hashed subpartition, it will also distribute the data reasonably. I dont have to have the segments separated by the partner_id because the data are not evenly distributed to the partners. partner_id , count(*) 1 4646545542 2 11164546466 ... and so on.. Thanks very much for your help. Ishwar -Original Message- DENNIS WILLIAMS Sent: Friday, June 20, 2003 3:10 PM To: Multiple recipients of list ORACLE-L Ishwar - What Oracle version. Just off the top of my head, I think that 8i only allows the subpartition to be hashed. What is your goal? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, June 20, 2003 12:00 PM To: Multiple recipients of list ORACLE-L Hey, Can anyone say if there is a way to breakup an existing partition into subpartitons. The partition contains data. Thx Ishwar. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ishwar Tewari INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ishwar Tewari INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services--
Re: Look's like Larry's at it again...
I figured he try for something closer to home...say Oragon? Then Bill would want to buy Mississippi (postal abreviation MS for our non-us listers). Jesse, Rich wrote: Oracle Makes Bid to Buy State of Delaware Software giant willing to assume state's $225 million deficit in exchange for legislative control, naming rights Wilmington, DE - Oracle CEO Larry Ellison today announced his intention to purchase the state of Delaware for $300 million in cash and Oracle stock. The move comes on the heels of Oracle's bid for rival software firm PeopleSoft, and is the first time that an offer has been made to buy a U.S. territory. Delaware governor Ruth Ann Minner responded to the bid with shock and seemed certain that the hostile takeover could be avoided. Oracle's bid comes as a big surprise to the government and people of Delaware, said Minner at a press conference. At this point, we are checking into whether or not a company, such as Oracle, can buy a state, and whether or not Delaware is actually for sale. Oracle's announcement sent shockwaves through the political and economic landscape. Oracle shares dropped 8% immediately following the announcement, only to rebound and break even for the day, with heavy volume being traded. Meanwhile, government officials in Washington scrambled to look into the legality of such a purchase, and who actually currently owns Delaware. In an afternoon press conference, Ellison seemed certain that Oracle would own Delaware in the near future. The fact is that the state of Delaware is in a budget crisis that it can not resolve. Oracle's bid will immediately pump $300 million into the state budget, and (Oracle) will also be assuming all current Delaware debt. Call this a 'hostile takeover' if you must, but the people of this great state deserve a better future, and I will be able to give them just that. President Bush, who was giving a speech to coal miners in Kentucky, called the Oracle bid interesting and added that 49 states would be easier for me to handle than 50. Ellison rival Tom Siebel called the move typical, and added Larry thinks he can take over the world, and I guess he thinks this is a good place to start. I personally would have targeted Vermont. Ellison defended his decision, citing fourteen state parks, a minor league baseball franchise, an annual Nascar race in Dover, and the annual Great Delaware Kite Festival as reasons that Delaware is primed for success. Delaware is a state rich in tradition and excitement. None of the existing festivals or events will be changed. I mean, who doesn't love minor league baseball and kites? If the takeover bid is successful, Ellison plans to place several Oracle executives in key state government positions, and is considering re-naming the state either New Ellison or OracleLand. [Couldn't resist, Jared! Hope it's not too OT!] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).begin:vcard n:Fink;Daniel tel;cell:303.808.3282 tel;work:303.272.3225 x-mozilla-html:TRUE adr:;; version:2.1 email;internet:[EMAIL PROTECTED] title:DB Services Lead x-mozilla-cpt:;-4832 fn:Daniel Fink end:vcard