Tags » SQL Developer

OraSASH Everybodies ASH ??

Active Session History ASH is part of the diagnostic and tuning pack of the Oracle enterprise edition. Using a few sql statements you can find top events, tops sqls or top waiting sessions in your database. 154 more words

Database

Analyzing OraSASH or ASH with SQL Developer

My talk at DOAG will be about OraSASH which is a great tool simulating parts of Oracles diagnostic and tuning pack.  If you want to learn more about OraSASH you are invited to come to DOAG and listen to my talk or read on in one of my next posts. 225 more words

Database

SQL Developer and Big Data Appliance (sort of)

Recently, Enkitec received an Oracle Big Data Appliance (BDA) for our server farm in Dallas (Thanks Accenture!).  With this new addition to the server farm, I’m excited to see what the BDA can do and how to use it.   585 more words

Sql Developer

Remote Debug Oracle Database in a VirtualBox VM using SQL Developer

It’s possible to debug pl/sql code in an Oracle Database, in much the same way as you can in any interactive debugger environment. Jeff Smith… 1,346 more words

Oracle

What is in my ASM Diskgroups

ASM will be more and more used as a database storage. The ASM diskgroups and their size can be displayed using command line tool asmcmd or using v$asm views. 143 more words

Database