Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> Db hang-up whlie create table with sub-query.
Aqeel
post Jan 8 2008, 06:08 AM
Post #1


Newbie
*

Group: Members
Posts: 5
Joined: 2-September 07
Member No.: 11,668



Hi,

We have a Oracle 9.2.0 db server on AIX 5.2.

User nbill has been assinged dba role.

while i am login with nbill user, i can create table and also select data from another schema like:
select *from ncash.country_code; //country_code is a view in ncash schema

but if i try to create a table like:
create table tab-name as
select*from ncash.country_code;
db hangs-up for unlimited time.

I will appreciate if anyone can help me.

Thanks allot

-Aqeel Anwar
Go to the top of the page
 
+Quote Post
dave
post Jan 8 2008, 06:16 AM
Post #2


Advanced Member
***

Group: Members
Posts: 5,207
Joined: 8-October 04
Member No.: 785



how do you know its hanging and not actually just doing its work
Go to the top of the page
 
+Quote Post
Aqeel
post Jan 8 2008, 06:46 AM
Post #3


Newbie
*

Group: Members
Posts: 5
Joined: 2-September 07
Member No.: 11,668



QUOTE (dave @ Jan 8 2008, 11:17 AM) *
how do you know its hanging and not actually just doing its work



May be you are right, but this query never returned any result after waiting a long time, while underlying table has only 377 records.

Further more, this view selects rows from a database on remote site, connected on E3 lines. I monitored network it looks fine.

Can you please suggest some ways to find where the problem is ???
Go to the top of the page
 
+Quote Post
burleson
post Jan 8 2008, 06:58 AM
Post #4


Advanced Member
***

Group: Members
Posts: 11,715
Joined: 26-January 04
Member No.: 13



Hi,

Here is a script to detect the causes of hanging:

http://www.dba-oracle.com/oracle_tips_top_session.htm

It's also common to see hanging on TEMP space usage:

http://www.dba-oracle.com/t_hanging_temp_usage.htm


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 25th November 2014 - 10:59 PM