Visit Our UNIX and Linux User Community

Oracle-performance tuning

Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Oracle-performance tuning
# 1  
Old 12-06-2005
Oracle-performance tuning

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?
# 2  
Old 12-06-2005
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
# 3  
Old 12-06-2005
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:
# 4  
Old 12-06-2005
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
# 5  
Old 12-06-2005
try this is not really an Oracle forum and I haven't played DBA for years.
# 6  
Old 12-07-2005
Has the table been analysed lately ???
# 7  
Old 12-07-2005
Tried Analysing,session is getting expired as the table size is around 200 million

Previous Thread | Next Thread
Test Your Knowledge in Computers #167
Difficulty: Easy
The Transmission Control Protocol (TCP) is one of the least used protocols of the Internet protocol suite.
True or False?

8 More Discussions You Might Find Interesting

1. Tips and Tutorials

The Most Incomplete Guide to Performance Tuning

Overview: Introduction What Does Success Mean? What Does Performance Mean? Every Picture is Worth a Thousand Words Work Like a Physicist Work Like You Walk - One Step at a Time Learn to Know Your System Choose Your Weapons! Tools of the Trade 1 - vmstat A Little Theory Along the Way -... (1 Reply)
Discussion started by: bakunin
1 Replies

2. Solaris

Solaris Performance tuning

Dear all, I have a Local zone , where users feel that performance is not good. Is it wise to collect the inputs from the local zone rather than taking from the global zone. And also Can I tune from Global zone , so that it will reflect in local zone. Rgds rj (2 Replies)
Discussion started by: jegaraman
2 Replies

3. AIX

Performance issue / tuning advice

Please take a look at this system and give your analysis / advice. Can it be tuned to get a better performance? We are not getting more hardware ressources at the moment. We have to live with what we have. Application running on the system is SAS. OS is AIX 6.1 Let me know if you need output of... (7 Replies)
Discussion started by: firefox111
7 Replies

4. UNIX for Advanced & Expert Users

Performance diagnosis & tuning

Hi, I am facing a strange issue. Application is deployed in a cluster with 2 Unix nodes (with same configuration). On one node the application is working fine but on another node we see this behavior I found using vmstat- when the server is not yet started everything is OK; when you start the... (3 Replies)
Discussion started by: ash.abrol
3 Replies

5. Shell Programming and Scripting

Performance Tuning

Hi All, In last one week, i have posted many questions in this portal. At last i am succeeded to make my 1st unix script. following are 2 points where my script is taking tooooo long. 1. Print the total number of records excluding header & footer. I have found that awk 'END{print NR -... (2 Replies)
Discussion started by: Amit.Sagpariya
2 Replies

6. UNIX for Dummies Questions & Answers

Performance Tuning

Hi to all, I'm interested in finding an introduction about Performance Tuning under Unix (or Linux); can somebody please point me in the right direction? Best regards (1 Reply)
Discussion started by: domyalex
1 Replies

7. Filesystems, Disks and Memory

EXT3 Performance tuning

Hi all, long time ago I posted something, but now, it is needed again :( Currently, I am handling with a big NFS Server for more than 200 clients, this sever has to work with 256 NFSDs. Because of this huge amount of NFSDs, there are thousands of small write accesses down to the disk and... (3 Replies)
Discussion started by: malcom
3 Replies

8. UNIX for Dummies Questions & Answers

Performance tuning.

can someone tell me a good site to go to in order to learn this. please do not recommen nay books because i dont have interest in that. if you know of any good sites with good straight forward explanation on how to split loads on machines that has excessive loading, please let me know Also,... (1 Reply)
Discussion started by: TRUEST
1 Replies

Featured Tech Videos