|
|
|
|
| Re: Reading from a control file [message #240142 is a reply to message #240125] |
Thu, 24 May 2007 04:24   |
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 #240737 is a reply to message #240119] |
Fri, 25 May 2007 10:54 |
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 #241112 is a reply to message #241079] |
Mon, 28 May 2007 06:15 |
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 #241482 is a reply to message #241338] |
Tue, 29 May 2007 15:05 |
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 #279735 is a reply to message #278589] |
Fri, 09 November 2007 18:10 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
