Alternatively the tables can also be analyzed by writing dynamic sql and
then running the spool file generated.


"Small things, done in great love, bring joy and peace."
-Mother Teresa
_________________________________
Manish kalra
Systems Executive
KPIT Cummins Infosystems ltd
35&36 , Rajiv Gandhi Infotech park,
Phase -1 , MIDC,
Hinjewadi , Pune - 411057
Phone - 020 - 56525000



-----Original Message-----
From: PremnathJ
[mailto:oracledba-ezmlmshield-x73802803.[Email address protected]
Sent: Sunday, August 31, 2003 3:47 PM
To: LazyDBA Discussion
Subject: Re: Parallelle processes....

to do this you need to first analyze all the tables with the help of the
dbms_stats package(check the name of the package for analzing) and then u
can take the count from the num_rows from the user_tables or dba_tables


----- Original Message -----
From: "rameshk" <oracledba-ezmlmshield-x48357959.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Wednesday, August 31, 2005 2:33 PM
Subject: RE: Parallelle processes....


>
> Hi ,
> Can any one tell me the way i can generate a simple report using SQL to
> get a list of all the tables having atleast one row in the database
> I want to pick up all these tables to avoid junk tables (with out any rows
> )in my database.
>
> K Ramesh Babu
> Tata Consultancy Services Limited
> Mailto: rameshk.[Email address protected]
> Website: http://www.tcs.com
>
>
>
> "Cardus Ian " <oracledba-ezmlmshield-x98904560.[Email address protected]
> 31/08/2005 13:51
>
> To
> "LazyDBA Discussion" <[Email address protected]
> cc
>
> Subject
> RE: Parallelle processes....
>
>
>
>
>
>
> Try the following
>
> SELECT 'ALTER TABLE ' || TABLE_NAME || ' PARALLEL 1;' FROM USER_TABLES
> WHERE DEGREE > 1;
>
> and then run the resultant ALTER TABLE statements.
>
> If this "parallelism" has appeared without you explicitly running ALTER
> TABLE...PARALLEL 8 (for example) then it may, I think, be because the
> table was created with a parallel query in a CTAS (CREATE TABLE ... AS
> SELECT) statement - the parallelism remains on the table and any
> subsequent queries will run as parallel queries unless you run the above
> ALTER statement.
>
>
>
> HTH
> Cardy
>
>
> -----Original Message-----
> From: Yves
> [mailto:oracledba-ezmlmshield-x82176730.[Email address protected]
> Sent: 30 August 2005 18:24
> To: LazyDBA Discussion
> Subject: Parallelle processes....
>
>
> Ever since we've moved to 10g, it seems that many queries are run in
> paralelle. When I do a 'top' on UNIX, I see about 12 processes like
> 'ora_p000_sid' to 'ora_p012_sid'.
>
> This seems to reduce the performance of some statements. What parameters
> should I change to limit the number of paralelle processes for each
> querie.
>
>
>
> Merci / Thanks
> Yves Leonard,
> Chef de Projet / Project Leader,
> DDS / SDD,
> RH Coats, 13-I
> Téléphone / phone : 613-951-3233,
> couriel / email : yves.[Email address protected]
>
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these terms:
> http://www.lazydba.com/legal.html
>
>
>
>
>
****************************************************************************
*
> This e-mail and its attachments are confidential and are intended for the
> above named recipient only. If this has come to you in error, please
> notify the sender immediately and delete this e-mail from your system. You
> must take no action based on this, nor must you copy or disclose it or any
> part of its contents to any person or organisation. Statements and
> opinions contained in this email may not necessarily represent those of
> Littlewoods Group Limited or its subsidiaries. Please note that e-mail
> communications may be monitored. The Registered Office of Littlewoods
> Group Limited and its subsidiaries is 100 Old Hall Street, Liverpool, L70
> 1AB. Registered number of Littlewoods Group Limited is 5059352.
>
****************************************************************************
*
>
>
>
>
> This message has been scanned for viruses by BlackSpider MailControl -
> www.blackspider.com
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these terms:
> http://www.lazydba.com/legal.html
>
>
> ForwardSourceID:NT000028C2
>
>
> Notice: The information contained in this e-mail message and/or
attachments to it may contain confidential or privileged information. If
you are not the intended recipient, any dissemination, use, review,
distribution, printing or copying of the information contained in this
e-mail message and/or attachments to it are strictly prohibited. If you
have received this communication in error, please notify us by reply e-mail
or telephone and immediately and permanently delete the message and any
attachments. Thank you
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
>
>




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page