FAQ

Search Discussions

288 discussions - 1,617 posts

  • Hi again, I've been reading the "Database Data Warehousing Guide" and just wonder if there's anything else needed (other than licensing;-) to implement partitioning. Is it just done by adding ...
    BPBP
    Oct 11, 2005 at 3:31 pm
    Oct 24, 2005 at 10:08 am
  • Hi TO ALL I have a doubt. Plz do reply. We have an Oracle 10g R1 db running here. we have 5 datafiles of 2 gb each. Now we use Oracle Forms as front end. Now as the daily transactions carry on i want ...
    Computer centreComputer centre
    Oct 18, 2005 at 3:56 am
    Oct 22, 2005 at 10:31 am
  • one more question: It is frequently said here that Linux is not ready for production. ( i used to laugh out load at this; i'm learning to control my giggles but i've about bitten a hole in my tongue) ...
    RobynRobyn
    Oct 7, 2005 at 9:12 am
    Oct 11, 2005 at 11:23 pm
  • I just received a notice from our technical team leader that we were going to schedule a 'refresh' on our transactional database in order to improve performance. They are going to truncate and ...
    Freeman, DonaldFreeman, Donald
    Oct 26, 2005 at 9:43 am
    Oct 28, 2005 at 12:09 pm
  • Hi All, I have consulting on site and he is trying to convince our management to use AUTOEXTEND almost on all datafiles and monitor on FS. Could you give me examples why we should not do AUTOEXTENTS? ...
    Ora_forumOra_forum
    Oct 4, 2005 at 2:11 pm
    Oct 5, 2005 at 9:37 am
  • Anyone seen their workload reduced due to unstructured data? Death of the database As improvements in networking technologies lead to real-time connectivity to any data, that data will be best kept ...
    Jared StillJared Still
    Oct 24, 2005 at 9:46 am
    Oct 31, 2005 at 1:15 pm
  • Hi All, I have several dbms_jobs scheduled and have had them there for a long time. Tuesday they stopped being executed on appointed times. I've looked in Metalink, but have not found anything. I ...
    Magnus AndersenMagnus Andersen
    Oct 27, 2005 at 8:34 am
    Oct 29, 2005 at 6:06 am
  • Everyone, We have a fairly large, truly mission critical database (Oracle 9.2.0.6) at a remote site that is currently running on Microsoft. In the past, others have tried to convince mgmt that the ...
    RobynRobyn
    Oct 6, 2005 at 5:01 pm
    Oct 7, 2005 at 9:31 pm
  • Hi All, I am observing lot of WIO when did a sar -u 2 5 $ sar -u 2 5 SunOS oracle 5.9 Generic_117171-02 sun4u 10/24/2005 09:37:54 %usr %sys %wio %idle 09:37:56 0 1 86 12 09:37:58 0 1 89 9 09:38:00 0 ...
    Raja raoRaja rao
    Oct 24, 2005 at 9:04 am
    Oct 25, 2005 at 10:15 am
  • We are looking at migrating to Linux from Windows and was wondering which version of Linux is the most popular/preferred. Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit ...
    Jeffrey BeckstromJeffrey Beckstrom
    Oct 28, 2005 at 11:01 am
    Oct 31, 2005 at 4:14 pm
  • Hello: I have a question about enqueues, we have oracle 9.2.0.6 on a HP UX.. here is a extract on an statspack report Top 5 Timed Events ~~~~~~~~~~~~~~~~~~ % Total Event Waits Time (s) Ela Time ...
    Alfonso LeónAlfonso León
    Oct 20, 2005 at 10:05 am
    Oct 28, 2005 at 7:09 am
  • I am getting ready to apply a patch to our databases and before doing so I need to test our RMAN backups to make sure I can get them all back in case there's a problem. Plus, it's just good practice ...
    Vanessa A. SimmonsVanessa A. Simmons
    Oct 13, 2005 at 7:52 am
    Oct 25, 2005 at 2:36 pm
  • Friends, My mgmt. has decided to move our datawarehouse, around 1.5 TB from AIX server to HP-SUPERDOM. We are using oracle 9i and only export and import possible, I believe. This database has around ...
    The Human FlyThe Human Fly
    Oct 12, 2005 at 5:26 am
    Oct 14, 2005 at 4:29 am
  • Hi, meanwhile we do always a immediate shutdown. We have decided not to backup temp neither undo tablespaces in a full backup we get periodically. Because it can be easily recreated. Does anyone has ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Oct 12, 2005 at 11:27 am
    Oct 13, 2005 at 6:42 pm
  • All, We�re trying to install Oracle 9iR2 on RHLinux8.0 box. After completing all pre-installations task, we invoked the runInstaller to start the install process. During the installation process, the ...
    Prabhu, KPrabhu, K
    Oct 16, 2005 at 11:59 pm
    Nov 9, 2005 at 10:08 am
  • Folks Need to groom a team of DBAs for internal performance Benchmarks of our product. This would involve grooming some existing as well as new software professionals having a few years of working ...
    VIVEK_SHARMAVIVEK_SHARMA
    Oct 10, 2005 at 11:25 am
    Oct 11, 2005 at 10:13 am
  • Oracle 10.2 on Windows I am playing with this and did a default install of the sample database. I was very surprised to find the admin and oradata trees under ORACLE\PRODUCT\10.2.0. Is there any ...
    Sarah SatterthwaiteSarah Satterthwaite
    Oct 5, 2005 at 2:18 pm
    Oct 6, 2005 at 1:16 pm
  • Hi, To speed process on my personal computer, ONLY FOR MY TESTING DATABASE, I want to use _disable_logging parameter. How much can I expect to save in time using it. Thank you in advance. -- ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Oct 7, 2005 at 8:48 am
    Nov 24, 2005 at 5:08 pm
  • Guys, I was in a meeting yesterday with a vendor who told me (and my manager) their product running on 10gr1 does not need any DBA intervention when used because they are using automatic memory ...
    Reidy, RonReidy, Ron
    Oct 20, 2005 at 11:17 am
    Oct 21, 2005 at 3:27 am
  • hi, all, Recently we have a SQL changed the plan, without any init parameter change, and table analyze. Oracle version is 9.2.0.5, and optimizer_mode=rule. Tables are not analyzed, but we have a ...
    Zhu chaoZhu chao
    Oct 13, 2005 at 8:10 am
    Oct 14, 2005 at 6:27 am
  • Hi I'm trying to get a variable from windows from a bat file but I cant. I had check the reg.exe utility but this give you more data than needed reg query ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Oct 11, 2005 at 11:05 am
    Oct 12, 2005 at 5:14 pm
  • from bugtraq: Having downloaded and given the Oracle October patch a cursory examination, some of the flaws Oracle told me were being fixed, remain exploitable. Once again the patch is not ...
    Ray StellRay Stell
    Oct 19, 2005 at 5:59 pm
    Oct 31, 2005 at 6:38 am
  • RHEL3ES Oracle 9205 OK, I have a new nfs mount on 3 db servers; dbA, dbB, dbC. All the these server need to fully share the files. 2 of the 3 servers (dbA, dbB) oracle OS users has the same gid and ...
    Marquez, ChrisMarquez, Chris
    Oct 5, 2005 at 11:22 am
    Oct 12, 2005 at 1:28 pm
  • Hi Again, I have a meeting tomorrow with one of our project managers who is going to request a new schema or database. He wants my advice on which is best for his needs. Now...as I've said before I'm ...
    BPBP
    Oct 5, 2005 at 4:11 pm
    Oct 9, 2005 at 5:14 am
  • Does anybody have good profiler ? Regards, Ranko. -- http://www.freelists.org/webpage/oracle-l
    Ranko MosicRanko Mosic
    Oct 21, 2005 at 2:49 pm
    Oct 23, 2005 at 11:42 pm
  • [Oracle 10g Enterprise on AIX 5L] Hi Everyone, It's me the neophyte dba again...I'm eager to patch our db's from 10.1.0.2 to 10.1.0.4, with the later being a prereq for the July 2005 Critical patch ...
    BPBP
    Oct 19, 2005 at 8:26 am
    Oct 19, 2005 at 12:47 pm
  • Hi, I want to enforce a business rule on two columns such that col1, col2 should be unique. However for a given value of col1 nulls should be allowed in col2. I can not implement that using a simple ...
    Sandeep DubeySandeep Dubey
    Oct 18, 2005 at 12:08 pm
    Oct 18, 2005 at 4:29 pm
  • Hi, Oracle 9.2.0.5 <http://9.2.0.5 on AIX Partitioned table ( list) ~ 10 mil rows in all distibuted almost equally across 5 partitions field1 ( used in the query) is not the PK. My autotrace ( ...
    Sanjay MadanSanjay Madan
    Oct 14, 2005 at 6:03 am
    Oct 18, 2005 at 12:13 am
  • Hi All, When I created a pfile from spfile the pfile has lines like the following.... *.background_dump_dest='?\admin\ I have a few doubts regarding that. 1 Why **.* is there before each line. 2 Why ...
    DBA DeepakDBA Deepak
    Oct 17, 2005 at 6:15 am
    Oct 17, 2005 at 7:42 am
  • We are considering using "resync" to copy our archive log files to a remote machine. I am particular interested in anybodies experiences using this method, are there any pitfalls in using this ...
    Peter DixonPeter Dixon
    Oct 5, 2005 at 4:14 am
    Oct 11, 2005 at 7:14 pm
  • AHHH, the old Mladen is finally back!!;-) From: oracle-l-bounce_at_freelists.org On Behalf Of Gogala, Mladen Sent: Monday, October 03, 2005 12:11 PM To: 'Chirag DBA'; Gogala, Mladen Cc: Oracle-L ...
    Goulet, DickGoulet, Dick
    Oct 3, 2005 at 2:18 pm
    Oct 4, 2005 at 3:55 pm
  • When creating a controlfile from a trace file, is this wording simply removed or altered: RECOVER DATABASE ALTER SYSTEM ARCHIVE LOG ALL; I have changed the other info to read �CREATE CONTROLFILE ...
    J. DexJ. Dex
    Oct 4, 2005 at 8:41 am
    Oct 4, 2005 at 3:46 pm
  • List, I am starting to manage Oracle databases in a Solaris cluster managed by Veritas Cluster Server (VCS). Has anyone seen some type of training guide for an Oracle DBA in this environment? Dennis ...
    Dennis WilliamsDennis Williams
    Oct 6, 2005 at 3:50 pm
    Oct 10, 2005 at 4:01 pm
  • Hi I changed my SGA size from 300mb to 1.5GB. Users are getting ora-03113 end-of-file comminication channed. Got this error after starting the Database. It is 9.2.0.2 <http://9.2.0.2 on solaris ...
    Chirag DBAChirag DBA
    Oct 5, 2005 at 12:02 pm
    Oct 5, 2005 at 2:16 pm
  • Hi, I am changing the name of user in USER$ table. SQL select user#,name from user$ where name like 'SCO%'; USER# NAME ---------- ------------------------------ 59 SCOTT 64 SCOTT1 SQL update user$ ...
    Chirag DBAChirag DBA
    Oct 1, 2005 at 11:01 am
    Oct 2, 2005 at 6:17 am
  • Not wishing to drag this way off topic.... In all seriousness is this the general perception of contractors across the globe? That we are a tolerated resource but ideally the world might be a better ...
    Johnson, GeorgeJohnson, George
    Oct 28, 2005 at 11:14 am
    Nov 3, 2005 at 12:13 pm
  • Brian, Yes we can write files on the NFS mount, and the syslogs have nothing in them. But the DB sure is having a pile of fun with it. Alter log says it's creating the archive log, but nothing shows ...
    Goulet, DickGoulet, Dick
    Oct 31, 2005 at 10:51 am
    Nov 1, 2005 at 9:04 am
  • Is it just me or are the postings for the last few days coming through again ? I seem to have a huge number of emails coming in and I've already seen them. Just wondering. Cheers, Norm. Norman ...
    Norman DunbarNorman Dunbar
    Oct 25, 2005 at 5:53 am
    Oct 27, 2005 at 7:16 pm
  • A list, Signal-to-Noise Ratio proposal... The absolute best list I ever saw envolved with was the DEC alpha managers list. It was operated in a completely different way, no fluff, ever, period. Even ...
    Ray StellRay Stell
    Oct 21, 2005 at 4:26 pm
    Oct 26, 2005 at 5:03 pm
  • Hi, Has anyone had dealings with the License Management Services (LMS) group at Oracle? LMS contacted our company saying that they want to audit our usage of Oracle software. Has anyone been audited ...
    David GrosserDavid Grosser
    Oct 17, 2005 at 9:35 am
    Oct 17, 2005 at 12:38 pm
  • I have started my Database with pfile and now want to create spfile. I am using create spfile='location' from pfile; When I see the audit parameters in pfile, it is AUDIT_TRAIL=DB, but in SPFILE it ...
    Chirag DBAChirag DBA
    Oct 12, 2005 at 8:50 am
    Oct 12, 2005 at 10:28 am
  • Hi Gurus, Is anybody facing this weird problem shown as below in 10.1 SID SQL_ADDRESS EVENT ---------- ---------------- ----------------------- 5068 C00000052B3E9BC8 log file sync 5074 00 SQL*Net ...
    Arun chakrapani raoArun chakrapani rao
    Oct 4, 2005 at 9:54 am
    Oct 10, 2005 at 3:05 am
  • Folks During a Benchmark the CPUs are NOT getting consumed at certain stages during the run in ALL DB, APP & Web Servers. NOTE - APP server contains OLTP nature of transactions pertaining to Banking ...
    VIVEK_SHARMAVIVEK_SHARMA
    Oct 4, 2005 at 12:03 pm
    Oct 5, 2005 at 10:16 am
  • Hi I'm trying to install in my computer windows xp, with only 256 megabytes of memory, and an alerts says there is not enough memory and installation stops. Somethign interesting is the fact it don't ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Oct 31, 2005 at 3:16 pm
    Nov 3, 2005 at 6:25 am
  • HI All, My simple select statemnt is giving improper results from a table which has only 1 row. The below is the case: SQL select hospital_id from image_staging_table; HOSPITAL_ID ASHFORD SQL select ...
    Raja raoRaja rao
    Oct 28, 2005 at 2:16 am
    Oct 28, 2005 at 8:14 am
  • Hi all, I'm trying to setup snapshots to run every 15 minutes during working hours, else hourly. I'm ignoring weekends for now,... Origonally I tried: var job number; begin sys.dbms_job.submit( job = ...
    T_adolph_at_hotmail.comT_adolph_at_hotmail.com
    Oct 26, 2005 at 9:16 am
    Oct 27, 2005 at 8:34 am
  • For interpreting Statspack reports? Any ideas or favorites? -- http://www.freelists.org/webpage/oracle-l
    Hollis, LesHollis, Les
    Oct 16, 2005 at 12:56 am
    Oct 24, 2005 at 12:52 pm
  • We are running with about 500 concurrent users. O racle Version 9.2.0.6 Solaris 2.9 0RA-1000 "Too many open cursors" error when selecting from a sequence over a dblink. Metalink Note:238407.1 ...
    Paula_Stankus_at_doh.state.fl.usPaula_Stankus_at_doh.state.fl.us
    Oct 17, 2005 at 3:08 pm
    Oct 21, 2005 at 11:45 pm
  • Hi, I am having weekend hangover with seemingly simple sql requirement. create table t(id number); insert into t values(1); insert into t values(2); commit; I want to query this with an Id set. All ...
    Sandeep DubeySandeep Dubey
    Oct 10, 2005 at 10:55 am
    Oct 21, 2005 at 2:58 pm
  • Hi, I have a table under replication and corrupted with duplicates. I cannot do any update/delete operation on the table since it needs a primary key. I cannot create a primary key since duplicates ...
    A JoshiA Joshi
    Oct 19, 2005 at 1:02 pm
    Oct 21, 2005 at 2:18 am
Group Navigation
period‹ prev | Oct 2005 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions288
posts1,617
users263
websiteoracle.com

263 users for October 2005

Marquez, Chris: 64 posts Mladen Gogala: 42 posts Goulet, Dick: 41 posts Jared Still: 41 posts David Sharples: 40 posts Paul Drake: 36 posts Oracle-l-bounce_at_freelists.org: 34 posts Juan Carlos Reyes Pacheco: 33 posts Radoulov, Dimitre: 33 posts Mercadante, Thomas F (LABOR): 31 posts Zhu chao: 30 posts Rjamya: 29 posts Chirag DBA: 26 posts Yechiel Adar: 26 posts Raja rao: 24 posts Richard Ji: 24 posts Christian Antognini: 23 posts Mladen Gogala: 23 posts Niall Litchfield: 23 posts Kevin Closson: 22 posts
show more
Archives