Só I tried to run this statement removing the subselect which retrieve the comments, and it runs almost instantaneously. OK, this query is doing exactly what it takes to allow editing the table, but for some reason it is slow, very slow. WHERE C.OWNER = :1 AND C.TABLE_NAME = :2 AND C.HIDDEN_COLUMN = ‘NO’ , C.DATA_TYPE_MOD, C.VIRTUAL_COLUMN, C.IDENTITY_COLUMN, C.DEFAULT_ON_NULL WHERE C.OWNER = CMT.OWNER AND C.TABLE_NAME = CMT.TABLE_NAMEĪND C.COLUMN_NAME = CMT.COLUMN_NAME) COMMENTS decode(C.CHAR_USED, ‘B’, ‘BYTE’, ‘C’, ‘CHAR’,null) ( SELECT CMT.COMMENTS FROM SYS.DBA_COL_COMMENTS CMT SELECT /*OracleDictionaryQueries.ALL_COLUMN_ORACLE12c_QUERY*/Ĭ.COLUMN_NAME, C.DATA_TYPE, C.DATA_TYPE_OWNER, C.DATA_LENGTH, C.DATA_PRECISION, C.DATA_SCALE, C.NULLABLE, C.DEFAULT_LENGTH, C.CHAR_LENGTH, C.DATA_DEFAULT, I checked my session activity from another SQL client, and it seems to be stuck in this query:
I open the table definitions, and after pressing the button “edit”, the dialog “Preparing editor for null” shows up, and it takes a long long time until I can actually navigate and modify table definition (more than 10 minutes). I’m facing a weird situation when trying to edit table definitions, maybe you can help me. When creating/editing tables, if you tried to go into the advanced column properties, you’d get a nasty Java error. However, I’ve had several internal folks with fancy new M1’s tell me the ARM version of the download fires right up 🙂 For all OS updates, there’s a single bug fix as well My Mac Mini is from 2018, so it’s an ‘old Intel’ chip based piece of hardware. It’s a Java 11 distribution, and we make sure the FX libraries are there as well. You can see this if you open up the Application properties. It will use the Java Home embedded in your SQLDeveloper app. No more complicated ‘How to’ guides for SQLDev and Macs
My friends with ARM architecture equipped Macs are telling me that SQLDev is easier 4x faster now that it’s using an ARM JDK. Starting today, we’re now offering the same for both hardware chipsets offered by Apple M1/M2 with ARM-based systems-on-a-chip? We have you covered! Oracle SQL Developer for the Mac (and Windows and Linux)įor many years we’ve offered a download for Windows users that included an Oracle JDK embedded in the software package.
0 kommentar(er)
