hi,
I've been using version 9 for a few weeks now and there are some observations I'd like to share with you. First of all, thanks for the continuous development and improvements, PLSQL Developer really is a very good program which I've been using since version 7 on daily bases!
I used version 8 with "Dual session" setting and have configured version 9 the same way, unfortunatelly there are some "annoying" differences.
1. in v8 it was possible to run a query and at the same time, while the query was running, display Explain plan in another window. This is not the case in v9, I have to wait till the query finishes and only after that the explain plan window appears.
2. when v8 got disconnected (e.g. notebook was hibernated) it was enough to enter the logon credentials once and everything was working again. The v9 shows logon dialog, after that seems to be logged in but when I try to edit properties for e.g. table, there is a message that it is not connected. The remedy to this is to explicitly log off (from the Session menu) and then log on again.
some more observations
- the program sometimes stops responding if a query is running and I switch back to it from another program (actually, happen just now while I'm writing this comment). There are 3 solutions - kill the running query in the database (kill session), wait till the query finishes, close the application. This used to happen with v8 as well, v9 just seems to be doing it more often.
- v9 seems to be even slower than v8 when switching between windows. When I press Ctrl+Tab the main menu (File, Project...) flickers for a while and only after that the other window is activated. Taking into account that the switch can take couple of seconds (on Intel i5 M 560 @ 2.67GHz, 2 Core(s), 4 Logical Processors) there for sure is space for improvement. It seems this problem is not directly linked to number of windows, it can happen with 10 as well as just 3 opened editor windows.
Question
- would it be possible to extend right click menu for materialized views? e.g.
"select * from mat_view" if I right click on "mat_view" I get edit/view options for the materialized view and I can extract it's DDL but in majority of the cases I'm more interested to see options for the underlying table (to check indexes, partitioning...).
Thanks for reading.
kind regards
Jiri
support info:
PL/SQL Developer
Version 9.0.0.1601
01.66335 - 100 user license
Windows 7 6.1 Build 7601 (Service Pack 1)
Physical memory : 2,097,152 kB (1,507,584 available)
Paging file : 4,194,304 kB (4,194,304 available)
Virtual memory : 2,097,024 kB (1,885,796 available)
Parameters
C:\Program Files\PLSQL Developer\PlSqlDev.exe
Preferences
Session mode: Dual
OCI Library:
Use OCI7: False
Plug-Ins
*Comment lines v1.4 (C:\Program Files\PLSQL Developer\PlugIns\commentline.dll)
*PL/SQL Documentation (plsqldoc) (C:\Program Files\PLSQL Developer\PlugIns\plsqldoc.dll)
(* is Active)
Homes
OraDb11g_home1 (c:\oracle\11gr2)
DLLs
c:\oracle\11gr2\bin\oci.dll
TNS File
c:\oracle\tnsnames.ora
Using
Home: OraDb11g_home1
DLL: c:\oracle\11gr2\bin\oci.dll
OCI: version 11.1
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
Character Sets
Character size: 4 byte(s)
CharSetID: 873
NCharSetID: 2000
Unicode Support: True
NLS_LANG: AMERICAN_AMERICA.AL32UTF8
NLS_NCHAR_CHARACTERSET: AL16UTF16
NLS_CHARACTERSET: AL32UTF8
I've been using version 9 for a few weeks now and there are some observations I'd like to share with you. First of all, thanks for the continuous development and improvements, PLSQL Developer really is a very good program which I've been using since version 7 on daily bases!
I used version 8 with "Dual session" setting and have configured version 9 the same way, unfortunatelly there are some "annoying" differences.
1. in v8 it was possible to run a query and at the same time, while the query was running, display Explain plan in another window. This is not the case in v9, I have to wait till the query finishes and only after that the explain plan window appears.
2. when v8 got disconnected (e.g. notebook was hibernated) it was enough to enter the logon credentials once and everything was working again. The v9 shows logon dialog, after that seems to be logged in but when I try to edit properties for e.g. table, there is a message that it is not connected. The remedy to this is to explicitly log off (from the Session menu) and then log on again.
some more observations
- the program sometimes stops responding if a query is running and I switch back to it from another program (actually, happen just now while I'm writing this comment). There are 3 solutions - kill the running query in the database (kill session), wait till the query finishes, close the application. This used to happen with v8 as well, v9 just seems to be doing it more often.
- v9 seems to be even slower than v8 when switching between windows. When I press Ctrl+Tab the main menu (File, Project...) flickers for a while and only after that the other window is activated. Taking into account that the switch can take couple of seconds (on Intel i5 M 560 @ 2.67GHz, 2 Core(s), 4 Logical Processors) there for sure is space for improvement. It seems this problem is not directly linked to number of windows, it can happen with 10 as well as just 3 opened editor windows.
Question
- would it be possible to extend right click menu for materialized views? e.g.
"select * from mat_view" if I right click on "mat_view" I get edit/view options for the materialized view and I can extract it's DDL but in majority of the cases I'm more interested to see options for the underlying table (to check indexes, partitioning...).
Thanks for reading.
kind regards
Jiri
support info:
PL/SQL Developer
Version 9.0.0.1601
01.66335 - 100 user license
Windows 7 6.1 Build 7601 (Service Pack 1)
Physical memory : 2,097,152 kB (1,507,584 available)
Paging file : 4,194,304 kB (4,194,304 available)
Virtual memory : 2,097,024 kB (1,885,796 available)
Parameters
C:\Program Files\PLSQL Developer\PlSqlDev.exe
Preferences
Session mode: Dual
OCI Library:
Use OCI7: False
Plug-Ins
*Comment lines v1.4 (C:\Program Files\PLSQL Developer\PlugIns\commentline.dll)
*PL/SQL Documentation (plsqldoc) (C:\Program Files\PLSQL Developer\PlugIns\plsqldoc.dll)
(* is Active)
Homes
OraDb11g_home1 (c:\oracle\11gr2)
DLLs
c:\oracle\11gr2\bin\oci.dll
TNS File
c:\oracle\tnsnames.ora
Using
Home: OraDb11g_home1
DLL: c:\oracle\11gr2\bin\oci.dll
OCI: version 11.1
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
Character Sets
Character size: 4 byte(s)
CharSetID: 873
NCharSetID: 2000
Unicode Support: True
NLS_LANG: AMERICAN_AMERICA.AL32UTF8
NLS_NCHAR_CHARACTERSET: AL16UTF16
NLS_CHARACTERSET: AL32UTF8
Last edited:
