GTT's

Tuning de Banco, Tuning de SQL, Ferramentas de tuning
  

Poston Fri, 16 Dec 2011 4:09 pm

Guys, good afternoon.

I need to perform a tuning here at the company and one of the exits for the process to improved, is the search in parts of the information, and then perform a join.

To do this, I'm using Global Temporary Tables, which will contain between 50 and 100 thousand records.

I'd like some tips from friends DBA 's, in terms of competition, like, if you have 20 people using this process at the same time etc, what kind of problems can have, even on the question of the amount of rows.

I thank you.
Trevisolli
Location: Araraquara - SP

Abraço,

Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP

Poston Sat, 17 Dec 2011 8:23 am

I don't think it will have no problem. The GTT were made for that!
dr_gori
Location: Seattle, WA, USA

Thomas F. G
https://www.patreon.com/glufke

Poston Mon, 19 Dec 2011 8:32 am

So my old ...

também I did not see any problem. I believe that even the amount of independent records, correct? I'm not a DBA, but I think the GTT's wear including another BD memory area, am I mistaken?

I was talking with a DBA, and I don't know how they see it, guided me to know how many records and stuff, I ended up getting a little in doubt, as the decision of the development.

Thanks a lot man.
Trevisolli
Location: Araraquara - SP

Abraço,

Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP



Return to DBA Tuning

Who is online

Users browsing this forum: No registered users and 2 guests