For those who don't have GUI tools like SQL developer or Enterprise Manager, you can still get an explain plan for a statement in SQL*Plus.… Read More »SQL Developer Explain Plan
Partitioned Index To align with the partitioned table we created by SQL developer previously, we can add a partitioned index for it to improve data… Read More »SQL Developer Create Index Partition
At the first time startup of SQL developer, you may want to new a connection to start to use the tool. But sometimes, you might… Read More »tnsnames.ora in SQL Developer
How do I Change NLS Date Format in SQL Developer ? Just like we said previously, NLS_DATE_FORMAT can be set at session, database or OS… Read More »SQL Developer NLS_DATE_FORMAT
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
In this post, we'll talk about how to monitor sessions and kill sessions in SQL developer. Monitor Sessions To monitor sessions in SQL developer, you… Read More »SQL Developer Kill Session