Search Discussions
-
I've been keeping an eye on the Boston Globe's Oracle DBA job postings, two years ago it wasn't uncommon to see eight or more per week, now I tend to see one or two, or none. For a while they also ...
Boivin, Patrice J
Aug 14, 2003 at 11:34 am
Aug 15, 2003 at 2:54 pm -
Just for grins, I'll ask this question... Is there any way to keep the Unix "root" user from logging into the database (i.e. connect internal or / as sysdba)? Currently using 8.1.7.4 on Solaris 8 ...
Walter K
Aug 28, 2003 at 3:34 pm
Aug 31, 2003 at 5:39 am -
Has anyone else noticed? Not so long ago, we saw quite a few more questions about such things as data modeling, application security architecture, physical database design, and Oracle Designer Not so ...
Jared Still
Aug 22, 2003 at 6:19 am
Aug 27, 2003 at 10:14 pm -
There seems to be a problem with consistent shutdowns in 9i Oracle 9i 64bit 9.0.1.3.0 - infrastructure database that comes with the application server 9.2.0.1.0 - that is the version of RDBMS we are ...
Paula_Stankus_at_doh.state.fl.us
Aug 20, 2003 at 4:24 pm
Aug 22, 2003 at 4:49 am -
Guys, When trying to duplicate database with this script I have my auxiliary setup as new database, target setup as old database and am using duplicate database command along with logfile command to ...
Paula_Stankus_at_doh.state.fl.us
Aug 4, 2003 at 9:09 pm
Aug 6, 2003 at 1:44 pm -
26
Hey Jared
Jared, Did you send the list/me some mail with "Your Details" as subject line. It has some .pif file as extention. Maybe that is some virus, So wanted to make sure before i open it. Thanks. Enter for ...Dilip Patel
Aug 25, 2003 at 5:14 pm
Aug 28, 2003 at 6:59 pm -
Hi Listers, One of my remote Clients is facing a problem with Redo Logs. The Redo Logs and the Archive logs in turn have suddenly started to generate at an alarming Rate. This has suddenly started ...
Munish Bajaj
Aug 1, 2003 at 10:34 am
Aug 4, 2003 at 1:34 pm -
Just came to know from CTOUG news that Oracle has chosen Arup Nanda(our List member) as "DBA of the Year". Congratulations Arup. thought I will share this news with the group. CTOUG Board Member, ...
Prasada.Gunda_at_hartfordlife.com
Aug 28, 2003 at 2:54 pm
Aug 29, 2003 at 10:44 pm -
Dear All, I am collecting (Just writing in a book ) of all tough problems, great issues handled with Oracle RDBMS as a DBA. Request you kindly send us the Top 5 Problems, Difficult scenarios(the most ...
Veeraraju_Mareddi
Aug 23, 2003 at 1:09 pm
Aug 27, 2003 at 11:09 am -
Hi, does anybody have any experience with setting the SGA_MAX_SIZE in 9i. I assumed the purpose of this parameter was that SGA would grow as requested to that limit. Example: You could configure your ...
Stephen.HODGKINSON_at_eaguk.com
Aug 1, 2003 at 9:54 am
Aug 9, 2003 at 1:09 pm -
Oracle 8.1.7.4 Win2k What is the consensus on datafile sizing and the impact/overhead multiple datafiles have on performance? For example, if I have one 2.5g datafile, and three 1g datafiles, and I ...
Dave Phillips
Aug 6, 2003 at 8:14 pm
Aug 8, 2003 at 12:15 pm -
Just completed the registration, and was wondering how much company I was going to have there. Who else has plans to attend? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author ...
Steve McClure
Aug 15, 2003 at 1:24 am
Aug 28, 2003 at 10:49 pm -
Hi, Whats the best way to write the results of a SQL query to a CSV file? Thanks. Hotmail messages direct to your mobile phone http://www.msn.co.uk/msnmobile -- Please see the official ORACLE-L FAQ ...
Imran Ashraf
Aug 25, 2003 at 12:39 pm
Aug 26, 2003 at 9:19 pm -
Our hardware people tell me that our disk array will not support Raid 10. Given a choice between Raid 1 or 5 for my tablespaces, which one is best? This is Oracle 8.1.7 on AIX 4.3.3. The application ...
Schauss, Peter
Aug 12, 2003 at 7:24 pm
Aug 15, 2003 at 2:34 am -
Guys, I have attached statspack report here. The ENV is Oracle 9.2.0.3 / Win2k AS - SP3. 1.Can you tell me which INIT parameters are to be changed which will give improved performance ? 2.can someone ...
Prem Khanna J
Aug 10, 2003 at 2:24 pm
Aug 14, 2003 at 5:14 am -
how different is it to administer oracle on different flavors of unix? Im running into some annoying nuassances in syntax between solaris korn shell and hp-unix korn shell. is it just little syntax ...
Rgaffuri_at_cox.net
Aug 26, 2003 at 1:24 pm
Aug 28, 2003 at 9:34 pm -
19
SharePlex
Hello, Quest is trying to sell us a product named SharePlex. It sounds very attractive, but then sales people are supposed to be good at that. We are a mid sized company, about 2.2 billion per year, ...Nelson, Allan
Aug 8, 2003 at 9:14 pm
Aug 11, 2003 at 9:44 am -
We have a situation where a process can't insert into a partition of a partitioned table. The process just keeps running. - A stored procedure executes a SQL insert statement (listing below). - It ...
DENNIS WILLIAMS
Aug 6, 2003 at 3:39 pm
Aug 8, 2003 at 9:24 pm -
Hi All I would like to ask for your thoughts on whether to RAC or just go vertical (more cpu) Background Txn - OLTP like txn during day but batch extracts at night and very big batch extract ...
Tjambu_fatcity_at_yahoo.com.au
Aug 5, 2003 at 12:29 pm
Aug 6, 2003 at 1:19 pm -
Does anyone have any experience using cursor_sharing in 8.1.7.4? I feel I need to use it due to literal SQL statements being used. We have had misc 4031 errors off and on and I feel this is my last ...
Fedock, John (KAM.RHQ)
Aug 19, 2003 at 6:49 pm
Aug 22, 2003 at 1:39 am -
DABs, Is there any way in my connection to get the sid and serial# for my own connection? Suppose I connect to Oracle db by sqlplus scott/tiger_at_test. In this connection, SQL What shoud I input to ...
Chuan.zhang_at_customs.gov.au
Aug 29, 2003 at 4:34 am
Aug 30, 2003 at 2:04 pm -
I have created my first 9i database on OS/390 v2.10. On my Oracle 8i instance, I can connect to the database using: sys/sys_password_at_the_instance HOWEVER, In Oracle 9i, I cannot do this. I am ...
Babette Turner-Underwood
Aug 17, 2003 at 4:29 am
Aug 18, 2003 at 5:44 pm -
Wolfe Knowing SQL Server and moving to Oracle is going to be tough. The other way round is very simple though from Oracle to SQL Server. Every database functions differently in many respects. Best is ...
Suhen Pather
Aug 1, 2003 at 12:29 am
Aug 4, 2003 at 11:54 pm -
I need to move selected tables from one schema to another schema within the same database. The tables I need to move all start with the same prefix (abc_sometablename). Say there are 200 tables out ...
Smith, Ron L.
Aug 4, 2003 at 4:14 pm
Aug 4, 2003 at 5:44 pm -
13
Grid
While I was cleaning up the other day, I noticed a magazine sticking out of the middle (sadly, closer to the top) of my still-to-be-read list. The cover story of Physics Today (Feb. 2002) is "The ...Henry Poras
Aug 25, 2003 at 6:09 pm
Aug 28, 2003 at 5:59 pm -
We currently have an application we are trying to speed up. In researching rule/cost based optimizers, I read that the cost based optimizer was the way to go (although rule had its moments) because ...
Burton, Laura
Aug 25, 2003 at 8:49 pm
Aug 26, 2003 at 9:49 pm -
Use RLS ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -----Original ...
Jamadagni, Rajendra
Aug 23, 2003 at 8:24 pm
Aug 25, 2003 at 8:24 pm -
Hi All, I'm trying to find some technical details about SharePlex, that is: How much network bandwidth I'd expect to replicate from database, generating 1-5 MB/sec redo. Does SharePlex send SQL text ...
Gorbounov,Vadim
Aug 21, 2003 at 5:49 pm
Aug 25, 2003 at 9:07 am -
hi all, in the latest code release, a group implemented RLS and since then spotlight is constantly flagging 'latch waits' in the system. Yesterday the latch waits were upwards of 90%. Most active ...
Jamadagni, Rajendra
Aug 19, 2003 at 3:19 pm
Aug 21, 2003 at 4:29 am -
Yesterday I got hit with the Blaster Bug. To make a long story short I cannot apply the MS fix to my XP Prof. since I don't have the Update.inf file. Would like some feedback on where I can locate it ...
KENNETH JANUSZ
Aug 13, 2003 at 3:49 pm
Aug 13, 2003 at 7:39 pm -
How do you guys collect capacity planning metrics, such as DB size? Do you use StatsPack, Oracle OEM, others? I'm interested in an efficient method to track DB growth in GB month over month. Best ...
David Wagoner
Aug 11, 2003 at 9:24 pm
Aug 12, 2003 at 3:59 pm -
12
SQL HELP!!!
Hello, I was wondering if someone can help me with a report. I am stuck figuring out what I can do to complete it. Here is what I need to do: for a given date range, i..e. start_date - end_date ...Viktor
Aug 26, 2003 at 8:59 pm
Aug 29, 2003 at 3:04 am -
12
32 or 64?
Daniel Fink -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Fink INET: Daniel.Fink_at_Sun.COM Fat City Network Services -- 858-538-5051 http://www.fatcity.com San ...Daniel Fink
Aug 18, 2003 at 4:14 pm
Aug 19, 2003 at 8:44 pm -
Hello, Suppose I have some SQL scripts in my /home/user directories, /usr/local/bin directories, etc. If I start 'sqlplus' from console in /home/user directories, I can load/execute the script by ...
Reuben D. Budiardja
Aug 14, 2003 at 6:09 pm
Aug 16, 2003 at 11:24 pm -
I just had a contractor tell me that the problem with my Diabetic detection and Listing 'feature' in their product (Integrated Clinical Database, ICDB) is because the 'view' crafted for that ...
Wolfe Stephen S GS-11 6 MDSS/SGSI
Aug 12, 2003 at 1:39 pm
Aug 13, 2003 at 3:04 pm -
Hi Guys and Gals, We are currently doing some testing to enable us to move our production database from one unix box to another. We are running a 7.3.4 db in archivelog mode. The approach that ...
Dobson, Lisa
Aug 7, 2003 at 12:20 pm
Aug 13, 2003 at 9:04 am -
Hi, Is there a statement in pl/SQL like case or is if elsif the only way. Meaning if I need to transalate state depending on input number as follows : 1 - CA 2 - OR 3 - WA 4 - AR Can I have one ...
A Joshi
Aug 7, 2003 at 8:24 pm
Aug 7, 2003 at 11:39 pm -
I see it here all the time. Any articles on it? Im assuming its some kind of storage system right? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Fat City Network Services ...
Rgaffuri_at_cox.net
Aug 4, 2003 at 6:19 pm
Aug 5, 2003 at 2:19 pm -
Sounds similar to the economic theories of Harry S. Dent, Jr. -- it's all based on birth-rate. Rich Rich Jesse System/Database Administrator rjesse_at_qtiworld.com Quad/Tech Inc, Sussex, WI USA -- ...
Jesse, Rich
Aug 29, 2003 at 4:14 pm
Aug 29, 2003 at 7:54 pm -
I am sure you guys might have some nice perl/shell script to analyze alert log for errors or potential problem . Can you share it with me /list . Ohh thanks in advance guys . -ak -- Please see the ...
AK
Aug 27, 2003 at 5:14 pm
Aug 28, 2003 at 2:54 pm -
Guys, ...thought of buying a good book for linux system administration. i came across the books below. which one is good ? 1.Running Linux From O'Reilly By Matt Welsh, Matthias Kalle Dalheimer, Terry ...
Prem Khanna J
Aug 26, 2003 at 10:14 am
Aug 27, 2003 at 8:44 am -
Hi, I just start testing the trcanlzr scripts (metalink 224270.1) I did not remember seeing any traffic on that utility on oracle-l, that's why I went on orafaq where there is only a post by ...
Stephane Paquette
Aug 25, 2003 at 6:24 pm
Aug 26, 2003 at 8:09 pm -
Hi all, I have a 9.2.0.3 DB and I need to connect to Forms 6i as user sys. There are 3 boxes for username, password and database. I tried a lot of combinations, eg: Username: sys as sysdba Password ...
Robo
Aug 21, 2003 at 8:54 am
Aug 22, 2003 at 8:54 pm -
im fairly certain its because DBMS_RLS doesnt use bind variables now. latch waits indicates plus your 100 concurrent users. you can check this by going to v$sqlarea and checking for similiar sql_text ...
Rgaffuri_at_cox.net
Aug 19, 2003 at 5:39 pm
Aug 21, 2003 at 9:09 pm -
Hello, env: Oracle 9.2.0.3 on Solaris. I am looking for any comments, good or bad, regarding Oracle Streams. We are considering using this to transfer data between some 9.2 databases on multiple Sun ...
Becker.bill_at_marshfieldclinic.org
Aug 13, 2003 at 5:04 pm
Aug 19, 2003 at 9:39 pm -
Hello I've an installation/implementation question! We've to analyse 50 document types, in total those 50 has 70 different attributes. We don't want to put all those document types into one table, ...
Vernaillen Tim
Aug 7, 2003 at 1:34 pm
Aug 7, 2003 at 10:14 pm -
Hi, We're busy setting up an upgrade for oracle 7.3.4 hp-ux 10.20 to oracle 9.0.1.0 on a different hp-ux 11.11 box. In order to be able to migrate we installed 7.3.4 on this machine, copied datafiles ...
Jeroen van Sluisdam
Aug 27, 2003 at 1:49 pm
Aug 30, 2003 at 4:24 am -
Guys, When user trys to run our application through a VPN behind the firewall in a url they get an error. They can use ssh to get to host where I installed the application server but not run the ...
Paula_Stankus_at_doh.state.fl.us
Aug 27, 2003 at 8:29 pm
Aug 28, 2003 at 10:29 pm -
We have a new requirement to support multiple languages in at least one of our databases. I'm reading the Oracle 9iR2 Globalization Support Guide (450 pages), but wonder if any of you can share ...
David Wagoner
Aug 27, 2003 at 6:34 pm
Aug 28, 2003 at 1:49 pm -
Gurus, Would appreciate any help that I can get on this... I have 9.2.0.1 on redhat 9 ... However I cannot seen to start the agent on the server... agentctl start just bails out.. no messages... This ...
Anjan Thakuria
Aug 20, 2003 at 7:04 pm
Aug 21, 2003 at 4:39 pm
Group Overview
group | oracle-l |
categories | oracle |
discussions | 492 |
posts | 2,415 |
users | 337 |
website | oracle.com |
337 users for August 2003
Archives
- June 2014 (35)
- May 2014 (401)
- April 2014 (496)
- March 2014 (524)
- February 2014 (610)
- January 2014 (547)
- December 2013 (404)
- November 2013 (387)
- October 2013 (456)
- September 2013 (311)
- August 2013 (255)
- July 2013 (446)
- June 2013 (515)
- May 2013 (396)
- April 2013 (568)
- March 2013 (694)
- February 2013 (558)
- January 2013 (655)
- December 2012 (309)
- November 2012 (394)
- October 2012 (438)
- September 2012 (499)
- August 2012 (560)
- July 2012 (471)
- June 2012 (427)
- May 2012 (519)
- April 2012 (440)
- March 2012 (522)
- February 2012 (419)
- January 2012 (441)
- December 2011 (366)
- November 2011 (699)
- October 2011 (718)
- September 2011 (530)
- August 2011 (778)
- July 2011 (541)
- June 2011 (642)
- May 2011 (482)
- April 2011 (593)
- March 2011 (704)
- February 2011 (687)
- January 2011 (253)
- December 2010 (212)
- November 2010 (290)
- October 2010 (272)
- September 2010 (202)
- August 2010 (162)
- July 2010 (180)
- June 2010 (228)
- May 2010 (170)
- April 2010 (171)
- March 2010 (534)
- February 2010 (878)
- January 2010 (864)
- December 2009 (719)
- November 2009 (695)
- October 2009 (703)
- September 2009 (614)
- August 2009 (560)
- July 2009 (780)
- June 2009 (647)
- May 2009 (670)
- April 2009 (801)
- March 2009 (862)
- February 2009 (826)
- January 2009 (595)
- December 2008 (551)
- November 2008 (832)
- October 2008 (856)
- September 2008 (751)
- August 2008 (657)
- July 2008 (644)
- June 2008 (717)
- May 2008 (760)
- April 2008 (1,019)
- March 2008 (807)
- February 2008 (735)
- January 2008 (979)
- December 2007 (549)
- November 2007 (819)
- October 2007 (785)
- September 2007 (848)
- August 2007 (1,000)
- July 2007 (995)
- June 2007 (897)
- May 2007 (963)
- April 2007 (1,096)
- March 2007 (1,142)
- February 2007 (1,193)
- January 2007 (1,159)
- December 2006 (1,146)
- November 2006 (1,257)
- October 2006 (1,179)
- September 2006 (1,336)
- August 2006 (1,222)
- July 2006 (871)
- June 2006 (1,315)
- May 2006 (1,385)
- April 2006 (1,169)
- March 2006 (1,142)
- February 2006 (1,062)
- January 2006 (464)
- December 2005 (403)
- November 2005 (930)
- October 2005 (1,617)
- September 2005 (1,304)
- August 2005 (1,748)
- July 2005 (1,129)
- June 2005 (1,453)
- May 2005 (1,260)
- April 2005 (1,364)
- March 2005 (1,332)
- February 2005 (1,251)
- January 2005 (1,179)
- December 2004 (1,353)
- November 2004 (1,205)
- October 2004 (1,201)
- September 2004 (1,709)
- August 2004 (2,223)
- July 2004 (2,436)
- June 2004 (2,462)
- May 2004 (2,074)
- April 2004 (1,893)
- March 2004 (3,145)
- February 2004 (2,979)
- January 2004 (2,392)
- December 2003 (2,095)
- November 2003 (2,016)
- October 2003 (2,800)
- September 2003 (2,022)
- August 2003 (2,415)
- July 2003 (2,725)
- June 2003 (2,173)
- May 2003 (2,891)
- April 2003 (2,460)
- March 2003 (2,334)
- February 2003 (2,928)
- January 2003 (2,931)
- December 2002 (2,049)
- November 2002 (2,199)
- October 2002 (2,708)
- September 2002 (2,101)
- August 2002 (3,028)
- July 2002 (2,862)
- June 2002 (2,654)
- May 2002 (3,081)
- April 2002 (3,066)
- March 2002 (2,777)
- February 2002 (2,084)
- January 2002 (3,044)
- December 2001 (1,868)
- November 2001 (2,132)
- October 2001 (1,975)
- September 2001 (2,990)
- August 2001 (4,066)
- July 2001 (3,124)
- June 2001 (4,424)
- May 2001 (3,422)
- April 2001 (2,325)
- March 2001 (2,846)
- February 2001 (2,522)
- January 2001 (2,565)
- December 2000 (2,091)
- November 2000 (2,549)
- October 2000 (2,454)
- September 2000 (2,266)
- August 2000 (2,561)
- July 2000 (2,360)
- June 2000 (3,655)
- May 2000 (2,787)
- April 2000 (357)
- March 2000 (8)
- September 1998 (1)
- February 1997 (1)
- January 1997 (1)
- March 1996 (147)
- February 1996 (275)
- January 1996 (686)
- December 1995 (105)
- March 1995 (183)