Oracle SQL Developer Scalability

it_user506928 - PeerSpot reviewer
Assistant Director, Applications Development Services in the Student Collaboration Center at Temple University

Personally, the product scales to my needs.

View full review »
it_user521805 - PeerSpot reviewer
Manager - Technical at Molina Healthcare

As our company keeps on growing, our data also keeps on growing.

Currently, we are a $12-billion company and this tool supports us.

Our projection in the future, is to grow from $12 billion to $20 billion in the next three years and I am not sure whether it might help then or not, as our data will also grow consequently.

View full review »
MK
Senior Database Consultant at Performing Databases

Scalability has room for improvement. Often if you have to do a heavy load of queries or are getting large result sets you have to be careful not to overload the Java virtual machine that's running.

View full review »
it_user493380 - PeerSpot reviewer
Infrastructure Principal at a tech company with 10,001+ employees

From a scalability point of view, because it's just an install on each machine individually, scalability is not really an issue. Because we're in a network environment, we're able to actually have SQL Developer share file system space. We can point SQL Developer to the shared space. Those types of things weren't really an issue. It's not like we add people to using the one instance.

SQL Developer is able to handle hundreds of thousands of rows and columns. I haven't seen any instance where SQL Developer itself is the issue. Most times, what we've seen is that, either I've got a memory constraint issue on the machines, so I can only load in so much stuff, and SQL Developer has a configuration point that limits the amount of rows you get back from this database to 500, or whatever that is.

You can address system limitations. We've run into experiences where people say, "Oh, this is running slow." It tends to be slow because a bad query that has been written, and SQL Developer has tools to go in and look at the SQL and start doing troubleshooting. Or, you're trying to run something big in the middle of a financial close, and actually the resources you're trying to reach are being consumed by other things.

As far as running SQL Developer itself - outside of the Java compatibility issues where you might see SQL Dev not find Java or hang because it doesn't have the right version - the actual ability for the tool itself to grab the data, I have not run into a scenario where it's SQL Developer, so much as I have run into it's actually the machine that I'm using that may be limited in resources.

View full review »
Theodoros Loizou - PeerSpot reviewer
Software engineer at a comms service provider with 10,001+ employees

Oracle SQL Developer is scalable. It can perform the same when more people use it.

Most of the people in my organization are using Oracle SQL Developer. We have approximately 100 people in the organization.

View full review »
it_user492777 - PeerSpot reviewer
Senior Technical Evangelist at Snowflake Computing

It seems to scale fine. If you're trying to return exceedingly large data sets into the tool for some reason to download, that could be a challenge, depending on the memory on your machine and the disk space you have to output it to. Oracle will perform the query just, depending on how well your database is tuned, but oyu do need space for the output.

On the Data Modeler side, people do run into issues with very large models with hundreds and thousands of objects, but there is actually a memory parameter and a config file which you can tweak to increase the amount of memory that the tool uses. That, of course, is then limited only by how much memory you have on the workstation you're using.

View full review »
it_user809487 - PeerSpot reviewer
Senior Consultant at Contracted by Siemens

It is just client. It does not really matter. It is scalable, especially the newer version is non-GUI version. You do not have to install it, just dump it on the OS, then use it.

View full review »
it_user505650 - PeerSpot reviewer
Oracle architect & senior DBA, OBIEE data analytics, warehousing & ETL specialist at a tech consulting company with 51-200 employees

We did not encounter any issues with scalability.

View full review »
it_user756873 - PeerSpot reviewer
Data Architect / Data Modeler - Contract at a consultancy with 1,001-5,000 employees

No scalability issues.

View full review »
it_user538206 - PeerSpot reviewer
Founder & Oracle Database Consultant / Trainer at RebellionRider.Com at a tech consulting company with 51-200 employees

To be frank, I haven’t had the chance to evaluate this software with respect to its scalability.

View full review »
it_user521631 - PeerSpot reviewer
Engineer at Cisco WebEx

It is scalable. Although, we don't use it to get large data, still it is scalable.

View full review »
it_user657591 - PeerSpot reviewer
Senior Partner at a manufacturing company with 1-10 employees

It can be used by many because it's mainly a client-server.

View full review »
it_user521538 - PeerSpot reviewer
Senior Level 2 Software Engineer at Akamai Technologies

I only work on a Lenovo Windows machine. I don't work on Apples. I don't know if it's scalable there or not.

View full review »
it_user593127 - PeerSpot reviewer
IBM Message Broker Developer - Onsite Technical Lead at a financial services firm with 10,001+ employees
it_user809544 - PeerSpot reviewer
CEO at ITFS

The scalability is very good. It can scale out, up.

View full review »
it_user809562 - PeerSpot reviewer
DBA at Yediot

It's scalable.

View full review »
it_user530439 - PeerSpot reviewer
Sócio Diretor at a tech services company with 201-500 employees

I have never stressed the product to find out.

View full review »
it_user746874 - PeerSpot reviewer
Ingeniero Especialista at a comms service provider with 10,001+ employees

No scalability issues as of yet.

View full review »
it_user477966 - PeerSpot reviewer
DBA at a aerospace/defense firm with 1,001-5,000 employees

There have been no issues with scalability.

View full review »
it_user729174 - PeerSpot reviewer
Cloud Transf & Migr Innov Sr Principal at a tech services company with 10,001+ employees

I did not encounter any issues with scalability.

View full review »
it_user809577 - PeerSpot reviewer
DBA at a tech vendor with 1,001-5,000 employees

Scalability is very good.

View full review »
it_user809574 - PeerSpot reviewer
DBA

It's scalable. Everybody can install it on his or her machine.

View full review »
it_user809580 - PeerSpot reviewer
DBA at a tech services company with 51-200 employees

No problem with scalability.

View full review »