Search Discussions

275 discussions - 1,245 posts

  • We are currently starting the process of interviewing/hiring a junior dba. My boss would like me to come up with a small case study (1/2 hour or less - no reference materials) to help determine the ...
    Shannon St. DennisShannon St. Dennis
    Feb 25, 2005 at 3:25 pm
    Mar 6, 2005 at 8:30 am
  • Hi! Oracle on AIX 5.2 We are nserting large amonts of data in one session without commiting = because of business reasons.=20 So, I'm wondering is there a way to monitor progress of this ...
    Sonja �ehovi�Sonja �ehovi�
    Feb 1, 2005 at 3:02 am
    Feb 4, 2005 at 9:25 am
  • oracle 9i code works something like this now: CURSOR c_user_tables IS SELECT table_name FROM user_tables; begin FOR x IN c_user_tables LOOP BEGIN SELECT table_name INTO dummy FROM myTables WHERE ...
    Guang MeiGuang Mei
    Feb 9, 2005 at 4:15 pm
    Feb 16, 2005 at 5:43 pm
  • Hi, I Would Just LIke To Ask Whether It Is Possible To Delete 60 Million Rows. At A Strech And Without Undo Contention. The Requirenment Is To Delete 60 Million Records From The 160 Million Records ...
    Sheldon QuinnySheldon Quinny
    Feb 8, 2005 at 4:42 am
    Feb 10, 2005 at 7:07 pm
  • Hi, Just Wanted The Answer From An Interview Point of View. What Is Oracle. (Should We Start From The Company Profile To The Product) What Is Logical Structure Of Oracle. If Log Buffer Default Size ...
    Sheldon QuinnySheldon Quinny
    Feb 11, 2005 at 11:06 pm
    Feb 17, 2005 at 2:47 pm
  • Hi, I want to ask two questions about the following 2 sql statements. The below tkprof output shows 2 executes for each of them although i executed each once. Is it because of the select statements ...
    Yasin BaskanYasin Baskan
    Feb 2, 2005 at 5:26 am
    Feb 4, 2005 at 10:37 am
  • what I need to do is return a cursor from one query in a procedure.... no problemo What I need to do is : for every ID returned in the first query returned ....use this in the where condition of the ...
    Duret, KathyDuret, Kathy
    Feb 2, 2005 at 1:58 pm
    Feb 15, 2005 at 12:27 pm
  • Koen I have zero experience with 10g RAC, but a I was talking to another DBA = who was looking in the same thing. He believed that with a 3rd party clusterware, you would HAVE TO use = Oracle storage ...
    Marquez, ChrisMarquez, Chris
    Feb 2, 2005 at 1:07 am
    Feb 18, 2005 at 5:36 pm
  • /* Hi Oracle partitioning gurus, I am trying to setup a group of tables partitioned on a date column so that monthly a new partition can be added and the oldest partition can be archived. I have ...
    Feb 4, 2005 at 5:06 am
    Feb 25, 2005 at 10:21 am
  • Hi: I am running a stored procedure(say P1 with 5000 lines) using a particular session (say sid=135). By joining gv$session and gv$sql, I can identify whether the stored procedure is running or not ...
    Sami SeeranganSami Seerangan
    Feb 5, 2005 at 9:33 am
    Feb 8, 2005 at 4:47 am
  • In my alert.log I have the following text: Mon Feb 14 20:29:29 2005 Starting ORACLE instance (normal) LICENSE_MAX_SESSION =3D 0 LICENSE_SESSIONS_WARNING =3D 0 Picked latch-free SCN scheme 2 ...
    Mladen GogalaMladen Gogala
    Feb 14, 2005 at 8:55 pm
    Feb 16, 2005 at 4:27 pm
  • wanted a bit of everyones take on letting the boss know that you had an interview and have confirmed being on the short list. Is it a good idea? consequences? your ideas? -- Bryan S Wells - DBA ...
    Bryan WellsBryan Wells
    Feb 25, 2005 at 11:22 am
    Feb 25, 2005 at 2:35 pm
  • Hi, I pay referral fees if the referral results in a hire. Therefore, if the position described below is not a match for you (i.e. qualifications, location,etc) but you know of someone who would be ...
    Feb 9, 2005 at 4:19 pm
    Feb 11, 2005 at 2:38 pm
  • Hi, all, We have a database which maxed its CPU capacity. and I did some SQL tuning /index creation. I happened to think some index should be useless and I enabled index monitoring for some index and ...
    Zhu chaoZhu chao
    Feb 5, 2005 at 4:55 am
    Feb 6, 2005 at 5:04 am
  • Hi, oraperf is "down" so I need some advice, I have a group of small tables 13,000 records 310,000 records, etc. A process took 5 minutos to complete and now takes 3:00 The only think changed was a ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Feb 17, 2005 at 3:04 pm
    Feb 18, 2005 at 4:27 pm
  • How can I find which sessions have open database links? I know v$dblink will show me if my own session has a database link open. And http://www.jlcomp.demon.co.uk/faq/find_dist.html shows how to find ...
    Reardon, Bruce (CALBBAY)Reardon, Bruce (CALBBAY)
    Feb 11, 2005 at 12:42 am
    Feb 16, 2005 at 8:14 pm
  • Hi, Some one tested RESETLOGS new functionality on 10g, in a big database? Now the backup after the resetlogs is optional "In prior releases, it was recommended that you back up the database ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Feb 23, 2005 at 12:42 pm
    Mar 3, 2005 at 1:30 am
  • If a Oracle datafile is removed from a file while the instance is still running and the database is open, is it possible to recover without using a backup before shutting down the database? Reason I ...
    Feb 24, 2005 at 3:32 pm
    Mar 1, 2005 at 12:15 pm
  • Hi, I would like to know the impact of changing the time on my UNIX machine. how would it impact a ORACLE database running on the server. I think Oracle takes its sysdate from the UNIX. Thanks for ...
    A JoshiA Joshi
    Feb 24, 2005 at 3:40 pm
    Feb 25, 2005 at 4:43 pm
  • We have a sequence that is about to reach it's maximum value (999999). Ordinarly, I would just expand the column and let it keep going, but it populates a business column. They don't care what the ...
    Knight, JonKnight, Jon
    Feb 17, 2005 at 4:58 pm
    Feb 24, 2005 at 8:27 pm
  • Hi: We have to store all the date/times in GMT format. Is there aeasy way to get db timezone without using java program in 9i? Thanks in advance Sami -- http://www.freelists.org/webpage/oracle-l
    Sami SeeranganSami Seerangan
    Feb 18, 2005 at 9:38 am
    Feb 23, 2005 at 12:17 pm
  • The development folks would like to be able to view the procedures, packages, etc., on a production reporting database, but we do *NOT* want them to be able change anything. This is sort of like a ...
    Feb 10, 2005 at 3:29 pm
    Feb 11, 2005 at 1:37 pm
  • I have an SQL script that looks for sufficient space for the next extent. I am having a problem though when Oracle is breaking the datafile into multiple free extents, i.e. 26 107,758 153,816 ...
    Jeffrey BeckstromJeffrey Beckstrom
    Feb 7, 2005 at 7:53 am
    Feb 7, 2005 at 1:00 pm
  • We use RMAN on Oracle9i to back up to disk. No SAN or MML, but use an RMAN catalog. I use cron to initiate the backup (Unix servers). In revising the system, I'm trying to decide whether it is better ...
    Feb 1, 2005 at 2:15 pm
    Feb 2, 2005 at 12:47 pm
  • (Reposted - previous post had wrong subject line. Sorry!) I'm trying to create a db link from a 9i database to an 8i database on another server. I've edited the tnsnames.ora file for the 9i database, ...
    Paul VincentPaul Vincent
    Feb 25, 2005 at 7:49 am
    Feb 28, 2005 at 12:03 pm
  • I am experimenting with advanced queueing in Oracle 9i and am able to enqueue and dequeue messages within the same database. However I would like to dequeue messages on a remote database via a ...
    John DunnJohn Dunn
    Feb 17, 2005 at 5:46 am
    Feb 18, 2005 at 8:02 am
  • Hi All, Looking for pointers on dealing with NLS_CHARACTERSET on Windows clients. We have 2 apps here that require different settings for the client. One of them requires UTF8, the other simply will ...
    Jared StillJared Still
    Feb 15, 2005 at 7:49 pm
    Feb 17, 2005 at 12:57 pm
  • I am trying to tune a custom app running on Oracle 9=2E2=2E0=2E5 for AIX 5L=20= (64bit) and found the following SQL in my statspack snapshot=2E=20= Why there are so many LIOs on an INSERT statement? ...
    Feb 10, 2005 at 10:09 am
    Feb 11, 2005 at 7:01 am
  • Hi, basic question on jobs, how can I schedule a job to run from Tuesday = to Saturday at 5am? regards, GAP -- http://www.freelists.org/webpage/oracle-l
    Aragon, Gabriel (GE Commercial Finance)Aragon, Gabriel (GE Commercial Finance)
    Feb 3, 2005 at 10:54 am
    Feb 5, 2005 at 5:18 pm
  • What is the current state of the art WRT CBO best practices? I'm working on and considering the 'automated statistics gatherin= g' approach. This involves turning on monitoring for any and ...
    Jeremiah WiltonJeremiah Wilton
    Feb 3, 2005 at 7:11 pm
    Feb 4, 2005 at 10:28 am
  • Hello, after upgrading a two nodes RAC from to I got a surprise. If a node don't see a link up on it's interconnect NIC than it doesn't give anymore service. For example, in my ...
    Magni FabrizioMagni Fabrizio
    Feb 1, 2005 at 3:08 am
    Feb 1, 2005 at 1:06 pm
  • Hi Rac gurus I am working on a 2 node 10g1.0.3 rac on HP itanium I am seeing that if any one of the node goes down The other working node crs freezes and releases to the clients after around 10 mins ...
    Arun chakrapani raoArun chakrapani rao
    Feb 21, 2005 at 5:42 pm
    Feb 24, 2005 at 3:11 pm
  • How can I monitor the average service time, %busy, %waiting, etc. for disks on the system? I get these metrics easily using < iostat -xcn on Solaris, but there is no equivalent on AIX. Thanks Waleed ...
    Khedr, WaleedKhedr, Waleed
    Feb 22, 2005 at 5:16 pm
    Feb 23, 2005 at 11:19 am
  • Gals & Guys, I'd like to have a quick poll, for my bosses sake, on the impression of the list on the use of mobile/wireless admin tools, like Expand Beyond's Pocket DBA. Anyone care to reply? ...
    Goulet, DickGoulet, Dick
    Feb 11, 2005 at 3:01 pm
    Feb 19, 2005 at 10:25 am
  • Really sorry for this OT. Hi list, this is a very important complaing against this list. I think this list is unfair with Mladen. Once I follow his advice to solve a problem and I formated a disk, ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Feb 18, 2005 at 8:56 am
    Feb 18, 2005 at 10:29 am
  • Which one is better? replace(replace(a.url_addr_text,';','/'),'?','/') translate(a.url_addr_text,';?','//') -- Sami Seerangan Oracle DBA -- http://www.freelists.org/webpage/oracle-l
    Sami SeeranganSami Seerangan
    Feb 10, 2005 at 12:10 pm
    Feb 14, 2005 at 10:15 pm
  • Just wondering if one of my strongly held untested assumptions is wrong. I always thought that when you connected to Oracle via the listener in dedicated server mode, you would come in via the ...
    Henry PorasHenry Poras
    Feb 4, 2005 at 10:04 am
    May 31, 2005 at 10:14 am
  • Dear friend We have deployed a production change today. Change incloves a Pro*C program running at backed from Application server and doing some insert into the table 1,2,3 based on certain ...
    Sanjay MishraSanjay Mishra
    Feb 21, 2005 at 11:48 am
    Feb 22, 2005 at 7:49 pm
  • John, I use them in a couple of applications and generally, they work fine. A slow network is a slow network. Yes, it can hurt performance. If you think that your network cannot support your ...
    Mercadante, Thomas FMercadante, Thomas F
    Feb 8, 2005 at 9:58 am
    Feb 14, 2005 at 12:08 am
  • Dear Guys, To save costs we are purchasing Oracle standard edition licenses where we can. I am considering purchasing them for our Oracle database server which only houses OEM's repository and RMAN's ...
    Feb 7, 2005 at 10:35 am
    Feb 9, 2005 at 12:05 am
  • Hi, do you have and Oracle online library account. what is better, 280U$ in 1 year Online Library account or 280U$ buying good books. Thank you -- Oracle 9i,10g Certified Professional (Experience on ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Feb 4, 2005 at 5:24 pm
    Feb 7, 2005 at 7:51 am
  • Anyone has an idea what is it like? 33 hours non-stop action! :))) http://partnercontent.oracle.com/home/news/emea/german/germany/hw/index.html?hw5.html Regards, Alex -- ...
    Alexander GorbachevAlexander Gorbachev
    Feb 25, 2005 at 4:13 am
    Feb 28, 2005 at 10:59 pm
  • Hello, I have a query using LIKE with the ESCAPE clause to search for an underscore '_' as a literal value. When I run the query with the ESCAPE clause it takes much longer then when the same query ...
    Feb 18, 2005 at 4:13 pm
    Feb 22, 2005 at 10:19 am
  • Hello list, Could any one give me the script or sql for the following requirements: If I need to know the 100th day of this year, like, If I pass value 100, want to extract the 100th day of the given ...
    Feb 15, 2005 at 7:47 am
    Feb 15, 2005 at 8:49 pm
  • Hi! Oracle 9.2.4 in AIX 5.2. I would like to limit time frame when some of my users can connect to = one of the databases.=20 That is, they can do whathever they want/need between 6 p.m. and 7. = ...
    Sonja �ehovi�Sonja �ehovi�
    Feb 6, 2005 at 10:13 am
    Feb 14, 2005 at 7:53 am
  • without writing a whole series of ifs, given a number 1 - 12 give the corresponding three letter month like what you get with date +%b, but someone supplies you the digits -- ...
    Michael McMullenMichael McMullen
    Feb 2, 2005 at 2:21 pm
    Feb 11, 2005 at 8:03 pm
  • Greetings, We have a legacy application using 8i database which we have to replicate using insert triggers. One of the tables includes LONG column, when we try to create a trigger it fails ...
    Nicolai TufarNicolai Tufar
    Feb 8, 2005 at 9:39 am
    Feb 8, 2005 at 6:51 pm
  • Different default 8i/9i column lengths when selecting pseudo columns... This is the issue... =20 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20 8.1.7 SQL*Plus=20 ...
    Marquez, ChrisMarquez, Chris
    Feb 1, 2005 at 5:22 pm
    Feb 8, 2005 at 10:33 am
  • Solaris Users called me up saying their packages/procedures no longer work. Of course, they've been working for years. I've whittled it down to a test case below Note I've logged in as the ...
    Michael McMullenMichael McMullen
    Feb 1, 2005 at 11:07 am
    Feb 3, 2005 at 3:09 am
  • Hi, I want to generate one script which can return me dd,mm, yyyy part of every day for a duration, for example .. if I start from Jan 01,1999 to jan 01, 2010 then wanted the record for every day. ...
    Feb 1, 2005 at 5:33 am
    Feb 1, 2005 at 5:17 pm
Group Navigation
period‹ prev | Feb 2005 | next ›
Group Overview
grouporacle-l @

265 users for February 2005

Niall Litchfield: 41 posts Mercadante, Thomas F: 39 posts Juan Carlos Reyes Pacheco: 38 posts Jared Still: 32 posts Sami Seerangan: 31 posts Martic Zoran: 27 posts Mladen Gogala: 26 posts Paul Drake: 25 posts David Wendelken: 23 posts Lex de Haan: 23 posts Goulet, Dick: 22 posts Ryan_gaffuri_at_comcast.net: 22 posts Tim Gorman: 22 posts Wolfgang Breitling: 21 posts Hollis, Les: 20 posts Tanel Põder: 20 posts Leonard, George: 17 posts Alexander Gorbachev: 16 posts Knight, Jon: 16 posts Mark Bole: 16 posts
show more