Search Discussions

349 discussions - 1,364 posts

  • Just got finished working on a little SQL perf problem. The query was something like... select a.col, b.col, (select count(distinct foo) from tbl3 where batch_id=3Db.batch_id) errors from tbl1 a, ...
    Post, EthanPost, Ethan
    Apr 21, 2005 at 5:51 pm
    Apr 25, 2005 at 12:05 pm
  • Hi guys! Anyone seen any issues with large locally mananged extents? Recently I noticed one of my applications taking a long time to do truncates. And an index rebuild where I increased the locally ...
    Wolfson Larry - lwolfsWolfson Larry - lwolfs
    Apr 23, 2005 at 12:30 am
    Apr 28, 2005 at 9:09 am
  • As a DBA should I be embarrassed?... ...besides optimizer_mode, I have never set any of these! Suggestions, articles, links, etc? Any "silver bullets" here? SQL show parameter opt NAME TYPE VALUE ...
    Marquez, ChrisMarquez, Chris
    Apr 22, 2005 at 1:08 pm
    Apr 28, 2005 at 6:38 pm
  • Hello all, I'm trying to dump some blocks with bbed. It asks for a password. According to Steve Adams, if I used strings on bbed I should find the password in 30 seconds... It's been 3 days.. ...
    Guerra, Abraham JGuerra, Abraham J
    Apr 12, 2005 at 5:48 pm
    Apr 20, 2005 at 7:02 am
  • Hi all, on Aix 5L. Before our cold RMAN backups, we shutdown and startup the instances as foll= ows: sqlplus '/ as sysdba' < Beginning consistent instance shutdown and mount: Thu Apr 14 ...
    Apr 14, 2005 at 9:49 am
    Apr 22, 2005 at 7:19 am
  • Who is going to be attending IOUG Live this year? Do we want to get together like we did last year? Sandra Arnold Principal DBA NCI Information Systems Oak Ridge, TN 37830 -- ...
    Arnold, SandraArnold, Sandra
    Apr 22, 2005 at 12:43 pm
    Apr 28, 2005 at 9:52 am
  • Just looking for opinions, unsubstantiated accepted, substantiated - even better. Q: How many triggers on a table is too many? any (all the business rules and constraints belong in THE application) ...
    Paul DrakePaul Drake
    Apr 21, 2005 at 4:56 pm
    Apr 22, 2005 at 11:22 pm
  • The index is on the simple status field on the huge partitioned table per day. Initially it is populated with value 0. When the record is processed I am thinking to put the value to NULL so removing ...
    Martic ZoranMartic Zoran
    Apr 7, 2005 at 9:30 am
    Apr 10, 2005 at 4:12 am
  • echoing Walt "Dream" Weaver, this was a fun read.=20 I liked the bits about surfing pr)n the best. Consider=20 serializing that in future "MyPost" emails, I would.=20 I am just dipping toe into ...
    Mohan, RossMohan, Ross
    Apr 7, 2005 at 1:18 pm
    Apr 15, 2005 at 12:43 am
  • Guys, I have a friend who is going to go through a security audit from an outside 3rd party. He would like to verify his security before they come. Does anyone know of any security opensource ...
    Apr 11, 2005 at 8:53 am
    Apr 14, 2005 at 5:51 am
  • This works on my Solaris server, when I run on my web host (not sure what OS) it will not set X and Y. Both are using ksh. Is this related to ksh versions or is this a stupid way to set multiple ...
    Post, EthanPost, Ethan
    Apr 5, 2005 at 3:00 pm
    Apr 6, 2005 at 11:41 am
  • Hi all, =09if someone is interested I just published=20 a free oracle resource profiler project on sourceforge. The actual url is http://sourceforge.net/projects/oraresprof/ where you can find the ...
    Giovanni CuccuGiovanni Cuccu
    Apr 27, 2005 at 10:41 am
    Apr 28, 2005 at 2:18 pm
  • We are running 9=2E2=2E0=2E6 on AIX 5L and suddenly we are getting weekly=20= ORA-600 [KGHALO4] errors in our alert=2Elog=2E Two weeks ago the database=20= actually crashed after one of these=2E ...
    Apr 4, 2005 at 1:00 pm
    Apr 8, 2005 at 4:02 pm
  • Hi, Oracle and Tivoli. My RMAN backups are running fine since few months. We just bought the agent for Tivoli. I would like to know is someone tried to create there RMAN backupsets either on ...
    Luc DemancheLuc Demanche
    Apr 21, 2005 at 4:41 pm
    Apr 29, 2005 at 8:52 am
  • RedHat Linux 9.0 Oracle Trying to start dbca and get this message..... [oracle_at_ceora9 9.2.0]$ /opt/oracle/9.2.0/jre/1.1.8/bin/../lib/i686/green_threads/libzip.so: symbol errno, version ...
    Hollis, LesHollis, Les
    Apr 28, 2005 at 4:05 pm
    Apr 29, 2005 at 9:54 am
  • Is there a way to determine (or trace) which individual statements are causing tempspace to be allocated to a session? I've got a databases where half a dozen sessions seem to gradually allocate more ...
    Greg NorrisGreg Norris
    Apr 19, 2005 at 3:58 pm
    Apr 21, 2005 at 8:04 am
  • We are in the process of upgrading several databases from 8i on AIX 4.3.3 to 9 on AIX 5.2 or 10g on AIX 5.2. The target version depends upon whether or not the application is supported on 10g or ...
    Tracy RahmlowTracy Rahmlow
    Apr 5, 2005 at 11:03 am
    Apr 7, 2005 at 6:56 pm
  • Hi: I like to know what is the relationship between AQ and JMS? Is AQ built on top of JMS? If not what is the underlying technology for AQ? I think AQ is written in C language and uses its own ...
    Sami SeeranganSami Seerangan
    Apr 9, 2005 at 10:18 pm
    Apr 14, 2005 at 6:47 am
  • Hi, I want to capture those queries on basis of following criteria. 1)SQLs that take more than 5 seconds 2)SQLs that take more than 10 seconds 3)SQLs that take more than 20 seconds Can I do it ...
    Seema SinghSeema Singh
    Apr 7, 2005 at 11:07 am
    Apr 8, 2005 at 5:24 am
  • I've been asked by one of our clients to take over monitoring their Oracle database. I'm still trying to find out exactly what they want us to do; to me that means running something like Spotlight ...
    Janine SiskJanine Sisk
    Apr 29, 2005 at 4:08 pm
    May 10, 2005 at 12:04 am
  • Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Subject: Batch load freezes every couple of minutes=20 RDBMS Version: RAC Operating System and ...
    Ranko MosicRanko Mosic
    Apr 17, 2005 at 7:57 pm
    Apr 20, 2005 at 7:39 pm
  • How do I compare two separatelly defined PL/SQL records without referencing each and every field ? source_rec source_table%rowtype; source1_rec source1_table%rowtype; Thanks, Ranko. -- ...
    Ranko MosicRanko Mosic
    Apr 29, 2005 at 9:05 am
    May 13, 2005 at 12:26 pm
  • Looking at going for it. However, we do NOT use RMAN. How much of a hinderence will that be for taking the tests? Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority ...
    Jeffrey BeckstromJeffrey Beckstrom
    Apr 14, 2005 at 11:23 am
    Apr 18, 2005 at 3:01 pm
  • Here's an interesting proposition: http://www.oreillynet.com/pub/a/network/2005/04/11/rsdp.html I don't particularly like the author's specific, proposed solution, but there may be merit in having a ...
    Jonathan GennickJonathan Gennick
    Apr 12, 2005 at 10:33 am
    Apr 17, 2005 at 3:22 pm
  • One of our new systems (Documentum from EMC) uses a database link to a remote database (Ocella from Ocella) for some processes. Due to organisation politics the people managing the Ocella database ...
    Stephen boothStephen booth
    Apr 26, 2005 at 6:57 am
    Apr 26, 2005 at 10:31 am
  • Hi all, I'm looking for guidelines, how should be the interactions between DBA team and other development teams. For example - Each new table has to have description ... Define table main queries . ...
    Amihay GonenAmihay Gonen
    Apr 12, 2005 at 10:14 am
    Apr 18, 2005 at 2:41 pm
  • --Env Oracle 9206 AIX 5.x I don't have much experience with "User Defined Datatypes" nor "XML Datatypes".=20 Trying to move a database for a client that uses these datatypes. (not sure but maybe some ...
    Marquez, ChrisMarquez, Chris
    Apr 15, 2005 at 4:36 pm
    Apr 22, 2005 at 11:57 am
  • I have a 7bn row, weekly partitioned IOT that adds hundreds of millions of rows each week. A five percent stats job estimate takes 20 hrs every weekend. Given that I only insert to the latest ...
    Teehan, MarkTeehan, Mark
    Apr 11, 2005 at 11:38 pm
    Apr 12, 2005 at 10:22 am
  • Which doc contains Lob Segment limits? I'm trying to get my head around the blob storage growth I'm experiencing.
    Apr 21, 2005 at 2:04 pm
    Apr 22, 2005 at 4:13 am
  • I wonder if anyone has seen this before 1 select constraint_name,table_name from all_constraints 2* where constraint_type='?' SQL / CONSTRAINT_NAME TABLE_NAME ------------------------------ ...
    Niall LitchfieldNiall Litchfield
    Apr 20, 2005 at 4:28 am
    Apr 21, 2005 at 7:59 am
  • I feel as though I'm looking for a needle in haystack on http://otn.oracle.com Is partitioning included in the 10g Standard Edition? TIA! -- http://www.freelists.org/webpage/oracle-l
    Sol beachSol beach
    Apr 8, 2005 at 4:03 pm
    Apr 10, 2005 at 8:53 am
  • We are contemplating creating a single Statpack database, on one server/instance, and pushing all of our Statspack data to it. This would probably include data from 7-8 instances. We are guessing ...
    Apr 29, 2005 at 12:44 pm
    May 1, 2005 at 10:12 am
  • I am running following procedure ( Oracle 9i ):=20 dbms_job.submit( l_job, 'background_submit_proc( JOB, NEXT_DATE);' ); create or replace procedure background_submit_proc( p_job in number, ...
    Ranko MosicRanko Mosic
    Apr 21, 2005 at 9:29 am
    Apr 26, 2005 at 2:58 pm
  • Got this ( windows ) ORA-04030: out of process memory when trying to allocate 16396 bytes (koh-k= ghu call,pl/sql: adt/record) What should I do ?=20 Thanks, Ranko. -- ...
    Ranko MosicRanko Mosic
    Apr 25, 2005 at 8:51 am
    Apr 25, 2005 at 10:01 am
  • Hope this brings any further inside and is what you were asking for. We have a SUN V490 - Ultrasparc IV prtdiag |less CPUs Run E$ CPU CPU Brd CPU MHz MB Impl. Mask --- ----- ---- ---- ------- ---- A ...
    Markus RegerMarkus Reger
    Apr 21, 2005 at 10:09 am
    Apr 24, 2005 at 4:20 pm
  • Could someone give me some "benchmarks" defining good performance? Our management comes from small shop, SQL Server world. I was the first Oracle resource here, about a year and a half ago. We have a ...
    Wiegand, JeffWiegand, Jeff
    Apr 20, 2005 at 2:05 pm
    Apr 24, 2005 at 4:53 am
  • greetings, we would like to implement RAC but have an issue with one application that is not RAC certified. can we have RAC and non-RAC databases on the same servers? we are currently running HP ...
    Haroon A. QureshiHaroon A. Qureshi
    Apr 18, 2005 at 2:47 pm
    Apr 22, 2005 at 4:06 pm
  • I'm getting confused on regular expressions (Oracle I want to strip all punctuation from a user supplied input string except for the '%' wildcard character. To see if my formatting of the ...
    William B FergusonWilliam B Ferguson
    Apr 20, 2005 at 4:15 pm
    Apr 22, 2005 at 8:55 am
  • I am having a databasse been using very much of CPU where during peak time, a single process used to call several time and so taking almost all CPU and stop the site.Is there way I can control that ...
    Sanjay MishraSanjay Mishra
    Apr 20, 2005 at 5:10 pm
    Apr 21, 2005 at 10:52 am
  • OS: Solaris 8 Oracle: AS10g (9.0.4) Infrastructure I'm in the process of removing all pieces of oracle before doing a fresh install and I found a directory called /var/preserve/oracle which has the ...
    Scott StefickScott Stefick
    Apr 20, 2005 at 8:48 am
    Apr 21, 2005 at 9:06 am
  • hello, wanna know is tat possible to install oracle 8i client and oracle 9i database in the same machine ? If yes, which one should i install first ? INstall oracle 9i database first or oracle 8i ...
    Kean JacintaKean Jacinta
    Apr 19, 2005 at 12:33 am
    Apr 19, 2005 at 11:23 am
  • Does anyone use OEM to run jobs against a server that contains multiple DBs? I have a server that has 2 databases on it and a need to run a job via OEM against both databases. The job is a mixture of ...
    Herring Dave - dherriHerring Dave - dherri
    Apr 12, 2005 at 9:33 am
    Apr 12, 2005 at 6:32 pm
  • Few days after the patchset was released there is still not a single 1-off patch in the Metalink. Does that mean that is bug free (a.k.a "unbreakable") or that Oracle Support personnel is ...
    Mladen GogalaMladen Gogala
    Apr 1, 2005 at 3:25 pm
    Apr 4, 2005 at 11:07 am
  • Is there a 32 bit version of Oracle 9i for AIX? The one I downloaded from otn did not specify 32 or 64 bit. Thanks, Manjula -- http://www.freelists.org/webpage/oracle-l
    Manjula KrishnanManjula Krishnan
    Apr 28, 2005 at 3:55 pm
    Apr 29, 2005 at 10:52 am
  • Can someone tell me what privilege is needed for a user to truncate a table that is not owned by that user? I have looked at Metalink and it states the Drop Any Table privilege, but this doesn't work ...
    Burton, LauraBurton, Laura
    Apr 25, 2005 at 11:51 am
    Apr 28, 2005 at 11:54 am
  • Hello All, I am having really hard time finding information about the 10g clusterware. I keep seeing references here and there to obscure executables in /app/crs/bin, but no other information ...
    Christo KutrovskyChristo Kutrovsky
    Apr 6, 2005 at 3:38 pm
    Apr 28, 2005 at 1:20 am
  • Any hints? 9204. thanks in advance Raj select standard_disclaimer from company_requirements where category = 'MANDATORY'; -- http://www.freelists.org/webpage/oracle-l
    Apr 26, 2005 at 12:39 pm
    Apr 27, 2005 at 5:53 pm
  • Hi all, I do have a table with a varchar2(300) coloumn. Whenever I do a select = on this, the output line gets linewrapped after the 274th. character. This CR/LF is definitely not added within the ...
    Apr 19, 2005 at 6:06 am
    Apr 19, 2005 at 8:53 am
  • I am wanting to test dbs_repair, but I need to corrupt a block within my test database. Anybody know how to do it? -- http://www.freelists.org/webpage/oracle-l
    Peter DixonPeter Dixon
    Apr 18, 2005 at 7:13 am
    Apr 19, 2005 at 2:54 am
  • All, I need to schedule a job to run weekly at a specific time. I want to use DBMS_JOB to run it but I'm having some issues. The error I get when I try to submit the job in SQL is this: SP2-0734 ...
    Jaehne, Richard SJaehne, Richard S
    Apr 15, 2005 at 2:14 pm
    Apr 15, 2005 at 2:37 pm
Group Navigation
period‹ prev | Apr 2005 | next ›
Group Overview
grouporacle-l @

354 users for April 2005

Jared Still: 42 posts Martic Zoran: 42 posts Christian Antognini: 39 posts Niall Litchfield: 35 posts Post, Ethan: 30 posts Mladen Gogala: 28 posts Stephen booth: 28 posts Mhthomas: 26 posts Paula_Stankus_at_doh.state.fl.us: 25 posts Mercadante, Thomas F (LABOR): 24 posts Rjamya: 23 posts Goulet, Dick: 22 posts Paul Drake: 21 posts Wolfgang Breitling: 19 posts Christo Kutrovsky: 17 posts Marquez, Chris: 17 posts Vitalis Jerome: 17 posts Lex de Haan: 15 posts Tim Gorman: 15 posts Kirtikumar Deshpande: 14 posts
show more