DatabaseJournal.com Staff

>>Script Language and Platform: Oracle Author: : Sunny Not all tools provide a GUI interface, making it difficult to find Oracle’s object referenced inside a PLSQL stored procedure. This script finds those objects. SELECT name, type referenced_owner, referenced_name, referenced_type, d.referenced_link_name from user_dependencies d where name= ‘AUTO_DISC_CAL’ order by referenced_owner, referenced_name, referenced_type Disclaimer: We hope that […]

>>Script Language and Platform: Oracle Author: Mir Sayeed Hassan This script will monitor CPU Usage Information. select ss.username, se.SID, VALUE/100 cpu_usage_seconds from v$session ss, v$sesstat se, v$statname sn where se.STATISTIC# = sn.STATISTIC# and NAME like ‘%CPU used by this session%’ and se.SID = ss.SID and ss.status=’ACTIVE’ and ss.username is not null order by VALUE desc; […]

By Mark Trinidad The sheer quantity of digital information available today makes storing, organizing and analyzing data extremely difficult. The issue is compounded by the fact that databases and big data stores are a prime target for hackers due to the amount of sensitive information residing within, including customer information, intellectual property and proprietary secrets. […]

>>Script Language and Platform: Oracle-PL/SQL Use this script to generate a random password. Author: Renan Medeiros create or replace function gera_passwd return varchar2 is passwd varchar2(30); passw1 varchar2(30); passw2 varchar2(30); passw3 varchar2(30); passw4 varchar2(30); zecond number; begin select dbms_random.string(‘Z’, 3), trunc(dbms_random.value(091, 999)), dbms_random.string(‘Z’, 2), trunc(dbms_random.value(07, 87)) into passw1, passw2, passw3, passw4 from dual; dbms_output.put_line(‘Password: ‘||passwd); […]

By Eliot Arlo Colon, Senior Vice President & Oracle Practice Leader, Miro Consulting, Inc. There is and will be significant impact to database performance and licensing with Oracle’s Database Standard Edition 2 (DBSE2) and its new licensing rules for the Standard Edition (SE) family. Oracle’s updated licensing terms and conditions has generated a number of […]

By Gerardo Dada, Vice President, Product Marketing and Strategy, SolarWinds Cloud computing is on the move. Slowly but surely, businesses are transitioning more and more key pieces of infrastructure to the cloud in order to take advantage of cost, flexibility and agility benefits. And databases, the heart and soul of all applications, are the most […]

Today’s world — the digital economy — runs in the cloud. Most consumers, including many business executives, don’t know much about the inner workings of the cloud or its architecture even though they expect a lot from it. We expect clouds — private, public and hybrid — to perform and deliver information quickly, even if […]

In today’s agile world, development teams must respond quickly to ever changing business needs. The traditional practice is to use a task management system, such as JiRA, TeamForge, TFS, RTC, or others. These systems manage the business requirements and break them into tasks for the developer who makes the change, both for the application code […]

>>Script Language and Platform: SQL Server Use this stored procedure to quickly capture all login information when needed, especially for security audit situations. Managing login and DB user permissions is among the responsibilities that DBAs must take care of. To catch the permission of all Users in a database or all permissions of a certain […]

By Gerardo Dada, Vice President, Database Group, SolarWinds For business executives looking to save on information technology costs, it may seem like a win-win scenario in Oracle database environments to transition from Oracle Enterprise to Standard Edition. CIOs who are eager to take advantage of cost savings of more than 70 percent may agree, as […]

In our previous article published on this forum, we have presented a somewhat unorthodox (from the perspective of a typical DBA or IT Pro – but certainly not that of a developer) method of managing Azure SQL Database that involves directly invoking REST APIs, providing an alternative to PowerShell-based scripting, which relies on Azure module […]

By Natik Ameen With the release of Oracle 12c, in September 2013, 500 plus new database features and enhancements were introduced to address specific problems customers were facing in their databases environments. This month, Larry Ellison, introduced one of the largest performance enhancing features, the Oracle 12c In-memory database option. This has dramatically changed the […]