The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
Oracle-performance tuning Oracle-performance tuning
Google UNIX.COM
Forums Portal Register Forum Rules FAQContribute Members List Arcade Search Today's Posts Mark Forums Read


Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts here.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
SCO unix server performance tuning forumuser7 SCO 0 03-22-2006 08:04 AM
Performance Tuning domyalex UNIX for Dummies Questions & Answers 1 07-15-2005 07:55 AM
EXT3 Performance tuning malcom Filesystems, Disks and Memory 3 06-14-2005 08:27 PM
Performance tuning. TRUEST UNIX for Dummies Questions & Answers 1 03-21-2003 11:50 AM
oracle performance on solaris 8 niasdad UNIX Desktop for Dummies Questions & Answers 3 11-03-2002 09:08 AM

Reply
Page 1 of 2 1 2 >
 
Submit Tools LinkBack Thread Tools Search this Thread Display Modes
  #1  
Old 12-06-2005
Registered User
  

Join Date: Nov 2005
Posts: 7
Oracle-performance tuning
Sorry,
This is out of scope of this group.But I require the clarification pretty urgently.

My Oracle database is parallely enabled.

Still,in a particular table queries do not work "parallely" always.

How is this?
Reply With Quote
Forum Sponsor
  #2  
Old 12-06-2005
Just Ice's Avatar
Lights on, brain off.
  

Join Date: Mar 2005
Location: in front of my computer
Posts: 629
since i don't do oracle --- i suggest you check here to see if it helps or Google it for more info if nobody gets back to you with the correct answer
Reply With Quote
  #3  
Old 12-06-2005
...@...
  

Join Date: Feb 2004
Location: NM
Posts: 4,298
Do you know about the /*+ parallel */ hint?

If you want to see what the query is doing, try EXPLAIN PLAN or use tkprof on a session with ALTER SESSION SET SQLTRACE TRUE;

For small tables joined against larger tables, parallel may not be part of the the possible optimizer choices.

Read Tom Kite's: 'Expert One on One ORACLE' or visit his website:

http://asktom.oracle.com/pls/ask
Reply With Quote
  #4  
Old 12-06-2005
Registered User
  

Join Date: Nov 2005
Posts: 7
Thanks Folks for your suggestions,

The trouble is the same table is running parallely when partitioned on a key.

It does not when run as a whole table
Reply With Quote
  #5  
Old 12-06-2005
...@...
  

Join Date: Feb 2004
Location: NM
Posts: 4,298
try www.orafaq.org this is not really an Oracle forum and I haven't played DBA for years.
Reply With Quote
  #6  
Old 12-07-2005
Registered User
  

Join Date: Dec 2005
Posts: 33
Has the table been analysed lately ???
Reply With Quote
  #7  
Old 12-07-2005
Registered User
  

Join Date: Nov 2005
Posts: 7
Tried Analysing,session is getting expired as the table size is around 200 million
Reply With Quote
Google The UNIX and Linux Forums
Reply
Page 1 of 2 1 2 >

« Splitting a file based on some condition and naming them | To What files root does not have access to?? »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode




All times are GMT -7. The time now is 12:00 AM.

The UNIX and Linux Forums RSS Feeds - Contact Us - The UNIX and Linux Forums - Archive - Top

Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited.
The UNIX and Linux Forums Content Copyright ©1993-2008. All Rights Reserved.Ad Management by RedTyger Visit The Complex Event Processing Blog

Content Relevant URLs by vBSEO 3.2.0