Problems adding a large schema to Team Coding

Toad for Oracle - Beta
1

TOAD 12.9.39 32bit on Windows 7

Oracle 11gR2

Subversion 1.6

I have a large oracle schema (14500 objects) that I am trying to add to Team Coding and Subversion.

After creating the team project successfully, I started the process of creating initial revisions in SVN and let it run overnight.

When I arrived in the morning, the progress dialog indicated that the process had completed. However, there was an error dialog on the screen that indicated TOAD had encountered an oracle error:

ORA-01555 Snapshot Too Old

I think this simply means that I need a bigger rollback segment, if I’m going to run such long update statements. Still, I’m not sure if this represents an event that may have left the process incomplete. I saved the log file, and closed the dialog box, and I received the following error from TOAD:

Cannot create file “…\TOAD_EC9E\User Files\VCPDebug.log”. The process cannot access the file because it is being used by another process. (Note- I was running this instance of TOAD using the /virtual command line parameter.)

when I closed this dialog, TOAD appeared to restart.

However, TOAD now seems to go in a loop and fails to complete the process of connecting to my database. After selecting the loging profile from the Database Login dialog, I get the SVN login dialog. That one closes, but the Database Login dialog will not close, and it just flashes between showing the (not responding) tag in the title bar, and not showing it.

However the entire TOAD UI remains unresponsive.

I’ve killed TOAD at the task manager a couple of times, but the behavior is the same each time.

It’s possible that TOAD is just doing work to read all the team coding data at startup time, so I’m just going to leave it and see if it completes successfully.

But for now, I am unable to run TOAD.

Any suggestions are welcome.

ORA-01555 Snapshot Too Old

2

Hey Cole,

I’m in the process of setting up a similar-sized database locally here for stress testing. I’ll know a bit more about this later this afternoon.

As for the ORA-01555 error you’re receiving, I believe you’re correct in that it looks to be related to the size of the server’s undo space for rollback segments; however, Team Coding should not be running updates to large segments of data. All of the data being updated during a Create Revision process should be to the TCX_OBJECTS and TCX_OBJECT_HISTORY tables in the TOAD schema.

Let me see if I can get a similar environment set up locally and do some troubleshooting today. As soon as I have an update, I’ll post it here as well as e-mail you.

-John

From: cdavisson_218 [mailto:bounce-cdavisson_218@toadworld.com]

Sent: Tuesday, March 15, 2016 12:23 PM

To: toadoraclebeta@toadworld.com

Subject: [Toad for Oracle - Beta Discussion Forum] Problems adding a large schema to Team Coding

Problems adding a large schema to Team Coding

Thread created by cdavisson_218

TOAD 12.9.39 32bit on Windows 7

Oracle 11gR2

Subversion 1.6

I have a large oracle schema (14500 objects) that I am trying to add to Team Coding and Subversion.

After creating the team project successfully, I started the process of creating initial revisions in SVN and let it run overnight.

When I arrived in the morning, the progress dialog indicated that the process had completed. However, there was an error dialog on the screen that indicated TOAD had encountered an oracle error:

ORA-01555 Snapshot Too Old

I think this simply means that I need a bigger rollback segment, if I’m going to run such long update statements. Still, I’m not sure if this represents an event that may have left the process incomplete. I saved the log file, and closed the dialog box, and I received the following error from TOAD:

Cannot create file “…\TOAD_EC9E\User Files\VCPDebug.log”. The process cannot access the file because it is being used by another process. (Note- I was running this instance of TOAD using the /virtual command line parameter.)

when I closed this dialog, TOAD appeared to restart.

However, TOAD now seems to go in a loop and fails to complete the process of connecting to my database. After selecting the loging profile from the Database Login dialog, I get the SVN login dialog. That one closes, but the Database Login dialog will not close, and it just flashes between showing the (not responding) tag in the title bar, and not showing it.

However the entire TOAD UI remains unresponsive.

I’ve killed TOAD at the task manager a couple of times, but the behavior is the same each time.

It’s possible that TOAD is just doing work to read all the team coding data at startup time, so I’m just going to leave it and see if it completes successfully.

But for now, I am unable to run TOAD.

Any suggestions are welcome.

ORA-01555 Snapshot Too Old

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

3

John,

Just an update. I left TOAD for about 2.5 hours, and the login/connection process appears to have completed.

Unfortunately, when I look at the tree of objects under the team project tab of the team coding manager, about 40% of the objects under the Constraints node are in checked-out, and the rest don’t appear to have been touched, yet… I see those constraint objects in subversion, but no others.

So, it appears that the process stopped when an error was encountered. At least, that’s my inexpert impression.

Thanks,

Cole

4

Hey Cole,

I’ve made some improvements to the inner workings of Team Coding, so larger schemas such as these should perform much faster. When you get a chance, feel free to give tomorrow’s beta a shot and let me know how it works in your environment.

-John