|
|
|
|
|
|
|
|
| Re: Transactions are failing due to insufficient space in the undo tablespace [message #683977 is a reply to message #683974] |
Fri, 12 March 2021 01:01   |
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Your putative interviewer may be less interested in whether you have memorized answers than in whether you have any problem solving skills. For example, you could begin by asking "What is the error? Is it, for example, an ora-30036 ?" If so:C:\Users\john>
C:\Users\john>oerr ora 30036
30036, 00000, "unable to extend segment by %s in undo tablespace '%s'"
// *Cause: the specified undo tablespace has no more space available.
// *Action: Add more space to the undo tablespace before retrying
// the operation. An alternative is to wait until active
// transactions to commit.
C:\Users\john> |
|
|
|
|
|
|
|
| Re: Transactions are failing due to insufficient space in the undo tablespace [message #683980 is a reply to message #683978] |
Fri, 12 March 2021 23:59 |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
BalajiDBA wrote on Sat, 13 March 2021 05:53Quote:Explain your question then.
I have already explained my question in this thread.
...
No, you didn't.
This is one the problems, you don't understand your question.
The proof: your question is "transaction [...] is failing due to insufficient space in the undo tablespace"
How do you know the transaction is failing? How do you know it is for this reason? How is this not about managing undo space? Do you understand my question?
As I already told you many times in these years and John reminded in this topic: "Your putative interviewer may be less interested in whether you have memorized answers than in whether you have any problem solving skills".
Anyway, it is just a wasting of time to try to explain you something because during these last 13 years:
1/ You showed you couldn't read the documentation
2/ You showed you couldn't search in the documentation
3/ You showed you couldn't search in the web
4/ You showed you couldn't understand what we explained
5/ You showed you couldn't even memorize what we said as you often repeated the same questions over the years
In the end, you showed you didn't want to help others when you said you had the answer as you refused to post it.
[Updated on: Sat, 13 March 2021 00:39] Report message to a moderator |
|
|
|
|
|
|
|
| Re: Transactions are failing due to insufficient space in the undo tablespace [message #683991 is a reply to message #683982] |
Mon, 15 March 2021 10:56 |
 |
EdStevens
Messages: 1376
Registered: September 2013
|
Senior Member |
|
|
Quote:Developer is doing a transaction and it is failing due to insufficient space in the undo tablespace.
Then later ...
Quote:I asked him but he said there were no errors for this issue.
Did it not occur to you to ask how it failed, if there were no errors?
Did it not occur to you to ask how it is known - with no errors - that the 'no error' failure was due to insufficient undo space?
Quote:Environment is prod.
How would you imagine that the solution for 'insufficient undo space' is different for prod that "not prod"? In other words, how is knowing the environement is "prod" relevant to the solution?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
