[no subject]

hi, Anybodygot some oracle question dumps or resources for oracle certified internet database administrator exam ?? (exam #1Z0 -411). Thanks in advance :) rgds sunil

Re: snapshot too old

Seema Singh wrote: Hi At time of export i am getting following error EXP-8: ORACLE error 1555 encountered ORA-01555: snapshot too old: rollback segment number 6 with name R03 too small Please suggest Thanks -Seema Mladen, any idea ? -- Regards, Stephane Faroult Oriole Ltd --

RE: Raw I/O

Thanks Martin I guess that's what we need... Witold On 16 Jan 2002 at 12:15, Martin Kendall wrote: Hey now, be nice :-). The best thing is to point people towards the archives. Martin http://oracle-rescue.com -Original Message- Mladen Sent: 16 January 2002 19:57 To:

[Q] can ORACLE FORMS 2.1 and 6i run under same NT computer?

Has anyone installed and run ORACLE FORMS 2.1 and 6i run time version under same NT compter? Will any problem happen? Thanks. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official

Standby Instance questions and HA

Hi, I was reading in the book Oracle 24/7 Tips and Techniques about Standby Instances. Note, this is not a standby database. From the book it seams to work in the following way... There is only one database. The database files exist on a shared disk pack. One machine is the primary instance,

RE: Disaster recovery using RMAN

Sona - I am planning to test a disaster recovery using RMAN also. My company won't completely trust it until I can. Like you, I currently use RMAN to back up to disk, and write the backup to tape, keeping a Level 0 backup on disk. Here are the steps I am planning for disaster recovery. 1.

Re:[Q] can ORACLE FORMS 2.1 and 6i run under same NT compute

If I remember right forms 2.1 depends on SQL*Net V1 which is not supported on NT. Should break. Dick Goulet Reply Separator Author: dist cash [EMAIL PROTECTED] Date: 1/17/2002 4:55 AM Has anyone installed and run ORACLE FORMS 2.1 and 6i run time

RE: Using RMAN

Soma - RMAN will only know about the disk backup since you aren't using a media manager like Legato or Veritas. When it needs to recover, RMAN will look to that spot on the disk and expect the correct file to be there. If for some reason the version on disk is unusable and RMAN needs an older

RE: Raw I/O

also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

RE: Database Views

Hello Srini We had a case like this where one of the tables was in a database that reside in a remote site. Our solution was to create a table that combine employees tables from 2 site into one TABLE in the local site. This way the select and join is done ONCE at night. Yechiel Adar, Mehish

Re: Using RMAN

If you are using a recovery catalog then rman keeps track of everything there. He knows if you've been naughty, he know if you've been nice, he knowsOOOPS I got carried away. But when you do a restore using rman he will tell you what backup sets you will need. Ruth - Original Message

Re: index hint

Jeroen, You need to reference the table in the hint with the alias that you gave it in the from clause (oa), then the hint should work. Jeroen van Sluisdam wrote: -Oorspronkelijk bericht- Van: Jeroen van Sluisdam Verzonden:donderdag 17 januari 2002 14:40 Aan: '[EMAIL

RE: Oracle 8.1.7 install error

Hello Ron I usually get this error when some other service is still using the DLL. I then start to stop all the services that I think use Oracle and hit retry. If still in error I just starting to stop all services on the machine, and hitting retry after stopping two or three services. At the

Re: index hint

Refer to aliases (in that case 'oa'), not tablenames, in hints. Jeroen van Sluisdam wrote: -Oorspronkelijk bericht- Van: Jeroen van Sluisdam Verzonden:donderdag 17 januari 2002 14:40 Aan: '[EMAIL PROTECTED]' Onderwerp:index hint Hi, I'm on Oracle 7.3.4 HP-UX

Re: index hint

change the hint to /*+ INDEX(oa I_OPTION_ALLOTMENTS_2) */ if the statement uses an alias for a table, then the hint must use the alias too hth, Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences

RE: Partitions

Having said all that, I suggest that you keep the statistics on these partitions up to date to help the optimizer... Of course, if data in some of the partitions become static, there is no need to analyze those partitions. - Kirti -Original Message- Sent: Thursday, January 17, 2002

Re: Partitions

Hamid, Partitions are basically for the use of Oracle. It allows you to break apart a large table into several smaller sections to help in the management of the table data and to help Oracle find the data you requested. Under ideal conditions, Oracle will only select the smallest area to search

RE: OT -: SQL BackTrack info

Has anybody did tests for Sqlbacktrack Vs Oracle rman? Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Valuthur, Srikanth [SMTP:[EMAIL PROTECTED]] Sent: Wed, January 16, 2002 10:40 PM To: Multiple recipients of list ORACLE-L Subject: RE: OT

RE: Database Views

that works as long as you can live with possibly inconsistent data in the joint table due to either 1) updates to the employee data on either site during the day not reflected in the joint table until the nightly processing is done 2) nightly process failing and data in the joint table either

RE: Which Character set?

Hey Ron, Here's that whitepaper I had mentioned on the list... Why We Are Moving Our Databases to the UTF8 Character Set by David F. Pennington, GlaxoSmithKline HTH Chris PS. For everyone else, you can find the whitepaper using Google, or email me direct. -Original Message- Sent:

RE: How to calculate user load on the system

Raj, Maybe another option would be to audit session for the database. For each logon/logoff you would see the logical/physical reads and the logical writes ( in dba_audit_session) by Oracle username (or osusername). Chaim Aponte, Tony [EMAIL PROTECTED]@fatcity.com on 01/16/2002 06:15:24 PM

RE: Raw I/O

I have been searching for the same answers for a long time and have downloaded a lot of papers on the raw vs cooked and to get definitive answers is a complicated task. Simple methods and opinions and examples will go a long way in the understanding of a controversial and complicated subject.

Re: RMAN backup and restore Q?

Hi My problem went away when I did a startup mount of the database. I have Rman user in TEST2 just for testing purposes (same username password on target catalog is easier with ctrl C ctrl V) One more question if I may. Do you or anybody else have an example of a very complex rman

Re: index hint

Try to use table alias in your hint instead of table name. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 17, 2002 8:45 AM -Oorspronkelijk bericht- Van: Jeroen van Sluisdam

RE: OT -: SQL BackTrack info

We must have been lucky because BMC support really saved our butt a few months back when we got a copy of LOGMASTER to recover some data from some archived redo logs (long story). We were really impressed with their support and everyone within our group commented on how helpful and knowledgeable

Re: Standby Instance questions and HA

What you are describing sounds like Oracle FailSafe. It is free from Oracle, does not require Oracle Enterprise version (Standard/workgroup can be used), only runs on NT, and requires MicroSoft Cluster Services (MSCS) which is included in NT4.0 EE or W2K Advanced Server. As for Sun Solaris, I

RE: Standby Instance questions and HA

I think your right. But does anyone know what is use on Solaris? Thanks, Jim -Original Message- Sent: 17 January 2002 15:00 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] What you are describing sounds like Oracle FailSafe. It is free from Oracle, does not require Oracle Enterprise

Session info

Hi Listers, We can find the program executed from Client in 'program' field in v$session. But the problem is the field length just 48 character. Is there any other dictionary (v$ or x$ ?) to find 'the client program' completely (more than 48 character) ? Thanks. Aldi

Oracle8i and the Jserv demos

Hi I have installed Oracle 8.1.7.0 on an AIX 4.3 box and the Jserv demos do not work. I looked at the jserv.log and it seems to not be finding the java executables. I downloaded Java.rte for AIX from IBM and put it in the $ORACLE_HOME/Apache/jdk/bin directory but it still doesn't work. I am not

Re: [Q] can ORACLE FORMS 2.1 and 6i run under same NT computer?

The only way this could work is to have a separate Oracle home for the Forms 2.1, with the appropriate binaries. And since this is a very old version of Oracle, you would need another box to put it on. And then it still might not work. Jared On Thursday 17 January 2002 04:55, dist cash

RE: SQL Loader Direct Load - Problem with Index Rebuild

Hello Jay Here is a little script that will generate the commands needed to rebuild the indexes: spool rebuild.sql select distinct 'alter table '||table_name||' modify partition '||p.partition_name||' rebuild unusable local indexes;' from user_ind_partitions p, user_TAB_PARTITIONS t where

Re: Database Views

This is why data marts were created. You would be much better off to create a reporting database based on the data you need to see. You won't be happy doing this with views from several databases. It won't perform well. As Rachel pointed out it will be inconsistent. At the very least you

RE: Database Views

Hello Rachel 1) Yes. You can also change your application to update the new table whenever something change in one of the file. Since personal do not change every day (hopefully) one day lag is OK for us. 2) This is done with SQL program that do delete and then insert and commit.

RE: Standby Instance questions and HA

Check the Sun web site. Sun has clustering. I do not know the name of the product off the top of my head since I use HP MC/ServiceGuard. -Original Message- McCann Sent: Thursday, January 17, 2002 7:06 AM To: Multiple recipients of list ORACLE-L I think your right. But does anyone

RE: Database Views

Thank you all for your opinions. The tables that I want to consolidate are 15 Million rows each. So five tables put together will constitute 75 million rows in one table. I will have to consider partitioning after that for optimum performance. Also Materialized view would take a long time to

RE: Standby Instance questions and HA

Full Moon. (it's going through stages, waxing. give me a break.) Supposedly they named it that because wolves howl at the moon. Get it? Wolfpack is microsoft's clustering moniker. Give me another break. Doesn't Scott McNealy have a jacuzzi at home he can spend time in?) -Original

RE: Session info

I just did describe v$session and the program field is 64 bytes long. Maybe you are using a tool that limits the value to 48 bytes. Oracle 8.1.6 on NT. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Aldi Barco [SMTP:[EMAIL PROTECTED]] Sent: Thu,

RE: Standby Instance questions and HA

Veritas also has a product that will do this for you... -Original Message- Sent: Thursday, January 17, 2002 10:46 AM To: Multiple recipients of list ORACLE-L Check the Sun web site. Sun has clustering. I do not know the name of the product off the top of my head since I use HP

RE: snapshot too old

Stephane... You're mean... :-) -Original Message- Sent: Thursday, January 17, 2002 6:25 AM To: Multiple recipients of list ORACLE-L Seema Singh wrote: Hi At time of export i am getting following error EXP-8: ORACLE error 1555 encountered ORA-01555: snapshot too old:

RE: procedure error

Hello Lance This one works: CREATE OR REPLACE PROCEDURE Primus_Report AS begin execute immediate 'Drop Table PRIMUS_TEMP_DUMP'; execute immediate 'CREATE TABLE PRIMUS_TEMP_DUMP (SOLUTION_ID VARCHAR2 (85) NOT NULL) TITLEVARCHAR2 (3498)), OWNERVARCHAR2

RE: Standby Instance questions and HA

I concur with BB.yea, I ran Sun cluster at deleted and it broke ALOT. Kept me and two full time Sun Engineers (they got paid ALOT more) in consulting dollars, but i made a mental note not to use it in my business. Caveat: this was 1.5 years ago. Things change. Mit Gluck, mein

RE: snapshot too old

Oh, no! Not Gogala M Laden! -Original Message- Stephane... You're mean... :-) -Original Message- Sent: Thursday, January 17, 2002 6:25 AM To: Multiple recipients of list ORACLE-L Seema Singh wrote: Hi At time of export i am getting following error EXP-8: ORACLE

RE: Partitions

Thanks Ron, So it's better I put partitions in deffrent tablespace and also for better performance in diffrent physical disks, it will helps. I am going to do the partition on Creation date or on Primary Key(PK is a sequence number), don't know can we use PK as a range for partitioning or not?

RE: Standby Instance questions and HA

We have this in place on Sun as well. It is similar to a cluster in that it has a separate box (Ultra 2) monitoring a heartbeat between both database servers. You will have a significant impact during failover. All drives common to both boxes will be unmounted on the primary and remounted on

Re: Standby Instance questions and HA

It's not an Oracle thing, so there wouldn't be anything in the docs yes, you need a clustered environment, or at the least the ability for the disks to be mounted on the second server when the first one goes down. As long as the disk that oracle has been installed on is one of the ones that

RE: Standby Instance questions and HA

Thanks for the advice everyone. So what do you recommend on a Sun cluster/machines for failover other than OPS? Quest Shareplex? Standby database? Any others? Thanks, Jim -Original Message- Sent: 17 January 2002 16:22 To: Multiple recipients of list ORACLE-L I concur with

Re: Maximum number of redo log members

I got this query from the list. I can try it. JOan select decode (indx, 3,'MAXLOGFILES',4,'MAXDATAFILES',2,'MAXINSTANCES',9,'MAXLOGHISTORY ') , rsnum from x$kccrs where indx in (3,4,2,9) union all select 'MAXLOGMEMBERS ',dimlm from x$kccdi / Rachel Carmichael wrote: I believe that

RE: Session info

I did that from sqlplus. In 816 Linux that is varchar2(48). The output is truncated so I don't know the name of the application from the client (it just showing C:\WINNT\Profiles\AldiTest\NewApplication\Sales\D). Aldi -Original Message- Sent: Thursday, January 17, 2002 10:07 AM To:

RE: Standby Instance questions and HA

we had it with FirstWatch from Veritas on top -- sometimes disks didn't get dismounted from the first server, or remounted on the second one.. then we had database failures --- Baker, Barbara [EMAIL PROTECTED] wrote: Jim: Sorry, you're not gonna like this answer. HA is a Sun product, not

RE: snapshot too old

There are several ideas, but I'm working on my charming and likable personality. I must do something before the duhveleopers organize a lynch mob and burn me at stake. -Original Message- Sent: Thursday, January 17, 2002 11:11 AM To: Multiple recipients of list ORACLE-L Stephane...

RE: snapshot too old

Don't be afraid. I'm not hungry today. -Original Message- Sent: Thursday, January 17, 2002 11:31 AM To: Multiple recipients of list ORACLE-L Oh, no! Not Gogala M Laden! -Original Message- Stephane... You're mean... :-) -Original Message- Sent: Thursday, January

RE: Disaster recovery using RMAN

Dennis, I hope you can clarify something in your plan for me. Why are you backing up to disk? By doing so, you are losing one of the chief benefits of RMAN. RMAN keeps a catalog of the tapes and knows which tapes to request to restore a backup, and which files to retrieve from those tapes.

used segment space in bytes

Title: Dieter Oberkofler Stationery hi guys! what would be the easiest way to compute the space in bytes used by a segment? it is rather easy to determine the # of used blocks by a specific segment by looking at the dba_extents for example. but how many blocks have been really used in one

RE: OT -: SQL BackTrack info

I'm glad to hear your success story with support on SQL*Backtrack, bacause it is a very good product, usually. A year ago the support was *very* bad. Maybe they got the message and got some people trained on the product. Jared

RE: Standby Instance questions and HA

IBM HACMP works well. Ooops. guess that means you'll have to change some things. ;-) Seriously, we *did* get the Sun clustering working, but it required some serious feet-to-fire holding and gyrations. -Original Message- Sent: Thursday, January 17, 2002 11:54 AM To: Multiple

RE: USER DUMP HOW?

yes, you can use TOAD or SQL*NAVIGATOR for that. Or you can write your own scripts, I have found this one between my scripts, I have never tested, I prefer to use Import/Export for that kind of job. HTH DC - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL

Partitioning and tkprof

All, Could of any of you ladies and gents take a peek at this and give me idea of what the explain planis getting at ?? Rows Execution Plan--- --- 0 SELECT STATEMENT GOAL: CHOOSE 0 PARTITION (CONCATENATED) 0 TABLE ACCESS GOAL:

Oracle Financials DBA with 11i Needed in Tampa, Florida area..

Come work for a great company in the Tampa Florida area (Clearwater) that needs an Oracle Financials DBA to join it's I.T. Team. You will work with Oracle Applications and must have experience with 11i and Excellent communications skills. Looking for someone with very solid hands-on experience.

Backup Strategy

Hi List, I have a white paper for Backup Strategy on Microsoft NT but I am looking for Backup Strategy for Oracle8i on Solaris, If anybody have any doc or link I realy appreciate. Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any

Re: Using RMAN

See currently we are using Unix scripts to do our hot backups .We take the backup on disk and everynight after the disk backup we copy the backup on tape using Veritas Net Backup. Presently we keep 2 days worth of backups on the disk and 3 days of archive logs.That means at any point in time i

RE: DBA Experiences with Oracle and RAID 0+1

Mogens: Just let me disagree with you at only one point. According to my experience, I think that the size of the disks in an array does matter sometimes. It's not the same to have 24 9GB disks that to have only 3 of 73GB. You have 24 spindles againts 3, the first option (in a well configured

Re: Disaster recovery using RMAN

Dennis, Could you please share your regular backup strategies with me for me to understand this better? Thanks - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 17, 2002 9:00 AM Dennis, I hope you can clarify something in your

RE: Session info

Maybe it has something to do with the client. I just did the same (ora81634 on NT) and the program contain only the program name, not the whole path. Our clients are sqlnet that came with 734 or 816. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From:

RE: Raw I/O

I had responded to Witold privately but it seems that people want more so here goes: We went raw with our production billing system a few months ago because the vendor told damagement that it would be faster. We also converted our failover and testing environments because we do some

RE: Freeable memory

Hi Michael: Why don't you use this Steve Adams' script to check the fragmentation of your shared pool, it may be badly fragmented and this problem could generate a lot of pressure at the shared pool latch. And this situation can also generate contention at a lower level latch (like the

Re: USER DUMP HOW?

Hi Diego Or you can write your own scripts, I have found this one between my scripts, I have never tested, I prefer to use Import/Export for that kind of job. The easy way to do this is to get the Freeware DBATool. It will read an export file (created ROWS=N) and present you with the DDL

Import taking up too much room with local managed tablespace

Title: Import taking up too much room with local managed tablespace Hi, I created a tablespaces in a test database to be locally managed with an extent size of 20544K. A normal database import usually will fill a datafile with 5.8GB of data (on a dictionary managed tblspace) but with the

RE: used segment space in bytes

Title: Dieter Oberkofler Stationery What about dba_segments? -Original Message-From: Oberkofler, Dieter [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 17, 2002 12:12 PMTo: Multiple recipients of list ORACLE-LSubject: used segment space in bytes hi guys! what would

8.0.5 to 8.1.7 migration problem

Evening gang; Why would the Oracle Database Migration Assistant (odma) be telling me that I am migrating a database from 8.1.5 to 8.1.7 when it is actually only a version 8.0.5 database ?? Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange

Re: Oracle 8.1.7 install error

And always shutdown Antivirus-Clients. Günter Seefelt, Beth wrote: I get a lot of those when installing on NT. I usually go into explorer, rename the existing file to .old and hit Retry and the install continues on. Sometimes that won't work if the file is truly locked by another

UNION

Hi, I try to use union and order by first column of first select statment and also first column of second select statment but get error, Any Idea how to do this?? SELECT A,B,C FROM TABLEABC UNION SELECT D,E,F FROM TABLEDEF ORDER BY A,D Hamid Alavi Office 818 737-0526 Cell818 402-1987

RE: used segment space in bytes

Title: Dieter Oberkofler Stationery Hi Dieter: As you've said, you can use dbms_space for this job. This package tells you how many blocks has the object and where's the HWM. And if you use the dbms_space.free_blocks() procedure, it will also report how many blocks below the HWM are in the

RE: Standby Instance questions and HA

I also heard of horror stories regarding Sun Clusters. I worked w/ HP MC Service guard, good product. Now working w/ IBM HACMP, also good product, although more complicated to set up (but then again I am not a IBM'er). IBM tends to do everything their way ;). In the future when I upgrade

RE: UNION

In the order by section use the relative column numbers. Plus, you can not individually order by a single column from each union. Its a comprehensive sort of the entire column. SELECT A,B,C FROM TABLEABC UNION SELECT D,E,F FROM TABLEDEF ORDER BY 1 -Original Message- Sent: Thursday,

RE: UNION

select * from ( SELECT A,B,C FROM TABLEABC UNION SELECT D,E,F FROM TABLEDEF) x ORDER BY A,D -Original Message- From: Hamid Alavi [SMTP:[EMAIL PROTECTED]] Sent: Thursday, January 17, 2002 12:31 PM To: Multiple recipients of list ORACLE-L

RE: UNION

Hamid, Look in the Sql manual. For UNION clauses, you must ORDER BY the item number: SELECT A,B,C FROM TABLEABC UNION SELECT D,E,F FROM TABLEDEF ORDER BY 1 = lookee here hope this helps Tom Mercadante Oracle Certified Professional -Original

RE: UNION

You have to use ORDER BY column position as in SELECT A,B,C FROM TABLEABC UNION SELECT D,E,F FROM TABLEDEF ORDER BY 1 HTH Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here

Re: UNION

Hamid Alavi wrote: Hi, I try to use union and order by first column of first select statment and also first column of second select statment but get error, Any Idea how to do this?? SELECT A,B,C FROM TABLEABC UNION SELECT D,E,F FROM TABLEDEF ORDER BY A,D Hamid Alavi Office 818

Checkpoint Redo ratio(High)

Hi I checked my database and see redo ratio is high. I ran the folling query select (req.value * 5000) / entries.value Redo Ratio from v$sysstat req, v$sysstat entries where req.name = 'redo log space requests' and entries.name = 'redo entries'; But the background checkpoints completed

Re: UNION

- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 17, 2002 20:31 SELECT A,B,C FROM TABLEABC UNION SELECT D,E,F FROM TABLEDEF ORDER BY A,D SELECT A as ord_col,B,C FROM TABLEABC UNION SELECT D as ord_col,E,F FROM TABLEDEF

RE: UNION

Did a little testing. I think that the columns names are decided by the first select only. The union adds the rows from the second select to the result set created by the first select. That's mean that your columns are a , b , c. So order by 'a' will work. It did in my test. Yechiel Adar,

Re: Using RMAN

I have gone through this process. We used to backup to disk using scripts as described in Velpuri's book. We now use RMAN to backup to disk. Your backups will be faster and smaller in size, because RMAN will skip unused blocks and it also allows you to specify mutilple channels. I can

Re: UNION

SELECT A,B,C FROM TABLEABC UNION SELECT D,E,F FROM TABLEDEF ORDER BY 1 Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 17, 2002 1:31 PM Hi, I try to use union and order by first column

Re: UNION

Use ORDER BY 1 (ie, the first column) At 10:31 AM 1/17/02 -0800, you wrote: Hi, I try to use union and order by first column of first select statment and also first column of second select statment but get error, Any Idea how to do this?? SELECT A,B,C FROM TABLEABC UNION SELECT D,E,F FROM

Re: Using RMAN

We use rman to backup all of our databases. But most importantly, we use it for production. Production databases are in archivelog mode. We do a level 1 backup at the end of the work day and prior to nitely batch processing. We do a level 0 backup early in the morning after batch and before

RE: Partitions

intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the

Re: Checkpoint Redo ratio(High)

Seema First remember the old rule : If it's not broken don't fix it. There is a rule of thumb that redo log switches should happened app. every 30 minutes, but if you se redo log switches happening more often at some times and nobody is complaining then just ignore the it. If you have a

Anybody in DOUG?

Anybody on this list in the Dallas Oracle Users Group? Just wondering if it is worth attending from your perspective. I am over at Park Central and I noticed the meetings are way over in Las Colinas area. In San Diego they were only a few doors down, hey but the houses are bigger... Thanks,

SPACE FREE HOW?

Hi I deleted millions of rows from diffrent tables and I have not seen any impact on database size.What I have to do to get that free space? Is it necessary to shutdown the database? Thx -Seema _ MSN Photos is the easiest way to

Re: Using RMAN

Ruth, I have a couple of questions 1. As I understand from your email ,you do incremental level 0 backups in the morning and level 1 backups in the evening and night everyday using RMAN...right. You mentioned that you also take the backups (i.e level 0 and 2 level 1's for a day )on tape every

RE: SPACE FREE HOW?

ALTER TABLE table DEALLOCATE UNUSED KEEP integer; the keep clause is optional. -sunil -Original Message- Sent: Thursday, January 17, 2002 2:58 PM To: Multiple recipients of list ORACLE-L Hi I deleted millions of rows from diffrent tables and I have not seen any impact on database

RE: SPACE FREE HOW?

Unfortunately, your space will remain the same because delete doesn't deallocate the free space allocated to the table whether you shut the database down or not. The ways to deallocate space would be to a) Rebuild the table in another tablespace with significantly reduced storage parameters

Re: SPACE FREE HOW?

Seema, The table has set it'd HWM where the old data resided. The easiest? method of recovering the space is to export the table and then truncate the table followed by importing the table data back into the table. The truncate function will remove all of the data and re-establish the size back

multiple extents are OK, dagnabbit!

Title: Message Hi there - I'm trying to convince a client that multiple extents for a table will not hurt their performance. It's a PeopleSoft app, and PeopleSoft is telling them that they need to reorg any object with greater than 10 extents (even indexes). This Oracle 8.1.6. I've

RE: multiple extents are OK, dagnabbit!

Title: Message Search Tom Kytes asktom.oracle.com and there is also paper athotsos.com. Also check out http://www.speakeasy.org/~jwilton/oracle/lots-of-extents.html. - Ethan -Original Message-From: Cunningham, Gerald [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 17, 2002 3:46

Re: Import taking up too much room with local managed tablespace

go to the following link and have a read of this, Your extent size is most likely way to big for the data you have http://otn.oracle.com/deploy/availability/pdf/defrag.pdf if it is for general testing and not much data you could use 128k extents for everything but if it is for a

Re: multiple extents are OK, dagnabbit!

Here's my swing at it: http://www.speakeasy.org/~jwilton/oracle/lots-of-extents.html -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Thu, 17 Jan 2002, Cunningham, Gerald wrote: I'm trying to convince a client that multiple extents for a table will not hurt their performance. It's a

RE: multiple extents are OK, dagnabbit!

Title: Message Jerry, If they want to pay you to reduce their extents, then let 'em! ;-) "A fool and his money are soon parted." If they employ youand want you to work weekends on this, then it's worth the effort to educate them. I'm surprised an official Oracle white paper didn't

RE: used segment space in bytes

Hi Do, Here is the breakup for a space usage for a segment: 1. Allocated size (use dba_segments) 2 Used Blocks in segments(use dba_tables.blocks) -- Truly Used ( ??) -- Free Blocks (??) 3. Unused Blocks (use dba_tables.empty_blocks) the caveat i guess is in step 2. The used block

smtp via PL/SQL

I am digging into the docs I can find on utl_smtp and utl_tcp, but I am really not finding much. I have Oracle's package reference docs, but that doesn't shed all that much light on the subject. I am pretty well a newbie to tcp and smtp. Geeze all that talking and no question yet. Can anyone

  1   2   >