Oracle global temp table- help

[Mr Mirchi]

Nenu oka stored proc rasthunna oracle lo… 300 concurrent uaers vubtaru at any given sec….

 

stored proc lo global temp table use cheyabothunna…..e temp table lo 750k records insert avuthavi per session(user)… so 300 sessions(users) ki 300x750k records insert avuthavi kadhaaa?????   If yes . Dhani valla performance prob vasthundhaaaa

Thanks

[Point]

3 hours ago, Mr Mirchi said:

Nenu oka stored proc rasthunna oracle lo… 300 concurrent uaers vubtaru at any given sec….

 

stored proc lo global temp table use cheyabothunna…..e temp table lo 750k records insert avuthavi per session(user)… so 300 sessions(users) ki 300x750k records insert avuthavi kadhaaa?????   If yes . Dhani valla performance prob vasthundhaaaa

Thanks

endh vaya

[bluebadger]

gtts ki hard limit undadu with enough temp space allocation, performance ante depends on data set/reads writes/indexing/stats/exec plan - multiple factors untaayi. in the end huge data sets n performance squaring off is always a given. 

[Picheswari]

dba question