Search Discussions

143 discussions - 760 posts

  • i was talking to someone about this today. I cannot remember where in the Concepts document that it says that separating data from indexes improves performances? -- ...
    Rick RickyRick Ricky
    May 15, 2008 at 6:17 pm
    May 19, 2008 at 7:29 pm
  • The Defense Travel System (DTS) is attempting to move to database independence. Last I read a few years ago they spent $600 million on this application up to that point. I'm sure its alot higher ...
    Rick RickyRick Ricky
    May 7, 2008 at 3:21 pm
    May 14, 2008 at 3:28 am
  • I have a session on a development system that is waiting on 'db file sequential read'. It has been waiting for ~6000 seconds (state=WAITING). File# (p1) is 201, yet the database only has file#'s from ...
    Henry PorasHenry Poras
    May 15, 2008 at 9:57 pm
    May 20, 2008 at 4:17 am
  • Note: forwarded message attached. Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. attached mail follows: Not just the government. I have redesigned alot of systems and ...
    Kathy duretKathy duret
    May 8, 2008 at 1:02 am
    May 12, 2008 at 4:10 pm
  • Folks Is following an appropriate pointer to check for Network Choking under (Benchmark) Transaction Load? Banking Java Application uses Oracle thin driver to connect to the Database. This Oracle ...
    May 30, 2008 at 7:45 am
    Jun 20, 2008 at 6:02 pm
  • On HPUX non-root users can chown on files. It appears on RedHat 5 this is not allowed. The sysadmins are saying that there is no way to grant users this ability with Linux. Is that true? -- ...
    Terrian, Thomas J Mr CTR DLA J6DIBTerrian, Thomas J Mr CTR DLA J6DIB
    May 6, 2008 at 2:09 pm
    May 16, 2008 at 8:28 am
  • We are trying to create a logical standby database (solaris) using data guard so we can use downstream data capture to populate a reporting database (Linux) for historical reporting. Any chance ...
    April WellsApril Wells
    May 1, 2008 at 3:47 pm
    May 2, 2008 at 1:07 pm
  • Using Oracle 10.2, does anyone know how to move a control file in that is in ASM 10.2? I want to move my control file from +DATA/db/control01.ctl to +DATA/db/CONTROLFILE/control01.ctl. I can change ...
    Terrian, Thomas J Mr CTR DLA J6DIBTerrian, Thomas J Mr CTR DLA J6DIB
    May 21, 2008 at 11:07 am
    May 27, 2008 at 11:50 am
  • Hi. We are running oracle on our test evironment in suse 9. Emc symmetrix storage. I was going over the settings and discovered that filesystemio_options was not set (no value given). I ...
    John SmithJohn Smith
    May 14, 2008 at 3:19 am
    May 18, 2008 at 2:37 pm
  • Hi, Solaris 9, Enterprise edition. I have an open SR about this, no response for 24 hours. Scheduled patch application time is this weekend, downtime (recompile views) in a short window ...
    S. Anthony SequeiraS. Anthony Sequeira
    May 28, 2008 at 8:33 am
    May 30, 2008 at 11:29 pm
  • Oracle 9205 on windows server 2000, SP 4. In the last 2 days the listener was dead twice. No messages in the listener.log, no nothing. Lsnrctl also failed to stop the listener. I had to restart the ...
    Yechiel AdarYechiel Adar
    May 21, 2008 at 10:33 am
    May 22, 2008 at 3:10 pm
  • Ok i guess i'm having a brain fart, someone asked me about this and for the life of me i can't figure it out. The 2nd index, what exactly is it doing with single quotes around the column name?? SQL ...
    May 19, 2008 at 5:54 pm
    May 20, 2008 at 9:42 am
  • I'm having some trouble getting Oracle to shutdown cleanly for our scheduled weekly Windows reboots. Win2K3 x64 SP2 Oracle 64 bit I followed Metalink note 231495.1 to add a script to the ...
    Allen, BrandonAllen, Brandon
    May 13, 2008 at 5:57 pm
    May 16, 2008 at 6:32 pm
  • I have been working with an AIX LPAR which has access to 6 CPU's, defaults to 3. Its primarily a data warehouse instance, so we enabled parallel on it and about half of the tables are large, and are ...
    John SmithJohn Smith
    May 6, 2008 at 5:43 pm
    May 7, 2008 at 12:46 pm
  • Hi Guyz, Its 64-bit SunOS 5.8 sparc, I'm installing Oracle 9.2 client. Everything goes well during the installing phase of the installation but during linking phase, I'm getting the following error ...
    Khan, Muhammad SKhan, Muhammad S
    May 15, 2008 at 2:45 pm
    May 21, 2008 at 6:00 pm
  • Folks, I have a situation like this: EE on Sparc 64bit An insert statement of the form ... INSERT INTO target_table (...) SELECT /*+ ORDERED FULL (t1) FULL(t2) FULL(t3) */ ... FROM t1, t2, ...
    David AldridgeDavid Aldridge
    May 15, 2008 at 8:17 pm
    May 19, 2008 at 6:23 pm
  • I'm in the process of replacing an old database and have been fiddling with a star schema in the new database (version on AIX). This database stores call detail records. I'll admit that I ...
    Hostetter, Jay MHostetter, Jay M
    May 14, 2008 at 12:22 pm
    May 18, 2008 at 11:49 pm
  • We have this doc (metalink): Subject: Script to Detect Tablespace Fragmentation Doc ID: Note:1020182.6 to detect tablespace fragmentation. Can I know if there exists another for other space usage ...
    Peter TeohPeter Teoh
    May 8, 2008 at 2:58 pm
    May 12, 2008 at 1:03 pm
  • Does any version of ORACLE support "bulk insert" like SQL server? I search on Google and can NOT find any info. Thanks. Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now ...
    Dba1 mccDba1 mcc
    May 5, 2008 at 2:46 pm
    May 8, 2008 at 2:43 pm
  • Hi list, I have created a role with just select privilege on all sysadm objects. The script run very fast at first time. Since there maybe new tables created in the prod. So I cron the script, run it ...
    Joan HsiehJoan Hsieh
    May 14, 2008 at 6:48 pm
    Jul 11, 2008 at 6:18 pm
  • Don't be these DBA's http://computerworld.com/action/sharktank.do?command=viewDailyFull&date=20080506 http://computerworld.com/action/sharktank.do?command=viewDailyFull&date=20080507 Arghhh. The type ...
    Jared StillJared Still
    May 29, 2008 at 6:39 pm
    Jun 17, 2008 at 1:44 pm
  • Say I've got a table that's partitioned by day and has 30 days worth of partitions. Every 30 days I'll create another 30 days worth of partitions and drop the previous 30 days worth. Stats are ...
    John ThompsonJohn Thompson
    May 28, 2008 at 3:57 pm
    Jun 2, 2008 at 5:43 pm
  • Oracle 10g, HPUX, Physical DataGuard, RMAN backups of Primary and Standby. What would be the best way to test our DataGuarded copy if we want to start it up and applying changes to it? We don't want ...
    Terrian, Thomas J Mr CTR DLA J6DIBTerrian, Thomas J Mr CTR DLA J6DIB
    May 30, 2008 at 10:51 am
    Jun 2, 2008 at 1:36 am
  • I installed Clusterware and patched to 10203. Installed RAC software for ASM and RDBMS Home and Patched to 10203. Now I restarted the Cluster but strange thing is that VIP of Node1 is always coming ...
    Sanjay MishraSanjay Mishra
    May 30, 2008 at 3:17 am
    May 30, 2008 at 8:27 pm
  • Once in a while (maybe once a month), our intranet is a victim of what I would call a DOS. Our application server (AS receives hundreds of requests (all the same request with the same ...
    May 29, 2008 at 2:36 pm
    May 30, 2008 at 7:32 pm
  • has anyone found a use for this other than for logging? 1. doing stuff 2. log what i am doing. commit it and don't want to commit do stuff 3. continue doing stuff anyone use it for anything else? -- ...
    Rick RickyRick Ricky
    May 22, 2008 at 3:56 pm
    May 29, 2008 at 8:08 pm
  • I executed these sql on my database: SQL select time_waited_micro/total_waits/1000000 from v$system_event where event_id in (select event_id from v$event_name where name='direct path read') ...
    Qihua wuQihua wu
    May 28, 2008 at 9:45 am
    May 29, 2008 at 5:52 am
  • Hi, Kindly clarify me on the below think We have Development users who uses PERL for there development work in oracle 32 bit version. In the past they had trouble compiling PERL on ORACLE 10g ...
    Shanmugam, DhandapaniShanmugam, Dhandapani
    May 2, 2008 at 9:44 am
    May 27, 2008 at 1:50 pm
  • As I now have several eBiz apps systems to care for, I am wallowing in a sea of log files. It seems that every component of apps generates log files, and the tend to grow rather quickly, consuming ...
    Jared StillJared Still
    May 21, 2008 at 6:17 pm
    May 22, 2008 at 5:54 am
  • Is there a way to deep copy a Record into same schema? For example, if I copy a Department, all the Employees under it should be copied having reference to new Department.. and so on.. Sandeep. -- ...
    Dixit, SandeepDixit, Sandeep
    May 15, 2008 at 1:53 pm
    May 16, 2008 at 9:55 pm
  • I need to rollup data by month. There are a couple ways to do this. I have a date field. So I can rollup with a to_char(mydate,'YYYYMM') this requires a where clause as followings where ...
    Rick RickyRick Ricky
    May 13, 2008 at 5:44 pm
    May 14, 2008 at 5:45 pm
  • Hi, I'm at a site where we're looking at setting up DataGuard as DR for a RAC system. The config for production is: 6 Nodes (Dell 2950 servers) 1 instance per node Windows Server 2003 SAP is ...
    Chris DunscombeChris Dunscombe
    May 7, 2008 at 7:57 am
    May 9, 2008 at 9:23 am
  • For streams, we need to set parallel_max_servers to 1. I made sure all tables and indexes have parallel set to 1 and then set the above parameter. Normal, homegrown queries started running in ...
    Fedock, John \(KAM.RIC\)Fedock, John \(KAM.RIC\)
    May 19, 2008 at 1:18 pm
    May 23, 2008 at 2:29 pm
  • I'm trying to build a physical standby server and have been following an article I found at 'http://www.dbasupport.com/oracle/ora10g/ manual_standby.shtml'. Everything is great until I execute the ...
    Michael MitchellMichael Mitchell
    May 14, 2008 at 8:43 pm
    May 15, 2008 at 9:03 pm
  • Hi List, Anybody using directory naming here? We have about 30 databases and use local naming and most clients are configured to share 1 tnsnames.ora file on a shared file server. I was tasked to ...
    Li LiLi Li
    May 8, 2008 at 3:39 pm
    May 9, 2008 at 4:28 pm
  • Anybody know of (a rough estimation of) the share in platform used for Oracle RAC? Anybody know if RAC on Windows/Itanium is common or obscure? Thanks, Frits Hoogland -- ...
    Frits HooglandFrits Hoogland
    May 2, 2008 at 8:58 am
    May 5, 2008 at 1:59 pm
  • SLES10, Oracle on IBMz9, app server is Dell RHEL4, 9i client (32 bit server), report server Windows/SQL Server 2000 We are trying to test our application against a production size 10g ...
    Sandra BeckerSandra Becker
    May 21, 2008 at 4:06 pm
    May 22, 2008 at 6:15 pm
  • I execute sys.dbms_support.start_trace(true,true); I then run a procedure with a query. I exit the session to get my last stat line. I run tkprof sys=no and I do not get an explain plan. If I use the ...
    Rick RickyRick Ricky
    May 19, 2008 at 3:23 pm
    May 19, 2008 at 6:16 pm
  • I can't use sqlplus in Unix as a normal user. It gives the below error. My oracle home is /usr/local/oracle/product/ Kindly suggest bash#/usr/local/oracle/product/ sqlplus Error 6 ...
    Shanmugam, DhandapaniShanmugam, Dhandapani
    May 15, 2008 at 4:12 pm
    May 15, 2008 at 7:05 pm
  • Hi Is there any restriction with bind variables and function based indexes. I noticed that if I have literals fbi is being used but if I replace that with bind variables then fbi is not used. DB ...
    Kumar MadduriKumar Madduri
    May 6, 2008 at 11:54 pm
    May 12, 2008 at 6:46 pm
  • I saw on a board somewhere that someone is having deadlock issues due to block level locking with Oracle RAC? I thought Oracle always did row level locking on everything? Could this be a ...
    Rick RickyRick Ricky
    May 9, 2008 at 6:39 pm
    May 10, 2008 at 10:33 pm
  • Broswing through various blogs, whitepapers and other presentations, I have seen folks like Tom Kyte and Lutz Hartman reference the HHWM and LHWM of ASSM tables, however I have been unable to find ...
    Charles SchultzCharles Schultz
    May 6, 2008 at 2:43 pm
    May 7, 2008 at 12:38 am
  • I have two different data sets. They come from two different feeds. I have an ID field that I can join on that is the same in both. However, I have a date field in each. Here is the catch, the dates ...
    Rick RickyRick Ricky
    May 14, 2008 at 6:31 pm
    Jun 11, 2008 at 5:32 pm
  • This is an old 8.1.7 installation on Linux, which suffers from the "2 GB per file" problem. A file upload started giving "ORA-01691: unable to extend lob segment" errors so I added another data file ...
    Janine SiskJanine Sisk
    May 30, 2008 at 8:51 pm
    Jun 3, 2008 at 2:40 pm
  • Yesterday I have no problem using a database link. Today I am getting tns errors. I have no access to the DB server (its owned by a different vendor). I have to go through channels to contact them ...
    Rick RickyRick Ricky
    May 30, 2008 at 12:36 pm
    May 31, 2008 at 7:33 pm
  • Hey does anyone know if 10g has depreciated the monitor nomonitor options when you create index or table? Looks like the default is to turn monitoring on in 10g. But I'm not sure. Thanks, Lizz -- ...
    Laura penaLaura pena
    May 29, 2008 at 9:21 pm
    May 30, 2008 at 7:54 pm
  • DBA's, What is you're log_buffer set to??? I have a 2 Tb oltp two node RAC database on that is showing lots of log file sync waits. My current setting is 1.5 Mb. Redo log files are 2Gb ...
    James HowertonJames Howerton
    May 19, 2008 at 10:04 pm
    May 21, 2008 at 12:09 pm
  • Have a good question from a friend of mine who's not on the list - wondering if anyone else would have input. Reply-all so that Steve can see the replies too - anyone have additional thoughts about ...
    Jeremy SchneiderJeremy Schneider
    May 13, 2008 at 3:44 pm
    May 18, 2008 at 5:21 am
  • Hello all, Relative newcomer to performance analysis. I was surprised, upon investigating a very slow import job, to find very high 'db file sequential read's. This activity was mostly associated ...
    May 9, 2008 at 7:22 am
    May 13, 2008 at 8:30 am
  • How can we find that who is using this materialized view. I had a database where MV log is created and is very big but cannot purge as I am not aware who has created. How we can say that this Log is ...
    Sanjay MishraSanjay Mishra
    May 2, 2008 at 1:51 am
    May 2, 2008 at 5:39 pm
Group Navigation
period‹ prev | May 2008 | next ›
Group Overview
grouporacle-l @

199 users for May 2008

Jared Still: 30 posts Yong Huang: 23 posts Rick Ricky: 20 posts Finn Jorgensen: 19 posts Mark W. Farnham: 18 posts Allen, Brandon: 15 posts Goulet, Dick: 15 posts David Aldridge: 14 posts Niall Litchfield: 14 posts Yechiel Adar: 14 posts Andrew Kerber: 13 posts TESTAJ3_at_nationwide.com: 12 posts Baumgartel, Paul: 11 posts Howard Latham: 11 posts Mark Brinsmead: 11 posts Bradd Piontek: 10 posts Dan Norris: 10 posts Peter Teoh: 10 posts William Wagman: 10 posts Hemant K Chitale: 9 posts
show more