FAQ

Oracle > oracle-l > August 2000

Search Discussions

832 discussions - 2,560 posts

  • *Description: Major Ft. Lauderdale, Florida company needs an Oracle DBA for their I.T.= team to provide database support for Oracle systems . This is a full time staff position. Candidates local to ...
    OraStaffOraStaff
    Aug 16, 2000 at 2:16 pm
    Aug 21, 2000 at 9:42 pm
  • Hello, My searches in Metalink show timed_statistisc=True is the recommended setting. I'm hearing that some Oracle classes recommend keeping timed_statistics=False unless you are tracing. Other than, ...
    Linda HagedornLinda Hagedorn
    Aug 18, 2000 at 8:51 pm
    Aug 23, 2000 at 7:17 am
  • I'm hitting up against locking(including deadlock) issues. Here is what we've done so far: using utllockt, dba_waiters, etc all of the normal delivered stuff has been used. I'm sure there is a way to ...
    Joseph S. TestaJoseph S. Testa
    Aug 7, 2000 at 5:37 pm
    Aug 11, 2000 at 3:16 pm
  • This is a multi-part message in MIME format. ------=_NextPart_000_008C_01BFFBC8.3E7502B0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable hi guys, i have to ...
    PaulPaul
    Aug 1, 2000 at 7:53 pm
    Aug 28, 2000 at 9:17 pm
  • Recently we have had occurances where our shared pool fills up and we have to flush the shared pool. The head of the product support group wants us to kill any process that is using "too much" of the ...
    Terry BallTerry Ball
    Aug 21, 2000 at 2:09 pm
    Aug 25, 2000 at 11:39 am
  • Where would I find the number of currently open cursors, instance wide? Thanks, Linda Hagedorn
    Linda HagedornLinda Hagedorn
    Aug 30, 2000 at 1:49 am
    Aug 31, 2000 at 10:33 am
  • Unfortunately, the reasons that Joe won't be there also apply to me. Sorry to those whom I promised to meet/greet/buy drinks, etc. Matt Adams
    Adams, Matthew (GEA, 088130)Adams, Matthew (GEA, 088130)
    Aug 30, 2000 at 1:16 pm
    Aug 31, 2000 at 5:27 pm
  • It's about time for me to hit-up my company for another conference. In 99 I went to IOUG-A and thought it was good. I've never been to OpenWorld and was wondering if there are strong feelings about ...
    Brian WisniewskiBrian Wisniewski
    Aug 11, 2000 at 7:16 pm
    Aug 21, 2000 at 4:11 pm
  • Is there a way a DBA can log on as other users (without saving the = encrypted password, changing the password of the account, logging in using the = new password, logging out, and restoring the ...
    Boivin, Patrice JBoivin, Patrice J
    Aug 29, 2000 at 2:08 pm
    Aug 30, 2000 at 3:41 pm
  • Against the repeated urging of the DBA (me), a developer insisted on creating all the numeric columns of his new appliction's tables as VARCHAR2. (Don't ask me why! I've explained it to him several ...
    Ed BittelEd Bittel
    Aug 28, 2000 at 6:22 pm
    Aug 29, 2000 at 7:54 pm
  • I just trasnferred some account from an oracle database on solaris to an oracle database on linux. Everything looked perfect, UNTIL I tried to insert or modify records from tables that do not belong ...
    Rivera, ClaudiaRivera, Claudia
    Aug 24, 2000 at 6:14 pm
    Aug 28, 2000 at 9:42 pm
  • This is a multi-part message in MIME format. ------=_NextPart_000_0065_01C00B6D.477B0800 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Dear DBAs ! I'm ...
    Andrey BronfinAndrey Bronfin
    Aug 21, 2000 at 10:42 am
    Aug 24, 2000 at 1:55 pm
  • Does anyone know the data dictionary view (or table) that has the list of the columns and datatypes that comprise a view? I can get the syntax for the view's SQL (in ALL_VIEWS, VIEW$) and the number ...
    Ari D KaplanAri D Kaplan
    Aug 18, 2000 at 5:33 pm
    Aug 21, 2000 at 3:06 pm
  • SQL alter system set user_dump_dest = 'e:\oradba\admin\tst'; * ERROR at line 1: ORA-02095: specified initialization parameter cannot be modified This is Oracle 8.0.5 on NT4-SP4. According to Oracle8 ...
    O'Neill, SeanO'Neill, Sean
    Aug 30, 2000 at 3:25 pm
    Aug 31, 2000 at 10:34 pm
  • List, which is the best "HOT standby" solution for an 24x7 database ?, able to "switch" to the standby DB, in shortest possible time. TIA Rahul
    RahulRahul
    Aug 24, 2000 at 6:56 am
    Aug 25, 2000 at 8:00 am
  • Our development team want to control access to application functionality via 'logical' users. That is, a list of users and the application functions they can use will be maintained in a database ...
    John DunnJohn Dunn
    Aug 15, 2000 at 11:23 am
    Aug 22, 2000 at 3:37 pm
  • I am ready to create a database, can anyone tell me if there are any advantages or disadvantages to using autoextend option for the system this is what I'd plan to use. create database PROTO ...
    Steff GonosSteff Gonos
    Aug 18, 2000 at 5:17 pm
    Aug 22, 2000 at 3:37 pm
  • I am in the process of building two DB servers - one live and the other standby. We are not overly concerned with disk capacity - but rather with speed of access. Our current configuration is primary ...
    Adam TurnerAdam Turner
    Aug 17, 2000 at 1:41 pm
    Aug 21, 2000 at 6:46 pm
  • Listers, We've been having excessive redo logging of data on one of our databases that is making archives hard to control. The people who own the app can't figure out why so much information is being ...
    Cherie_Machler_at_gelco.comCherie_Machler_at_gelco.com
    Aug 2, 2000 at 12:51 pm
    Aug 2, 2000 at 10:09 pm
  • How do I know 32 or 64 bit oralce are installed on HP and AIX? Thanks Linda
    Linda WangLinda Wang
    Aug 29, 2000 at 7:29 pm
    Aug 31, 2000 at 5:34 pm
  • Does anyone have any good reasons why a database's logical model would differ from the physical model? Haven't run across any good business reasons why this should/would happen. james
    James ellisJames ellis
    Aug 22, 2000 at 8:31 pm
    Aug 24, 2000 at 6:40 pm
  • This is a multi-part message in MIME format. ------=_NextPart_000_0042_01C00D12.F26D5DC0 Content-Type: text/plain; charset="iso-2022-jp" Content-Transfer-Encoding: 7bit Hi All How to rename an Oracle ...
    MageshMagesh
    Aug 23, 2000 at 6:00 am
    Aug 23, 2000 at 3:53 pm
  • Hi guys Real quick question here! Using SQL plus, how can I determine the physical size of my database? If that cannot be done, is there a way to see the size of individual tables? Thanks a lot Peter ...
    Peter HazeltonPeter Hazelton
    Aug 21, 2000 at 1:39 pm
    Aug 21, 2000 at 6:55 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_01C002CE.954C45E0 Content-Type ...
    Uma Sankara_SivadanamUma Sankara_Sivadanam
    Aug 10, 2000 at 1:26 pm
    Aug 11, 2000 at 9:36 pm
  • *Description: We have several client companies in Dallas, Texas that need Oracle DBAs to join their I.T. teams. Mid-level and Sr. level positions available. These are full time staff positions ...
    OraStaffOraStaff
    Aug 2, 2000 at 10:54 am
    Aug 3, 2000 at 1:58 pm
  • Dear Listers, When I query v$waitstat I get a large number for the class data block and my database is running very slowly. Are these two things related and is there anything I can do? As always, ...
    Ruth GramoliniRuth Gramolini
    Aug 30, 2000 at 11:31 am
    Aug 31, 2000 at 7:06 pm
  • Any idea as to why my call to DBMS_STATS blows up when it's a compiled PL/SQL, but works fine when I call it via anonymous PL/SQL? I've verified via DBA_TAB_PARTITIONS that the statistics are being ...
    Thomas JeffThomas Jeff
    Aug 23, 2000 at 6:46 pm
    Aug 28, 2000 at 12:13 pm
  • Hi, I found that some of the Oracle user process consumes memory as high as 3= 00M. (For a single process only!) Is there any tuning that I can do to control the memory usage on each use= r process ? ...
    Michael ChanMichael Chan
    Aug 24, 2000 at 11:15 am
    Aug 25, 2000 at 12:57 pm
  • If I rename the alert log, will Oracle create a new one if it doesn' find it? I think our alert log has grown too large. Thanks Ana E. Choto Systems Programmer American University Office of ...
    Achoto_at_american.eduAchoto_at_american.edu
    Aug 22, 2000 at 5:48 pm
    Aug 23, 2000 at 1:46 pm
  • I was recently asked, what is the difference between SQL, SQL Plus and PL/SQL. I admit it ... I choked !! Where can I find a good definition of each?? TIA Al Rusnak COM (804) 734-4937 DSN 687-4937
    Rusnak, George A. IIRusnak, George A. II
    Aug 22, 2000 at 1:49 pm
    Aug 23, 2000 at 7:15 am
  • I need to erase some rows from a table. But when I try to do it, nothing happens. The system just hangs in there until I press Ctrl C to stop it. Now, I tried to drop the table, and it gave me the ...
    Rivera, ClaudiaRivera, Claudia
    Aug 1, 2000 at 2:03 pm
    Aug 21, 2000 at 9:08 pm
  • I have a parameter set up on my report. Call it :P_TEST_NUM. My SQL query will be: SELECT TEST_NUM from TABLE where TEST_NUM = :P_TEST_NUM I want this parameter to accept several different numbers ...
    Peter HazeltonPeter Hazelton
    Aug 17, 2000 at 6:42 pm
    Aug 18, 2000 at 8:57 pm
  • a production database has misteriously lost all of its data...I can re-create it from backup but before I do I'd like to find out who was the last person to access certain tables in order to find out ...
    Roy FergusonRoy Ferguson
    Aug 16, 2000 at 9:39 pm
    Aug 17, 2000 at 8:27 pm
  • Does index creation lock the underlying records or table for the duration of the creation, and subsequently interfere with other transactions, such as on-line?
    Linda HagedornLinda Hagedorn
    Aug 11, 2000 at 11:40 pm
    Aug 16, 2000 at 7:05 am
  • Hi Yong, In answer to a similar question, available in the question and answer section of my web site for 3 March 2000 I wrote, "In 8.0.5 a heartbeat mechanism was included in CKPT's timeout action ...
    Steve AdamsSteve Adams
    Aug 7, 2000 at 2:29 am
    Aug 9, 2000 at 5:30 pm
  • Hi! Sorry if I am adding too many 'opinions'! At our site, DBAs used to create database objects because tablespace creation was DBA's responsibilty and tablespace was created by DBA because backup ...
    Cyril ThankappanCyril Thankappan
    Aug 2, 2000 at 7:27 pm
    Aug 8, 2000 at 7:59 am
  • Dear lister, We are using Oracle v8.0.5 and Windows NT 4.0. The database is 24x7. In the Oracle documentation (Backu & Recovery Guide) it is said that 'we should backup controlfile after making a ...
    Slamet FusiantoSlamet Fusianto
    Aug 29, 2000 at 8:55 am
    Aug 29, 2000 at 2:58 pm
  • A quick diversion from all those important technical questions that = trouble us every day. I am planning a skiing trip to North America for March 2001, I think = either Whistler or Stowe are ...
    Stuart HoulstonStuart Houlston
    Aug 22, 2000 at 12:30 pm
    Aug 24, 2000 at 5:27 pm
  • Hi all, I am new to the Oracle world. I am pretty good with simple queries, basic joins, etc. But I want to learn how to write stored procedures, packages, functions, etc. What do you all recommend ...
    Fred SmithFred Smith
    Aug 21, 2000 at 5:07 pm
    Aug 23, 2000 at 3:51 pm
  • Dear List, I want to put my database in cost mode when I try to put optimizer_mode = cost in initsid.ora it is giving error at database startup what should I do?Thanks in advance. Regards, Rajanish ...
    Rajanish JoshiRajanish Joshi
    Aug 19, 2000 at 11:25 am
    Aug 21, 2000 at 9:02 pm
  • A fellow DBA has a need to insert records into a temp table (in order) via a stored proc. Does anyone know a way to accomplish this? Apparently, SQL-Server has this ability and they're in the process ...
    McGlaughlin,StewartMcGlaughlin,Stewart
    Aug 16, 2000 at 5:10 pm
    Aug 17, 2000 at 6:10 pm
  • What are the minimal privileges required to create a table I have a user with resource privilege but when I try to create after connecting as that user a table I get "insufficient privileges" John
    John DunnJohn Dunn
    Aug 15, 2000 at 3:18 pm
    Aug 16, 2000 at 2:53 pm
  • Is it possible to install Oracle 8i on Windows NT workstation? If it is possible what are some of the limitations? Thanks for you input!!! Tony Barker State of Indiana, DBA
    Barker, TonyBarker, Tony
    Aug 14, 2000 at 5:20 pm
    Aug 15, 2000 at 2:20 pm
  • gurus, is there a way i could create a synonym of an object for other accounts without actually logging to each account? thanks
    Grace limGrace lim
    Aug 10, 2000 at 8:07 am
    Aug 11, 2000 at 10:41 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_01BFFE22.2C4F446E Content-Type ...
    Webber Valerie HWebber Valerie H
    Aug 4, 2000 at 2:42 pm
    Aug 7, 2000 at 1:18 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_01BFFD43.91F58090 Content-Type ...
    Swapna_PSwapna_P
    Aug 3, 2000 at 12:08 pm
    Aug 4, 2000 at 9:18 am
  • Regretfully, i'll not be attending openworld(and hence my 2 presenations on logminer wont either). if you want the details of why(since i wont air Oracle Corp's dirty laundry here), email me direct ...
    Joseph S. TestaJoseph S. Testa
    Aug 30, 2000 at 12:36 pm
    Aug 30, 2000 at 7:32 pm
  • Looking for comments: I'm planning to purchase a copy of Quest's Spotlight (formerly Instance = Monitor) and I/Watch. I'm feeling a little guilty about spending the = money when I know that with ...
    Kristen CameronKristen Cameron
    Aug 29, 2000 at 9:20 pm
    Aug 30, 2000 at 3:23 pm
  • Dear listers,
    Eric LansuEric Lansu
    Aug 23, 2000 at 7:45 am
    Aug 29, 2000 at 5:52 am
  • I have three versions of software on each of several boxes. I have three separate tnsnames and listener files (one for each version). All of the databases for each level use the same port. So ...
    Cherie_Machler_at_gelco.comCherie_Machler_at_gelco.com
    Aug 23, 2000 at 12:43 pm
    Aug 25, 2000 at 12:26 pm
Aug 2000
12345…17
Group Navigation
period‹ prev | Aug 2000 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions832
posts2,560
users458
websiteoracle.com

458 users for August 2000

Rachel Carmichael: 57 posts Steve Adams: 57 posts Lyall Barbour: 52 posts Ron Rogers: 49 posts Koivu, Lisa: 48 posts Dgoulet_at_vicr.com: 37 posts Rahul: 37 posts Jared Still: 36 posts Joseph S. Testa: 35 posts Eric D. Pierce: 34 posts Cherie_Machler_at_gelco.com: 29 posts Ruth Gramolini: 29 posts Paquette stephane: 27 posts Diana Duncan: 26 posts Linda Hagedorn: 26 posts Thapliyal, Deepak: 25 posts Philip West: 22 posts Winnie_Liu_at_infonet.com: 22 posts Boivin, Patrice J: 21 posts Chuck Hamilton: 21 posts
show more
Archives