Re: NT Script
I did this on another server and can't remember the exact details, but it went something like this: 1) In SQLPlus create a rename.sql file with: Spool rename_export.bat select 'HOST REN export_file_name export_file_name_'||to_char(sysdate,'MMDD') FROM DUAL; spool off; 2) In your script have two commands: sqlplus user/password start rename.sql call rename_export.bat HTH, Jim -Original Message- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Monday, June 18, 2001 9:56 AM >Hello all, > I know, I know, NT. Anyway, I was wondering if anyone knew how to append >the system date to a file created through a script. Basically, what I want >to do is have files set up to run exports every night, however, I need to be >able to appened the system date to the file when it is created so I don't >just over write the file that was created the night before. Does anyone >know how to do this, it would be greatly appreciated!! > >Sincerely, >Kevin Kostyszyn >DBA >Dulcian, Inc >www.dulcian.com >[EMAIL PROTECTED] > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Kevin Kostyszyn > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Walski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Should Archive Log File OS Size be the same?
Oracle 8.1.5 and 7.3.4.5 No Alter System switch logfile performed. NT 4.0 I am testing some recovery plans, and I tried to restore a cold backup and roll the database forward. However, when I went to apply the 1st archive log since the cold backup it complained about a size of the transaction and indicated the archive log was corrupted. When I review all the archive logs on the production system I notice the OS size of the files are not always the exact same. Should they be the exact same size assuming that no one does an "alter system switch logfile" command? The archive logs are 10MB each and some appear to be off 1-4k Normal = 10241, Others = 10,237,10240,10238) Thanks, Jim Jim Walski ClassicPlan Chino, CA 91710 email [EMAIL PROTECTED] http://www.classicplan.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Walski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Need oracle patch 8.1.7.1.1
I just received this from a iTar. It is for Win NT. Go to Metalink. On the left side, choose Patches. Under Patch Download, click: ==> NEW! Click here for ALL Product Patches On the Patch Download screen, choose: Oracle Server for Product Family 8.1.7.1 for Product Release MS Windows NT for Platform Click search. You should find: ID:611940 Patchset::1711240 8.1.7.1.1 ORACLE SERVER PATCH SET NOTE: Do NOT enter a Patch Number. This is a patchset not a patch, & it will not match if you enter it as a patch number. -Original Message- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Tuesday, May 08, 2001 8:26 AM >I must be going blind -- I search for the patch and the latest I find is 8.1.7.0.2 ... could you provide the ID number and/or a working >method to find the .1.1 patch for NT? > >The Oracle DBA wrote: > >> I guess you are not on NT because the .1.1 patch is there. The std procedure for 817 is to install 817, patch it to .1.1 then .1.2. >> >> Cheers, >> >> Earl >> >> --- >> >> TheOracleDBA >> [EMAIL PROTECTED] >> >> On Fri, 04 May 2001 10:31:23 >> Shaw, John B wrote: >> >I just downloaded patch 8.1.7.1.2 from metalink - >> >in the readme (yes I actually read it before installing ) it states that >> >the earliest version that this patch may be applied to is >> >8.1.7.1.1 - I can't find this patch on metalink >> >anybody know where I can get it? >> > >> > >> > . .-.. .--. .. ...- . -... . . -. .--. .-. --- -... . -.. >> >John B. Shaw >> >Intergraph Public Safety >> >mailstop LR24A4 >> >[EMAIL PROTECTED] >> >256-730-8038 >> >All the usual disclaimers and some of the certifications >> > >> >-- >> >Please see the official ORACLE-L FAQ: http://www.orafaq.com >> >-- >> >Author: Shaw, John B >> > INET: [EMAIL PROTECTED] >> > >> >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >> >San Diego, California-- Public Internet access / Mailing Lists >> > >> >To REMOVE yourself from this mailing list, send an E-Mail message >> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >> >the message BODY, include a line containing: UNSUB ORACLE-L >> >(or the name of mailing list you want to be removed from). You may >> >also send the HELP command for other information (like subscribing). >> > >> >> Get 250 color business cards for FREE! >> http://businesscards.lycos.com/vp/fastpath/ >> -- >> Please see the official ORACLE-L FAQ: http://www.orafaq.com >> -- >> Author: The Oracle DBA >> INET: [EMAIL PROTECTED] >> >> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >> San Diego, California-- Public Internet access / Mailing Lists >> -------- >> To REMOVE yourself from this mailing list, send an E-Mail message >> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >> the message BODY, include a line containing: UNSUB ORACLE-L >> (or the name of mailing list you want to be removed from). You may >> also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Walski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: authentication externally on WinNT
I was just recently playing around with this and found a couple of tips to fix my problem: There is a registry setting called: OSAUTH_PREFIX_DOMAIN that is now defaulted to TRUE for 8.1 databases. To get my machine to login without a username/password I had to create an oracle user name like "MYDOMAIN\USERABC". ( not sure if it matters but the notes also said to put everything in uppercase). You can set this to false and then i believe the domain name can be left off the oracle username. There is an init.ora parameter = REMOTE_OS_AUTHENT that must be set to TRUE ( I do believe this causes some security risks so you may want to investigate those issues to.) There is also an init.ora parameter OS_AUTHENT_PREFIX that needs to be set. I believe the default is now "" (no prefix required for the oracle user account). I used these keywords and was able to locate some helpful documents in Metalink. HTH, Jim References Metalink: Note:102665.1 -Original Message- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Wednesday, April 18, 2001 2:28 AM >Hi! > >Oracle8.1.7 on WinNT. >I created database user with external authentication with whom I'm logged on >that WinNT server. >When I start exp there is error > invalid username/password logon denied. >What am I missing? It works just fine on UNIX! > >TIA, >Sonja >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: =?iso-8859-2?Q?Sonja_=A9ehovi=E6?= > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Walski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Insufficient privs to connect internal
Bill, Have you tried using the connect "as SYSDBA"? I am not sure this would come into play, but since Oracle is phasing out the INTERNAL usage, maybe sqlplus prefers the "as SYSDBA" syntax. Jim -Original Message- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Monday, April 02, 2001 4:31 PM >Greg, > >It is my understanding that it is only necessary to set >SQLNET.AUTHENTICATION_SERVICES= (NTS) if oracle is going to be relying on >the client NT workstation for authentication. Is that not correct? > >Also, in my situation I am invoking SQL*Plus and SVRMGRL from the command >prompt in a DOS window so sql*net does not come into play. > >If I am missing something please let me know. > >Thanks. > >At 02:16 PM 4/2/01 -0800, Nelson, Greg wrote: >>Check your SQLNET.ORA. You should have: >> >>SQLNET.AUTHENTICATION_SERVICES= (NTS) >> >>in it to verify your NT id as a user with database rights >> >>Greg >> >>-Original Message- >>Sent: Monday, April 02, 2001 5:52 PM >>To: Multiple recipients of list ORACLE-L >> >> >>Hello, >> >>I am running oracle 8.1.6.1.3 on NT 4.0 and am having difficulties >>attempting to connect internal from SQL*Plus. >> >> From a DOS prompt logged in as the Oracle user which has full >>administrative rights... >> >>c:\>set ORACLE_SID=sidname >>c:\> sqlplus /nolog >>SQL> connect internal >>Enter Password: ** >>ERROR: >>ORA-01031: insufficient privileges >>SQL> exit >>c:\> svrmgrl >>SVRMGRL> connect internal >>Password: * >>Connected: >>SVRMGRL> >> >>There is an ORA_DBA group on the machine and the oracle user is a member. >>In the init.ora file... >> >>remote_login_passwordfile=shared >> >>I do not uderstand the reason for this. Any help in resolving this quandry >>would be greatly appreciated. >> >>Thanks. >> >>Bill Wagman >>Univ. of California at Davis >>Information Resources >>[EMAIL PROTECTED] >>(530) 754-6208 >> >>-- -- >>- >>I like to pick up hitchhikers. When they get in the car I say, 'Put on your >>seat belt. I want to try something. I saw it once in a cartoon, but I think >>I can do it.' >>- Steven Wright >> >>-- >>Please see the official ORACLE-L FAQ: http://www.orafaq.com >>-- >>Author: Bill Wagman >> INET: [EMAIL PROTECTED] >> >>Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >>San Diego, California-- Public Internet access / Mailing Lists >> >>To REMOVE yourself from this mailing list, send an E-Mail message >>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >>the message BODY, include a line containing: UNSUB ORACLE-L >>(or the name of mailing list you want to be removed from). You may >>also send the HELP command for other information (like subscribing). >>-- >>Please see the official ORACLE-L FAQ: http://www.orafaq.com >>-- >>Author: Nelson, Greg >> INET: [EMAIL PROTECTED] >> >>Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >>San Diego, California-- Public Internet access / Mailing Lists >> >>To REMOVE yourself from this mailing list, send an E-Mail message >>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >>the message BODY, include a line containing: UNSUB ORACLE-L >>(or the name of mailing list you want to be removed from). You may >>also send the HELP command for other information (like subscribing). > > >Bill Wagman >Univ. of California at Davis >Information Resources >[EMAIL PROTECTED] >(530) 754-6208 > >--- -- >I like to pick up hitchhikers. When they get in the car I say, 'Put on your >seat belt. I want to try something. I saw it once in a cartoon, but I think >I can do it.' >- Steven Wright > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Bill Wagman > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this m
Verify Parallel Query is working?
Hello, I am trying to play on a test machine with the Parallel Query Option. I cannot seem to get a query to perform a parallel full table scan. I have searched on metalink and I believe I have all the proper init.ora parameters set: NT 4.0, Oracle 8.1.7 Enterprise Edition. parallel_threads_per_cpu = 2 parallel_min_servers = 0 parallel_max_servers = 5 The test machine only has 1 CPU, does the parallel query even work if the machine only has 1 CPU? I realize you need more than 1 cpu for it to be very beneficial, however, I am not really concerned with the performance, but I would just like to see a query use the parallel option. To Test: I built a 1,000,000 row table and I am using the following query: SELECT /*+ FULL(TEST) PARALLEL */ COUNT(*) FROM TEST When I do an explain plan, I cannot seem to get any parallel execution. Is there something I am missing or must you have > 1 CPU? Is 1,000,000 rows too small? Thanks, Jim -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Walski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Nologging
Yes you can issue the alter table nologging but it will only be relevant for certain operations not all UPDATE, DELETE, conventional path INSERT statements. Jim Reference the following I found on metalink: Doc ID: Note:1038660.6 Type: PROBLEM Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 21-NOV-1997 Last Revision Date: 02-MAY-2000 Language: USAENG PURPOSE This article gives further information about the options UNRECOVERABLE in Oracle7 and NOLOGGING in Oracle8. SCOPE & APPLICATION For users requiring further information about these options. The options UNRECOVERABLE in Oracle7 and NOLOGGING in Oracle8 can be used when creating a table as select. They will send the actual create statement to the redo logs (this information is needed in the data dictionary). All rows loaded into the table during the create are not sent to the redo logs. With UNRECOVERABLE in Oracle7 any subsequent Data Manipulation Language (DML) command on the table WILL be sent to the redo logs. The UNRECOVERABLE option can be used in early versions of Oracle8 but will eventually be replaced by the NOLOGGING option. With NOLOGGING in Oracle8, although you can set the NOLOGGING attribute for a table, partition, index, or tablespace, NOLOGGING mode does not apply to every operation performed on the schema object for which you set the NOLOGGING attribute. Only the following operations can make use of the NOLOGGING option: alter table...move partition alter table...split partition alter index...split partition alter index...rebuild alter index...rebuild partition create table...as select create index direct load with SQL*Loader direct load INSERT All of these SQL statements can be parallelized. They can execute in LOGGING or NOLOGGING mode for both serial and parallel execution. Other SQL statements (such as UPDATE, DELETE, conventional path INSERT, and various DDL statements not listed above) are unaffected by the NOLOGGING attribute of the schema object. -Original Message- To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>; Jwalski3 <[EMAIL PROTECTED]> Date: Wednesday, March 28, 2001 5:25 PM > >that has nothing to do with the question. But anyway, try ALTER TABLE >NOLOGGING instead. > >oli > > >[EMAIL PROTECTED] wrote >> Alter database noarchivelog; >> >> will change the entire database. >> >> see the following for detailed information: >> >> http://technet.oracle.com/docs/products/oracle8i/doc_index.htm >> >> HTH, Jim >> >> -Original Message- >> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >> Date: Wednesday, March 28, 2001 4:37 PM >> >> >I know it is possible when creating a table to specify no logging >> >so that it doesn't generate redo logs. Is it possible, AFTER >> >the table has already been created, to change it to nologging? >> > Also this is a dev database that we don't care about doing any >> >type of recovery and just want to do some quick loads -- is it >> >possible to change the entire database to nologging? >> >This is on Oracle 8.0.5. >> > >> >- >> >Sent using MailStart.com ( http://MailStart.Com/welcome.html ) >> >The FREE way to access your mailbox via any web browser, anywhere! >> > >> >-- >> >Please see the official ORACLE-L FAQ: http://www.orafaq.com >> >-- >> >Author: >> > INET: [EMAIL PROTECTED] >> > >> >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >> >San Diego, California-- Public Internet access / Mailing Lists >> > >> >To REMOVE yourself from this mailing list, send an E-Mail message >> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >> >the message BODY, include a line containing: UNSUB ORACLE-L >> >(or the name of mailing list you want to be removed from). You may >> >also send the HELP command for other information (like subscribing). > >-- >Oliver Artelt >Oracle Certified DBA > >cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg >telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 >email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Walski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Nologging
Alter database noarchivelog; will change the entire database. see the following for detailed information: http://technet.oracle.com/docs/products/oracle8i/doc_index.htm HTH, Jim -Original Message- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Wednesday, March 28, 2001 4:37 PM > >I know it is possible when creating a table to specify no logging >so that it doesn't generate redo logs. Is it possible, AFTER >the table has already been created, to change it to nologging? > Also this is a dev database that we don't care about doing any >type of recovery and just want to do some quick loads -- is it >possible to change the entire database to nologging? >This is on Oracle 8.0.5. > >- >Sent using MailStart.com ( http://MailStart.Com/welcome.html ) >The FREE way to access your mailbox via any web browser, anywhere! > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Walski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Standard vs Enterprise Edition
>The cost of the Enterprise Edition compared to the Standard Edition is large >(2 x). The way i figure enterprise is over 6.5 times more expensive. Enterprise = $100/Universal Power Unit to $15.00/Universal Power Unit. That is quite a difference.I would sure make sure we used feature available ( if they work..) Jim -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Walski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Tuning Matter ==> Parameter PCT_USED in a Table
Are all the columns completely filled? ie all the "ename" are 10 chars long and all the "job" fields are 9 chars. When you use the varchar2 field it only stores the length _used_. Jim -Original Message- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Friday, March 23, 2001 9:21 AM Hi Ron, Let's take a example: SQL> desc emp NameNull?TypeBYTES -- -- -- EMPNO NOT NULL NUMBER(4) 21 ENAME VARCHAR2(10)10 JOB VARCHAR2(9) 9 MGR NUMBER(4) 21 HIREDATEDATE 7 SAL NUMBER(7,2) 21 COMMNUMBER(7,2) 21 DEPTNO NUMBER(2) 21 TOTAL=3+(SUM OF COLUMN SIZES)+(# OF COLUMNS < 250)+(3* # OF COLUMNS > 250) So according to ur formula TOTAL=3+131+8=142 BYTES Is this OK 'coz after analyzing the table with COMPUTE I got AVG_ROW_LEN 40. Can there be such a HUGE difference ? Pl. comment. Thanks, - Harsh -Original Message- Sent: Friday, March 23, 2001 3:16 PM To: Multiple recipients of list ORACLE-L max(row size) is the sum of all of the columns sizes in the table plus overhead. The following is the column sizes and the sum formula to calculate the size of a row in a data block. NUMBER =21 CHAR = COLUMN SIZE VARCHAR = COLUMN SIZE DATE = 7 TOTAL=3+(SUM OF COLUMN SIZES)+(# OF COLUMNS < 250)+(3* # OF COLUMNS > 250) This is part of the calculations used to determine the storage needed for a table. OR: you could analyze you table and use the average row size is you need a general calculation of actual usage. ROR m*?*m >>> [EMAIL PROTECTED] 03/22/01 08:45PM >>> Dear Listers, I've download a presentation talking about Calculating PCT_USED . the formula is quite simple : PCT_USED + PCT_FREE < 100 PCT_USED = PCT_FREE + 1 row size but I have no idea to calculate the size of 1 row in a table . is there anyone who knows to calculate it ? or any alternative formula to calculate PCT_USED ? Thanks a lot in advance : ) =bambang= <> Bambang Setiawan <> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bambang Setiawan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harsh Agrawal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Walski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: NT Server very slow
Since you mention there are only a few users, I would take a look at the jobs these users are running. Maybe one of these users is firing off a poorly tuned job that brings the database to a grinding halt. Is the database the only product on the Server? Or are there other applications ( email server, web server...) Jim -Original Message- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Friday, March 23, 2001 7:50 AM >I have an Oracle 8.1.6 instance on an NT Server. The application has only a >few users. Very often throughout the day it seems response time drops to >about 20 seconds. By the time I log on to look at the problem everything is >back to normal. If I do a simple query the result is returned immediately. >I have looked at SQL through Quest's SQLAB and there is nothing that stand >out. The hit ratio averages between 88% and 92%. Is there a good way to >diagnose this type of problem? > >Ron Smith >Database Administration >[EMAIL PROTECTED] > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Smith, Ron L. > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Walski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Is there anything called session specific tables
You could add a session_ID ( use dbms_sesssion.unique_session_id to get a unique id) to the report table and then pass that variable to the report. Then in the report add to the WHERE clause "AND v_session_id = whatever_the_id_is" This should only then return the rows for the specific user. hth, Jim -Original Message- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Friday, March 16, 2001 12:00 AM >Hello Listers, > >I am facing a typical problem. In one of my D2K appliaction >I need to first populate the data in a particular itermediate >table and then run the reporting job. The data population >has been done in the report trigger. But the problem is if >at the same time another user fires the same report, the >data population becomes erroneous as he is also >sharing the same table. > >Is there any concept of session specific tables. > >Please help. >Regards, > >Tapas > > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: tapas dutta > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Walski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Locally Managed Tablespace Uniform Extent
I have to move a 7.3.4 database to 8i and I want to use the uniform extent size to reduce fragmentation. I read the article "stop defragmenting and start living" and it indicates to have 3 extent sizes - 128K, 4M, 128M. I also read an article on Steve Adams site that indicates to keep the number of extents under (db_block_size/16) - 7 ( which in my case ( 8k block) would be 505 extents. ) In the database I am moving there are some segments that are currently 1GB in size, if i was to put those in the 4M tablespace it would already have over 250 extents starting off. Are there any other performance type issues to consider? Should I create another extent size between 4M and the 128M? Maybe 64M increment? Thanks, Jim Jim Walski ClassicPlan Chino, CA 91710 email [EMAIL PROTECTED] http://www.classicplan.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Walski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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: MetaSlop - Another Response Scenario for Paul.
Title: RE: RE: MetaSlop - Another Response Scenario for Paul. Ross, I think a certain ex-president ( last name something like clinton) needs a spin doctor like you. Thanks for the great laughs! Jim -Original Message-From: Mohan, Ross <[EMAIL PROTECTED]>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>Date: Tuesday, February 27, 2001 1:59 PMSubject: RE: RE: MetaSlop - Another Response Scenario for Paul. Scenario Two: ## For Immediate Release ### Ap/UPI/AFP/Reuters --- Redwood Shores, 27 Feb 00 Oracle Denial of Service Attack Oracle Corporation announced today, in a stunning revelation, that they have been issuing a massive Denial of Service (DoS) attack against its own customers via its "Support" website, MetaBlink. The scam worked like this: clever hackers within Oracle Corporation configured MetaLink with Oracle default values, guaranteeing devastating failure. As long term Oracle customers, sorely vexed by arcane command sequences, byzantine product offerings, and constantly shifting product versions came to the "support web site" to seek help, they were shunted away, losing hours of productive time, watching key applications fail, marriages dissolve, and world peace slip from their grasp. Precisely at this vulnerable moment, a crack team of marketers ( or a team of crack-smoking marketers, field reports are not clear ) created a campaign to lead key customers to believe "application upgrades" and "more hardware" were the problem. Sources in the McNealy Command Bunker indicate Oracle's innovative DoS is working, as record numbers of customers are throwing massive amounts of hardware at problems relatively easy to rectify. Further, back at Armani HQ, Redwood Shores, initial reports are that the "application upgrades" orders are coming in quickly. IBM, HP, and other industry leaders are likely to follow the Oracle Corporation trend, and begin to knock off key customers shortly, using a combination of DoS, confusing price plans, deliriously inaccurate marketing campaigns, and other tools of corporate psychological warfare. ( - Ross Mohan, Cub Reporter, Daily Planet ) -Original Message- From: Paul Baumgartel [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 3:21 PM To: Multiple recipients of list ORACLE-L Subject: RE: RE: MetaSlop And if you were running a comparable system, what would *you* say? Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 917 549-4717 (mobile) -Original Message- Sent: Tuesday, February 27, 2001 2:51 PM To: Multiple recipients of list ORACLE-L Man, these guys just invite the wise-ass comment, don't they? Such as: Well maybe if the product worked better/was less confusing/had better documentation we wouldn't all be in Metalink! Oh no! If 4 new servers brought the system to its knees just think how bad it'll be when the rest of the hardware arrives! 4 new top-of-the-line servers, just think what that'll do to their power unit charges! Plus I can't rid myself of the image of us all 'staggering' to Metalink for help. Jim >>> [EMAIL PROTECTED] 02/27/01 01:21PM >>> For those interested, right from the horses mouth, or other orifice as you desire: News & Notes MetaLink Performance - An Update We apologize for the slow response times recently on MetaLink. All over the world our customers are coming to and using this valuable knowledge base in staggering numbers. Our Global IT team are working these performance issues as their number one priority. What is Being Done This week four new front-end web servers were brought on line to help manage the load. Additional hardware has been purchased and will arrive soon which will make a significant improvement in performance. We appreciate your patience during this time of significant growth in MetaLink usage. Thanks, The MetaLink Team --
