OraFAQ Forum: Server Administration » problem in execution

Home » RDBMS Server » Server Administration » problem in execution

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

problem in execution [message #261549]

Thu, 23 August 2007 00:47

anamika_025
Messages: 81
Registered: July 2007
Location: Indore

Member

hello all,

i have a large database. problem is that here if i m executing then there is no show error and also database is not running.
what to do??

regards,
Anamika

Report message to a moderator

Re: problem in execution [message #261553 is a reply to message #261549]

Thu, 23 August 2007 00:54

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

What you execute?
What is the result of this query?

select open_mode from v$database;

Report message to a moderator

Re: problem in execution [message #261556 is a reply to message #261553]

Thu, 23 August 2007 00:58

anamika_025
Messages: 81
Registered: July 2007
Location: Indore

Member

11:22:02 SQL> select open_mode from v$database;

OPEN_MODE
----------
READ WRITE

but if i m execting select statement the database is not shown and oracle is also not given error.

if the database upload is less then the execetion is fine..if upload the database is more then the execution is not show the database or any errors.

Report message to a moderator

Re: problem in execution [message #261566 is a reply to message #261549]

Thu, 23 August 2007 01:14

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

It seems to be it is working ok. It may be a problem in the terminal from which you are executing command. If you use sql*plus check the settings on

Show Pause

Report message to a moderator

Re: problem in execution [message #261569 is a reply to message #261566]

Thu, 23 August 2007 01:17

anamika_025
Messages: 81
Registered: July 2007
Location: Indore

Member

nope i m not using SQL*PLUS

it is not working fine

if i m using select statement the data is not shown and not shown any error

Report message to a moderator

Re: problem in execution [message #261573 is a reply to message #261549]

Thu, 23 August 2007 01:21

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

By it I mean database not about client tools.

Use "show pause" and whats the result of it. Ensure that you set it off.

set pause off

Report message to a moderator

Re: problem in execution [message #261577 is a reply to message #261573]

Thu, 23 August 2007 01:28

anamika_025
Messages: 81
Registered: July 2007
Location: Indore

Member

it is not here...
it is some another place...

Report message to a moderator

Re: problem in execution [message #261892 is a reply to message #261577]

Thu, 23 August 2007 23:58

anamika_025
Messages: 81
Registered: July 2007
Location: Indore

Member

when was my execution is not terminate.so my collegaue restart a computer after that database execute fine.
how to solve this problem?

Report message to a moderator

Previous Topic:	Create a new oracle home
Next Topic:	Session increase

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 18:48:36 CDT 2024