FAQ

Oracle > oracle-l > November 2005

Search Discussions

191 discussions - 930 posts

  • ········· SPECS ········· Dell 2650 PERC 4/DC (Dual Channel) RAID Controller for *external* storage (on 2 servers) PERC 3/DC (Dual Channel) RAID Controller for *external* storage (on 2 other servers) ...
    Marquez, ChrisMarquez, Chris
    Nov 16, 2005 at 3:20 pm
    Nov 23, 2005 at 6:58 am
  • Hi all, Is this one good? http://www.amazon.com/gp/product/0974599352/103-0891699-0877465?v=glance&n=283155&n=507846&s=books&v=glance I can see the review from Mr. Burleson who was apparently an ...
    Alex GorbachevAlex Gorbachev
    Nov 11, 2005 at 3:44 pm
    Jun 8, 2006 at 10:53 pm
  • Hi All, The alter system switch logfile hangs in my database. What might be the reason, what else should I check for? -- Regards, Deepak Oracle DBA -- http://www.freelists.org/webpage/oracle-l
    DBA DeepakDBA Deepak
    Nov 7, 2005 at 11:35 pm
    Nov 9, 2005 at 7:05 pm
  • There is a discussion going on at work concerning calculated fields. I am claiming that any calculated field in a table is a violation of at least 3NF if not 2NF. I can find all sorts of references ...
    Chris StephensChris Stephens
    Nov 1, 2005 at 12:28 pm
    Nov 2, 2005 at 5:53 am
  • 10.1.0.3.0 on TRU64 V5.1 Scenario. currently i have a number of RACed databases (3 in total) which are running 10g RAC on a 4-node (say node 1, node2, node3 and node4) TRU64 Cluster. what i want to ...
    Zabair AhmedZabair Ahmed
    Nov 16, 2005 at 3:33 am
    Nov 18, 2005 at 7:07 pm
  • Hi! We need to test the maximum I/O throughput of our SAN storage system and therefore need an Oracle database to generate so much load that there is an I/O bottleneck. Does anybody out there have ...
    Daiminger, HelmutDaiminger, Helmut
    Nov 18, 2005 at 10:00 am
    Nov 21, 2005 at 12:08 pm
  • Hi, please What can I do to solve this situation. I get an import hanged on an undo segment. Thank you SQL select row_wait_file#,row_wait_block# from v$session where not row_wait_block#=0 ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Nov 23, 2005 at 11:43 am
    Nov 24, 2005 at 7:13 am
  • This is just for fun, I have a solution but wondering what others would do. I will post mine later. Task: Monitor load average on a unix host. Requirements: * Notify me via email when load exceeds 8 ...
    Post, EthanPost, Ethan
    Nov 14, 2005 at 1:21 pm
    Nov 15, 2005 at 2:41 pm
  • What does WAIT_TIME = -1 indicate? I have this wait state that I want to learn more about. EVENT SQL*Net message to client P1TEXT P1 P1RAW ---------- ---------- ---------------- driver id 1650815232 ...
    Ray StellRay Stell
    Nov 23, 2005 at 8:34 am
    Nov 24, 2005 at 9:26 am
  • We want to setup daily email notification about database issues/alerts & warning levels. Say for example % free space in each tablespace, hanging sessions, replication queue count, broken jobs,locked ...
    Sami SeeranganSami Seerangan
    Nov 2, 2005 at 12:10 pm
    Nov 7, 2005 at 1:07 pm
  • Anyone want to start a pool on when Metalink will start offering RSS feeds for new/updated articles, scripts. bugs etc...Why do I still need to log in to see this stuff? DANG! However, they are going ...
    Post, EthanPost, Ethan
    Nov 1, 2005 at 1:06 pm
    Nov 3, 2005 at 12:20 pm
  • Hello, is there any way in Oracle to dynamically create a new temporary table direct from select? Like In Transact SQL : SELECT INTO FROM.... Thanks. Dominik Smatana -- ...
    Dominik SmatanaDominik Smatana
    Nov 21, 2005 at 3:51 am
    Nov 28, 2005 at 9:15 pm
  • I have a SQL statement as follows: INSERT INTO A1 SELECT * FROM B1; Table A1 has about 900K rows, 1 PK and has 4 Bitmap indexes. When I run the above from SQL*Plus with a 10046 trace, I see a lot of ...
    Deepak SharmaDeepak Sharma
    Nov 18, 2005 at 12:52 pm
    Nov 24, 2005 at 3:50 am
  • We recently upgraded an 8i (test) database to 9.2.0.6, the batch jobs are taking more than 4 times longer to complete in the 9i environment. When traced one of the batch jobs using DBMS_SUPPORT ...
    Thomas BijuThomas Biju
    Nov 10, 2005 at 11:33 am
    Nov 14, 2005 at 9:48 pm
  • Good morning We are implementing Oracle 10gR2 64bit on RHAS4 with EMC storage system. We are planning to take advantages of ASM in Oracle 10g, but would like to know anyone had been successfully ...
    Chen, SarahChen, Sarah
    Nov 7, 2005 at 10:40 am
    Nov 8, 2005 at 11:06 am
  • Hello guru's, Does anyone know if there is any way to get the ip address of someone that is logged into Oracle. My manager wants to audit users logging into our Lawson database running on Oracle. He ...
    Randy SambergRandy Samberg
    Nov 30, 2005 at 7:16 pm
    Dec 7, 2005 at 9:11 am
  • I found this utility http://www.officerecovery.com/oracle/, to recover oracle as if it were an office document, well I can't say is a b ad product, did you tested? -- Oracle Certified Profesional 9i ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Nov 25, 2005 at 5:19 pm
    Nov 29, 2005 at 8:46 am
  • List, I am moving schemas between instances and need to make some schema changes, like storage sizes. This is Oracle 8i, so I can't use the new DBMS_METADATA package. Thanks to a tip from Jared Still ...
    Dennis WilliamsDennis Williams
    Nov 10, 2005 at 8:56 am
    Nov 10, 2005 at 4:39 pm
  • Has anyone ever seen a reason for two tables to have foreign keys on each other (different columns)? I am working with an application in which this is the case on a couple tables. I have not checked ...
    Post, EthanPost, Ethan
    Nov 4, 2005 at 9:36 am
    Nov 6, 2005 at 1:55 pm
  • Hi, Is there a preferred tool/script available to compare schemas. Thanks Meenakshi -- http://www.freelists.org/webpage/oracle-l
    Aggarwal, MeenakshiAggarwal, Meenakshi
    Nov 29, 2005 at 10:45 am
    Nov 30, 2005 at 7:41 am
  • I am running multiple instances on test machine, Windows, 9ir2. Both have SGA of 100m and machine memory is 512 mb. I am getting the following error. C:\DOCUME~1\CMAJMU~1 set ORACLE_SID=chirep ...
    Chirag DBAChirag DBA
    Nov 1, 2005 at 9:45 am
    Nov 7, 2005 at 8:15 am
  • Hi I know this should be fairly simple but I dont seem to get this working. We have all the OS files (control,data, allologs and ini files). but we had to reinstall the OS on the machine. Nothing ...
    Mark JohnMark John
    Nov 28, 2005 at 4:11 am
    Nov 28, 2005 at 10:23 am
  • Redhat 3 ES, 2.4.21-32.0.1.ELsmp, Oracle 10.2.0.1 RAC, OCFS 1.0.12 I run database backups to an ext3 filesystem, using both rman and regular hotbackups on different servers. Linux uses all available ...
    Teehan, MarkTeehan, Mark
    Nov 21, 2005 at 9:38 pm
    Nov 24, 2005 at 3:39 am
  • Hi! Does anybody out there know of clustering software for a failover cluster on Red Hat Linux Enterprise Edition? I am only familiar with Veritas Cluster Server or HP MC/Service Guard. Thanks, ...
    Daiminger, HelmutDaiminger, Helmut
    Nov 18, 2005 at 9:58 am
    Nov 20, 2005 at 4:25 am
  • I want to install OEM 10g for Windows without creating a database. Is it possible the way in 9i. I don't want grid control, management server stuff etc. Thanks Sandeep -- ...
    Sandeep DubeySandeep Dubey
    Nov 8, 2005 at 3:34 pm
    Nov 10, 2005 at 12:35 pm
  • How do you reuse a "page" created in one application with other application? -- http://www.freelists.org/webpage/oracle-l
    Nirmalya DasNirmalya Das
    Nov 28, 2005 at 3:35 pm
    Dec 6, 2005 at 2:47 pm
  • Hi, I've a process which need to do a lot of processing (summaries) on a large set of data. The main flow is as follow: copy the new rows since last run (up to defined row count) to a temporary ...
    Amihay GonenAmihay Gonen
    Nov 30, 2005 at 2:44 am
    Dec 2, 2005 at 10:01 am
  • Hi All OS - XP Oracle - 8i (one of our clients has 8i and doents want to change) I created a simple db throught hte DB config assistant. and was able to login. But once the machine is restarted when ...
    Mark JohnMark John
    Nov 29, 2005 at 1:34 pm
    Nov 30, 2005 at 2:45 pm
  • All, Im having big trouble in a recovery scenario, here is what I have 1, A small shell of a database with all datafiles copied to a backup location (cold backup) 2. Database is in archivelog mode ...
    OrclOrcl
    Nov 27, 2005 at 8:58 am
    Nov 30, 2005 at 6:16 am
  • Hi guys, Just for the first time I was asked to take a look at an Oracle 10g database. The first thing I was upset about is the inability to get the exact sql being executed by the parallel slaves ...
    Khedr, WaleedKhedr, Waleed
    Nov 25, 2005 at 10:59 am
    Nov 26, 2005 at 6:34 pm
  • Hi, please can some body share some rules about running this dbms_stats procedures. In documentation says, you have to run.... but I still don't got, how frequently, or if some background process ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Nov 17, 2005 at 2:33 pm
    Nov 24, 2005 at 12:59 am
  • Hi, Today I had been asked one question : Scenario is : My DB is in noarchive log mode, no backup available, one of the datafile got corrupted say users01.dbf containing one schema TEST. Now can I ...
    Onkar N TiwaryOnkar N Tiwary
    Nov 19, 2005 at 4:56 am
    Nov 20, 2005 at 11:18 pm
  • We're having this issue which started today and we cant get ot the bottom of it looged in as the oracle owner TWO_TASK is unset SQL connect sys_at_dbname as sysdba Enter password: Connected. SQL ...
    Fuad ArshadFuad Arshad
    Nov 17, 2005 at 10:12 am
    Nov 18, 2005 at 6:18 am
  • A co-worker needs to modify a varchar2 column from 100 bytes to 200 bytes in a large table. We think that it will just modify the data dictionary and not do a full table scan. Does anyone know for ...
    Strickland, MarkStrickland, Mark
    Nov 15, 2005 at 5:31 pm
    Nov 17, 2005 at 4:45 am
  • Hi Listers, I need to unload several large database tables unto flat files on a Unix database server. I am using Tom Kyte's SQL*Plus unloader. However, there seems to be a problem when a varchar ...
    D chengD cheng
    Nov 16, 2005 at 6:33 am
    Nov 16, 2005 at 9:28 pm
  • I have database #1 on a server that I want to clone/restore from a cold backup so that it becomes database #2. Database #2 wiill be on the same server as #1 but I want to rename it. Other than ...
    J. DexJ. Dex
    Nov 10, 2005 at 9:02 pm
    Nov 12, 2005 at 4:14 am
  • Hi All, I am working on a sql script to make trace files (10046 traces) available to developers through sqlplus (mixed sun/win environment, oracle 9.2.0.5). I have found several options of which the ...
    Eric BuddelmeijerEric Buddelmeijer
    Nov 10, 2005 at 1:47 pm
    Nov 11, 2005 at 12:38 am
  • Hi, I encountered the demand to store the euro sign. With the current character set impossible. So I have to migrate to a new one. Docs state alter database character set is possible when new ...
    Jeroen van SluisdamJeroen van Sluisdam
    Nov 4, 2005 at 10:17 am
    Nov 8, 2005 at 1:32 am
  • I have an "export" for an Oracle 8.1.7.4 I am "importing" it into an Oracle 10g database. What is the best way to make sure all the objects imported correctly? I usually have problems with ...
    Nirmalya DasNirmalya Das
    Nov 16, 2005 at 10:46 pm
    Nov 17, 2005 at 2:32 pm
  • Either I didn't ask the right question or Barb~ has no clue what RSS is and why it might be useful. Hi Ethan, I'm sorry, but the forums are limited to user input of typed in data and do not have any ...
    Post, EthanPost, Ethan
    Nov 11, 2005 at 12:29 pm
    Nov 15, 2005 at 10:36 am
  • Hi, upgrade manual says Initialization Parameters Deprecated in Release 10.2 The following initialization parameters were deprecated in release 10.2: LOGMNR_MAX_PERSISTENT_SESSIONS ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Nov 11, 2005 at 6:35 am
    Nov 11, 2005 at 9:57 am
  • hi guys, I have installed oracle 9i on windows many times but this time its giving a lot of problems. when i am trying to run setup.exe from the location(irrespective of cd or s/w copied on hard ...
    Onkar N TiwaryOnkar N Tiwary
    Nov 4, 2005 at 12:45 am
    Nov 10, 2005 at 11:02 pm
  • For index we can monitor the index and find out if it's been used. Other than adding custom code to the stored procedure to track it's execution, is there any other way to do it without modifying it? ...
    San SridharanSan Sridharan
    Nov 9, 2005 at 6:29 pm
    Nov 10, 2005 at 1:22 pm
  • Hi guys, Since today morning I am facing one problem : ORA-12547 : TNS lost contact when i re-started my server, i worked for couple of seconds and then again i was getting the same error. I searched ...
    Onkar N TiwaryOnkar N Tiwary
    Nov 9, 2005 at 6:22 am
    Nov 10, 2005 at 11:56 am
  • We are in the process of configuring a disaster recovery system for four small Oracle instances. Our approach will be to install Oracle on the box, restore backups of the production databases for ...
    Schauss, PeterSchauss, Peter
    Nov 4, 2005 at 1:42 pm
    Nov 8, 2005 at 9:35 pm
  • Hi Team, We recieve data from various sources in lower,upper case. We want all the data to be stored in upper case in the table. The whole data will be loaded using sqlloader. Is there any way toload ...
    Raja raoRaja rao
    Nov 5, 2005 at 6:19 pm
    Nov 8, 2005 at 8:18 am
  • Just got the following link from an E-week news message. Think all of us will be interested. http://lists.grok.org.uk/pipermail/full-disclosure/2005-October/038290.h tml Or: http://tinyurl.com/9so5f ...
    Goulet, DickGoulet, Dick
    Nov 3, 2005 at 2:40 pm
    Nov 5, 2005 at 3:43 am
  • Hi, One of my friends wanted to take the training in "Oracle DBA for beginners". He is a SQL Server DBA. Does any one know good training centers in and around Manhattan,NY or in New ...
    Subbiah, NagarajanSubbiah, Nagarajan
    Nov 29, 2005 at 12:37 pm
    Nov 30, 2005 at 7:32 am
  • I have been reviewing the white papers for the DBFlash product from CONFIO. I am impressed, but I do have one reservation. DBFlash works by running a SQL statement (or group of statements) against X$ ...
    Sam BootsmaSam Bootsma
    Nov 16, 2005 at 4:22 pm
    Nov 18, 2005 at 2:28 pm
  • Folks, While doing Application Testing of Hybrid Trans (OLTP mostly though) by 200 users (approx) on a NEWLY configured HITACHI SAN Storage, on DB Server (of AIX) High wait for IO i.e. wio = 70 % ...
    VIVEK_SHARMAVIVEK_SHARMA
    Nov 11, 2005 at 1:01 pm
    Nov 16, 2005 at 2:43 am
Nov 2005
1234
Group Navigation
period‹ prev | Nov 2005 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions191
posts930
users226
websiteoracle.com

226 users for November 2005

Juan Carlos Reyes Pacheco: 39 posts Jared Still: 21 posts Kevin Closson: 20 posts Radoulov, Dimitre: 19 posts David Sharples: 18 posts Alex Gorbachev: 17 posts Dennis Williams: 17 posts Marquez, Chris: 17 posts Post, Ethan: 17 posts Yechiel Adar: 16 posts Goulet, Dick: 15 posts MARK BRINSMEAD: 15 posts Thomas Day: 15 posts Bobak, Mark: 14 posts Onkar N Tiwary: 14 posts Oracle-l-bounce_at_freelists.org: 14 posts Ray Stell: 14 posts Jonathan Lewis: 13 posts Norman Dunbar: 13 posts Pete Sharman: 12 posts
show more
Archives