RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments

Here is the list of top 10 do's and don't that I came up with. #1 - Do Maintain your Expertise #2 - Do Use the DBMS_STATS Package to Collect Statistics #3 - Do Use Bind Variables #4 - Do Put your Production Database in ARCHIVELOG Mode #5 - Do Use Locally Managed Tablespaces #6 - Do Monitor Your

Alert Log reporting question

Hi all, I am writing a script that can grep ORA- from alert log. I think it will be good if I can grep the time of the error occur, can you please help me? If you are lazy to type please introduce me any related unix function, I will do man the function myself. Thanks Sinardy -- Please

installation / recovery question

Hi all, I have a test installation of Oracle 817 and 902 on my PC - installed completly on a device other than system device. Now my computer is getting buggy (well it's Win2k on it) so the sysadmin want's to reinstall the system device. Is there any way to save the registry entries for Oracle

Which is beter a cursor or a for loop?

Title: Which is beter a cursor or a for loop? Hello, I was just asked by one of our developers which is beter to use:- a cursor or a for loop? I must admit I am not sure Anyway the specific piece of code in discussion is similar to the following FOR X IN (SELECT X FROM

RE: Alert Log reporting question

Hi all, I am writing a script that can grep ORA- from alert log. I think it will be good if I can grep the time of the error occur, can you please help me? If you are lazy to type please introduce me any related unix function, I will do man the function myself. Thanks Sinardy Sinardy,

Re: initial/next computation with DOP 4

You really should be looking at locally managed tablespaces with uniform extent size (see www.dbazine.com for one article on this, www.oracledba.co.uk for another). Even if you want to avoid LMTs, then you should be looking at aiming for uniform extent sizing by mechanical methods. (initial =

RE: Oracle Names Server 8.1.7 on HP 11

Hello Stephen, sorry for the delay in reply, the names respository is located on a different server as compared to the names server. I would be interested in the white paper, it be great if you could send it over. Thanks Zabair "Karniotis, Stephen" [EMAIL PROTECTED] wrote: Zabair:

Re: Error pinning PKS in shared pool

... oops and then you might want to add that you really have to mess around with quote marks and begin/ends to get it to work - something like (and I really ought to test this before posting, 'cos it's one of those tiny details that there's no point in wasting valuable memorisation time on)

RE: installation / recovery question

Hi, ***Suggestions*** I think your consent is more toward OS backup, From the DB point of view (assume your databases are created and populated) - Do cold backup (Oracle redundancy set + all parameter files (db and network) + password file + user docs + scripts + everything) - backup the

RE: installation / recovery question

I don't know about entries for a particular product. You can explore regedit and regedit32 utilities provided with windows. Aleem -Original Message- Sent: Monday, February 24, 2003 1:39 PM To: Multiple recipients of list ORACLE-L Subject:installation / recovery question Hi

RE: Which is beter a cursor or a for loop?

I would suggest that the cursor is the best way to go. -Original Message- Sent: 24 February 2003 08:39 To: Multiple recipients of list ORACLE-L Hello, I was just asked by one of our developers which is beter to use:- a cursor or a for loop? I must admit I am not sure Anyway

Lost Mail

Apologies to anyone out there that is hoping for a reply to a question that they may have sent directly. I upgraded to IE 5 over the weekend. The upgrade process was thorough, firing on all cylinders, and has destroyed half my email database, and duplicated the other half (so on average no

RE: Which is beter a cursor or a for loop?

Hello, I was just asked by one of our developers which is beter to use:- a cursor or a for loop? I must admit I am not sure Anyway the specific piece of code in discussion is similar to the following FOR X IN (SELECT X FROM TABLE_NAME WHERE COL1 =

Re: newbie sqlplus ?

hi! in your profile set $ORACLE_HOME to your oracle directory and put $ORACLE_HOME/bin in your path daniel Les Ayudo wrote: I have just installed Oracle 8i1.7 on solaris 9 (ultra sparc 10) and issued the command sqlplus and I rec'd a command not found error. Is there something I forgt to

RE: installation / recovery question

Run REGEDIT, then go to HKEY_LOCAL_MACHINE\SOFTWARE, click oracle and then from the file menu choose export. it will save the Oracle key to a .reg file. Then you can go to HKEY_LOCAL_MACHINE\SYSTEM\CUrrent Control Set\Services and do the same for all the services which start with Oracle. After

RE: Which is beter a cursor or a for loop?

--_=_NextPart_001_01C2DBF5.0AC6B3E0 Content-Type: text/plain; charset=iso-8859-1 Denham The for loop is a lot easier to read. It can be a real pain scrolling to the top every time you want to see what such-and-such a cursor is doing. On the other hand, it can be a bit limiting in more

RE: Which is beter a cursor or a for loop?

-Original Message- Sent: 24 February 2003 08:39 To: Multiple recipients of list ORACLE-L Hello, I was just asked by one of our developers which is beter to use:- a cursor or a for loop? I must admit I am not sure humour on That's like asking I have a Porsche. What's the

File Table Overflow on Oracle DB Server

We have the following query reg. an error on HP-UX ORacle DB server. We are encountering HPUX Error: 23: File table overflow' on the Oracle database server while executing stress tests for our application. We are not opening any files on the database server through the application still

Re: Which is beter a cursor or a for loop?

It's purely syntactical sugar unless you use the BULK features of the explicit cursor, in which case, you may gain some performance. /Bjrn. Denham Eva wrote: Which is beter a cursor or a for loop? Hello, I was just asked by one of our developers which is beter to

Re: File Table Overflow on Oracle DB Server

Vivek: I remember you getting the same problem some time back. I guess you need to increase the nfiles kernel paramter (it defaults to maxuser*constant or something similar to that) Just bump the max users or change the nfile parameter. KG = Have a nice day !!

Re: Alert Log reporting question

Sinardy, I've posted a shell script called chk_oerr.sh on http://www.EvDBT.com/tools.htm;. It doesn't do exactly what you ask, but it remembers where it left off scanning in the alert.log file. You can run it hourly, daily, or weekly if you like, and the timing of the emails it sends you should

RE: Testing database links

I think I spoke too soon. The v$dblink view shows the db_links opened by the current session only. I want to be able to find out the db_links opened by all current sessions and the sids for the sessions. This way I can monitor all the application instances that opened the db_link and those that

RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments

I don't agree with don't #1 and #5. From: Stephane Faroult [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments Date: Mon, 24 Feb 2003 00:23:37 -0800 Here is

RE: Error pinning PKS in shared pool

Thanks Suzy, Waleed, John, Richard, Connor, Jonathan, for your help. Out of shape on sundays :-) TKS -Original Message- Vordos Sent: Sunday, February 23, 2003 3:44 PM To: Multiple recipients of list ORACLE-L Don't think you need to use execute immediate. Try this (should be run as

Re: File Table Overflow on Oracle DB Server

Here is Kirti's reply to it (long time back in June). I think it was to you that time also... Babu Vivek, You are right, this is an OS related issue, but a DBA must be aware of why it happens ;) Error 23 means 'File Table Overflow' and it is generated when the system wide limit for the number

Re: Which is beter a cursor or a for loop?

Both use cursors, but a FOR loop is more concise coding. Technically, they are exactly equivalent; the differences are just stylistic... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, February 24, 2003 3:08 AM I would suggest that the

RE: Top 10 DBA Do's and Don'ts anyone - Here is my list,

You brought to mind another one... DON'T assume that changes in one environment will have the same impact across all environments so DO test the impact of any change in all environments that you can, before implementing it in production. We had a change go in to the dev environment that fixed the

RE: Alert Log reporting question

Title: RE: Alert Log reporting question Checkout http://www.zephyrus.com ... it is a very nice tool ... Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts,

RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments

MccDBA: It is just Robert's Don't list ;) but you can always give your opinion abt that. Would you mind telling us 'Why you don't agree on them?' KG --- dist cash [EMAIL PROTECTED] wrote: I don't agree with don't #1 and #5. From: Stephane Faroult [EMAIL PROTECTED] Reply-To:

RE: JDK_HOME - Do we need damn JDK_HOME?

I left it blank, and all is well. -Original Message-From: Vladimir Barac [mailto:[EMAIL PROTECTED]Sent: Saturday, February 22, 2003 10:04 AMTo: Multiple recipients of list ORACLE-LSubject: JDK_HOME - Do we need damn JDK_HOME? Good day to everyone I'm installing

Fwd: Re: Optimizer help, get query to run as good as with RULE

Jonathan, Thanks. I am able to get better performance running -- SELECT /*+ CHOOSE */ DISTINCT -- SELECT /*+ RULE */ DISTINCT -- SELECT /*+ index (prcd_instruction, prcd_instruction_pk) */ DISTINCT -- SELECT /*+ index (prcd_instruction_runsheet, prcd_instruction_runsheet_pk) */ DISTINCT -- SELECT

Re: initial/next computation with DOP 4

Jonathan: Just what I was looking for -- thank you so much! I can (and will) turn this tablespace into locally managed. Just can't do it right at this moment. I kinda thought that making the next the same for all of my extents would be enough to keep fragmentation down, but that obviously did

RE: Error pinning PKS in shared pool

Instead of modifying the trigger all the time, why not just maintain rows in a table? Here's what I've written after I got tired of making typos that caused the objects after it to fail to pin: CREATE OR REPLACE TRIGGER sys.qt_pin_on_startup AFTER STARTUP ON DATABASE DECLARE v_count

Re: Alert Log reporting question

I have a script to do this (but not access to it at the moment) but its basically egrep and awk to: a) grep for ORA-, ^Mon, ^Tue, ... ^Sat b) results piped through awk which does: if $0 like ORA-, the print p, $0 if $0 like Mon,Tue,...Sat, then p=substr($0,12) hth connor --- Sinardy

Re: Which is beter a cursor or a for loop?

If you are after the n'th degree performance then the: for x in (select ... ) will be minisculely faster (simply because its slightly less code and plsql is interpreted). And unless I have a particular need for the cursor %attributes, or the cursor needs to be passed around I prefer the sql

RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments

#4 on the Do list assumes that you are an On-Line Transaction Process database. If you are a Decision Support database, then ARCHIVELOG is not needed. But, as a general rule, the world would be a better place if more production DBAs had their databases in ARCHIVELOG mode. #4 on the DO list is

Upgrading from 8.1.5 to 8.1.6

After upgrading oracle database from V8.1.5 to V8.1.6, a new directory is created to store new version's files and the old directory of old version 8.1.5 is still there. Is is safe to remove the old directory to save disk spaces on the disk? Is there any files being linked to the old version

RE: Testing database links

There is an underlying x$table named x$uganco that contains a column named inst_id which is being filtered in the view_definition for V$DBLINK as found in V$FIXED_VIEW_DEFINITION. Selecting from the x$uganco should do the trick. Mind you there are no rows in there when the links are not active

How long to hold onto old Oracle CDs?

Hey all, Can anyone think of a reason to hold on to Oracle 7.3.3 HP/UX CDs? We've been at 8.1.7 for 18 months now. I can't think of a good reason, other than the software isn't available anymore. Anybody want some old CDs? :) Rich Rich JesseSystem/Database

Top 10 normalised down to Top 2

I have to admit my list is considerably smaller: DO: #1: Listen, Think, Learn, Communicate #2: Have a passion for what you do. If its just a job, then you're in the wrong one. DON'T: #1: Do the opposite of the Do's Cheers Connor --- Rachel Carmichael [EMAIL PROTECTED] wrote: You brought to

RE: How long to hold onto old Oracle CDs?

You should keep them. You never know when you will decide to get a shotgun and be in need of some targets. -Original Message- Can anyone think of a reason to hold on to Oracle 7.3.3 HP/UX CDs? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee

RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comm

I'm curious as to an explanation on don't #1 (what constitutes reorganization?) and what is ASSM for don't #5? Assembly??? Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent:

RE: How long to hold onto old Oracle CDs?

Title: RE: How long to hold onto old Oracle CDs? Just remember during some versions of 7.x most of dbms_xxx packages weren't encoded, that could be a good reference if you are so interested. Raj - Rajendra dot Jamadagni at espn dot

RE: storing credit card numbers in a database

None taken! :) Rich -Original Message- Sent: Friday, February 21, 2003 5:44 PM To: Multiple recipients of list ORACLE-L No offense Rich, but I think a crypto expert would make short work of decrypting this. Jared Jesse, Rich [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED]

Re: How long to hold onto old Oracle CDs?

Glue felt on one side and sell as trendy coasters at local flea market. [EMAIL PROTECTED] 02/24/03 08:58AM Hey all, Can anyone think of a reason to hold on to Oracle 7.3.3 HP/UX CDs? We've been at 8.1.7 for 18 months now. I can't think of a good reason, other than the software isn't

RE: Top 10 DBA Do's and Don'ts anyone - Here is my list,

I agree with not relying on a GUI tool, but can't necessarily agree with a Good DBA will use command line SQL first. Personally, I figure a good DBA should make effective use of their time. Use or don't use the tool when it makes sense to do so. I use the tools for one off items but not for

encryption - peoplesoft 8 - oracle ??

Title: storing credit card numbers in a database Has anyone used data encryption/decryption with peoplesoft8 HR application with oracle backend? Any hints will be appreciated.. Thanks Mohammed Ahsanuddin Oracle DBA -Original Message-From: Nick Wagner [mailto:[EMAIL

RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments

Wouldn't ARCHIVELOG on a DSS DB depend on how much downtime you can withstand on that DB? If your recovery time for most situations is much shorter using ARCHIVELOG mode (perhaps on very large DBs or systems w/limited IO), wouldn't that be better than NOARCHIVELOG? Rich Rich Jesse

Export generates ORA-04031 error

I received following errors during export. I had increased shared_pool_size in configuration file several times, it just fixed the problem for couple weeks then now I received the same problem. Is there a better way to fix this issue permanently? And what is the maximum limit size can I

RE: How long to hold onto old Oracle CDs?

CD's make great coffee coasters! Just ask our competition!! ;) -Original Message- Sent: 24 February 2003 15:34 To: Multiple recipients of list ORACLE-L You should keep them. You never know when you will decide to get a shotgun and be in need of some targets. -Original

Re: How long to hold onto old Oracle CDs?

Actually the CD's are available. You just have to request them from Oracle. Of course, this does depend upon having a support contract. Ordered a replacement CD a couple of months ago for 7.3.4 (HP/UX) due to cracked media. From: Jesse, Rich [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To:

Re: How long to hold onto old Oracle CDs?

Hold on to them - they're really good for hanging in branches of fruit trees to scare the birds off. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon one-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see

Re: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments

Tom, Having a data warehouse database in NOARCHIVELOG is, like any other database, only the very last resort when ARCHIVELOG is simply not possible. Your advice results from several assumptions which may or may not be valid: * data warehouse are read-only; don't worry about transaction

RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comm

Automatic Segment Space Management -Original Message- Sent: 24 February 2003 15:39 To: Multiple recipients of list ORACLE-L comm I'm curious as to an explanation on don't #1 (what constitutes reorganization?) and what is ASSM for don't #5? Assembly??? Rich Rich Jesse

corrupted block

I recently inherited a 40GB 7.3.4 database (yes, it needs to upgrade). Last night I analyzed the tables and a corrupted block was found. I know which table and datafile it is, and it's the only table in the affected tablespace. The database is in archivelog mode so I can recover the

RE: Upgrading from 8.1.5 to 8.1.6

It depends on whether or not you are talking about your old $ORACLE_HOME. You may still have shared lib dependancies there. You don't give enough information in your post to be absolutely certain so you might consider relinking if this is the case. -Original Message- Sent: Monday,

RE: Top Do's and Don'ts - Ferenc's list

Good list yerself!! :-)) Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (It's everywhere that I am!) +++ ***Author*** of several books you can find on Amazon.com!

Re: How long to hold onto old Oracle CDs?

Under no circumstances would you consider moving your production db back from 8.1.7 to 7.3.3, would you? So the only possible reason for retaining them would be to support a newly-acquired application (!?!?!?!). Even if you still had the CDs, shouldn't you just say you didn't? :-) They make

RE: How long to hold onto old Oracle CDs?

I stil have my 4.1.14 installation for DOS 3.3. (3 5.25 floppies) -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED] Sent: Monday, February 24, 2003 9:59 AM To: Multiple recipients of list ORACLE-L Subject: How long to hold onto old Oracle CDs? Hey all, Can anyone

RE: File Table Overflow on Oracle DB Server

Vivek, The database backend process will open the file on your behalf, and each open takes up one entry in your 'Numbe of Open files in the System' OS table. Not many people monitor the output of 'sar -v'. Look for overflows of some of the OS tables under the 'ov' column... (this will also

RE: How long to hold onto old Oracle CDs?

We covered an entire wall in the operations manager's office with the Oracle cd's. We even had enough red ones to create a nice design... It all started because I asked him if we recycle cd's. He said only if I could find a new use for them. He shouldn't have said that and then taken a day

RE: Export generates ORA-04031 error

9M is not a large shared pool. What db version? What app? We really do need some details to provide intelligent responces. You might consider bumping it to 20M and see what happens. Without more information it is impossible to be more specific. Allan -Original Message- Sent: Monday,

RE: corrupted block

See Note:61685.1 (metalink) Good luck Waleed -Original Message- Sent: Monday, February 24, 2003 11:09 AM To: Multiple recipients of list ORACLE-L I recently inherited a 40GB 7.3.4 database (yes, it needs to upgrade). Last night I analyzed the tables and a corrupted block was found.

RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comm

A... but in my world view, DBA's need to THINK like developers, since we are always the ones who the real SQL tuning gets pushed down to. Also, DBA's often are called on to design the database, and when views are brought to them to create they need to ask themselves, is this really a good

Using fully qualified table_name.database_object in application code?

I would like to know if it is advocated to use fully qualified table_name.database objects in application code. Example would be schema.table_name in a PL/SQL code. I would like to know the Pros/Cons if there are any? Thanks in advance.Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips,

Re: Teradata baned from IOUG???

Robert, I agree, personal attacks are inappropriate and fairly pointless. On the other hand, I do sympathise with the people who are irritated by the divergence between Rich Niemiec's claims to be one of the best, and the poor, even dangerous, work that he publishes. Please note, I do not

RE: How long to hold onto old Oracle CDs?

Tim: I can't say that I can shoot BB's @ 10M, I prefer a .30 caliber @ 150 yds, although I must admit that I can't keep them inside the center hole at that distance. I do know they don't load worth a hoot with 3 or 4 extra holes in them ;} Rick Weiss -Original Message- Sent: Monday,

Re: newbie sqlplus ?

I'm just going to reinstall Oracle8i and start from scratch. Any docs out there on uninstalling Oracle8i? The only ones I have found are on Windows and they're all saying how Oracle does not completely uninstall. Is this true for Oracle on Solaris? I ran the uninstaller and removed everything

RE: corrupted block

Suzy, Just more questions: Are your sure that this corruption has made it to the disk? It could be memory related. Can you export the table to /dev/null to double check the corruption? What do you get when reading that particular block using dba_extents? - Kirti -Original

RE: How long to hold onto old Oracle CDs?

Yeah, these are actually replacements, too. But when I ordered them, the person (back when you could actually talk to a person on a non-level 1 call) was surprised that they had any 7.x media in stock. She had said that they would distribute the CDs only as long as they had stock. Maybe I'll

RE: How long to hold onto old Oracle CDs?

Talking of old Oracle stuff, just been cleaning out the bookshelf. 'UFI', 'IAF', 'IAG', 'IAP', 'RPT' bring back any memories? This lot is going OUT. peter On Mon, 2003-02-24 at 10:33, Stephen Lee wrote: You should keep them. You never know when you will decide to get a shotgun and be in

Re: How long to hold onto old Oracle CDs?

That's about the only thing that AOL CDs are good for. I don't know if Oracle CDs would be scary enough! Jonathan Lewis

Re: corrupted block

Rama Velpuri's book had the answer to how to copy rows from a table when a corrupted block exists. The downside is the table is roughly 18GB, and has LONG. So my next question, is there any way to determine by trace file when the block corruption occurred? I'm still under the assumption

RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments

All the hearsay evidence I've seen (including comments attributed to Cary at his HotSOS symposium that I heard second hand last week) leads me to believe that don't #5 is true...I must admit I've not done benchmarking myself... :-) I am, however, ever open minded. RF Robert G. Freeman Technical

RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comm

E! That icky LMT option? Ick! Ick! Ick! Thx! Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Monday, February 24, 2003 10:29 AM To: Multiple recipients of list

RE: Upgrading from 8.1.5 to 8.1.6

David Just now getting to 8.1.6? Do you wait for a version to be desupported before you upgrade to it? Just kidding, I'm still on 8.1.6 myself. Are we talking data files or program files? Not knowing how you did the upgrade, it is hard for me to make a blanket statement. Look at file

RE: corrupted block

I think more recent versions of Oracle have options for skipping corrupt blocks with exports. One possible way: If you have a valid primary key index on the table, and the index is in a good tablespace, you might be able to cycle through all the primary keys, select the row corresponding to that

RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments

Rich, I agree. We have a warehouse here that is not in archivelog mode. They perform loads two days a week (Sunday and Monday) followed by a cold backup on Tuesday. The cold backup is now taking 18 hours to complete. I've suggested switching into Archivelog mode and performing Rman backups -

Re: corrupted block

Have you tried copying it into a new table? Assuming that you have tried and failed, try creating a new table something like this: Create new_table as (select * from old_table where substr(rowid,1,8) != 02457856); I believe that that's the way the rowid was set up in Oracle 7.3.4 but my

RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comm

Care to share why...? Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (It's everywhere that I am!) Author of several books you can find on Amazon.com! -Original Message- Sent: Monday, February 24, 2003 6:29 AM To: Multiple

Re: corrupted block

Hi, If you can afford to forget the data in the corrupted block you can use the event 10231 to skip the corrupted block during table scan. Set the event and you can do a CTAS with a new table name and then you can rename that as original table after dropping the original table. Here is the

RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comm

* SHOCK * You mean someone disagrees with *ME* Horrors the world is soon to come to an end!! :-)) RF Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (It's everywhere that I am!) Author of several books you can find on

RE: corrupted block

Suzy - Here is an article that explains it well. Hopefully this will work with 7.3.4. http://www.fortunecity.com/skyscraper/oracle/699/orahtml/oramag/16tech.html Once you get past the immediate crisis, there are a couple of ways to detect block corruption more quickly. Dennis Williams DBA,

RE: Using fully qualified table_name.database_object in

Title: Message Most application developers in my experience are in love with synonyms exactly so they won't have to fully qualify the table name. Oracle uses them fairly extensively in APPs. They do require some overhead for looking up the synonym and they can be a mess if nested deeply

RE: How long to hold onto old Oracle CDs?

How about making them into clocks. I have seen this done. A potential revenue source is available. Or drink coasters for the fashionable IT person. From: Jesse, Rich [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: How

RE: Top 10 DBA Do's and Don'ts anyone - Here is my list,

Title: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, Another Do's ... 0.1: When in doubt, ask your question with relevant details on this list and then listen to masters share their wisdom. Raj - Rajendra dot Jamadagni

RE: Top 10 DBA Do's and Don'ts anyone - Here is my list,

Oo, that *IS* a good one May need to add that to the list somewhere somehow. RF Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (It's everywhere that I am!) Author of several books you can find on Amazon.com! -Original

Re: corrupted block

Hi Suzi, The first thing I would suggest is to determine if it is actualy in use by the database (ie allocated to an object)... dbv has an "os perspective" on the file and hence does not understand what objects contain what blocks. Metalink note Doc ID: 28814.1 has some good basic information on

RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments

Good one for the don't list. I suppose that the ARCHIVELOG mode question depends on the situation, but for the most part I think ARCHIVELOG mode in production is a good do... Granted, if you don't have changes, then as long as you can stand the outage, then you can do cold backups. :-) RF

Re: SqlNet Response ports

Redhat Linux 7.2 At 07:28 PM 2/21/2003 -0800, you wrote: What platform is this? Windows? Don Granaman OraSaurus - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 21, 2003 5:48 PM Hi listers, Here is a question my client asked me,

Re: corrupted block

Thanks Kirti. Interesting, dba_extents doesn't return rows for block_id=57856. However, export to /dev/null does report the corruption. Does this indicate disk or memory corruption? Deshpande, Kirti wrote: Suzy, Just more questions: Are your sure that this corruption has made it to the

RE: Using fully qualified table_name.database_object in application code?

One possibledisadvantage is thatyour apps are then 'tied' to a particular schema... if you wanted to run them against another schema, you would have to go back and modify everything... To get around this: You could create public synonyms pointingto aparticular

RE: How long to hold onto old Oracle CDs?

Title: RE: How long to hold onto old Oracle CDs? Two months ago, I tried to order older non-supported CDs (7.3, 8.0.5, 8.0.6) and they told me they could not ship them. How did you order them? Matt Adams - GE Appliances - [EMAIL PROTECTED] We have enough youth. How about a fountain

RE: Top 10 normalised down to Top 2

I bow at the feet of the master. :-) Very good sir RF Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (It's everywhere that I am!) Author of several books you can find on Amazon.com! -Original Message- Sent: Monday,

Re: Upgrading from 8.1.5 to 8.1.6

The best pratice is rename the old directory to a new name and wait to see if you have problem. joan Nelson, Allan wrote: It depends on whether or not you are talking about your old $ORACLE_HOME. You may still have shared lib dependancies there. You don't give enough information in your

Re: installation / recovery question

Antje, Have you ever completely removed Oracle from a Windoze machine and gone throught the consequent cleanup of the registry? If not, MetaLink document 124353.1 describes the process. There are many more entries for Oracle in the registry for than what you will see in HKLM\Oracle. I

Re: corrupted block

Suzy, The big question is whether or not the block actually contains data. It appears that it does not, if I am reading the last few lines correctly. This means you are in luck. Use a non-full table scan query to extract the data, drop the tablespace and remove the datafile. Recreate the

RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments

On a DSS the database is usually in maintenance mode for batch updates (usually Friday night). After the updates you can do a cold backup or full export before bringing the database on-line for regular users. The database would normally not have any other update activity. But in most instances

RE: sqlplus connect errors 1034/27101/svr4...

Hi Les, Check to see if you have enough semaphores available (/etc/system) for the cumulative number of PROCESSES for all your db's on the server. - Jerry -Original Message- Sent: Sunday, February 23, 2003 9:09 AM To: Multiple recipients of list ORACLE-L Looked over some websites and

RE: security alerts #48, 49, 50, 51 - patchsets, 9i

Title: RE: security alerts #48, 49, 50, 51 - patchsets, 9i Guys, Have some complicated 3rd party software and a number of databases all within firewalls. I am considering (since plans in w9orks for migration to 9i latest release) to wait on applying the patches until after the 9i migration.

  1   2   3   >