oracle sql developer

akescpt

akescpt

Honorary Master
Joined
Aug 12, 2008
Messages
24,204
Reaction score
2,589
Location
the MATRIX
been using sql server for 3 months now my current task requires this beast. its so cumbersome and slow. any alternatives to this?
 
MySQL
Oracle
Interbase
Postgress
Sybase
MaxSQL
CouchDB

...

Really, really depends on what you are trying to do: And no, SQL Server is not slow. Chances are pretty high if it is slow in SQL Server, it's going to be slow in whatever else you use. The only exception I see is when you start hitting 100GB databases, in which case I would start looking at Oracle rather.
 
Sql server is a ferrari compared to this. To view table data I can't just open the table, no, to simple. A select query is required! :(
 
Toad cost a crap load but is a awesome tool. I'm currently using that and PLSQL developer.
Partition the table and select from the partitions :)
Yesterday I had to do some exports.
Data in 4 partitions, partitioned per day =600gb ;) Oracle is the master for HUGE db's.
DB2 I have no experience in but hear its not too bad either.
 
Try compressing your huge partitions. Also, sub-partition them, range-hash, perhaps.
 
If your db is slow, then start looking at the hardware (memory, raid 1+0?, gbit ethernet / fiber?, etc). Making use of raid 1+0 instead will give a big boost. Place you recovery catalogs and redo-logs on separate disks if possible.

Only when your hardware is sorted, can you look at the table design (is it normalized?, indexes, etc), and obviously caches, etc.

Lots to think about ...
 
volstruis said:
Toad cost a crap load but is a awesome tool. I'm currently using that and PLSQL developer.
Partition the table and select from the partitions :)
Yesterday I had to do some exports.
Data in 4 partitions, partitioned per day =600gb ;) Oracle is the master for HUGE db's.
DB2 I have no experience in but hear its not too bad either.
Click to expand...

What industry are you in? That's huge...
 
If your Oracle DB is running very slowly then there is a problem with the way it has been set up. If it's an enterprise grade solution then you should probably get someone with decent Oracle DBA skills in to optimise it.

Strange how companies who are data-centric based companies complain about a DB (anyone really) being slow but won't pay the cost of having a DBA to keep things running smoothly. It's like a service garage not having a head mechanic.
 
Roo! said:
If your Oracle DB is running very slowly then there is a problem with the way it has been set up. If it's an enterprise grade solution then you should probably get someone with decent Oracle DBA skills in to optimise it.

Strange how companies who are data-centric based companies complain about a DB (anyone really) being slow but won't pay the cost of having a DBA to keep things running smoothly. It's like a service garage not having a head mechanic.
Click to expand...

So so so true. Then you need to add in that they NEVER want to buy any hardware to upgrade the database server.
 
not sure of the hardware setup. table has 48 mil records. i was just given an investigation to do so was flying blind and didn't work very smartly either. considering the records sql developer was performing ohk. its sitting out of our area so no control.
 
akescpt said:
not sure of the hardware setup. table has 48 mil records. i was just given an investigation to do so was flying blind and didn't work very smartly either. considering the records sql developer was performing ohk. its sitting out of our area so no control.
Click to expand...

Seems like either the indexes on the table are not set up properly, if at all, or you are not writing your statements using the indexes. You'll need to get the definition of the table (the DDL) to ensure that you are using the indexed correctly.

The two Oracle alternatives for dev are Oracle SQL Developer and TOAD. Most people I have spoken to like TOAD, so get the freeware version or the trial version for your current project.
 
im working with both Oracle and MSSQL. SQL Developer is the worst tool ever, flippen hate it. I'm using SQL Navigator, its 10 billions times better.

And i will say, Oracle DBs that are not set up correctly or maintained are disgustingly slow. After my very limited experience with Oracle, it is no wonder Oracle DBA contractors can charge R750 per hour.
 
Last edited:
Roo! said:
Seems like either the indexes on the table are not set up properly, if at all, or you are not writing your statements using the indexes. You'll need to get the definition of the table (the DDL) to ensure that you are using the indexed correctly.

The two Oracle alternatives for dev are Oracle SQL Developer and TOAD. Most people I have spoken to like TOAD, so get the freeware version or the trial version for your current project.
Click to expand...

i must still enquire about downloading TOAD. everything through IT
 
akescpt said:
shooting off an email now.
Click to expand...

Only thing with TOAD is that is is !@##$!@ expensive so unless your company gets you a license it is unfeasible for personal use.
Try PLSQL Developer its cost a whole lot less.
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X