Have the DBA's set the SPATIAL_ACCELERATOR option on the Oracle DB? -----Original Message----- From: pradeep2751 [mailto:pradeepkuma...@gmail.com] Sent: Saturday, 24 October 2020 2:38 AM To: geoserver-users@lists.sourceforge.net Subject: Re: [Geoserver-users] GeoServer and Oracle
hi, Facing performance issue with loading spatial data and any update related to spatial is taking more time then 12C database. As number of users increases this even get worse, i have collected some stats which I am attaching with post. stats.JPG <https://aus01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fosgeo-org.1560.x6.nabble.com%2Ffile%2Ft383959%2Fstats.JPG&data=04%7C01%7Cgraham.humphries%40stategrowth.tas.gov.au%7C264ec66788834a5c3fe808d8776bae23%7C64ebab8accf44b5ca2d32b4e972d96b2%7C0%7C0%7C637390652637490473%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=5cIkrl3XWxGePOeIwe8ELeHSGPQLJ%2BMuHF3mgTxoef8%3D&reserved=0> -- Sent from: https://aus01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fosgeo-org.1560.x6.nabble.com%2FGeoServer-User-f3786390.html&data=04%7C01%7Cgraham.humphries%40stategrowth.tas.gov.au%7C264ec66788834a5c3fe808d8776bae23%7C64ebab8accf44b5ca2d32b4e972d96b2%7C0%7C0%7C637390652637490473%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=kNOHcG3wgRljTfq0sxbLcuP3ez3btk3o4hOpMoIn%2BYs%3D&reserved=0 _______________________________________________ Geoserver-users mailing list Please make sure you read the following two resources before posting to this list: - Earning your support instead of buying it, but Ian Turton: https://aus01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.ianturton.com%2Ftalks%2Ffoss4g.html%23%2F&data=04%7C01%7Cgraham.humphries%40stategrowth.tas.gov.au%7C264ec66788834a5c3fe808d8776bae23%7C64ebab8accf44b5ca2d32b4e972d96b2%7C0%7C0%7C637390652637500468%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=%2FJoNvQJJuyPyp%2B9t%2FPmK5ni9vhwbPlJRcb3Trw1xY%2Fk%3D&reserved=0 - The GeoServer user list posting guidelines: https://aus01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgeoserver.org%2Fcomm%2Fuserlist-guidelines.html&data=04%7C01%7Cgraham.humphries%40stategrowth.tas.gov.au%7C264ec66788834a5c3fe808d8776bae23%7C64ebab8accf44b5ca2d32b4e972d96b2%7C0%7C0%7C637390652637500468%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=2zbK%2F15Po%2FvS0Vmc6IBBV2%2F07gdcFw4nxaZfrB9yI9s%3D&reserved=0 If you want to request a feature or an improvement, also see this: https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fgeoserver%2Fgeoserver%2Fwiki%2FSuccessfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer&data=04%7C01%7Cgraham.humphries%40stategrowth.tas.gov.au%7C264ec66788834a5c3fe808d8776bae23%7C64ebab8accf44b5ca2d32b4e972d96b2%7C0%7C0%7C637390652637500468%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=bDoCzQj8QQaydd4BKTrMXMM8zDAT2SwAYJP7HFQ6VI0%3D&reserved=0 Geoserver-users@lists.sourceforge.net https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.sourceforge.net%2Flists%2Flistinfo%2Fgeoserver-users&data=04%7C01%7Cgraham.humphries%40stategrowth.tas.gov.au%7C264ec66788834a5c3fe808d8776bae23%7C64ebab8accf44b5ca2d32b4e972d96b2%7C0%7C0%7C637390652637500468%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=GY68j9k2RX6xTjFnRHe%2BSmdF4AAt%2BAQ4%2FZXB445UFAk%3D&reserved=0 ________________________________ CONFIDENTIALITY NOTICE AND DISCLAIMER The information in this transmission may be confidential and/or protected by legal professional privilege, and is intended only for the person or persons to whom it is addressed. If you are not such a person, you are warned that any disclosure, copying or dissemination of the information is unauthorised. If you have received the transmission in error, please immediately contact this office by telephone, fax or email, to inform us of the error and to enable arrangements to be made for the destruction of the transmission, or its return at our cost. No liability is accepted for any unauthorised use of the information contained in this transmission. _______________________________________________ Geoserver-users mailing list Please make sure you read the following two resources before posting to this list: - Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/ - The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users