Search results

@Rob Fitzpatrick - Thanks for confirming my assumptions.

Sorry for not being clear. My assumption; the whole point of doing this exercise is to have a pre-grown db that is logically empty. Let's consider an example, we have an AREA with variable extent that will have a table which is 30 GB (121229599 Records). As part of our exercise; 1. Let's say I...

That's weird - I will keep a tab on it. Thanks Cringer.

Sure Rob, will make a note of it on my check list. Thanks a lot for your advise.

@Rob Fitzpatrick @Cringer - Thank you! Just wanted to make sure the extends doesn't get recalculated during the second time load (I understand there may still be few) as its pre-grown.

I have a question in continuation to the above one, (hope it can be on the same thread as it's inter related) Based on old design I saw the below piece of log on promon; Database extends 16640 99840 1664.00 2.80 What does 2.80 represent? In our process will I see this value as 0.00 or...

True, I agree Tom. I agree Rob but when I brought up this point they said tables to grow to this point will take another 4 to 6 years before which we will have db maintenance and we can plan by then. This point needs to be seriously taken into consideration. I hope they don't say me that they...

@Rob Fitzpatrick - we started the test today. Meanwhile there was one more idea that came up during the meeting which we aren't sure it will work the way we think (basically to avoid fixed extent but still get db performance which will be more or less same as that of having fixed extent). Below...

@TomBascom @Rob Fitzpatrick - Thanks for your advise. Compilation on Client Server to the database took 1 hr 20 minutes. When I ran the compilation with DB on the same server it hardly took less than 6 minutes for the same set of programs. As suggested by Tom, we are also planning to run couple...

Got it, thanks Rob! Theoretically looks promising - will test this workflow and keep you posted.

@Rob Fitzpatrick - Quick question, in this case as we have the db pre-grown but pretty much with no data the initial load becomes faster even though its using variable extent. is my understanding right? Sequence of actions; 1. Use prostrct and create the db with all variable extents area 2. Do...

So in this case do you mean 13000+ programs should not take 1 hr 20 minutes when we compile one by one on a good server? Is it advisable to do it in serially? If yes, rather than investing time on this, I can invest time on workaround with the deployment schedule. :)

@Rob Fitzpatrick - my bad, I missed one zero on it. It's 13000+ programs scattered across 15 folders. Sorry for the inconvenience.

@Rob Fitzpatrick - sure, will test this approach.

Thanks @Rob Fitzpatrick

I got a question from my organization yesterday. Is it possible for me to restrict my posts appearing on google search (i mean on different search engines)? It's fine people logging into progresstalk and searching but not from search engines. I don't see any option but just wanted to check if...

@All - We have 1300+ programs scattered across 15 folders which takes 1 hr 20 minutes for a full build. We are planning to automate our build process. Is there a way to do compilation in parallel? We don't have too many user licenses and we can't run parallel compilation on different sessions...

Looks like you are using static queries but not handling the deletion of object properly. As @RealHeavyDude mentioned looks like a memory leak issue. Is it possible for you to change the table names/field names and post the query? It may be easy for us to narrow down the issue.

Do you want to just have a look at data of couple of tables? Or Is there any other purpose behind it? Are you trying to debug some data related issue?

@TomBascom @Cringer @Rob Fitzpatrick - Thank you! As my current db on 9.1E is using variable extents and users/developers are fine with performance; can I stick with the same? with one exception - we have 4 Fast Growing Tables which are more than 100 GB. Can I go with 32 GB fixed extents...