FAQ

Search Discussions

500 discussions - 2,460 posts

  • Front page of this weeks Computer Weekly, announcing Microsoft 64-bit SQL Server.... Large databases which use more than 4Gb of data run more efficiently on 64-bit systems I wonder what MS calls 4 TB ...
    Jonathan LewisJonathan Lewis
    Apr 15, 2003 at 4:28 pm
    Apr 18, 2003 at 7:51 pm
  • I know I've heard several comments indicating that some of you are attending IOUG Live next week. Anyone else interested in a list get together? Maybe Monday night 7ish? Stephen Andert -- Please see ...
    Stephen AndertStephen Andert
    Apr 22, 2003 at 4:32 pm
    Apr 26, 2003 at 5:06 pm
  • I have one Oracle instance which supports an application server which always maintains a database connection. The UNIX system administrator tells me that this instance always hangs when she tries to ...
    Schauss, PeterSchauss, Peter
    Apr 2, 2003 at 3:03 pm
    Apr 7, 2003 at 8:08 am
  • We have a consultant doing some work at our site and he claims that in most shops the DBA's have the responsibility of tuning duhvelopers code. I find that hard to believe. I was wondering if maybe I ...
    IT - Database (Do Not Use)IT - Database (Do Not Use)
    Apr 14, 2003 at 5:29 pm
    Apr 16, 2003 at 8:29 pm
  • Okay ... For a critical system, we have max_open_cursors set to 1024, but developers complained that they are getting number of open cursors exceeded at times. So a fellow DBA bumped it to 3000 ...
    Jamadagni, RajendraJamadagni, Rajendra
    Apr 8, 2003 at 1:39 pm
    Apr 9, 2003 at 11:58 pm
  • I am out of office until 5/5. I am not reacheable by pager. I will be checking my voice mail and e-mail at least daily. Hi, Im looking for a Java or PLSQL dev list, any suggestions? TIA Gabriel "Any ...
    Stephen AndertStephen Andert
    Apr 29, 2003 at 12:51 am
    Apr 29, 2003 at 6:02 am
  • We are in the midst of pondering a move from HP Unix (HP/UX) to WIN2K and upgrading Oracle 7.3.4 to 9iR2. I would like opinions from people on the merits or problems with supporting/administering ...
    David davisDavid davis
    Apr 24, 2003 at 8:41 pm
    Apr 28, 2003 at 3:30 pm
  • Dear Ann (hehe), Previous to this assignment I have been considered to be principled about technology but reasonable and pragmatic. At this assignment I was given a big send up and there were some ...
    Paula_Stankus_at_doh.state.fl.usPaula_Stankus_at_doh.state.fl.us
    Apr 6, 2003 at 7:28 pm
    Apr 9, 2003 at 9:39 pm
  • Hello, How does the list feel about providing developers access to ad-hoc/real-time, problem solving diagnostics tool such as Spotlight, Mamba etc. to developers to provide first-line support. I'm ...
    Shamita & Chiran GhoshShamita & Chiran Ghosh
    Apr 16, 2003 at 5:58 am
    Apr 18, 2003 at 5:57 pm
  • Hi Listers, I am in the process of setting up a new Oracle database on 9.2.0.3.0. I want to use locally managed tablespaces, but im not sure about the extent and segment management options. Should I ...
    Ceri TownsendCeri Townsend
    Apr 11, 2003 at 2:37 pm
    Apr 18, 2003 at 2:11 am
  • Hello, Is anyonw aware of performace issues related to setting too many OEM (9.2.0.1) events ??? At the site that I am currently at, they have the following events set on all production databases ...
    Sunny VergheseSunny Verghese
    Apr 13, 2003 at 4:43 pm
    Apr 17, 2003 at 11:26 pm
  • Has anyone been able to make direct SGA access work for 64 bit databases? My C knowledge is as good as my lisp knowledge, i.e. just about zero. I tried playing with the xksuse.c, but all it does is ...
    Jamadagni, RajendraJamadagni, Rajendra
    Apr 10, 2003 at 9:38 pm
    Apr 14, 2003 at 2:49 pm
  • Dear All, is there any way to find which tables (table name) are suffering from full table scan,so that i can create indexes on them to enhance the performance. Thanks Arvind -- Please see the ...
    Arvind KumarArvind Kumar
    Apr 3, 2003 at 4:58 am
    Apr 4, 2003 at 5:29 pm
  • I'm sure that most of you have seen various claims along the lines of: Oracle will use an for a query that access less than X% of the rows. X is usually given as something in the region of 2% to 5% ...
    Jonathan LewisJonathan Lewis
    Apr 24, 2003 at 9:21 pm
    Apr 27, 2003 at 7:26 am
  • I am out of office until 5/5. I am not reacheable by pager. I will be checking my voice mail and e-mail at least daily. Hamid Consider using the RR date format. The YY format assumes your date is in ...
    Stephen AndertStephen Andert
    Apr 29, 2003 at 1:11 am
    Apr 29, 2003 at 5:57 am
  • Hi List, I would like your views on migrating from Microsoft Access to Oracle8i. Folloing is one of the scenarios that we might come across. There are columns in table need to insert as a row. e.g ...
    Sam dSam d
    Apr 9, 2003 at 5:33 am
    Apr 11, 2003 at 11:48 pm
  • Dear All Can anyone of u throw light on how remote dbas work. I would appreaciate if any whitepaper / document on this topic is sent to me directly at rpapnoi_at_vsnl.net or rpapnoi_at_hotmail.com ...
    Ramesh PapnoiRamesh Papnoi
    Apr 2, 2003 at 8:34 pm
    Apr 7, 2003 at 4:53 pm
  • How can I find out if an import is dead or alive? I have an import of 1.6M+ rows that's been running for over 45 minutes. Oracle 8.1.7.0.0 AIX 4.3.3 What can I check? Thanks, Saira -- Please see the ...
    Saira SomaniSaira Somani
    Apr 30, 2003 at 2:06 pm
    Apr 30, 2003 at 7:31 pm
  • Has anyone benchmarked external tables versus sqlldr for loading data? Before I start using external tables I thought I'd see if it was worth my time. Dave -- Please see the official ORACLE-L FAQ ...
    David TurnerDavid Turner
    Apr 23, 2003 at 10:31 pm
    Apr 25, 2003 at 7:08 pm
  • Hey all, One of our 3rd-party vendors has a query from a Win2K executable (possibly Pro*C) going against 8.1.7.2.0 on Solaris 2.8. OK so far. The problem is that sometimes the query has upwards of ...
    Jesse, RichJesse, Rich
    Apr 10, 2003 at 4:48 pm
    Apr 11, 2003 at 4:33 pm
  • http://searchdatabase.techtarget.com/originalContent/0,289142,sid13_gci893031,00.html Ray Stell stellr_at_vt.edu (540) 231-4109 KE4TJC 28^D -- Please see the official ORACLE-L FAQ ...
    Ray StellRay Stell
    Apr 14, 2003 at 2:48 pm
    Apr 16, 2003 at 8:59 pm
  • The tables that didn't create all contain LOB's. The tables without LOBs created with no problems. CREATE TABLE ........... TABLESPACE "SYSTEM" ENABLE STORAGE IN ROW CHUNK 4096 P" "CTVERSION 10 ...
    Godlewski, MelissaGodlewski, Melissa
    Apr 15, 2003 at 3:03 am
    Apr 16, 2003 at 5:18 pm
  • I think I am having problems with my redologs. Under normal circumstances no errors arise, but if I do a massive import of data as I was doing last night, this is what alertSID.log shows from time to ...
    Fermin Bernaus BerraondoFermin Bernaus Berraondo
    Apr 3, 2003 at 8:03 am
    Apr 8, 2003 at 5:08 am
  • Question: If some idiot decides to circumvent Oracle's referential integrity and re-implement it by using triggers (insert, update, delete) that checks the foreign (parent/child) key fields in other ...
    DEEDSD_at_Nationwide.comDEEDSD_at_Nationwide.com
    Apr 1, 2003 at 5:48 pm
    Apr 7, 2003 at 4:28 am
  • Hi all, we have bought the hardware already so it has been decided but where we are able to influence is the OS should I start using Linux or W2K when I will have three instances with total size upto ...
    Joshua BeckerJoshua Becker
    Apr 24, 2003 at 6:11 am
    Apr 25, 2003 at 9:56 pm
  • Hi. Manager and myself were debating over this issues for quite few days now.... We were planning to hire a junior DBA, but Oracle Sales repersentatives are justifying us that we dont need one, as ...
    Arun AnnamalaiArun Annamalai
    Apr 15, 2003 at 6:58 pm
    Apr 16, 2003 at 8:54 pm
  • Our RMAN backup is backing up much more than the actual data blocks when doing a full backup. I know that it backs up all blocks that have "ever been used", but I'm trying to figure out exactly what ...
    Keith MooreKeith Moore
    Apr 3, 2003 at 4:43 pm
    Apr 7, 2003 at 11:03 am
  • For a 400 GB tablespace, which one is better? 200 2GB datafiles 100 4GB datafiles 50 8GB datafiles 25 16GB datafiles [64-bit Oracle 9i on Solaris 9] Thanks, This email has been scanned for all ...
    Roger XuRoger Xu
    Apr 28, 2003 at 9:01 pm
    Apr 30, 2003 at 9:26 pm
  • what is equivalent of "tail -f " in windoz ? -ak -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: AK INET: oramagic_at_hotmail.com Fat City Network Services -- 858-538-5051 ...
    AKAK
    Apr 24, 2003 at 12:01 am
    Apr 25, 2003 at 12:08 am
  • Here's a question that came up around here that nobody was sure about. Suppose you need to drop and index on a busy table, and you keep getting the "Resource busy .... " error. So you create a ...
    Stephen LeeStephen Lee
    Apr 15, 2003 at 8:09 pm
    Apr 16, 2003 at 6:53 pm
  • Hash_Area_Size runtime 10,000,000 6:16 ( 6+ mins ) 1,000,000 0:15 ( 16 secs) Why? Isn't bigger always better for hash_area_size? Is another param affected? That's the only param that changed, via ...
    Chris BarrChris Barr
    Apr 8, 2003 at 4:43 am
    Apr 15, 2003 at 2:14 pm
  • Hey all, Just upgraded a 3rd-party app's DB from 8.1.6.0.0 to 32-bit 8.1.7.2.0 on 64-bit Solaris. The Oracle install was not standard -- it was "installed" (i.e. files just copied to $ORACLE_HOME) by ...
    Jesse, RichJesse, Rich
    Apr 7, 2003 at 8:16 pm
    Apr 9, 2003 at 7:24 pm
  • Hi all Some time ago there was a discussion about the use of the different extent management types and that if my memory serves me that there was a perception that Auto allocate extents had some ...
    Peter.McLarty_at_mincom.comPeter.McLarty_at_mincom.com
    Apr 3, 2003 at 4:03 am
    Apr 5, 2003 at 1:28 am
  • Does anyone have a solution to bulk binding in Native Dynamic sql? I'm currently using an Open For Using statement which seems to nullify any possibility of using bulk collect in the fetch ...
    Mark MoynahanMark Moynahan
    Apr 17, 2003 at 5:57 pm
    Apr 18, 2003 at 5:52 pm
  • I am trying to format a find command to delete files older than n days. The command is in a script and incorporates the ORACLE_SID variable. I can't get the command to work with the first part of the ...
    Smith, Ron L.Smith, Ron L.
    Apr 10, 2003 at 2:58 pm
    Apr 10, 2003 at 7:04 pm
  • Hi List, We all need to kill the user sessions in the situations of locking or sometime on end user / application support person's request . I would like to know best practices followed before ...
    Reddy, MadhusudanaReddy, Madhusudana
    Apr 4, 2003 at 4:33 pm
    Apr 9, 2003 at 8:34 pm
  • We are in the process of moving from traditional hot backups to one using RMAN. Total databases are around 200+. Should we be using 1 or few RMAN catalogs, or 1 catalog per database? Thanks, Deepak
    Deepak SharmaDeepak Sharma
    Apr 4, 2003 at 8:08 pm
    Apr 8, 2003 at 8:03 am
  • Hey all, Fighting with a lot of ORA-1555s lately on 8.1.7.4 on HP/UX. Most of them are now coming from long-running Business Objects (B.O.) queries against our OLTP DB. I think I need to recreate the ...
    Jesse, RichJesse, Rich
    Apr 4, 2003 at 4:53 pm
    Apr 7, 2003 at 8:50 pm
  • MYSQL BECOMES ENTERPRISE-WORTHY | eWEEK MySQL AB is a well-respected open-source database, used by many devotees. Developers have added many new features in version 5, which they hope will make it ...
    Goulet, DickGoulet, Dick
    Apr 22, 2003 at 5:47 pm
    Apr 23, 2003 at 9:26 pm
  • I want to mess around at home and dont want to be bothered with designer. Are there any free or cheap data modelling tools? I dont need a corporate license. I dont need alot of functionality. Just ...
    RyanRyan
    Apr 19, 2003 at 8:06 pm
    Apr 21, 2003 at 8:27 pm
  • I'm currently involved in a discussion about the virtues of backups to disk AND to tape of production databases. I'm for the idea, and there are others who are only wanting to backup to disk, and ...
    Freeman Robert - ILFreeman Robert - IL
    Apr 16, 2003 at 9:30 pm
    Apr 17, 2003 at 8:32 pm
  • List, I have a problem when I do a full import into an instance that I just made. No matter what size I make the "DIAMOND" tablespace ( or datafile) I seem to always get an ORA-1658 or ORA-1659. I ...
    Ehresmann, DavidEhresmann, David
    Apr 15, 2003 at 7:33 pm
    Apr 16, 2003 at 9:39 pm
  • Paula, I work in a similiar environment (DOD Civilian project), and have seen all you listed on a daily basis. When I had a major malfunction with one particular individual, I ended up requesting a ...
    Scott.Shafer_at_dcpds.cpms.osd.milScott.Shafer_at_dcpds.cpms.osd.mil
    Apr 7, 2003 at 5:23 pm
    Apr 10, 2003 at 4:13 pm
  • Hi Gurus, I am having trouble getting connected as sys to a remote database. In Oracle8i, I used use the following: sqlplus sys/password_at_Remote_db With Oracle9i, I have to login using "as sysdba" ...
    CSP2201_at_netscape.netCSP2201_at_netscape.net
    Apr 9, 2003 at 5:58 pm
    Apr 9, 2003 at 8:53 pm
  • I am out of office until 5/5. I am not reacheable by pager. I will be checking my voice mail and e-mail at least daily. Roger This is an extra-cost option available only with Oracle Enterprise ...
    Stephen AndertStephen Andert
    Apr 29, 2003 at 1:37 am
    Apr 29, 2003 at 5:49 am
  • What's the best way to determine the optimal tablespace blocksize? Ray Stell stellr_at_vt.edu (540) 231-4109 KE4TJC 28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray ...
    Ray StellRay Stell
    Apr 22, 2003 at 2:31 pm
    Apr 22, 2003 at 8:42 pm
  • It was the best of times, it was the worst of times... Server A: Linux version 2.4.18-3smp (Red Hat Linux 7.3 2.96-110) 2GB of RAM 2 CPU's Intel Pentium 3 846 MHz with 256K cache Oracle 9.2 tkprof ...
    Orr, SteveOrr, Steve
    Apr 8, 2003 at 1:43 am
    Apr 11, 2003 at 9:48 pm
  • Hi Everyone For some time now I have been trying to update my website to include links to the many Oracle security white papers, articles and presentations and info that I have collected over the ...
    Pete FinniganPete Finnigan
    Apr 7, 2003 at 5:43 pm
    Apr 9, 2003 at 12:53 am
  • All this discussion on shutdown does motivate me to ask why is everyone shutting down so frequently? Almost without exception my ideal for any oracle database is never shut it down if you really do ...
    Connor McDonaldConnor McDonald
    Apr 4, 2003 at 2:58 am
    Apr 4, 2003 at 8:08 pm
  • Qs.1 Why is NO excessive Redo Generated wsing RMAN Backups unlike HOT Backups when taking backup of an OPEN Database which is undergoing User Transactions ? (Or am i mistaken ?) Qs.2 How does RMAN ...
    VIVEK_SHARMAVIVEK_SHARMA
    Apr 1, 2003 at 3:18 pm
    Apr 3, 2003 at 5:28 pm
Group Navigation
period‹ prev | Apr 2003 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions500
posts2,460
users337
websiteoracle.com

337 users for April 2003

DENNIS WILLIAMS: 114 posts Stephen Andert: 110 posts Jared.Still_at_radisys.com: 79 posts Goulet, Dick: 75 posts Rachel Carmichael: 56 posts Jamadagni, Rajendra: 55 posts Jonathan Lewis: 49 posts AK: 46 posts Jacques Kilchoer: 41 posts Jesse, Rich: 38 posts Paula_Stankus_at_doh.state.fl.us: 35 posts Stephane Paquette: 35 posts Gogala, Mladen: 30 posts Hemant K Chitale: 29 posts Igor Neyman: 29 posts Chris Berry: 28 posts Ray Stell: 27 posts Orr, Steve: 26 posts Wolfgang Breitling: 26 posts Nelson, Allan: 25 posts
show more
Archives