Search Discussions

96 discussions - 568 posts

  • Dear listers, recently we noticed that the Oracle SQL Developer causes a kind of unwanted "inverse" connection storm to all configured databases, when we start the SQL Developer. It's not restoring ...
    Martin KlierMartin Klier
    Apr 3, 2013 at 3:32 pm
    Apr 10, 2013 at 2:53 pm
  • EE on AIX 6.1 Any known instrumentation issues / oddities when fetching LOBS? Tracing a process, 10046 level 8, 91% of the time on sql*net message from client, with 99.8% of that accumulated ...
    Larry ElkinsLarry Elkins
    Apr 30, 2013 at 1:23 am
    May 9, 2013 at 12:35 pm
  • Experts I am looking for some suggestions based on your experience to move more than 7Tb database. Current Environment : 11g R1 with Database file on Raw Devices and Operating system is Solaris Sparc ...
    Sanjay MishraSanjay Mishra
    Apr 19, 2013 at 12:56 pm
    Apr 22, 2013 at 9:30 pm
  • I think this is a quick question. As I'm going through the hugepages information, I'm trying to figure out if you can, or cannot, have multiple instances on 1 host running different configurations? ...
    Christopher Taylor2Christopher Taylor2
    Apr 29, 2013 at 2:21 pm
    May 2, 2013 at 10:37 am
  • Hi all, I think most of us has seen someone trying to be smart or trying to gain database independencies by not using oracle sequence but instead roll their own system by using a table, and a row for ...
    Johan ErikssonJohan Eriksson
    Apr 12, 2013 at 3:25 pm
    Apr 23, 2013 at 7:57 pm
  • We recently upgraded one of our ERP databases from to on Solaris 10. The following SQL statement, which used to run in a few minutes, is now taking forever to run and is not even ...
    Hameed, AmirHameed, Amir
    Apr 26, 2013 at 8:25 pm
    Apr 29, 2013 at 6:35 pm
  • Hi all, I'm having some troubles comparing datetimes in oracle... what's wrong with these queries: file: login.sql alter session set nls_timestamp_tz_format='YYYY-MM-DD HH24:MI:SS.FFTZD'; select ...
    Jose SoaresJose Soares
    Apr 17, 2013 at 1:00 pm
    Apr 19, 2013 at 2:39 pm
  • DBMS_STATS does not compute number of chained rows. analyze table x list chained rows - this does but if the table is large and has lots of chained rows, then need a lot of rollback space for rows ...
    Jeffrey BeckstromJeffrey Beckstrom
    Apr 15, 2013 at 2:59 pm
    Apr 18, 2013 at 12:10 pm
  • Ok, I have a 10g version on my unix box. I just loaded 11g. I set the new ORACLE_HOME, ORACLE_BASE and ORACLE_SID to the 11g directories I enter sqlplus and I get: Error 6 initializing SQL*Plus ...
    Zelli, BrianZelli, Brian
    Apr 5, 2013 at 2:54 pm
    Apr 6, 2013 at 3:04 pm
  • Hey all, On, we had our DB server crash. DB and instance are fine (whew!), but afterwards one UPDATE statement is now using an inefficient index: UPDATE MYSCHEMA.MYTABLE SET ...
    Rich JesseRich Jesse
    Apr 15, 2013 at 12:11 pm
    Apr 18, 2013 at 11:49 pm
  • Hi Does anybody use Eclipse for SQL (Oracle) development? I love Open Source, but use at the moment Toad. Any review of Eclipse for SQL developers? I don't wish to switch to other closed Source tool ...
    Lukas LehnerLukas Lehner
    Apr 15, 2013 at 5:08 pm
    Apr 23, 2013 at 2:46 pm
  • I don't want to flush the buffer cache but need to verify disk IO speeds on 3 servers in my rac cluster. According to DBA_HIST_SQLSTAT, the elapsed times for some queries are significantly slower on ...
    Christopher Taylor2Christopher Taylor2
    Apr 22, 2013 at 7:59 pm
    Apr 23, 2013 at 2:19 am
  • Hi, I have a query that does not run in RAC environment. It uses a "lot of' TEMP tablespace. I got sucess running it in the single instance. The hint used is: SELECT /*+ USE_HASH(table1, table2) */ ...
    Eriovaldo AndriettaEriovaldo Andrietta
    Apr 14, 2013 at 8:24 am
    Apr 15, 2013 at 2:27 pm
  • Hi I have a database that has a requirement of retaining archivelogs for 1 year. The database must be able to recover to ay point in time in 1 year period. So I have thought of using keep until time ...
    Ls ChengLs Cheng
    Apr 22, 2013 at 10:22 pm
    Apr 23, 2013 at 7:01 pm
  • Hi, I'm looking to buy either a tablet or an e-reader fo tablet to mainly read manuals and course books, so what would you recommend , an e-reader or a tablet? And, which one? Features I would like ...
    D'Hooge FreekD'Hooge Freek
    Apr 21, 2013 at 10:57 am
    Apr 22, 2013 at 2:52 pm
  • Hello, We have a developer who wants to access dbms_sqltune which requires the advisor system privilege I was curious if others had any concerns with granting developers this access in your ...
    Michael SchmittMichael Schmitt
    Apr 9, 2013 at 3:35 pm
    Apr 10, 2013 at 12:18 pm
  • Hi, At times when the performance goes slow some of DBA in our team says that the stats get corrupted . asking how do you determine dont bring any good explanation. Anyone please throw some insights ...
    K RK R
    Apr 30, 2013 at 10:15 am
    May 1, 2013 at 2:26 pm
  • Again back with an interview question. Table A has 400 million rows and table b has 1 million rows. I want to compare table A and Table B and find all the rows available in b which are already ...
    Rajugaru VijRajugaru Vij
    Apr 26, 2013 at 1:46 pm
    Apr 29, 2013 at 7:23 pm
  • Hello All, Could you please tell me how to find out when an Oracle table was updated the last time in Oracle 8i. In Oracle 10g you could use the following query SQL SELECT ...
    Mandal, AshokeMandal, Ashoke
    Apr 23, 2013 at 10:07 pm
    Apr 25, 2013 at 1:45 am
  • We're in the process of migrating existing ASM Disk Groups to a new storage configuration (new disks (metavolumes), same array). We've done this in DEV/QA and everything went fine. Now, in Prod, I ...
    Christopher Taylor2Christopher Taylor2
    Apr 24, 2013 at 7:17 pm
    Apr 24, 2013 at 7:48 pm
  • The MTL_MATERIAL_TRANSACTION table in the Oracle ERP database has multiple indexes on it. Statistics are gathered on this table once a week. We have noticed that SQL plan for a particular SQL ...
    Hameed, AmirHameed, Amir
    Apr 23, 2013 at 3:38 pm
    Apr 23, 2013 at 8:56 pm
  • Hello all, we had a situation on a 2 node RAC system where for some reason the system more or less stopped working due to excessive "cursor: pin S wait on X" waits. (89% of the DB time on one node, ...
    Thomas KellererThomas Kellerer
    Apr 9, 2013 at 8:59 am
    Apr 12, 2013 at 1:54 pm
  • Hi Friends, How can I convert the column USER_TAB_COLUMNS.DATA_DEFAULT to VARCHAR2 in order to compare the content with a VARCHAR2 column, using SQL or PL/SQL. The column DATA_DEFAULT has LONG ...
    Eriovaldo AndriettaEriovaldo Andrietta
    Apr 12, 2013 at 4:52 pm
    Apr 13, 2013 at 9:36 pm
  • hi all, I'm trying to dump an oracle database to load into postgres using expdp but the result output file is a binary file. Is there a way to create a text file instead? I tried to export/import ...
    Apr 4, 2013 at 8:20 am
    Apr 5, 2013 at 5:07 pm
  • Hi , I am using a table as a cache for an oracle object type collection.The query to build the object collection is time consuming .So idea is to build the cache object once and store the elements in ...
    Anupam PandeyAnupam Pandey
    Apr 1, 2013 at 3:24 pm
    Apr 1, 2013 at 8:12 pm
  • I have a windows server (32 bit) which I am attempting to upgrade from to For this particular application we are running test and production instances on the same server (not my ...
    Schauss, Peter (ESS)Schauss, Peter (ESS)
    Apr 22, 2013 at 6:02 pm
    Apr 22, 2013 at 8:00 pm
  • All, We recently migrated an application into a 11g database in a server. After the upgrade one of the accounts necessary for connecting to the DB keeps locking up, because some application is trying ...
    C PC P
    Apr 11, 2013 at 4:54 am
    Apr 11, 2013 at 11:14 pm
  • isqlplus has been dessuported in 11g. The only access we get to production is from a locked down box that has a browser and notepad on it and that is about it. We cannot get any additional software ...
    Dba DBADba DBA
    Apr 9, 2013 at 3:20 pm
    Apr 10, 2013 at 7:05 am
  • I've just begun troubleshooting some various Oracle issues with invalid ROWIDs, ORA-600 [25027], ORA-600 [kcbzfb_1], ORA-08103: object no longer exists errors. The trace file dumped for the 25027 ...
    Christopher Taylor2Christopher Taylor2
    Apr 8, 2013 at 4:15 pm
    Apr 9, 2013 at 3:52 pm
  • Some list members may be adjunct or full-time faculty members and interested by the fact that I'm currently working on a 450-page textbook on Database Programming (title "SQL Success", subtitle ...
    Stéphane FaroultStéphane Faroult
    Apr 2, 2013 at 12:17 pm
    Apr 30, 2013 at 10:31 pm
  • Hi, Iam trying to run a query, which is taking 13 to 14 minutes. Its cost is 70. Its waiting for something. How to know for what my query is waiting and taking so long. Thanks Sent on my BlackBerry® ...
    Rajugaru VijRajugaru Vij
    Apr 25, 2013 at 1:29 pm
    Apr 26, 2013 at 5:53 pm
  • We have a Win32 server running four instances of Oracle I want to upgrade one of these, the test instance, to while leaving the other three production instances at for the ...
    Schauss, Peter (ESS)Schauss, Peter (ESS)
    Apr 18, 2013 at 9:01 pm
    Apr 19, 2013 at 2:20 pm
  • I'm looking for a count or graph of the worldwide production instances by version. And by worldwide I mean whatever someone has that contains more than just your own enterprise... Thanks, Mark Brady ...
    Brady, MarkBrady, Mark
    Apr 16, 2013 at 3:16 pm
    Apr 17, 2013 at 12:54 am
  • I just loaded oracle 11g on a HPUX server, created a little database and I checked to make sure the dbconsole and agent are running but when I put in the URL, I get: "There is a problem with this ...
    Zelli, BrianZelli, Brian
    Apr 10, 2013 at 8:29 pm
    Apr 11, 2013 at 5:12 pm
  • Anybody know of a way to monitor who and when someone connects to a database with Oracle SQL Developer? Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority ...
    Jeffrey BeckstromJeffrey Beckstrom
    Apr 5, 2013 at 2:39 pm
    Apr 5, 2013 at 7:13 pm
  • (Oracle on AIX) Hi, I faced something today which I still haven't figured out. On couple of SQL we get a lot of child cursors (cursor_sharing=similiar) and for those of them that has ...
    Johan ErikssonJohan Eriksson
    Apr 18, 2013 at 4:55 pm
    Apr 18, 2013 at 5:32 pm
  • an application schema dead.App schemas get upgraded on a routine basis and ,mostly, apps migrate to a newer one leaving behind the old schema. Such events are not communicated (and we try hard). As ...
    Apr 11, 2013 at 3:10 pm
    Apr 11, 2013 at 9:43 pm
  • Hi folks I would like to get your opinion on unscheduled outage of Oracle Support. IMHO, it's not professional for the software company that provides HA solutions to experience (scheduled, or) ...
    Kamran Agayev (ICT/SNO)Kamran Agayev (ICT/SNO)
    Apr 29, 2013 at 4:33 am
    Apr 29, 2013 at 12:29 pm
  • Hi, I need to safely transfer databases / tables with LONG RAW coloumns from one machine to another. What parameters have to be used to make exp work with the LONG RAW data type and what are all the ...
    Raja SubramaniyanRaja Subramaniyan
    Apr 23, 2013 at 4:14 am
    Apr 23, 2013 at 3:25 pm
  • Hi, I have a situation where my function based index is not getting used. Its an NVL based functional index NVL(gender,0) =0 Is my where clause. And I have a index on NVL(gender,0) It was getting ...
    Rajugaru VijRajugaru Vij
    Apr 23, 2013 at 12:17 pm
    Apr 23, 2013 at 2:36 pm
  • I have used Jonathan's index efficiency script to plot the graph.The graph is attached with this mail. This index is a single column index ( it's like a status column which has only 4 values say 1 - ...
    Apr 20, 2013 at 2:21 am
    Apr 20, 2013 at 3:14 pm
  • I'm getting a weird ETIMEDOUT error on a linux appserver connecting to my database server in the STRACE output and was curious if anyone has worked through anything like this? This is a JDBC ...
    Christopher Taylor2Christopher Taylor2
    Apr 11, 2013 at 6:31 pm
    Apr 12, 2013 at 8:51 pm
  • Hallo , after upgrade from 10G to DB allocated 430M of shared_io_pool select ksppinm, ksppstvl, ksppstdvl from x$ksppcv a, x$ksppi b where a.indx=b.indx and b.ksppinm like '%shared_io%' ...
    Petr NovakPetr Novak
    Apr 10, 2013 at 8:54 am
    Apr 10, 2013 at 7:21 pm
  • 2 versions: Oracle 10.2, Oracle 11.2 (different DBs). OS: Redhat, Solaris, HP, IBM AIX (not sure on versions, but could be on any of these OSs). If we drop a partition with the purge option, is the ...
    Dba DBADba DBA
    Apr 8, 2013 at 6:59 pm
    Apr 8, 2013 at 8:01 pm
  • Have to admit, I think this is the first time I've seen this. Anyone know what the [key] differences are (and if it could be impacted by the row lock enqueues that occurred?) Session Flat Profile ...
    Christopher Taylor2Christopher Taylor2
    Apr 16, 2013 at 1:41 pm
    May 3, 2013 at 5:27 am
  • Howdy, In EM12c BP1, I've got a few databases throwing some of the many errors that Support says "oh, just ignore those" (then why generate them in the first place?!?!?). So these ignorables get ...
    Rich JesseRich Jesse
    Apr 30, 2013 at 2:30 pm
    Apr 30, 2013 at 6:50 pm
  • Good day, all, I am trying to figure out if my expectations are way too high, or if the state of development in general has simply gone astray. While exploring the Provisioning Procedures in 11g ...
    Charles SchultzCharles Schultz
    Apr 21, 2013 at 2:28 pm
    Apr 22, 2013 at 1:49 pm
  • Oracle Enterprise Edition Linux 64 bit RHL 4.5 I have a question about space allocation in ASSM tablespaces. I am using a 8KB block size and 8MB extents. I started off with a single extent ...
    Peter HitchmanPeter Hitchman
    Apr 8, 2013 at 3:32 pm
    Apr 22, 2013 at 1:42 pm
  • Hi, I have a customer interested in implementing basic grid control, they already have the diagnostics and tuning pack for their databases. As I understand GC licensing, they don't need any ...
    Guillermo Alan BortGuillermo Alan Bort
    Apr 13, 2013 at 1:30 pm
    Apr 13, 2013 at 5:45 pm
  • Is Index Compression part of the basic database license or is it part of the Advanced Compression Option? -- http://www.freelists.org/webpage/oracle-l
    Jeffrey BeckstromJeffrey Beckstrom
    Apr 12, 2013 at 6:17 pm
    Apr 12, 2013 at 7:08 pm
Group Navigation
period‹ prev | Apr 2013 | next ›
Group Overview
grouporacle-l @

142 users for April 2013

Christopher Taylor2: 37 posts Hans Forbrich: 30 posts Mark W. Farnham: 23 posts Niall Litchfield: 20 posts Guillermo Alan Bort: 16 posts Hameed, Amir: 14 posts Jeff Smith: 13 posts Rjamya: 13 posts David Fitzjarrell: 11 posts John Hurley: 11 posts Jonathan Lewis: 11 posts Job Miller: 10 posts Peter Hitchman: 10 posts Sanjay Mishra: 10 posts Thomas Kellerer: 10 posts Dba DBA: 9 posts Jeffrey Beckstrom: 9 posts Jose Soares: 9 posts Rich Jesse: 9 posts Bobak, Mark: 8 posts
show more