How SQL Developer Monitor SQL
Real Time SQL Monitor Select Connection Then select which database you want to connect to and monitor. SQL List DBA Panel In fact, the "Real… Read More »How SQL Developer Monitor SQL
SQL Developer
SQL Developer Monitor and Kill Sessions
Monitor Sessions To monitor sessions in SQL developer, you may find the entry in the function menu of "Tools". Select Connection Then select which database… Read More »SQL Developer Monitor and Kill Sessions
SQL Developer Create Table Partition
Since the create a table partitioning syntax is hard to keep in mind, we'd better use GUI tools to facilitate us to create. Here we… Read More »SQL Developer Create Table Partition
Oracle Change User Password
Change User Password Periodically, you may like to change your own password for more protection. In fact, there're many ways that can change user's password… Read More »Oracle Change User Password
How Oracle Rename Table
You can either using SQL statement or GUI tools to rename a table, depending on your requirement. Table Rename by SQL Statement Table Rename by… Read More »How Oracle Rename Table
SYS_AUTO_SQL_TUNING_TASK Report
SYS_AUTO_SQL_TUNING_TASK Sometimes, you don't have to run SQL tuning report for a specific statement, because the automatic SQL tuning job (SYS_AUTO_SQL_TUNING_TASK) could have identified long-running… Read More »SYS_AUTO_SQL_TUNING_TASK Report
How to Resolve Unable to launch the Java Virtual Machine Located at path
Unable to launch the Java Virtual Machine Saw an error dialog when I launch SQL Developer for the first time. Unable to launch the Java… Read More »How to Resolve Unable to launch the Java Virtual Machine Located at path
How to Resolve ORA-24247: network access denied by access control list (ACL)
ORA-24247 There're two error patterns of ORA-24247 in this post. Resolve or Connect Privilege Debug Mode in SQL Developer A. Resolve or Connect Privilege For… Read More »How to Resolve ORA-24247: network access denied by access control list (ACL)
How to Resolve SP2-0158: unknown SHOW option
SP2-0158 SP2-0158 means that the issued command is not supported by this release of SQL*Plus utility. For example, we use SQL*Plus 11.2.0.4 to connect to… Read More »How to Resolve SP2-0158: unknown SHOW option
SQL Developer for MySQL
How do I enable MySQL in SQL Developer? By default, SQL developer can be used to connect only Oracle databases. As you can see, there's… Read More »SQL Developer for MySQL