FAQ

Search Discussions

134 discussions - 657 posts

  • I am familiar with appropriate technical questions. The hardest part for me in interviewing is finding out of the candidate has the right type of personality. My ideal person is a problem solver who ...
    Dba DBADba DBA
    Aug 13, 2008 at 4:01 pm
    Sep 3, 2008 at 2:12 pm
  • I need to get this of my chest.... I disagree that "all triggers are evil". Sure, a lot are evil, but not all. From where I stand you can use (table) triggers for two purposes: To implement "business ...
    Toon KoppelaarsToon Koppelaars
    Aug 20, 2008 at 1:32 pm
    Sep 4, 2008 at 2:46 pm
  • Hi list, I've got massive wait events named "PX Deq Credit: send blkd". As far as I know, that's a parallel query issue, a producer is faster then the consumer. But thats a textbook explanantion I ...
    Martin KlierMartin Klier
    Aug 29, 2008 at 2:51 pm
    Sep 23, 2008 at 12:13 pm
  • Hi On a non-technical note I have read a few times that some guys are the only dba in a company. What happens when you are sick / go on holiday? Who would recover the databases in such scenario ...
    Rob DempseyRob Dempsey
    Aug 22, 2008 at 11:10 am
    Aug 31, 2008 at 3:40 pm
  • For those using Raw Devices (wether for Redo Logs in non-RAC or for Database Files as well in RAC), see MetaLink Note#578455.1 "Announcement of De-Support of RAW devices in Release 12G " Hemant K ...
    Hemant K ChitaleHemant K Chitale
    Aug 7, 2008 at 3:02 pm
    Aug 12, 2008 at 11:52 am
  • Dear list, A question - maybe I am just silly, but I can't explain how that comes: One of my 10gR2 Databases is in NORACHIVELOG mode. (v$database log_mode is NOARCHIVELOG). If I force a logswitch ...
    Martin KlierMartin Klier
    Aug 21, 2008 at 4:29 pm
    Aug 26, 2008 at 9:35 am
  • I am curious about the acceptance and usage of AWR (Active Workload Repository) This has been around a few years now, and I see some bits of conversations where the assumption is made that AWR is ...
    Jared StillJared Still
    Aug 13, 2008 at 10:18 pm
    Aug 14, 2008 at 5:07 pm
  • I have functions that return ref cursors. We are getting these intermittent. The query in question is a join between 2 tables. Table A:Has never changed in production it is 100% static Table B: Gets ...
    Dba DBADba DBA
    Aug 29, 2008 at 1:58 pm
    Oct 17, 2008 at 6:08 pm
  • I know this is not a sys admin forum, but this is an oracle product so I hope its ok. My understanding is that in order to have a linux server see files on a SAN(and I would guess a netapp too) is ...
    Dba DBADba DBA
    Aug 18, 2008 at 9:42 pm
    Aug 19, 2008 at 3:12 pm
  • Sorry, my mistake. I checked the trace file and Cursor #10 is not in there. In fact I checked several traces and there are many SQL statements but never the one for the unaccounted for time. I am not ...
    Keith MooreKeith Moore
    Aug 6, 2008 at 8:22 pm
    Sep 18, 2008 at 6:59 pm
  • Windows: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 when I ran this on a very simple db: RMAN spool log to c:\temp\rman_test_log.txt RMAN run { 2 allocate channel dev1 type disk; 3 ...
    Guang MeiGuang Mei
    Aug 27, 2008 at 8:51 pm
    Aug 29, 2008 at 12:15 am
  • Hi all, Here is the test case: SQL select * from v$version; BANNER Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod PL/SQL Release 10.2.0.4.0 - Production CORE 10.2.0.4.0 Production ...
    Asif MomenAsif Momen
    Aug 1, 2008 at 4:30 pm
    Aug 4, 2008 at 5:53 pm
  • 64-bit 10.2.0.3 on Solaris 10 x86 When trying to export a single table, we get: ORA-01555: snapshot too old: rollback segment number with name "" too small The table contains out of line LOBs using ...
    Richa03_at_gmail.comRicha03_at_gmail.com
    Aug 26, 2008 at 3:49 pm
    Apr 6, 2009 at 5:19 pm
  • Hi, We have a situation where we would need to insert into a remote table from a read only database via a database link. My initial testing suggests that this is not possible as any distributed ...
    Debaditya ChatterjeeDebaditya Chatterjee
    Aug 27, 2008 at 3:08 pm
    Aug 29, 2008 at 3:58 pm
  • Hello all, Some of the older list members may remember me; I've been more or less away from Oracle for a few years but we still have a few old 9i systems I still maintain on a sporadic basis. Anyway, ...
    Walt WeaverWalt Weaver
    Aug 8, 2008 at 3:00 pm
    Aug 10, 2008 at 1:27 pm
  • Today I had a developer object that I was raising too many CMs, here's my usual process: [CM = Change Mangement Request] Receive a request Develop the scripts to fulfill that request Test them in an ...
    Ahbaid GaffoorAhbaid Gaffoor
    Aug 20, 2008 at 5:39 pm
    Sep 4, 2008 at 8:46 pm
  • If I rebuild an index online changing the initrans parameter, does it change initrans for all blocks of the index or just future blocks? Is there a method by which I can prove this? TIA, Rich -- ...
    Richa03_at_gmail.comRicha03_at_gmail.com
    Aug 21, 2008 at 12:26 am
    Aug 22, 2008 at 3:08 am
  • Folks, much appreciated if I can get some info: Anyone here using Netbackup agent to backup their dbs directly to tape - without using a FRA? If so, what's your opinion of ease of logging and ...
    Nuno SoutoNuno Souto
    Aug 13, 2008 at 3:02 pm
    Aug 14, 2008 at 2:16 pm
  • Oracle 9.2.0.4, Solaris We are having a production issue where user processes are very slow. We are seeing 'cache buffers chains' latch events in the 10046 trace file. What I'm not fully ...
    Keith MooreKeith Moore
    Aug 6, 2008 at 5:02 pm
    Aug 8, 2008 at 10:45 am
  • If only it were that simple. That gets me all the days and I am interested in the weekdays only. Brgds Jack -- J.A. van Zanen -- http://www.freelists.org/webpage/oracle-l
    Jack van ZanenJack van Zanen
    Aug 4, 2008 at 5:54 am
    Aug 7, 2008 at 12:17 am
  • First here's what I'm running on: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit PL/SQL Release 10.2.0.3.0 - Production CORE 10.2.0.3.0 Production TNS for Linux IA64: Version ...
    Rumpi GravensteinRumpi Gravenstein
    Aug 27, 2008 at 9:54 pm
    Aug 29, 2008 at 2:46 am
  • Hi, Oracle version 11.1.0.6 Any ideas why when I run this ddl: CREATE TABLE PILOT1_METADATA ( PATENT_SK NUMBER(9) NOT NULL,COLLECTION_ID VARCHAR2(8) NOT NULL,PDOC_COUNTRY CHAR(2) NOT NULL,PDOC_SERIAL ...
    Peter HitchmanPeter Hitchman
    Aug 18, 2008 at 1:38 pm
    Aug 18, 2008 at 2:50 pm
  • Hi, we are looking for a tool to measure and report the availability of our databases in the HA range, i.e. with high precision. At this time we are only interested in the database state, not whether ...
    Ingrid VoigtIngrid Voigt
    Aug 28, 2008 at 7:10 pm
    Aug 29, 2008 at 8:51 pm
  • Hi all, By default database auto starts with init pfile when reboot windows DB machine. In order to make database autostart using spfile, I edited registry key ORA__PFILE from '...\init.ora' to ...
    Jiang, LuJiang, Lu
    Aug 26, 2008 at 7:19 pm
    Aug 27, 2008 at 3:08 pm
  • I need to understand how RAC handles hostnames in JDBC connection strings. If I have an application that uses a JDBC connection string(that contains a hostname) to connect to the Oracle database, ...
    John DunnJohn Dunn
    Aug 14, 2008 at 9:31 am
    Aug 19, 2008 at 3:23 pm
  • Hi All, Anyone using ASM/clusterware on single databases in a active-passive configuration. Most of our medium sized customer installations are single databases in active-passive configuration using ...
    StalinStalin
    Aug 14, 2008 at 8:34 pm
    Aug 19, 2008 at 1:15 pm
  • For V11 Oracle Metalink says supported OS includes Windows Vista x64 - Business, Enterprise, and Ultimate editions My question is, for non-production/home use will V11 Oracle run on Vista Home ...
    Sol beachSol beach
    Aug 8, 2008 at 1:51 pm
    Aug 15, 2008 at 11:54 am
  • *Note:401132.1 I was trying to add a new node to a V10.2 RAC on OCF2 when encountered errors. From the note it says "*It is not possible to directly install Oracle Clusterware 10gR2 to use the block ...
    Sol beachSol beach
    Aug 12, 2008 at 4:53 pm
    Aug 13, 2008 at 2:38 pm
  • I am trying to find some sort of tool that will allow me to give a parent primary key entry, and the tool with either export or generate sql to create the entire object, the parent and all children, ...
    Andrew KerberAndrew Kerber
    Aug 22, 2008 at 2:24 am
    Aug 27, 2008 at 7:22 pm
  • I am created new database on LINUX/ORACLE 10.2.0.4 (64 bits). I don't have any error, but after startup database I always get error message on alert.log: Errors in file ...
    Dba1 mccDba1 mcc
    Aug 22, 2008 at 1:35 pm
    Aug 27, 2008 at 7:04 am
  • From the 10046 trace, I am trying to check the datatype of the bind: Bind#0 oacdty=01 mxl=128(57) mxlc=00 mal=00 scl=00 pre=00 oacflg=05 fl2=1000000 frm=01 csi=871 siz=128 off=0 ...
    Arul RamachandranArul Ramachandran
    Aug 23, 2008 at 10:57 pm
    Aug 26, 2008 at 2:51 pm
  • Hello, *- Oracle 9.2.0.8.0 - Solaris 8* I have two servers as above. One for production and one for staging. In both I have an oracle user, in which profiles I have the following lines: export ...
    David PintorDavid Pintor
    Aug 21, 2008 at 11:36 am
    Aug 21, 2008 at 5:47 pm
  • I sent out an email to a few developers yesterday with a link to the recent article by Tom Kyte in Oracle magazine. I get into an email exchange with one of them about some of Tom's points. The ...
    Stephens, ChrisStephens, Chris
    Aug 19, 2008 at 8:54 pm
    Aug 20, 2008 at 3:04 pm
  • did oracle enhance redhat at all or just change the splash screen and just give you the packages you need for oracle ? -- http://www.freelists.org/webpage/oracle-l
    Dba DBADba DBA
    Aug 18, 2008 at 11:37 pm
    Aug 19, 2008 at 4:38 pm
  • Folks For the same SQL with the same execution Path on the same Database, what is the possible cause for High Elapsed Time ub Case 2 (below)? NOTE - Table sizes having grown Slightly (by a few GB) in ...
    VIVEK_SHARMAVIVEK_SHARMA
    Aug 14, 2008 at 5:10 pm
    Aug 18, 2008 at 10:22 am
  • The poem of the Oracle DBA Interviewee.... Hello sir, how do you do? I'm an Oracle expert, Let me interview with you! Twenty years experience here. Oracle is the one, that my experience is near. Yes ...
    Robert FreemanRobert Freeman
    Aug 14, 2008 at 10:57 pm
    Aug 15, 2008 at 7:42 pm
  • Isn't possible to access a SQL Server database from within an Oracle database. If true, can someone point me in the right direction. Jeffrey Beckstrom Database Administrator Greater Cleveland ...
    Jeffrey BeckstromJeffrey Beckstrom
    Aug 8, 2008 at 5:53 pm
    Aug 9, 2008 at 5:03 am
  • What is the command to start applying archive log on a standalone standby database? I can't find it in the docs. Get ideas on sharing photos from people like you. Find new ways to share ...
    J. DexJ. Dex
    Aug 22, 2008 at 2:10 pm
    Aug 22, 2008 at 4:08 pm
  • Oops, I hit reply instead of reply all. You're probably running into a password reuse issue, where you can't reuse the last N number of passwords. Carol Bristow DPRA Inc. 1655 N. Ft Myer Dr. Ste925 ...
    Carol BristowCarol Bristow
    Aug 20, 2008 at 5:36 pm
    Aug 22, 2008 at 4:35 am
  • can you set the materialized view to rollup using parallel query so it runs faster ? how does the materialized view know which records are new and need to be added to the rollup? Doesn't it add some ...
    Dba DBADba DBA
    Aug 21, 2008 at 4:08 pm
    Aug 22, 2008 at 12:25 am
  • Typical - I go on holiday for day and somebody generates an abnormal load of archived logs. They filled up the disk, moved the wrong files then moved the right files - did a reboot and hey presto ...
    Howard LathamHoward Latham
    Aug 21, 2008 at 2:54 pm
    Aug 21, 2008 at 3:41 pm
  • We thought we were pretty good with 'su''ing to another account within the DB using the following script: spool temp.sql select 'alter user &1 identified by values '||chr(39)||password||chr(39)||';' ...
    Newman, ChristopherNewman, Christopher
    Aug 20, 2008 at 4:56 pm
    Aug 20, 2008 at 7:02 pm
  • Hi, Long story short, the target server had some issues with X that I didn't have time to monkey with this morning, so I installed a Solaris 64bit 10.2.0.4 agent using the response file, -silent and ...
    Newman, ChristopherNewman, Christopher
    Aug 18, 2008 at 1:45 pm
    Aug 19, 2008 at 4:43 pm
  • We are seeing lots of "row cache lock" waits in the DB during a long running insert and the performance is really poor on this insert. Any suggestions on what to look for? We have not come up with ...
    A EbadiA Ebadi
    Aug 11, 2008 at 7:43 pm
    Aug 18, 2008 at 6:25 am
  • It seems that ML is down, at least from Portland Oregon. Is it working for anyone else? -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-l
    Jared StillJared Still
    Aug 14, 2008 at 11:41 pm
    Aug 15, 2008 at 12:45 am
  • About a week ago, I asked where people are installing the Oracle client. To date, my responses are as follows: run from a shared network drive and importing registry entries into the client - 2 put ...
    Jeffrey BeckstromJeffrey Beckstrom
    Aug 7, 2008 at 11:49 am
    Aug 7, 2008 at 1:19 pm
  • Just learned that our Solaris admins are switching from sparc based Sun server to x-86 based. I'm not sure what particular models. I've warned my management that this is a secondary platform for ...
    Keith MooreKeith Moore
    Aug 27, 2008 at 10:29 pm
    Sep 10, 2008 at 12:37 am
  • Okay, let me preface this with I am not a GIS person. Also, I was trying to get this posted on the Oracle forums, but the site is still experiencing hiccups from their software upgrade last weekend, ...
    Bill FergusonBill Ferguson
    Aug 28, 2008 at 3:01 pm
    Sep 3, 2008 at 2:32 pm
  • If I have to open a support ticket, I have to get trace files from all of my RAC nodes (I have 10 of them). We have had several problems lately. This is very tiresome. Has anyone had success sticking ...
    Dba DBADba DBA
    Aug 29, 2008 at 2:15 pm
    Aug 29, 2008 at 8:11 pm
  • All, Does anyone know what, if any, special licensing is required to use Grid Control (10gR2) to monitor Oracle Standard Edi (10gR2)? We're mostly an enterprise shop but are getting a "package deal" ...
    Weatherman, JohnWeatherman, John
    Aug 28, 2008 at 2:04 pm
    Aug 28, 2008 at 3:03 pm
Group Navigation
period‹ prev | Aug 2008 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions134
posts657
users188
websiteoracle.com

188 users for August 2008

Jared Still: 34 posts Andrew Kerber: 26 posts Dannorris_at_dannorris.com: 21 posts Dba DBA: 20 posts Bobak, Mark: 18 posts Robert Freeman: 15 posts Riyaj Shamsudeen: 14 posts Martin Klier: 13 posts Niall Litchfield: 13 posts Tanel Poder: 13 posts Nuno Souto: 12 posts Stephens, Chris: 11 posts Mark W. Farnham: 10 posts Jack van Zanen: 9 posts Keith Moore: 9 posts Gints Plivna: 8 posts LS Cheng: 8 posts Roman Podshivalov: 8 posts Sol beach: 8 posts Howard Latham: 7 posts
show more
Archives