Search Discussions

359 discussions - 2,436 posts

  • OK folks. I've slammed this around every which way I can think of. Two columns of a table are char(18) and contain 13, 15, or 16 numeric digits. The digits are KNOWN to be strictly numeric (except ...
    Jul 14, 2004 at 6:52 pm
    Jul 21, 2004 at 3:23 pm
  • Does anyone have OEM 10G startup/stop scripts for Solaris or Redhjat which I can reference? I plan to put script under /etc/rc0.d and /etc/rc3.d. Thanks.
    Dba1 mccDba1 mcc
    Jul 1, 2004 at 9:45 am
    Jul 6, 2004 at 1:04 pm
  • http://otn.oracle.com/books/pdfs/oaktable_ch5.pdf Please see the official ORACLE-L FAQ: http://www.orafaq.com To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the ...
    Chris StephensChris Stephens
    Jul 29, 2004 at 9:01 am
    Aug 7, 2004 at 6:46 am
  • Dear All, Can you let me know the difference between count(*) and count(1) ? Warm Regards, Mukund CONFIDENTIALITY CAUTION This communication (including any accompanying documents) is intended only ...
    Jul 8, 2004 at 12:58 am
    Jul 11, 2004 at 10:43 am
  • Guys, I know you can reconstruct data in a table (given your undo segments in = your undo tablespace is not overwritten) with flashback query. However, you should be able to do the same using = ...
    Jul 23, 2004 at 4:21 pm
    Aug 23, 2004 at 3:38 pm
  • Hi all, There seems to be some question about the use of AWR in 10g, and whether it requires licenses in addition to licensing the database software. This link to the Oracle docs indicates that AWR ...
    Jared StillJared Still
    Jul 26, 2004 at 9:16 pm
    Jul 28, 2004 at 4:18 pm
  • Hi ORACLE-L list posters, Warning if you posted on Oracle-L lately... I just got an email from dgoulet_at_vicr.com with ZIP attached. Yahoo scan did not detect virus, but my McAfee did trap the ...
    Michael ThomasMichael Thomas
    Jul 8, 2004 at 8:42 pm
    Jul 14, 2004 at 7:57 am
  • I'm trying to improve my knowledge of tuning and the performance of my = 9i Ver data warehouse by creating histograms on columns used in = where clauses with skewed data values. I have ...
    Freeman, DonaldFreeman, Donald
    Jul 21, 2004 at 1:01 pm
    Jul 24, 2004 at 6:26 am
  • Oracle 8173. I have a query like this: select x, count(1) cnt from ABC group by x; which shows: X CNT ---------- ---------- 1 25 2 18 6 156 7 529 8 43 9 355 What I want is X CNT ---------- ---------- ...
    Guang MeiGuang Mei
    Jul 19, 2004 at 2:47 pm
    Jul 20, 2004 at 3:08 pm
  • I'd love to hear comments on the following Q&A (by a well-known Oracle "expert"). Do list members think that this view prevails today? Am I correct in believing that the importance of normalization, ...
    Paul BaumgartelPaul Baumgartel
    Jul 29, 2004 at 10:29 am
    Jul 30, 2004 at 3:33 pm
  • I had a question about a problem with 9.2 V$ views where a RULE hint helped V$LOCK tremendously. Someone suggested Analyzing the SYS tables. IS everyone doing that now or is there considerable ...
    Wolfson Larry - lwolfsWolfson Larry - lwolfs
    Jul 29, 2004 at 1:24 pm
    Jul 30, 2004 at 5:40 pm
  • My company said they would pay for the certified masters and I get a training budget so I can use that for the required courses. Can I assume that the same classes you can take for 9i, you can take ...
    Jul 21, 2004 at 12:47 pm
    Jul 26, 2004 at 10:56 am
  • I need to install Oracle on the below configuration. We have 20GB of = memory and are running the hugemem kernel. I would like to take = advantage of this as much as possible. We have already ...
    Ken PaytonKen Payton
    Jul 30, 2004 at 4:57 pm
    Aug 12, 2004 at 10:57 am
  • Folks How are "free buffer waits" (below) to be addressed? Case - Benchmark of OLTP Transactions(ATM Trans) of a Banking Application Machine - HP Superdome Storage XP1024 DB Server =3D 32 CPUs ...
    Jul 26, 2004 at 12:29 pm
    Jul 30, 2004 at 2:16 am
  • On all of our machines we have enterprise edition databases. Due to price constraint, for one of our applications, the business = bought standard edition. Question: After installing standard edition ...
    Jul 21, 2004 at 6:21 pm
    Jul 26, 2004 at 12:06 pm
  • We are testing a streams based replication ... currently log switches happen every minute, we would like to bring this down to few seconds (to have more instantaneous data available). Is it possible? ...
    Raj JamadagniRaj Jamadagni
    Jul 7, 2004 at 8:57 am
    Jul 9, 2004 at 11:05 am
  • Hi list I'm investigating this, if your default blocksize is 8k, and you create a tables using 2k block you have the ALTER SYSTEM SET DB_2K_CACHE_SIZE = 100M; to set the size for this block cache But ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Jul 21, 2004 at 9:32 am
    Aug 2, 2004 at 3:18 pm
  • Hi all, We need to rebuild our table and index segments. I guess we wouldn't have problems rebuilding the indexes online. However, I don't see any way to move tables online. Of course, I can issue ...
    Alexandre GorbatchevAlexandre Gorbatchev
    Jul 26, 2004 at 4:24 pm
    Jul 28, 2004 at 11:52 am
  • I am trying to switch to GLOBAL_NAMES=TRUE. If I have two databases and set global_names=true on database A, on database B I need to ALTER DATABASE RENAME GLOBAL_NAME TO sid.domain. Currently this ...
    Jul 21, 2004 at 9:44 am
    Jul 22, 2004 at 8:57 pm
  • We're making plans to upgrade the Oracle client on our user's PCs (running Win 2000). I spent several days trying to deinstall the current client (8.1.6) via a script with the Oracle Installer. After ...
    Hostetter, Jay MHostetter, Jay M
    Jul 6, 2004 at 9:33 am
    Jul 15, 2004 at 10:48 am
  • Hello list,=20 I'm trying to duplicate a DB from host A to host B using RMAN, after = dealing with the directories stuff (having the backup files in the same = path as the original) I tried once ...
    Aragon, Gabriel (GE Commercial Finance)Aragon, Gabriel (GE Commercial Finance)
    Jul 15, 2004 at 6:02 pm
    Jul 20, 2004 at 10:49 am
  • Hi, guys. We were getting killed on SAP, when checking locks, after we upgraded to 9.2 One of the other DBAs came up with this and it was a dramatic improvement. Not sure if he got it from metalink ...
    Wolfson Larry - lwolfsWolfson Larry - lwolfs
    Jul 26, 2004 at 4:39 pm
    Aug 10, 2004 at 12:58 pm
  • Hi All, SQL alter system backup controlfile to trace; Does anybody have a script to parse this control file backup ? that is, i need to create a neat script that contains just STARTUP NOMOUNT CREATE ...
    Prem Khanna JPrem Khanna J
    Jul 1, 2004 at 12:08 am
    Jul 5, 2004 at 9:20 pm
  • List, As part of the never ending SarbOx effort, I'm putting together a method to get a baseline of Oracle databases for auditing purposes. My current criteria for this are as follows: Track the ...
    Jul 20, 2004 at 4:01 pm
    Jul 22, 2004 at 4:20 am
  • Platform: Oracle Solaris 2.9 ArcSDE 8.3 I am running a DSS - geodatabase with 30 concurrent users. I am getting = ORA-04031 errors. I have verified that last_failure_size ...
    Jul 14, 2004 at 9:24 am
    Jul 15, 2004 at 8:28 am
  • �Someone was telling me connecting as sysdba from sqlplus is not allowed in 9i. I tried and found it did seem to not be available. Is this a security consideration... And/or does anyone have a ...
    Spears, BrianSpears, Brian
    Jul 12, 2004 at 8:43 am
    Jul 13, 2004 at 1:30 pm
  • I am looking to move to RMAN as a backup tool and away from my shop's standard of BMC sqlbacktrack. This is certainly a popular topic on this list, as I've seen many posts related to this specific ...
    Michael FontanaMichael Fontana
    Jul 1, 2004 at 1:30 pm
    Jul 2, 2004 at 5:02 pm
  • Does anyone know how to switch off the superset check when changing the = national character set. I would like to change the character set of a = new database without rebuilding it and I am receiving ...
    Ken PaytonKen Payton
    Jul 30, 2004 at 6:58 am
    Aug 1, 2004 at 12:12 am
  • Hi, As part of our move to 9i, we're looking at various features, and I'm wondering about compiled PL/SQL. Does anyone have any experience with it? Any major issues or problems? Is there any gold at ...
    Bobak, MarkBobak, Mark
    Jul 28, 2004 at 9:44 am
    Jul 28, 2004 at 3:52 pm
  • I'm having a hard time determining how much time is actually spent on CPU, Consider the following Runtime TRACE_ID EVENT WAITS WAIT_SECS ELAPSED_SECS CPU_SECS 25-JUN-2004 12:05 nlco_ora_7279 db file ...
    MacGregor, Ian A.MacGregor, Ian A.
    Jul 1, 2004 at 3:39 pm
    Jul 7, 2004 at 12:28 pm
  • List, For creating function index I have Granted "create any indextype" to user BUT still this user can not create Function Index. What kind of Privilege user need to create function index, I don't ...
    Hamid AlaviHamid Alavi
    Jul 26, 2004 at 1:35 pm
    Jul 26, 2004 at 5:38 pm
  • Oracle 9i. The DBA used enterprise manager to change memory parameters and restart the database, but the database can't grab all the data specifiied, so it won't start back up. He can't get ...
    David wendelkenDavid wendelken
    Jul 21, 2004 at 5:09 pm
    Jul 22, 2004 at 11:47 am
  • Hello Gurus, Here is the situation, I have a Oracle 7.3.4 dump, which am importing into a Oracle 9.2 server, both Windows platforms. I created a new user "schema" for the data, with it's own ...
    Denham EvaDenham Eva
    Jul 13, 2004 at 9:28 am
    Jul 15, 2004 at 12:28 am
  • Anybody knows when this Book is scheduled to release ??? Cheers, Ganesh R For more information about Barclays Capital, please visit our web site at http://www.barcap.com. Internet communications are ...
    Jul 6, 2004 at 4:14 pm
    Jul 8, 2004 at 4:09 pm
  • I need to shutdown oracle8i database to move data file to another disk but it takes about 40 minutes to shutdown immediate. Can I go ahead to issue "shutdown abort" then move data file? Does it hurt ...
    Nguyen, David MNguyen, David M
    Jul 8, 2004 at 10:45 am
    Jul 8, 2004 at 1:40 pm
  • Hi list I had done a simple function table to get free space only in tables for 9.2 I'll improve some day. hope be usefull to you. grant analyze any to daz; DROP TYPE DAZ.typ_space; CREATE OR REPLACE ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Jul 28, 2004 at 4:22 pm
    Jul 29, 2004 at 9:35 am
  • I need to execute a sql script on unix, which will connect to a remote oracle database. What can I do to prevent hard-coding the oracle password within the script? American Express made the following ...
    Tracy RahmlowTracy Rahmlow
    Jul 19, 2004 at 1:28 pm
    Jul 20, 2004 at 2:19 pm
  • Enviroment: Oracle / AIX 5.2 Scenario: I have an rman backup (nocatalog) and a separate control file backup done at 11:00 pm. The database is in archivelog mode. At 11:00 am the next morning ...
    Schauss, PeterSchauss, Peter
    Jul 13, 2004 at 3:08 pm
    Jul 15, 2004 at 12:34 pm
  • I would like to make you a question Documentation is really nice, now I'm doing a advanced tuning course, and in the documentation there is a fault of touch with the reality for example in tuning ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Jul 14, 2004 at 11:46 am
    Jul 15, 2004 at 7:55 am
  • Hi all We are in need of a solution to capture all changes to a schema, table creates, alters drops, procedure creates... functions, views, indexes etc etc. one option is Auditing, The other is via a ...
    Leonard, GeorgeLeonard, George
    Jul 12, 2004 at 3:52 am
    Jul 12, 2004 at 12:09 pm
  • Dear list, I have installed Oracle 10g (Linux) with the WareHouse example database. What I want is to learn more info about this example database (schema etc.). Where can I find the info? many ...
    Mihalis I. TsoukalosMihalis I. Tsoukalos
    Jul 2, 2004 at 6:26 am
    Jul 5, 2004 at 12:56 am
  • I believe there is a view that will have all of the oracle errors listed in it. I am not talking about dba_errors which has all the current errors. Just a lookup of Oracle errors. One of the guys ...
    Jul 27, 2004 at 10:25 am
    Jul 29, 2004 at 9:28 am
  • � Hi list, once I read Tom Kyte use some hints, I ask where you get informatoin about them, or is only for Oracle people, I think they should help when tuning and try to find the specific problem ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Jul 23, 2004 at 5:46 pm
    Jul 26, 2004 at 12:40 pm
  • Folks, Is there a single query or builtin PL/SQL routine that allows one to calculate the (character) length of a column that works for both 8i and 9i? For 8i, character length = data_length For 9i, ...
    Adam DonahueAdam Donahue
    Jul 14, 2004 at 2:26 pm
    Jul 14, 2004 at 4:41 pm
  • Larry, I've got a second client who seems to be doing this 80% of the time. Gonna have the DBA ask if they're using Weblogic. Larry -----Original Message----- From: oracle-l-bounce_at_freelists.org ...
    Wolfson Larry - lwolfsWolfson Larry - lwolfs
    Jul 1, 2004 at 7:49 pm
    Jul 9, 2004 at 4:38 pm
  • 11


    Heh, What do people use to create a simple ERD. I just want to quickly draw an ERD which shows a few tables and how they are related. Is there a simple tool which just does that? I don't even really ...
    Lee LeeLee Lee
    Jul 12, 2004 at 3:30 pm
    Sep 4, 2004 at 4:24 pm
  • Hi, I got a table w/ the ff: data id startdate enddate 1 10/01/2004 12/13/2004 2 12/01/2004 12/02/2005 3 12/03/2004 02/20/2005 need to produce the ff:output mm/yyy id 11/2004 1 12/2004 1 12/2004 2 ...
    Jul 31, 2004 at 4:35 am
    Aug 2, 2004 at 3:29 pm
  • Sorry if this is the dumb question for the day, but how does one go about dropping the definition for a global temp table? DROP TABLE doesn't do the job for me. Best regards, Jonathan Gennick --- ...
    Jonathan GennickJonathan Gennick
    Jul 29, 2004 at 2:42 pm
    Jul 30, 2004 at 11:25 am
  • Hi, We are having insert performance problem and need some suggestions on tuning.=20 Overview of the scenario In our application, one of the main components is insertion of about 2 million records ...
    Harvinder SinghHarvinder Singh
    Jul 27, 2004 at 2:44 pm
    Jul 27, 2004 at 5:10 pm
  • Hi list does any one knows How I know in oracle's dictionary if a procedure is wrapped thanks Juan Carlos Reyes Pacheco OCP Please see the official ORACLE-L FAQ: http://www.orafaq.com To unsubscribe ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Jul 27, 2004 at 10:18 am
    Jul 27, 2004 at 12:42 pm
Group Navigation
period‹ prev | Jul 2004 | next ›
Group Overview
grouporacle-l @

312 users for July 2004

Tanel Põder: 129 posts Juan Carlos Reyes Pacheco: 74 posts DENNIS WILLIAMS: 67 posts Mark W. Farnham: 62 posts J.Velikanovs_at_alise.lv: 56 posts Raj Jamadagni: 56 posts Bobak, Mark: 52 posts Jared Still: 48 posts Mladen Gogala: 45 posts Wolfgang Breitling: 43 posts Mercadante, Thomas F: 38 posts Mladen Gogala: 38 posts Powell, Mark D: 37 posts Wolfson Larry - lwolfs: 35 posts Jared.Still_at_radisys.com: 33 posts Goulet, Dick: 32 posts Jonathan Gennick: 32 posts David: 31 posts Paul Drake: 31 posts Stephen.Lee_at_DTAG.Com: 31 posts
show more