FAQ

Search Discussions

574 discussions - 2,725 posts

  • This is a multi-part message in MIME format. ------=_NextPart_000_055B_01C350EF.886DD110 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Now this one is ...
    AKAK
    Jul 23, 2003 at 2:53 pm
    Jul 24, 2003 at 8:37 am
  • vi is what I use and it's the predominant editor for SysAdmin/DBA types but I'm curious as to how many DBA's use emacs. I just saw a demo of SQL*Plus running under emacs and it was quite ...
    Orr, SteveOrr, Steve
    Jul 25, 2003 at 7:11 pm
    Jul 30, 2003 at 10:04 pm
  • Hi all, What is the correct answer for this? Q If you have 2 redo log groups with 4 members each, how many disks does Oracle recommend to keep the redo log files? 8 2 1 4 Which is the correct ...
    Senthil KumarSenthil Kumar
    Jul 30, 2003 at 5:19 pm
    Jul 31, 2003 at 6:29 pm
  • FYI One of my friends at Microsoft, (yes I must to confess, I have friends at MS) gave me a "present", it's a 4 cd's kit called "SQL Server 2000 for the Oracle Customer", the kit consist in 4 cd's ...
    Gabriel AragonGabriel Aragon
    Jul 1, 2003 at 4:11 pm
    Jul 7, 2003 at 7:27 pm
  • Guys, i have a 9iR2/win2k test instance. i just renamed CONTROL01.CTL once and tried to start the instance. SQL startup But it gave a ORA-00205 error. so i removed CONTROL01.CTL from INIT.ORA file ...
    Prem Khanna JPrem Khanna J
    Jul 15, 2003 at 2:03 am
    Jul 17, 2003 at 8:04 pm
  • Greetings, How can I set the interval in my dbms job to have it run on the first Wednesday of every month? Is this even possible? I have been trying to noodle it thru for a week to no avail. tia, Josh
    Josh CollierJosh Collier
    Jul 22, 2003 at 6:16 pm
    Jul 22, 2003 at 11:29 pm
  • Hi Everyone! HELP! I upgraded my SAP *PRODUCTION* instance to 9.2.0.3 over the weekend. Everything up until now has been OK. However, I now have some SAP Transactions (read: data entry forms) that ...
    Vergara, Michael (TEM)Vergara, Michael (TEM)
    Jul 21, 2003 at 8:05 pm
    Jul 22, 2003 at 9:26 pm
  • Hello List, We are running Benchmark tests on Solaris 2-Node RAC. Consistently noticed the following : - Very high Kernel usage (averaging 45%) on TOP Statspack has "IPC Send Completion sync" waits ...
    Ravi KulkarniRavi Kulkarni
    Jul 10, 2003 at 3:35 pm
    Jul 17, 2003 at 5:07 am
  • This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------=_NextPartTM-000-924c8586-3bbf-49ee-b9ea-0fd8d76d7182 ...
    Adams, Matthew (GECP, MABG, 088130)Adams, Matthew (GECP, MABG, 088130)
    Jul 17, 2003 at 6:48 pm
    Jul 21, 2003 at 3:26 pm
  • This is a multi-part message in MIME format. ------=_NextPart_000_107A_01C34AF6.E3FD89C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: upgrade to AIX ...
    RyanRyan
    Jul 15, 2003 at 9:31 pm
    Jul 16, 2003 at 7:28 pm
  • There has been alot of literature stating that you will recieve performance improvements by seperating indexes and tables across multiple I/O points. Ie... you have a tables tablespace and an index ...
    Rgaffuri_at_cox.netRgaffuri_at_cox.net
    Jul 15, 2003 at 1:49 pm
    Jul 15, 2003 at 8:10 pm
  • Hi listers, I am working on a nt script. I download FORFILE exe, it works fine. My intention is finding the ORA-03113 string in the log. If there is a match, then reboot the server, else do nothing ...
    Joan HsiehJoan Hsieh
    Jul 1, 2003 at 3:41 pm
    Jul 2, 2003 at 3:40 pm
  • Minneapolis, Minnesota company has a great opportunity available for a Sr. level Oracle DBA to join their IT staff. The selected candidate must be highly skilled in solving extremely complex and very ...
    OraStaffOraStaff
    Jul 3, 2003 at 3:20 pm
    Jul 16, 2003 at 3:46 pm
  • we've started them recently -- only had two so far, part 1 and 2 presentations/interactive sessions on "extreme programming" the goal is to get us talking across the various application groups, ...
    Rachel CarmichaelRachel Carmichael
    Jul 1, 2003 at 5:34 pm
    Jul 11, 2003 at 4:04 pm
  • This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C34BA2.07A19B50 Content-Type ...
    Smith, Ron L.Smith, Ron L.
    Jul 16, 2003 at 1:56 pm
    Jul 17, 2003 at 5:49 am
  • Hi, I have a security question about Oracle database. Recently I have taken full control an Oracle database in my department. Now I would like to make sure that no other people except myself can ...
    Don YuDon Yu
    Jul 11, 2003 at 7:44 pm
    Jul 15, 2003 at 2:07 pm
  • Hi Kirti, As I have mentioned, my data is clean. I could import this data into an existing 8i database. Do you still think that importing data in two passes would fix it? Anything changed form 8i to ...
    Surendra.Tirumala_at_mail.state.ky.usSurendra.Tirumala_at_mail.state.ky.us
    Jul 8, 2003 at 5:36 pm
    Jul 14, 2003 at 1:07 pm
  • There have been over 10,000,000 entries made in the National Do Not Call Registry since Friday June 27. Does anyone know the database engine in which this is stored? Curious in Bozeman, MT -- Please ...
    Orr, SteveOrr, Steve
    Jul 1, 2003 at 5:17 pm
    Jul 12, 2003 at 2:19 am
  • Reports on "Bugs" in IBM's DB2 which led to "a critical operational situation" http://theregister.co.uk/content/archive/30095.html and ...
    Hemant K ChitaleHemant K Chitale
    Jul 18, 2003 at 2:50 pm
    Jul 21, 2003 at 1:50 pm
  • Hello, There is alot of talk about multi-skilling/reskilling going on here at my company. We use Oracle and MSSQL dbs. I have been wondering if anyone is aware of a resource that shows the oracle ...
    Denham EvaDenham Eva
    Jul 31, 2003 at 9:34 am
    Jul 31, 2003 at 10:09 pm
  • Hi Guys, I am new to this clustering concept. Just trying to understand few basics . Need ur help . what is differece between oracle running on sun /hp cluster with 2 nodes and oracle with RAC ...
    AKAK
    Jul 28, 2003 at 4:14 pm
    Jul 31, 2003 at 2:54 pm
  • Dan, I was running a 10046 (level 12) trace on an awful piece of PeopleSoft SQL today and got some really odd results in my trace file (8.1.7). 2003-07-23 15:40:59.149 WAIT #1: nam='db file scattered ...
    Henry PorasHenry Poras
    Jul 23, 2003 at 9:03 pm
    Jul 28, 2003 at 10:24 pm
  • I finally get to put our 8.1.7 on NT databases into archivelog mode. We have a third party app vendor that would not support us if I did this but I finally convinced them that is the way to go and it ...
    Farnsworth, DaveFarnsworth, Dave
    Jul 23, 2003 at 6:12 pm
    Jul 25, 2003 at 12:37 am
  • This is a multi-part message in MIME format. ------=_NextPart_000_0001_01C34B8C.DAE7B9F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hi All, I have inherited a ...
    Nuala CullenNuala Cullen
    Jul 16, 2003 at 10:24 am
    Jul 21, 2003 at 7:42 am
  • This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C34C8D.1F7F9320 Content-Type ...
    David WagonerDavid Wagoner
    Jul 17, 2003 at 5:59 pm
    Jul 19, 2003 at 3:50 pm
  • This is a multi-part message in MIME format. ------=_NextPart_000_000A_01C34BA3.5C2C85C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi All =20 At first ...
    MitchellMitchell
    Jul 16, 2003 at 6:05 pm
    Jul 17, 2003 at 3:54 pm
  • Greetings all, I've set up my login.sql so that my prompt shows my username & the sid of the db to which I'm connected. This works well, but has made it tough to drag-select text b/c now the first ...
    Pardee, Roy EPardee, Roy E
    Jul 22, 2003 at 3:43 pm
    Jul 23, 2003 at 8:03 pm
  • Everything I have seen says no. I did the following. Set PCTINCREASE = 0 Set my initial and next extents to 5m so they are uniform. A woman I work with swears there is Oracle documentation that in ...
    Rgaffuri_at_cox.netRgaffuri_at_cox.net
    Jul 1, 2003 at 4:56 pm
    Jul 2, 2003 at 9:47 pm
  • Hi: I need to convert RBS tablespace (used for rollback segments) from DMT to LMT on a 24x7 production machine (Solaris 2.8, Oracle 8173). Here are the steps I am thinking of taking: create a new ...
    Guang MeiGuang Mei
    Jul 23, 2003 at 4:24 pm
    Jul 24, 2003 at 2:43 am
  • Short form of my question: How can I enable a Role for a User within a database trigger (owned by another Schema) on a table owned by yet another Schema? - The M's I've RTF'd indicate that a trigger ...
    JApplewhite_at_austin.isd.tenet.eduJApplewhite_at_austin.isd.tenet.edu
    Jul 27, 2003 at 3:59 pm
    Jul 31, 2003 at 10:39 pm
  • Hi List, could you please tell me wich Character Set you are using in your database ? Thank in advance! Philippe -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: NGUYEN ...
    NGUYEN Philippe (Cetelem)NGUYEN Philippe (Cetelem)
    Jul 30, 2003 at 2:04 pm
    Jul 31, 2003 at 10:44 am
  • Guys, SQL SELECT NAME,AGE,MEMNO,BLOODTYPE,HIGHT,LOOKSLIKE,CONTENT,PICID FROM PROFILE WHERE PREF = :PREF AND SEX = :OP_SEX AND FLAG = :FLAG AND ENTPC = :ENTPC AND NAME IS NOT NULL AND FACCESS SYSDATE ...
    Prem Khanna JPrem Khanna J
    Jul 24, 2003 at 8:58 am
    Jul 30, 2003 at 5:19 am
  • Is anyone putting datafiles on SAN storage? Success? Horror? Tell me a story. Tim Levatich, Database Administrator Cornell Laboratory of Ornithology, 159 Sapsucker Woods Road, Ithaca, New York 14850 ...
    Tim LevatichTim Levatich
    Jul 15, 2003 at 3:29 pm
    Jul 16, 2003 at 8:08 pm
  • I have a table of about one million records. About 100,000 of them have a flag which I need it set to 0. Because of the size of the rollback segment, I cannot update them all and then commit, I need ...
    Maryann AtkinsonMaryann Atkinson
    Jul 8, 2003 at 10:15 pm
    Jul 9, 2003 at 12:46 pm
  • Dear Friends, I am willing to buy Oracle DBA 9i books.,I need your suggestion on this. I got information friends from this list that the book ("Practical Oracle 8i - Jonathan Lewis".) is practically ...
    Veeraraju_MareddiVeeraraju_Mareddi
    Jul 1, 2003 at 7:54 am
    Jul 4, 2003 at 11:19 am
  • I'm doing research for an article on union queries. I'm interested in finding examples of problems that were solved using UNION, UNION ALL, INTERSECT, or MINUS, with the latter two being of special ...
    Jonathan GennickJonathan Gennick
    Jul 24, 2003 at 12:04 pm
    Jul 25, 2003 at 6:36 pm
  • This is a multi-part message in MIME format. ------=_NextPart_000_0080_01C3510F.0B07B680 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit I found no signs of RMAN being ...
    Michael KlineMichael Kline
    Jul 23, 2003 at 3:39 pm
    Jul 23, 2003 at 10:25 pm
  • I have a developer that has ALTER ANY PROCEDURE rights. He changes a procedure, then compiles it and it says there are errors. But when he does a SHOW ERRORS in SQPlus, it shows nothing. If I do the ...
    Farnsworth, DaveFarnsworth, Dave
    Jul 21, 2003 at 2:46 pm
    Jul 22, 2003 at 3:53 pm
  • --0-1061927177-1058290377=:91023 Content-Type: text/plain; charset=us-ascii I've been asked to interview a system admin candidate for our Solaris shop. I've search Google and altavista, but haven't ...
    M.GodlewskiM.Godlewski
    Jul 15, 2003 at 5:32 pm
    Jul 16, 2003 at 5:56 pm
  • Hi all, Does anybody know the syntax to schedule a monthly "at" job on Windows (2000)? I need to schedule a job for the 1st and 15th every month, and would like to avoid the Task Scheduler GUI. A ...
    Cunningham, GeraldCunningham, Gerald
    Jul 8, 2003 at 3:46 pm
    Jul 9, 2003 at 11:42 am
  • Hello ALL, I am trying to find quarter number from a given date . Here is the description Our Financial year runs from July thru June. So, Given any date between these dates I need to find 3 ...
    Surendra.Tirumala_at_mail.state.ky.usSurendra.Tirumala_at_mail.state.ky.us
    Jul 2, 2003 at 3:50 pm
    Jul 7, 2003 at 7:37 pm
  • Hi, I have Oracle 8i Enterprise Server, Oracle 9i Enterprise Server and Oracle 7.3.4 client on my NT4 machine. When I connect to remote/local databases through TOAD 6.5 (which supports LOBs) and try ...
    Charu JoshiCharu Joshi
    Jul 29, 2003 at 3:19 pm
    Jul 31, 2003 at 3:39 pm
  • Hi All, Please help me tune this i/o related wait event. This is my 8.1.6 statspack top-5 wait list: Top 5 Wait Events ~~~~~~~~~~~~~~~~~ Wait % Total Event Waits Time (cs) Wt Time ...
    Hans de GitHans de Git
    Jul 29, 2003 at 3:54 pm
    Jul 30, 2003 at 6:04 pm
  • <http://metalink.oracle.com/images/metalink/generic/usaeng/kur_left_top.gif <http://metalink.oracle.com/images/metalink/generic/usaeng/kur_right_top.gif Update TAR Go to End ...
    Goulet, DickGoulet, Dick
    Jul 18, 2003 at 7:03 pm
    Jul 22, 2003 at 9:53 pm
  • 11

    RAC

    This is a multi-part message in MIME format. ------=_NextPart_000_0116_01C34F75.DFAA3E30 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Is it possible to ...
    AKAK
    Jul 21, 2003 at 5:50 pm
    Jul 22, 2003 at 2:43 pm
  • Hello all, We have setup a Microsoft Cluster Server (MSCS) cluster, with two nodes, using W2K, and now are in the process of deploying Oracle 9i on it. For the purpose of high availability (HA), we ...
    Hussain Ahmed QadriHussain Ahmed Qadri
    Jul 16, 2003 at 3:45 pm
    Jul 20, 2003 at 1:52 pm
  • Hello Folks, I have discovered something *very* disturbing. We have a person(x2) who has earned their MCDBA - Microsoft DBA certifiction. These two don't have any clue, about database issues, when ...
    Denham EvaDenham Eva
    Jul 17, 2003 at 9:31 am
    Jul 18, 2003 at 5:54 pm
  • This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------=_NextPartTM-000-c9bae432-313c-4380-bc86-57b3df6c0df2 ...
    Jamadagni, RajendraJamadagni, Rajendra
    Jul 17, 2003 at 1:46 am
    Jul 17, 2003 at 4:11 pm
  • Is there a way to prevent end users from connecting directly to the database via sqlplus without restricting access of those same users via application code. The application is a third party package ...
    Schauss, PeterSchauss, Peter
    Jul 9, 2003 at 6:36 pm
    Jul 11, 2003 at 2:29 am
  • I have 512 MB RAM in my Redhat Linux intel machine running Oracle 9. What should I set the Kernal parameters to..... shmmax, shmmni, shmall, sem ???? JD -- Please see the official ORACLE-L FAQ ...
    John DunnJohn Dunn
    Jul 3, 2003 at 8:54 am
    Jul 7, 2003 at 5:04 pm
Group Navigation
period‹ prev | Jul 2003 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions574
posts2,725
users355
websiteoracle.com

355 users for July 2003

Tanel Poder: 107 posts Jamadagni, Rajendra: 101 posts Ryan: 72 posts Goulet, Dick: 67 posts DENNIS WILLIAMS: 62 posts Jared.Still_at_radisys.com: 55 posts Jesse, Rich: 53 posts Rachel Carmichael: 53 posts AK: 52 posts Mladen Gogala: 50 posts Gogala, Mladen: 48 posts Ron Rogers: 40 posts Boivin, Patrice J: 39 posts Jkstill_at_cybcon.com: 39 posts Daniel Fink: 38 posts Arup Nanda: 36 posts Matthew Zito: 35 posts Prem Khanna J: 35 posts Jacques Kilchoer: 31 posts Kirtikumar Deshpande: 30 posts
show more
Archives