Re: SPACE FREE HOW?

If you deleted rows, you can't see space unless untill you reoraganize that objects..If you truncate you can see free space immediately!! >From: "Seema Singh" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: SPACE FREE HOW?

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 (8

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 t

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 ref

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 inf

RE: SPACE FREE HOW?

Deleting records from a table does not free up space in the database. Search for high water mark in the concepts manual and you should find an explanation of how this works. The statement below only frees up space above the high water mark on the table. You can... create table foo nologging as

RE: multiple extents are OK, dagnabbit!

Title: Message hit metalink...there are things there     -Original Message-From: Cunningham, Gerald [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 17, 2002 4:46 PMTo: Multiple recipients of list ORACLE-LSubject: multiple extents are OK, dagnabbit! Hi there -  

RE: multiple extents are OK, dagnabbit!

Title: Message Search Tom Kytes asktom.oracle.com and there is also paper at hotsos.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

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 productio

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 you and want you to work weekends on this, then it's worth the effort to educate them.  I'm surprised an official Oracle white paper did

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 r

RMAN-20202 error while recovery

Hi i am trying to recover the database from the loss of SYSTEM datafile. After mounting the database ,I tried recovery using RMAN RMAN> run 2> { 3> allocate channel c1 type disk ; 4> restore tablespace "system"; 5> recover tablespace "system"; 6> sql 'alter database open'; 7> release channel c1;

RE: Standby Instance questions and HA

I recommend HP. But that does not run on Sun to well:-) -Original Message- Sent: Thursday, January 17, 2002 9:12 AM To: Multiple recipients of list ORACLE-L IBM HACMP works well. Ooops. guess that means you'll have to change some things. ;-) Seriously, we *did* get the Sun "clusterin

RE: Disaster recovery using RMAN

Sona - Please keep in mind that we are RMAN novices at this stage. Of all the DBA duties, I feel that the ability to recover the data is the most important. I picked our smallest database to start getting some operational experience with. We still do weekly cold backups, writing

RE: Standby Instance questions and HA

You will always have the same issues with fail over technology. Your users will get disconnected. My databases take less then 5 minutes to fail over and that is an acceptable time frame to the client. Its great from my standpoint for maintenance cause I can do it on one node, fail the databases

RE: multiple extents are OK, dagnabbit!

Jerry - Maybe I'm missing something here. Since you refer to them as a "client", you must have a consulting relationship with them - right? So if you rebuild the tables, you get more money - right? So you rebuild the tables, the client is happy, and you are a little wealthier - right? Or maybe you

RE: Backup Strategy

Hamid - You might consider buying the book "Oracle8i Backup and Recovery" by Rama Velpuri, George Williams, Anand Adkoli. It is highly recommended by everyone, myself included. I believe that it will help you design a backup strategy that works for your system. A backup strategy will vary widely,

RE: [resend] multiple extents are OK,

- Forwarded by CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group on 18/01/2002 11:36 AM - CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group18/01/2002 11:21 AM Jerry, Multiple extents is not a problem, true. But you could put in some "consulting" effort to resize the extents --- recreate

RE: RMAN-20202 error while recovery

Sona, Try it without the quotes (""). Example: { ... allocate channel t1 type disk; restore tablespace system; } Regards, Sujatha -Original Message- Sent: Friday, 18 January 2002 12:06 PM To: Multiple recipients of list ORACLE-L Hi i am trying to recover the database from the loss

Re[2]: UNION

If you do happen to need each part of the result set ordered individually, you can do something like the following: SELECT 1,A,B,C FROM TABLEABC UNION SELECT 2,D,E,F FROM TABLEDEF ORDER BY 1,2 Bizarre as it may seem, I've used this technique to good effect many times in the past. Basically, I on

Re: Lookup Table Usage

Try using V$DB_OBJECT_CACHE , I think it does exist in 7.3.4 Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd [EMAIL PROTECTED] 17/01/2002 07:07 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L

<    1   2