All, Just verifying that these indexes are supposed to be created automatically (for either Oracle or Postgres) as they exist in the 6.0 database migration scripts: https://github.com/DSpace/DSpace/blob/dspace-6_x/dspace-api/src/main/resources/org/dspace/storage/rdbms/sqlmigration/oracle/V6.0_2015.03.07__DS-2701_Hibernate_migration.sql#L368
It sounds like the migrations may not have all completed successfully. Not sure why that would be. The logs from the initial installation may have provided more information as to whether the "V6.0_2015.03.07__DS-2701_Hibernate_migration" migration succeeded or not. You also could double check that your database reports successful migrations by running [dspace]/bin/dspace database info (This command reports the current database status, and a larger table that lists all database migrations and whether each has run successfully on the database.) Good luck, Tim On Tue, Sep 19, 2017 at 1:25 AM Alan Orth <alan.o...@gmail.com> wrote: > Good to know, Christian. I don't use Oracle so I'm not sure, but I assume > that these indexes were supposed to be created by DSpace during > installation. Must be a bug. > > Regards, > > On Tue, Sep 19, 2017 at 12:50 AM christian criollo <ccrioll...@gmail.com> > wrote: > >> Hi Alan >> >> I find the reason of slowly and the problem it was indexes database in >> the table metadatavalue that strangely not executed the scripts are the >> next: >> >> CREATE INDEX metadatavalue_object on metadatavalue(dspace_object_id); >> CREATE INDEX metadatavalue_field_object on >> metadatavalue(metadata_field_id, dspace_object_id); >> >> I executed this scripts and the performance of the application improve >> noticeably already respond in seconds that is the normal >> >> thanks for your attention and help >> >> >> >> >> El jueves, 14 de septiembre de 2017, 1:28:55 (UTC-5), Alan Orth escribió: >> >>> Hello, >>> >>> Your server should have enough power to run DSpace well. Is there >>> anything else running on the server? How much of the machine's RAM is >>> dedicated to the Java JVM heap? You can look in the "Java Information" >>> section of the control panel when logged into DSpace as an administrator. >>> Also, is your DSpace a clean installation or is there a lot of content >>> submitted in it? >>> >>> Regards, >>> >> >>> On Wed, Sep 13, 2017 at 7:37 PM christian criollo <ccrio...@gmail.com> >>> wrote: >>> >>>> >>>> Hi Alan >>>> >>>> this is my configuration >>>> >>>> - Operating system version R/ SUSE Linux Enterprise Server 11 (x86_64) >>>> - PostgreSQL version R/ the database is Oracle Database 11g Release >>>> 11.2.0.3.0 - 64bit >>>> - Java version R/ java version "1.7.0_45" >>>> - Tomcat version R/ 7.0.50 >>>> - Hardware specifications of your server, like RAM and CPU R/ *three >>>> proccesors* Intel(R) Xeon(R) CPU E5-2690 v4 @ 2.60GHz *RAM * 5994588 >>>> kB >>>> >>>> I hope htis help >>>> >>>> >>>> >>>> >>>> El miércoles, 13 de septiembre de 2017, 7:43:56 (UTC-5), Alan Orth >>>> escribió: >>>> >>>>> Hello, Christian. >>>>> >>>>> You need to give us more information before we would be able to help >>>>> you. For example: >>>>> >>>>> - Operating system version >>>>> - PostgreSQL version >>>>> - Java version >>>>> - Tomcat version >>>>> - Hardware specifications of your server, like RAM and CPU >>>>> >>>>> Regards, >>>>> >>>>> On Tue, Sep 12, 2017 at 6:02 PM christian criollo <ccrio...@gmail.com> >>>>> wrote: >>>>> >>>> Hi all >>>>>> >>>>>> Recently I installed Dspace 6.2 when I give click in a community, >>>>>> collection or item it takes too long to respond normally it should be a >>>>>> few >>>>>> seconds what t could be happenning ? >>>>>> >>>>>> thanks for the help >>>>>> >>>>>> -- >>>>>> You received this message because you are subscribed to the Google >>>>>> Groups "DSpace Technical Support" group. >>>>>> >>>>> To unsubscribe from this group and stop receiving emails from it, send >>>>>> an email to dspace-tech...@googlegroups.com. >>>>>> To post to this group, send email to dspac...@googlegroups.com. >>>>> >>>>> >>>>>> Visit this group at https://groups.google.com/group/dspace-tech. >>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>> >>>>> -- >>>>> >>>>> Alan Orth >>>>> alan...@gmail.com >>>>> >>>> >>>>> https://picturingjordan.com >>>>> https://englishbulgaria.net >>>>> https://mjanja.ch >>>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "DSpace Technical Support" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to dspace-tech...@googlegroups.com. >>>> To post to this group, send email to dspac...@googlegroups.com. >>>> Visit this group at https://groups.google.com/group/dspace-tech. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> -- >>> >>> Alan Orth >>> alan...@gmail.com >>> https://picturingjordan.com >>> https://englishbulgaria.net >>> https://mjanja.ch >>> >> -- >> You received this message because you are subscribed to the Google Groups >> "DSpace Technical Support" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to dspace-tech+unsubscr...@googlegroups.com. >> To post to this group, send email to dspace-tech@googlegroups.com. >> Visit this group at https://groups.google.com/group/dspace-tech. >> For more options, visit https://groups.google.com/d/optout. >> > -- > > Alan Orth > alan.o...@gmail.com > > > https://picturingjordan.com > https://englishbulgaria.net > https://mjanja.ch > > -- > You received this message because you are subscribed to the Google Groups > "DSpace Technical Support" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to dspace-tech+unsubscr...@googlegroups.com. > To post to this group, send email to dspace-tech@googlegroups.com. > Visit this group at https://groups.google.com/group/dspace-tech. > For more options, visit https://groups.google.com/d/optout. > -- Tim Donohue Technical Lead for DSpace & DSpaceDirect DuraSpace.org | DSpace.org | DSpaceDirect.org -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
