FAQ

Oracle > oracle-l > December 2005

Search Discussions

90 discussions - 403 posts

  • Trying to resend with attachment ..., it seems that the previous one didn't reach the list. Regards, Dimitre P.S. Rename to zip. -- http://www.freelists.org/webpage/oracle-l application/octet-stream ...
    Radoulov, DimitreRadoulov, Dimitre
    Dec 2, 2005 at 8:50 am
    Dec 5, 2005 at 12:49 pm
  • The resolution...and this is no joke...directly from Dell...I was on the conference call; Dell (and I assume its hardware partners) could not resolve our/their hardware problem, nor will they further ...
    Marquez, ChrisMarquez, Chris
    Dec 8, 2005 at 3:20 pm
    Dec 12, 2005 at 2:30 pm
  • I've heard mention in a number of talks that you shouldn't gather stats very often, even not at all once a system is bedded in, as it can cause your database to start performing really badly. I don't ...
    Stephen boothStephen booth
    Dec 7, 2005 at 12:59 pm
    Dec 9, 2005 at 3:32 am
  • I have a relativelly fast machine for testing. It's a 4 cpu XEON 3.6 ghz with 1 mb of cache 16 gb of ram and a lot of fast storage. It's running RedHat linux 4 64 bit with 64 bit Oracle 10g and ASM ...
    Christo KutrovskyChristo Kutrovsky
    Dec 14, 2005 at 9:46 am
    Dec 15, 2005 at 12:25 pm
  • Anybody have a good method for tracking top SQL by 'db block changes'? It seems this statistic is only tracked by session and instance, but not by SQL statement. The 'disk_reads' are tracked in v$sql ...
    Allen, BrandonAllen, Brandon
    Dec 15, 2005 at 11:51 am
    Dec 18, 2005 at 7:20 am
  • Hello list, Does any one has worked or has any experience on 'RAC on extended distance clusters'? If any good docs. and ppt. are highly welcomed. -- Best Regards, Syed Jaffar Hussain OCP 8i & 9i DBA, ...
    The Human FlyThe Human Fly
    Dec 13, 2005 at 7:54 am
    Dec 18, 2005 at 7:19 am
  • Hi, Oracle 9.2.0.6 Standard Edition I have issues when I want to switch between my standby and primary database. I got this error ARCH: Archiving not possible: No standby destinations ARCH: Failed to ...
    Luc DemancheLuc Demanche
    Dec 7, 2005 at 8:23 am
    Dec 9, 2005 at 8:53 am
  • �Oracle version is 9206. I'm tracking DDL changes by running such a query: select object_name,to_char(last_ddl_time,'YYYY-MM-DD-HH24:MI:SS'), timestamp from dba_objects where last_ddl_time ...
    Khemmanivanh, SomckitKhemmanivanh, Somckit
    Dec 13, 2005 at 4:54 pm
    Dec 14, 2005 at 1:50 pm
  • Saturday, December 10, 2005, 7:40:51 AM, Jonathan Gennick (jonathan_at_gennick.com) wrote: Friday, December 9, 2005, 10:21:22 PM, Mark Brinsmead (mark.brinsmead_at_shaw.ca) wrote: MB Jonathan, your ...
    Jonathan GennickJonathan Gennick
    Dec 10, 2005 at 6:57 am
    Dec 13, 2005 at 12:04 am
  • List, I need to password protect the listener on my Solaris 8 9iRel2 db. If I password protect the listener will the listener auto start upon server reboot when the dbora/dbstart/dbstop scripts are ...
    Joe SmithJoe Smith
    Dec 1, 2005 at 12:15 pm
    Dec 3, 2005 at 12:03 am
  • We have ORACLE database on DELL Redhat AS 3.6. The server is dedicate for database purpose. I checked Redhat manual and found "mke2fs" can ONLY create file system block size=1k, 2k and 4k. Does there ...
    Dba1 mccDba1 mcc
    Dec 9, 2005 at 10:36 am
    Dec 13, 2005 at 4:43 am
  • I am getting my feet wet with RAC. Platform is Oracle 10g R2 on Windows 2000. I¹ve setup a 1-node test cluster, and now I¹m attempting to add a second node. However, when I try to create the ...
    Jason HeinrichJason Heinrich
    Dec 1, 2005 at 5:25 pm
    Dec 2, 2005 at 2:27 pm
  • Here is dumb question, I have a remote user who often complains about slowness, sometimes it is network, sometimes it isn't. Network guys are doing their bit to identify, I need to do my bit. will a ...
    RjamyaRjamya
    Dec 1, 2005 at 12:09 pm
    Dec 2, 2005 at 10:41 am
  • i have the following query in oracle apps: 1 select inventory_item_id code, description meaning, description 2 from mtl_system_items_b 3 where organization_id = fnd_profile.value('ORG_ID') 4 and 63 = ...
    Haroon A. QureshiHaroon A. Qureshi
    Dec 15, 2005 at 2:49 pm
    Dec 15, 2005 at 5:22 pm
  • All, When trying to "truncate ", I'm getting the following: ORA-01552: cannot use system rollback segment for non-system tablespace 'AMA30_DATA' Since truncate can't be rolled back, why is this a ...
    Knight, JonKnight, Jon
    Dec 5, 2005 at 10:46 am
    Dec 5, 2005 at 5:11 pm
  • Hi, I am using the below package for the send mail functionality from Oracle. When I use pass the multiple e-mail addresses (using comma or semicolon delimeter), I get the following error message. Do ...
    Subbiah, NagarajanSubbiah, Nagarajan
    Dec 5, 2005 at 10:55 am
    Dec 5, 2005 at 2:47 pm
  • Can advanced replication just push the deltas or changes to the tables or must it push the whole table every time? thanks. Express yourself instantly with MSN Messenger! Download today - it's FREE! ...
    Joe SmithJoe Smith
    Dec 2, 2005 at 8:57 am
    Dec 5, 2005 at 11:43 am
  • So i just stepped throught the wonderful wizard in database control to clone a 10gR2 database. Everything went very smoothly. The only problem is that I believe I need another instance of database ...
    Chris StephensChris Stephens
    Dec 2, 2005 at 6:20 am
    Dec 5, 2005 at 10:58 am
  • If dbca is used to create a new 10g R2 database (completely), one frame of the wizard allows the choice of either enterprise edition or standard edition. Alternatively, dbca will create script & ...
    Sol beachSol beach
    Dec 14, 2005 at 1:38 pm
    Dec 15, 2005 at 4:01 pm
  • The same 9.2.0.4 instance on Solaris 8 (do you remember the "hash join vs nested loops" thread :)) Trying to gather system statistics in a period with common workload, CPU load 30-70%, only one ...
    Radoulov, DimitreRadoulov, Dimitre
    Dec 7, 2005 at 3:24 pm
    Dec 13, 2005 at 3:35 pm
  • I just came up with a function I would like, but don't think exists. TABLE TEST (X NUMBER) 2 2 4 select sum(x) from test; will return 8... what I need is select multiply(x) from test; will return 16, ...
    Ethan PostEthan Post
    Dec 9, 2005 at 4:13 pm
    Dec 10, 2005 at 3:02 am
  • Hi! Is anybody out there running a 10g database on Linux on VMWare ESX servers? We are thinking about putting a 10g database on there, but I heard that there are serious issues with VMWare when it ...
    Daiminger, HelmutDaiminger, Helmut
    Dec 5, 2005 at 6:39 am
    Dec 5, 2005 at 5:59 pm
  • Hello List, I was little confused about the settings of pga_aggregate_target parameter. I was in a assumption that when we set this parameter to a certain value, the usage of pga wont go beond this ...
    The Human FlyThe Human Fly
    Dec 13, 2005 at 12:04 am
    Dec 18, 2005 at 9:20 am
  • Has anyone got ideas or run across this intermittent export error? Randomly getting this error in the export full. Metalink does not show anything related at our version so a tar created. . ...
    Spears, BrianSpears, Brian
    Dec 13, 2005 at 3:23 pm
    Dec 14, 2005 at 9:48 am
  • I am loading a flatfile fields enclosed by double-quotes and delimited by comma. We found that some column values can also contain double-quotes. How do I _escape_ the double-quotes in the column ...
    RjamyaRjamya
    Dec 9, 2005 at 5:42 am
    Dec 12, 2005 at 1:03 pm
  • 9.2.0.5, 2 Node RAC, Redhat 2.1 AS Got an annoying situation where our database isn't being load balanced correctly. We have a database test, the database also has an added service_name of prod ...
    David SharplesDavid Sharples
    Dec 9, 2005 at 5:53 am
    Dec 9, 2005 at 8:42 pm
  • Hello All, I'm trying to load data using SQL Loader and ran into the ORA-01858: a non-numeric character was found where a numeric was expected error. Below is my control file. As you can see, the ...
    Madhavi KanugoMadhavi Kanugo
    Dec 7, 2005 at 12:19 pm
    Dec 9, 2005 at 9:55 am
  • Is there a way to create an index on a column and only index those where the value meets a certain expression? For example, if I have a numeric column, can I just have the index built for those ...
    Rick StephensonRick Stephenson
    Dec 6, 2005 at 12:47 pm
    Dec 8, 2005 at 11:09 am
  • I need some help with an RMAN issue. I restored a database to a new server using an RMAN level0 backup. I then renamed the database and all the files to the new instance name. I am not using an RMAN ...
    Laura penaLaura pena
    Dec 7, 2005 at 1:59 pm
    Dec 7, 2005 at 2:38 pm
  • Looking into a performance problem on RHEL 3.0 AS QU4 running on Dell 2850s with 8gB RAM and dual 3.6gHz PIV processors and a fibre-attached EMC CX-500. A simple 100000 row insert on an identical ...
    David BarbourDavid Barbour
    Dec 5, 2005 at 2:55 pm
    Dec 6, 2005 at 1:03 pm
  • We have encountered bug 4075120 when trying to get our logical standby working. Basically, the logical standby fails to skip ddl (such as grants) related to temp tables that got created on the ...
    Adams, Matthew (GE Consumer & Industrial)Adams, Matthew (GE Consumer & Industrial)
    Dec 1, 2005 at 10:26 am
    Dec 6, 2005 at 3:32 am
  • So, we've finally upgraded from the 8.0.5 client to 9.2.0.7.0. During testing, I had used a TNSNAMES.ORA file on the test boxes in order to be able to redirect production DB connections to test. But ...
    Jesse, RichJesse, Rich
    Dec 7, 2005 at 8:39 am
    Dec 15, 2005 at 1:33 pm
  • I may have this requirement to implement something that captures session details and sessions waits at very short intervals in a 9204 database. AWR kinda does that in 10g, but this is no 10g. I am ...
    RjamyaRjamya
    Dec 13, 2005 at 5:06 am
    Dec 14, 2005 at 12:51 pm
  • Here is an interesting review of SQL Server 2005 by EWeek. Seems to be quite objective. http://www.eweek.com/article2/0,1895,1896097,00.asp One of the more interesting bits from an Oracle ...
    Jared StillJared Still
    Dec 13, 2005 at 4:08 pm
    Dec 14, 2005 at 11:00 am
  • 10gR2 on linux We have a queue that accepts xml documents. Documents are members of sets. No document can be processed unless the entire set has been enqueued. We indicate this by a 'isLastInSet' ...
    Chris StephensChris Stephens
    Dec 9, 2005 at 1:27 pm
    Dec 9, 2005 at 7:21 pm
  • I have a logon trigger that enables event 10046 for certain users. However there are too many users with this same name. If I want to reduce the amount of sessions that have 10046 enabled, how to ...
    Paul van den BogaardPaul van den Bogaard
    Dec 9, 2005 at 3:58 am
    Dec 9, 2005 at 8:23 am
  • Hi folks: I am coming up with a strange problem. my system tablespace keep on increasing every day by 100M. and i query the v$dba_segments,then i found this table: IDL_UB1$ size is 15031091200bytes ...
    Yu FishYu Fish
    Dec 8, 2005 at 2:05 am
    Dec 8, 2005 at 12:13 pm
  • Is it possible to use lag, but you don't know how many rows you want to go back? create table history ( history_id number, history_sequence number, history_status varchar2(20), history_balance ...
    Ryan_gaffuri_at_comcast.netRyan_gaffuri_at_comcast.net
    Dec 7, 2005 at 3:13 pm
    Dec 8, 2005 at 6:14 am
  • Dear all, Version: 9.2.0.6 OS: Solaris 8 I am tracing a very very slow session. I am seeing a strange thing in the trace file generated. I see a recursive SQL taking LOTS and LOTS of 'SQL*Net Message ...
    Charudatta JoshiCharudatta Joshi
    Dec 3, 2005 at 9:01 am
    Dec 7, 2005 at 8:47 am
  • hi, how can i get the NAME of the XML node, example - SELECT EXTRACT (VALUE (e), '/').getstringval () as xml, EXTRACTVALUE (VALUE (e), '/') as VALUE --, ??? as tag FROM TABLE (XMLSEQUENCE (EXTRACT ( ...
    Shay ToderShay Toder
    Dec 5, 2005 at 4:15 am
    Dec 6, 2005 at 1:00 am
  • I've been struggling with this for a day. I am trying to get dependent DDL (constraints) for a table, and have written the following function to do it (using literals for testing): function ...
    Paul BaumgartelPaul Baumgartel
    Dec 15, 2005 at 3:54 pm
    Dec 15, 2005 at 4:12 pm
  • Hi Does anyone know where I can download Designer version 9.0.2.0, OR the Internet Develoment Suite install for 9.0.2.? that I believe also contains this Designer version? It seems to have been ...
    Ben PoelsBen Poels
    Dec 7, 2005 at 8:38 am
    Dec 15, 2005 at 3:12 pm
  • Hello, I generally have all of my datafiles on the local server, however we recently had the need to create a datafile that was larger than the server's available space (20GB). So I created the ...
    Fred SmithFred Smith
    Dec 15, 2005 at 9:51 am
    Dec 15, 2005 at 11:39 am
  • Our university is purchasing this product from IBM for backup of our SAN. The tech sales rep tells me it can also be used for Oracle online backups. Has anyone used this product? How can this utility ...
    Don MorseDon Morse
    Dec 14, 2005 at 1:24 pm
    Dec 15, 2005 at 10:56 am
  • Hello, We have an OLTP system. We would like to copy some tables data into an "archive" system. Some part of data should be the exact copy of the original, but some should be "accumulated". In the ...
    Veres LajosVeres Lajos
    Dec 13, 2005 at 4:09 pm
    Dec 14, 2005 at 7:54 am
  • List, I am trying to do an incomplete recovery of my 9iRel2 db on Solaris 8. I am in archive log mode. This is a test environment. I autobackup my control file and snapshot the control file. The ...
    Joe SmithJoe Smith
    Dec 13, 2005 at 8:57 am
    Dec 13, 2005 at 9:41 am
  • list, when i try to execute an pl/sql package i get the following error: i have search on internet & they mentioned i have to change my listener, but i need an real example: please SQL exec ...
    Hamid alaviHamid alavi
    Dec 9, 2005 at 1:21 pm
    Dec 10, 2005 at 9:10 pm
  • Hi list, I'm looking to implement some global error handling code with a database (9.2.0.7) AFTER SERVERERROR trigger. My question relates to a PL/SQL situation in which the trigger does not fire. If ...
    Steve BaldwinSteve Baldwin
    Dec 6, 2005 at 2:34 pm
    Dec 9, 2005 at 2:42 pm
  • List, We are migrating our network platform to Win from Novell and will be having several SQL Server databases. The current Linux/Oracle configuration will remain intact for a least a few years. I ...
    Ron RogersRon Rogers
    Dec 8, 2005 at 6:56 am
    Dec 8, 2005 at 11:50 am
  • See metalink Note: 1060605.6, translating to your version. Also see the RMAN way http://download-west.oracle.com/docs/cd/B19306_01/backup.102/b14191/reco scen003.htm You probably want to learn about ...
    Joel GarryJoel Garry
    Dec 7, 2005 at 7:03 pm
    Dec 8, 2005 at 9:45 am
Dec 2005
12
Group Navigation
period‹ prev | Dec 2005 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions90
posts403
users139
websiteoracle.com

139 users for December 2005

Allen, Brandon: 15 posts Radoulov, Dimitre: 13 posts Jared Still: 11 posts Christo Kutrovsky: 10 posts Rjamya: 10 posts Ethan Post: 9 posts John Kanagaraj: 9 posts Jonathan Lewis: 8 posts Mark Brinsmead: 7 posts Oracle-l-bounce_at_freelists.org: 7 posts Stephen booth: 7 posts Bobak, Mark: 6 posts David Sharples: 6 posts Goulet, Dick: 6 posts Lex de Haan: 6 posts Mark Bole: 6 posts Pete Sharman: 6 posts Tanel Põder: 6 posts Brian.x.wisniewski_at_jpmchase.com: 5 posts Chris Stephens: 5 posts
show more
Archives