Projects tagged ‘dba’ and ‘oracle’

Eclipse SQL Explorer is a thin SQL client that allows you to query and browse any JDBC compliant database. It supports plugins with specialized functionality for individual databases (Oracle, DB2 and ... [More] MySQL) and can be extended to include specialized support for other databases. The project started as a fork from the original JFaceDb project which has gone commercial and uses some of the core libraries of SQuirreL SQL. [Less]

EnglishThis management tool is designed for the Oracle RDMS. The tool was developed using Borland Delphi 7.0 programming environment which provides fast Access to the Oracle database. The code was ... [More] developed after examining techniques to determine the fastest and the most effective ways of database Access to increase the overall performance of the system. As a consequence of this study, the most effective techniques and SQL statements are determined for better performance and put into action. DBAExplorer allows you to access an Oracle database and perform any administrative task. Here are some of the features of DBAExplorer: Object Browser: you can browse through the database objects like, Schema, Tables, Packages, Sequences, Views, Procedures, DB Links, Synonyms, Functions and advanced objects etc. DBA Utilities: Allows DBAs to perform administrative tasks in a convenient way and most of the time with just clicks. It allows you to create Tablespaces, Rollback Segments, Users and redo log files. DBAConnect also allows you to manipulate all the information regarding an instance, SGA, Block, Free space and to alter wherever it is needed. Developer Utilities: Allows you to perform the developers related actions like creating tables, views, synonyms, DB Links, Procedures, Functions, Packages and Types. It allows you to execute any SQL command through an editor window. Also provides search facility to find any object, dependencies, relationships between tables and privileges. DBA Admin: Instance Monitoring & Space Management: includes active and running jobs, SGA information (Shared pool, Library cache, UGA space used, Data Dictionary, Redo log buffer cache, Database buffer cache), Free space information, Locks, Redo log files, Object and Data files, Rollback segment, Session information, User information, Table Space and Data files. You can change or alter any information by clicking on the active link for example to drop a user or to kill a session or even to change control files. If you have any questions, comments, or suggestions please contact me. alpaslankilickaya@gmail.com Note: You must install Oracle Client (9i - 10g) before trying this program. TürkçeOracle veri tabanı yönetim sistemi için hazırlanmış bir Veri Tabanı Yönetim Aracıdır. Yazılan program, veri tabanına hızlı erişim sağlayan Borland Delphi 7.0 programlama dili ile geliştirilmiştir. Programın hazırlanmasında veri tabanı erişim yöntemleri incelenmiş, en hızlı ve etkin bağlanma şekilleri araştırılmıştır. Yapılan araştırmalar sonucunda en etkin performans yöntemleri ve SQL cümleleri bulunmuş ve hazırlanmıştır. Eğer herhangibir öneri veya sorunuz var ise benle irtibat kurabilirsiniz. alpaslankilickaya@gmail.com [Less]

This is a new intiative to develop a unique Dashboarding application. The development will be in PHP. The studio will allow to connect to any database and Excel files. It will allow you to create ... [More] reports and Dashboards. Dashboard Studio will be able to import dashboard definitions directly from InfoCaptor Designer. It will also have in-built role and security mechanism. This will be a totally new application from InfoCaptor which is a java based Dashboard application. [Less]

a plsql utility for easily determining table sizes. The data returned includes table data size, index size, and lob size. Each value is returned individually, and also summed to provide a total ... [More] table size. Figured are reported in MB and GB. To run, first create the types and then the package. This currently works for the current user, I'm going to modify it to accept a schema as input and point the references to all_tables/all_segments/all_indexes/all_lobs instead of the user views. to execute, run select from table(table_info_pkg.table_info(table_name)); where table_name is a string. example: select from table(table_info_pkg.table_info('CLAIMS')); [Less]

COMING SOON.... AnyDBA will be a library of SQL scripts for Oracle & MySQL DBAs. AnyDBA will provide easy database monitoring and troubleshooting scripts which can manage many databases from ... [More] one place. The scripts are developed in pure SQL using SQL*Plus / mysql command line tools. [Less]

OraClever, Oracle RDBMS Administrator Client Layer Enhanced Visual Edit and Repair toolkit, is a oracle toolkit to make oracle to be used and managed with ease.

Report Oracle Database Info