database - performance tuning - Insert -

-

i have 1 unix script in creating table, index , loading date file table using sql loader . , doing near 70 direct update (not using or bulk collect) on table.

at last inserting new table data table. per day it's processing 500 000 records. these update fast.

during inserting data table taking 20 minutes. how can improved?

  1. no problem in insert because on same table inserting 500 000 rectors table that's working fine. insert done in less minute.

insert tables () select () tablex; it's taking 20 min 500 000 records tablex- created , loaded , 70 direct update done in same shell script .

checked explain plan cost select alone , insert script both same.

insert tables () select () tabley; above statement executed less second.

  • i used parallel hint. cost reduced . , cpu utilisation zero.
  • shall create 1 more table tablez load data tablez final table?
  • is stats gathering required? daily run program.

when direct path insert using sql loader, records inserted above highwatermark. after load completed , highwatermark moved up, there lots of empty blocks below original/old highwatermark position. if select going full table scan, reading empty blocks too. check see if table has accumulated lots of empty blocks on period of time. may use segment advisor this. based on advisor recommendations, shrink table , free unused space. speed execution. hope helps.


Comments

Post a Comment

Popular posts from this blog

Django REST Framework perform_create: You cannot call `.save()` after accessing `serializer.data` -

-
i have following viewset: class artistprofileviewset(viewsets.modelviewset): queryset = artistprofile.objects.all() serializer_class = artistprofileserializer def perform_create(self, serializer): if serializer.is_valid(): serializer.save() with following serializers: class simpleartisttrackserializer(serializers.hyperlinkedmodelserializer): class meta: model = artisttrack fields = (...my fields...) class artistprofileserializer(serializers.hyperlinkedmodelserializer): owners = userserializer(many=true, required=false) tracks = simpleartisttrackserializer(many=true, required=false) class meta: model = artistprofile fields = (...my fields...) i getting following error: assertionerror: cannot call `.save()` after accessing `serializer.data`.if need access data before committing database inspect 'serializer.validated_data' instead. i don't see editing serializer.data object. th...
Read more

Why does Go error when trying to marshal this JSON? -

-
i'm trying rather simple example of trying decode json file structs using golang. however, when attempting error that json: cannot unmarshal object go value of type []main.track which don't understand. here's code in question, , json can found here . package main import ( "encoding/json" "fmt" "net/http" "os" ) // tracks group of track types type tracks struct { tracks []track } // track represents singular track type track struct { name string url string artist artist } // artist represents single artist type artist struct { name string mbid string url string } func main() { url := "http://ws.audioscrobbler.com/2.0/?method=geo.gettoptracks&api_key=c1572082105bd40d247836b5c1819623&format=json&country=netherlands" response, err := http.get(url) if err != nil { fmt.printf("%s\n", err) os.exit(1) } de...
Read more