Home » RDBMS Server » Server Administration » Reading from a control file
Reading from a control file [message #240119] Thu, 24 May 2007 03:05 Go to next message
orafacjublu
Messages: 95
Registered: May 2006
Location: KOLKATA
Member
Can anyone tell me is there any way by which one can see values stored within a control file
Re: Reading from a control file [message #240125 is a reply to message #240119] Thu, 24 May 2007 03:35 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Can anyone tell me is there any way by which one can see values stored within a control file
Yes or no.
if YES when you create text control file
alter database backup controlfile to trace;
check UDUMP FOLDER and open in text editor.


if NO when your control file is binary
alter database backup controlfile to 'c:\test.ctl';

Note: database controlfile (which currently using) is binary format so please first you have to create text format control file and read.

Regards
Taj

Re: Reading from a control file [message #240142 is a reply to message #240125] Thu, 24 May 2007 04:24 Go to previous messageGo to next message
orafacjublu
Messages: 95
Registered: May 2006
Location: KOLKATA
Member
That was great , now tell me where is a savepoint name stored in the database .Suppose one forgets the savepoint name before ending a transaction can he check the name from any data dictionary view or table or from the controlfile like you said.
Waiting for a reply Taj;
Re: Reading from a control file [message #240151 is a reply to message #240142] Thu, 24 May 2007 04:37 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't think Taj will reply more than where you already posted this question: http://www.orafaq.com/forum/t/82247/102589/

Savepoints are not in control file, it is useless to store on disk data that will not cross instance life. Savepoints are in memory.

Regards
Michel
Re: Reading from a control file [message #240166 is a reply to message #240151] Thu, 24 May 2007 05:07 Go to previous messageGo to next message
orafacjublu
Messages: 95
Registered: May 2006
Location: KOLKATA
Member
Jolly Good, then if it is in the memory it could also be queried from some dynamic view or other ? which view it will be
Re: Reading from a control file [message #240172 is a reply to message #240166] Thu, 24 May 2007 05:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why "it could be queried"?
Do you say everything you think?

Regards
Michel
Re: Reading from a control file [message #240176 is a reply to message #240172] Thu, 24 May 2007 05:36 Go to previous messageGo to next message
orafacjublu
Messages: 95
Registered: May 2006
Location: KOLKATA
Member
I am not going for a debate. What simply I want that technicall why can't I get the name of my savepoint. I have checked the control file also , it is not there
Re: Reading from a control file [message #240181 is a reply to message #240176] Thu, 24 May 2007 05:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What I meant is this is because something is in memory that Oracle put it on display.
There are many things in memory that can't be seen outside.

Regards
Michel
Re: Reading from a control file [message #240737 is a reply to message #240119] Fri, 25 May 2007 10:54 Go to previous messageGo to next message
dbaxchangedba
Messages: 26
Registered: November 2005
Junior Member
Quote:
if it is in the memory it could also be queried from some dynamic view or other


Not sure of a dynamic view or a fixed table that could give the savepoint information for a given session since savepoints are transaction specific but you most certainly can dump the savepoint information for the current session in to a dump trace file using this command:

alter session set events 'immediate trace name savepoints level 1'


Good luck...

http://www.dbaxchange.com
Re: Reading from a control file [message #241067 is a reply to message #240737] Mon, 28 May 2007 04:53 Go to previous messageGo to next message
orafacjublu
Messages: 95
Registered: May 2006
Location: KOLKATA
Member
After trying this command I am getting error ora-2194.I had given the same alter session command that you gave.Pls check it
Re: Reading from a control file [message #241079 is a reply to message #241067] Mon, 28 May 2007 05:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Event must not be used unless you have an Oracle support notification.
Finally what us your REAL problem?
Does a dump will suit you? Why?

Regards
Michel
Re: Reading from a control file [message #241112 is a reply to message #241079] Mon, 28 May 2007 06:15 Go to previous messageGo to next message
orafacjublu
Messages: 95
Registered: May 2006
Location: KOLKATA
Member
What i did was :-

1) create table a1(id number));
2)insert into a1 values(5);
3)savepoint ab;
4)alter session set events 'immediate trace name savepoints level 1';

now i go to udump folder but I don't find my trace file.Then the trace file is not generated isn't it ?

So unless I can generate this trace file I can't get the name of the save point what to do?
Re: Reading from a control file [message #241149 is a reply to message #241112] Mon, 28 May 2007 08:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you have the savepoint names in a trace file what can you do?
If you have set many savepoints and don't know which ones correspond to what, what can you do with the savepoint names?

In the end, aren't the savepoint names in your code?

Regards
Michel
Re: Reading from a control file [message #241182 is a reply to message #241149] Mon, 28 May 2007 11:37 Go to previous messageGo to next message
dbaxchangedba
Messages: 26
Registered: November 2005
Junior Member
Quote:
now i go to udump folder but I don't find my trace file


Works for me in 9.2.0.6! What is your oracle version?

Good luck.....

http://www.dbaxchange.com
Re: Reading from a control file [message #241338 is a reply to message #241182] Tue, 29 May 2007 05:15 Go to previous messageGo to next message
orafacjublu
Messages: 95
Registered: May 2006
Location: KOLKATA
Member
mine is also oracle9i release 9.2.0.6
Re: Reading from a control file [message #241482 is a reply to message #241338] Tue, 29 May 2007 15:05 Go to previous messageGo to next message
dbaxchangedba
Messages: 26
Registered: November 2005
Junior Member
Well then, sounds like either the owner of the oracle software on your host machine does not have proper privileges on the udump directory location where the trace files need to be created or what you've defined as the udump location for the instance is not correct.
Either way, check and see if trace files get created by doing a simple test of either setting sql_trace for a session or by running a backup controlfile to trace command. If no trace files get created as part of the test then, give the owner of your oracle software, proper privileges on the udump directory which will allow for the trace files to be created.

Good Luck....

http://www.dbaxchange.com
Re: Reading from a control file [message #243346 is a reply to message #241482] Thu, 07 June 2007 00:31 Go to previous messageGo to next message
orafacjublu
Messages: 95
Registered: May 2006
Location: KOLKATA
Member
In case of backup to control file its working fine.But in case of the savepoint its not working . Could you kindly give me the steps;(A simple example)
Re: Reading from a control file [message #278582 is a reply to message #240119] Mon, 05 November 2007 01:48 Go to previous messageGo to next message
halfydba
Messages: 20
Registered: November 2007
Location: Australia
Junior Member
Not sure what values you want, but v$controlfile_record_section and the rest of the v$controfile views are good place to start
Re: Reading from a control file [message #278589 is a reply to message #278582] Mon, 05 November 2007 02:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It seems you want to make a speciality to answer either (or both):
- old post
- same thing as that was posted
- (slighty) out of topic

There, tell me what you post add to this old thread.

Regards
Michel
Re: Reading from a control file [message #279735 is a reply to message #278589] Fri, 09 November 2007 18:10 Go to previous message
halfydba
Messages: 20
Registered: November 2007
Location: Australia
Junior Member
Sure, point taken. I only read the first 2 posts about "see values stored within a control file" and didn't look at any of the discussion on savepoints, or the date of the post.
I will ensure I read the question properly and update only new topics in future.

Thanks
Previous Topic: Database server configuration and 4000 concurrent users
Next Topic: Rebuliding index issue
Goto Forum:
  


Current Time: Thu Dec 08 23:55:58 CST 2016

Total time taken to generate the page: 0.11646 seconds