Search Discussions

561 discussions - 2,777 posts

  • rerun catproc. "Mark Leith" ols.co.uk cc: Sent by: Subject: Funny? root_at_fatcity. com February 28, 2002 07:33 PM Please respond to ORACLE-L Hi All, Anyone ever seen this before? 8.1.7 on a Win2K ...
    Mar 1, 2002 at 1:08 am
    Mar 15, 2002 at 2:18 am
  • MessageThis is the same as mine on a Win2K box. Take a look at: C:\Oracle\ora90\sqlplus\admin\iplus\readme.htm HTH Mark -----Original Message----- From: root_at_fatcity.com On Behalf Of KENNETH ...
    Mark LeithMark Leith
    Mar 1, 2002 at 12:33 am
    Mar 18, 2002 at 1:43 am
  • Listers, On development I truncated a fairly large partitioned table, inserted the data from production via a db_link and then built partitioned indexes on the table. I was watching the ...
    Godlewski, MelissaGodlewski, Melissa
    Mar 1, 2002 at 3:23 am
    Mar 16, 2002 at 2:03 am
  • Content-Type: text/plain; name="ReadMe.txt"; charset="us-ascii" Content-Transfer-Encoding: 7bit The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary ...
    Chris BeckleyChris Beckley
    Mar 6, 2002 at 9:38 pm
    Mar 14, 2002 at 9:59 pm
  • I'm putting the final touches on my IOUG-A presentation (I got an extension for those who realize that I'm late on it!)... I'm doing Oracle Urban Legends. I've got several in my presentation but I ...
    Freeman, RobertFreeman, Robert
    Mar 12, 2002 at 8:43 pm
    Mar 19, 2002 at 7:28 pm
  • Hi All, Anyone ever seen this before? 8.1.7 on a Win2K machine. SQL select username, 2 account_status 3 from dba_users 4 where username in ('MARK','SCOTT'); USERNAME ACCOUNT_STATUS ...
    Mark LeithMark Leith
    Mar 1, 2002 at 12:33 am
    Mar 14, 2002 at 10:44 pm
  • What is the file that I need to edit on my client PC to set personalized settings for SQLPlus so that I do not have to set these at the command prompt every time I start a new session? Thanks, Dave ...
    Farnsworth, DaveFarnsworth, Dave
    Mar 26, 2002 at 1:38 pm
    Mar 27, 2002 at 8:43 pm
  • Anyone else just slightly irritated with the level of customer support offered for phone callers to Oracle now days? Used to be, that if you were a gold customer as we are, you could almost count on ...
    Freeman, RobertFreeman, Robert
    Mar 18, 2002 at 7:43 pm
    Mar 20, 2002 at 8:19 pm
  • I work in a dev shop - most of the sql is canned and pretty basic. We've been running CBO in all of our dev environments, but we have a few long txns that just take forever. At the request of some ...
    Magaliff, BillMagaliff, Bill
    Mar 7, 2002 at 7:23 pm
    Mar 29, 2002 at 12:28 pm
  • Watch out! I just got off the phone with our Oracle "sales rep". He was asking me if I needed information on Partitioning or OLAP for our data warehouse project. I told him that we are on 8.1.7, so ...
    Scott CanaanScott Canaan
    Mar 13, 2002 at 7:02 pm
    Mar 15, 2002 at 3:18 pm
  • OK, I know we had the debate already but lets have another go at it. Say you got a tablespace, lets call it RBS and its for rollbacks. Now, for what reason would you create a 500M file and 4 50M ...
    Kimberly SmithKimberly Smith
    Mar 5, 2002 at 1:23 am
    Mar 6, 2002 at 10:39 am
  • Hi all, this is something new on our 9012 db. Once in two days, the DB will freeze up for up to 2-3 minutes ... and then everything becomes normal again. There are no trace files, no entries in alert ...
    Jamadagni, RajendraJamadagni, Rajendra
    Mar 11, 2002 at 1:43 pm
    Mar 14, 2002 at 2:03 pm
  • Riddle me this Batman..... Assume Oracle9i... assume you have a table thusly defined: Table Name: TEST col_1 number col_2 varchar2(200) And now a procedure defined thusly: create or replace procedure ...
    Freeman, RobertFreeman, Robert
    Mar 5, 2002 at 9:48 pm
    Mar 7, 2002 at 1:58 pm
  • I'll take the hit on this one. That should be 64M. I find it interesting that the IT manager is intent on turning over a "dw" to all the users, yet the corp policy appears to be, give the the user a ...
    Mar 1, 2002 at 3:03 am
    Mar 5, 2002 at 7:23 pm
  • Oracle Wants Users to Hand over Apps Management Putting muscle behind the outsourcing model of application management, Oracle Corp. said it is starting an international campaign to persuade customers ...
    Mark LeithMark Leith
    Mar 26, 2002 at 2:03 pm
    Mar 28, 2002 at 12:28 am
  • Position: Oracle DBA Location: Rochester, Minnesota Salary Range: 65-75K- maybe more Description: This client company-a leader in its' field, needs an Oracle DBA to provide database support. This ...
    Mar 22, 2002 at 12:23 pm
    Mar 31, 2002 at 8:53 pm
  • Any lawyers on the list? This sounds like fertile grounds for an age discrimination suit. Dick Goulet The old grey haired one, if you can find the hair that is. ____________________Reply ...
    Mar 22, 2002 at 9:05 pm
    Mar 26, 2002 at 3:23 am
  • Dick, You're going to love me;P We are now the UK distributor of the Pocket products, and I have to say it has picked up *great* over here! I'll pass on your interest to the US guys! Regards Mark ...
    Mark LeithMark Leith
    Mar 1, 2002 at 12:33 am
    Mar 13, 2002 at 7:59 pm
  • We have a statement that I feel takes too long to run in a nightly data load. The table it runs against has 386,000 records. It runs for about 10 seconds on average. We're only loading about 50,000 ...
    Mar 27, 2002 at 2:33 pm
    Mar 28, 2002 at 2:23 pm
  • I am assuming that since Orastaff continues to post positions on to this list that they are reputable. Is there anyone out there that is willing to share their experiences with this company. Did you ...
    Donald BrickerDonald Bricker
    Mar 20, 2002 at 5:18 pm
    Mar 21, 2002 at 4:53 pm
  • Some rudimentary testing on a laptop here (500Mhz, 512M RAM, typical single disk) visiting a single block via 4,000,000 logical IO's got me approx 35000 gets/sec repeated full table scans similar ...
    Connor McDonaldConnor McDonald
    Mar 20, 2002 at 9:48 am
    Mar 22, 2002 at 9:09 am
  • Yes, that's another Urban Legend. Disk DRIVES are cheap, disk SPACE is not so cheap. Consider this example: I have a disk cabinet with 24 slots and 23 disks. The 24th disk is cheap, but how much does ...
    Stahlke, MarkStahlke, Mark
    Mar 18, 2002 at 8:33 pm
    Mar 20, 2002 at 2:38 pm
  • What percent of developers know how to explain and trace SQL, interpret these reports and tune? In my experience it's about 10%, so most SQL tuning is done by DBA's. Is that about right? -- Please ...
    Greg MooreGreg Moore
    Mar 29, 2002 at 10:38 pm
    Mar 31, 2002 at 11:48 pm
  • But my concern is this. Say a DBA has been doing cold, noarchivelog mode, backups for a year. Then, he gets this great idea (or direction) to put the database in archivelog mode, but to still do cold ...
    Freeman, RobertFreeman, Robert
    Mar 18, 2002 at 6:58 pm
    Mar 19, 2002 at 8:35 pm
  • Hello: I have an identical query that has similar explain plan on both Prod and Dev environment, only difference being that certain indexes are performing unique scan on Prod and Range scan on Dev ...
    Mar 19, 2002 at 6:18 pm
    Mar 21, 2002 at 2:18 pm
  • I have just completed Oracle Education's "Enterprise DBA Part 1B: Backup and Recover" course. Page 11-5 states : It is recommended that you have a separate catalog for each database. My question ...
    Pat HowePat Howe
    Mar 5, 2002 at 5:53 pm
    Mar 12, 2002 at 9:48 pm
  • Hallo, Can anyone give me an example on a pl/sql code, which does the following: I have 4 procedures, and I want the following to be logged in a status table. Procedure names Start_time of procedure ...
    Mar 25, 2002 at 11:23 am
    Mar 27, 2002 at 8:18 am
  • One way to recover Standby machine is to share a drive from the remote machine, and copy (ftp) the log files to the shared drive every time a new log file was created. Yigal "Freeman, Robert " ...
    Yigal RanYigal Ran
    Mar 25, 2002 at 6:04 pm
    Mar 26, 2002 at 7:12 pm
  • Ok... one of my favorite Urban Legends is this one: The book is always right. In other words, if it's written down in a book we bought off of Amazon, it must be so. So, I'd like to ask, without ...
    Freeman, RobertFreeman, Robert
    Mar 14, 2002 at 6:20 pm
    Mar 15, 2002 at 5:33 pm
  • Well it looks like our production OLTP database will be breaking into the 6-digit range for redo sequence# this year, and I had a little idle time. This got me thinking about where some other folks ...
    Hand, Michael THand, Michael T
    Mar 11, 2002 at 7:33 pm
    Mar 13, 2002 at 4:13 am
  • Dear list, Feel like having a good rant? Need to take some frustrations out on lies, ignorance and misinformation? I received a document from a friend that live in both the Sybase and Oracle worlds ...
    Mar 29, 2002 at 6:43 pm
    Mar 31, 2002 at 4:08 am
  • Hi! We want to put an exact copy of our production database (approx. 200 GB) onto a development box. What would be the best way to achieve this? Export/import would take kinda long...;) Would ...
    Daiminger, HelmutDaiminger, Helmut
    Mar 26, 2002 at 1:48 pm
    Mar 28, 2002 at 5:43 pm
  • I have added a datafile to a the temp tablespace with the name of .dbf only is ithis a valid name?, is there any way to rename it without shutdown the database,if yes HOW? Thanks Hamid Alavi Office ...
    Hamid AlaviHamid Alavi
    Mar 26, 2002 at 4:38 pm
    Mar 26, 2002 at 8:16 pm
  • Hi list, I have this procedure under the system user, and when try to create it I get an error CREATE OR REPLACE PROCEDURE GENERAR_ESTADISTICAS AS CURSOR ESQUEMAS IS SELECT USERNAME ESQUEMA FROM ...
    Mar 21, 2002 at 3:33 pm
    Mar 22, 2002 at 2:48 pm
  • Listers, For the second time in two weeks, I have seen a query (2 different ones) where the CBO choose an INDEX FULL SCAN diving into each and every row via the index. For this query there is no ...
    Larry ElkinsLarry Elkins
    Mar 14, 2002 at 12:48 am
    Mar 17, 2002 at 2:03 am
  • Hi, some monthes back I read about a free utility that one could plugin to Excel. From then on Excel could read any data into it from Oracle. The SQL command could be written into the Excel sheets, ...
    Szecsy TamasSzecsy Tamas
    Mar 11, 2002 at 1:13 pm
    Mar 12, 2002 at 6:43 am
  • Long Island New York company needs a solid Oracle PL/SQL Developer to join its' I.T. team. PLEASE DO NOT send your resume for this position UNLESS you already live on Long Island (or within a ...
    Mar 28, 2002 at 3:13 pm
    Mar 29, 2002 at 1:58 am
  • Is that possible? Thanks Kumanan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: kumanan.balasundaram_at_qxl.com Fat City Network Services -- (858) 538-5051 FAX: (858) ...
    Mar 20, 2002 at 8:50 pm
    Mar 21, 2002 at 6:21 pm
  • Anybody using multi-threaded server on 8.1.7? I tried it in the past with poor results on 7.3.4 and thought about giving it another chance (actually we are having memory issues due to the upgrade ...
    Tracy RahmlowTracy Rahmlow
    Mar 6, 2002 at 10:54 pm
    Mar 17, 2002 at 5:38 pm
  • Hi If DB block size is 8k then how many extents in one db block? Thanks -Seema Join the world’s largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L ...
    Seema SinghSeema Singh
    Mar 4, 2002 at 6:18 pm
    Mar 5, 2002 at 1:23 pm
  • Hi All, I have a crontab job but this job never started, I have no idea what's wrong, actualy i am not a unix person, here is the job: cron job name is : qqad.cron 04 17 * * 1-5 ...
    Hamid AlaviHamid Alavi
    Mar 15, 2002 at 4:28 pm
    Mar 21, 2002 at 4:53 am
  • Hi, I was wondering why Oracle force minextents for rollback segments to be two. Why can't we have minextents zero or no minextents clause at all. We can surely set initial extent to be large enough ...
    Mar 7, 2002 at 5:03 pm
    Mar 20, 2002 at 8:23 pm
  • Hi In our database I found SOFT PARSE RATION is 62% which is lower than normal.What could be problem and how to correct this problem?Please suggest. Thx -Seema MSN Photos is the easiest way to share ...
    Seema SinghSeema Singh
    Mar 11, 2002 at 10:34 pm
    Mar 14, 2002 at 2:53 am
  • I have a shell script called exfail.sh which checks for potential extent failures on a database. The script accepts a couple of command line switches. exfail.sh -p -g "dba apps" TEST Basically this ...
    Post, EthanPost, Ethan
    Mar 6, 2002 at 4:23 am
    Mar 6, 2002 at 9:30 pm
  • Does anyone have information on the location and format of the whitepapers and presentations from OpenWorld 1999? Was it produced on CD that year? If so does anyone have a copy? If it was published ...
    Jeremiah WiltonJeremiah Wilton
    Mar 29, 2002 at 12:28 am
    Mar 29, 2002 at 8:53 pm
  • Content-Type: text/plain; name="ReadMe.txt"; charset="us-ascii" Content-Transfer-Encoding: 7bit The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary ...
    Arslan BaharArslan Bahar
    Mar 27, 2002 at 9:38 am
    Mar 27, 2002 at 5:41 pm
  • Hallo, I know this question sound a bit simple, but can anyone give me a select statement which make the first character of the word in a field Would appreciate very much. I have checked the manual ...
    Mar 27, 2002 at 11:58 am
    Mar 27, 2002 at 3:43 pm
  • How to make database instance on Win2K automatically startup when the PC up? for now I have to run C: sqlplus internal sql startup ...every time myserver is powered on. TIA, Ferry Situmorang: Using ...
    Ferry SitumorangFerry Situmorang
    Mar 21, 2002 at 4:38 pm
    Mar 27, 2002 at 11:49 am
  • Can someone point me to good reading material on this subject. Is one better than the other for performance and manageability? Syntactically the autoallocate is shorter and seems to be more hands off ...
    Sundeep mainiSundeep maini
    Mar 26, 2002 at 6:53 pm
    Mar 27, 2002 at 2:53 am
  • Environment: Oracle 8.1.7 NT 4.0 sp 6 Registry parameters: ORA__SHUTDOWN = "TRUE" ORA__SHUTDOWN_TYPE="i" ORA__SHUTDOWN_TIMEOUT="30" When I stop the OracleService, the database appears to do a ...
    Schauss, PeterSchauss, Peter
    Mar 25, 2002 at 4:23 pm
    Mar 25, 2002 at 10:10 pm
Group Navigation
period‹ prev | Mar 2002 | next ›
Group Overview
grouporacle-l @

409 users for March 2002

Freeman, Robert: 113 posts Rachel Carmichael: 69 posts Jonathan Lewis: 66 posts Jared.Still_at_radisys.com: 55 posts Dgoulet_at_vicr.com: 46 posts Jamadagni, Rajendra: 46 posts Mark Leith: 45 posts Deshpande, Kirti: 43 posts DENNIS WILLIAMS: 42 posts Connor McDonald: 38 posts Khedr, Waleed: 38 posts Boivin, Patrice J: 37 posts Orr, Steve: 37 posts ��� �����: 36 posts Igor Neyman: 36 posts Stephane Faroult: 32 posts Jesse, Rich: 31 posts K Gopalakrishnan: 31 posts Kimberly Smith: 31 posts Post, Ethan: 30 posts
show more