background preloader

TIPS

Facebook Twitter

Olsadef esp v101003 070586. Licenciamiento Oracle para bases de datos. Questions & Answers from SQL Developer Tips & Tricks ODTUG Webinar. Tell Others About This Story: We had a great webinar yesterday with more than 350 people attending.

Questions & Answers from SQL Developer Tips & Tricks ODTUG Webinar

Even tacking on 10 minutes at the end, I didn’t have enough time to answer all the questions (31!) So I’m going to tackle them here in quick order. If you want a more detailed answer, use the search form on your right as I’ve probably covered the topic you’re asking about in more depth and detail. Top 10 Tips & Tricks for Oracle SQL Developer. Tell Others About This Story: Being a short week due to the holiday, and with everyone enjoying their Summer vacations (apologies Southern Hemispherians), I reckoned it was a great time to do one of those lazy recap-Top 10-Reader’s Digest type posts.

Top 10 Tips & Tricks for Oracle SQL Developer

I’ve been sharing 1-3 tips or ‘tricks’ a week since I started blogging about SQL Developer, and I have more than enough content to write a book. …el día a día… » Base de Datos. ¿spfile o init.ora? Oracle large pool tips. Question: What is the Oracle large pool and how is the large pool used within the SGA?

Oracle large pool tips

Answer: The large pool buffer is an important part of the Oracle 11g SGA that provides the following functions: Parallel Query performance management. Recovery Manager (RMAN) backup and recovery operations. Shared Server operations (MTS) - NOT recommended! It is recommended to use the Oracle 11g Automatic Shared Memory Management (ASMM) discussed earlier to size the SGA buffers, including the large pool. Controlfiles - Control File Concepto. Oracle Tips and Tricks of the Week Part 2. Using UTL_TCP to send E-Mail from PL/SQL with Oracle 8.1.6 The UTL_TCP is a TPC/IP package that provides PL/SQL procedures to support simple TCP/IP-based communications between servers and the outside world.

Oracle Tips and Tricks of the Week Part 2

It is used by the SMTP package, to implement Oracle server-based clients for the internet email protocol. For more information see: Oracle8i Supplied PL/SQL Packages Reference Release 2 (8.1.6). The following procedure SEND_MAIL can be used to send an E-Mail directly from the database. Oracle Database 9i – Basic Architecture. Introduction This post is regarding the basic database architecture for 9i.

Oracle Database 9i – Basic Architecture

Its been very late to upload this basic stuff, but I realized that it would be an incomplete blog without having even a brief architecture. So here it is. Below is the figure which gives a overview of “Inside Oracle”. Comunidad Oracle Hispana. 100 Things You Probably Didn't Know About Oracle Database. Recently, while delivering a presentation on Cache Fusion at New York Oracle Users Group (www.nyoug.org), the regional user group where I have been a long time member, I was surprised to hear from many participants some beliefs they had held for a long time that were completely wrong.

100 Things You Probably Didn't Know About Oracle Database

I always thought these were as obvious as they come; but of course I was dead wrong. What was even more surprising that most of these believers were veterans in Oracle Database technologies; not newbies. Part of the problem – I think – lies with the system that focuses on the execution rather than learning and part of it due to the lack of clear documentation. The Arup Nanda Blog: 100 Things You Probably Didn't Know About Oracle Database. Un commit hace que mi informacion se escriba en los datafiles? ORACLE-BASE - DBA Scripts for Oracle 12c, 11g, 10g, 9i and 8i. Comunidad Tecnológica de Oracle en Latinoamérica. Dbms_ijob Tips. Oracle Spin - Flimatech Blog. DBMS_JOB allows one to create/manage jobs under user who has logged but using sys.dbms_ijob one can manage jobs all jobs scheduled in DBA_JOBS.

Oracle Spin - Flimatech Blog

Here are some of the functions available in sys.dbms_ijob.To execute/run job: You don’t have to be an owner of the job SQL> exec sys.dbms_ijob.run(5); If one tried executing the job not owned by the user using DBMS_JOB, one can’t run it and you will get the following error “ORA-23421: job number 21 is not a job in the job queue” To enable/disable job: -- to disable a job.

Note one should set this when the job is not running by checking DBA_JOBS_RUNNING, because if the job is running you will have to wait till it finishes before disabling it and it has to be followed by a commit. Oracle PL/SQL Database Code Library and Resources. ORACLE-BASE - Oracle Naming Conventions. Home » Articles » Misc » Here Nothing is carved in stone, but these are the sort of rules I follow: Entities & Tables.

ORACLE-BASE - Oracle Naming Conventions

Oracle Naming conventions. Table names are plural, field name is singularTable names should not contain spaces, words should be split_up_with_underscores.The table name is limited to 30 bytes which should equal a 30 character name (try a DESC ALL_TABLES and note the size of the Table_Name column) If the table name contains serveral words, only the last one should be plural: APPLICATIONS APPLICATION_FUNCTIONS APPLICATION_FUNCTION_ROLES There are pros and cons to adding a prefix or suffix to identify tables-Pros: If most access will be made via VIEWS then prefixing all the tables with T_ and all the views with V_ keeps things organised neatly, you will never accidentally query the wrong one.Cons: Suppose, your naming convention is to have the '_TAB' suffix for all tables.

Oracle Naming conventions

According to that naming convention, the APPLICATIONS table would be called APPLICATIONS_TAB. If as time goes by, your application gets a second login, perhaps for auditing, or for security reasons. Oracle Dba: Flash Recovery Area. 1.

Oracle Dba: Flash Recovery Area

What is a Flash Recovery Area ? The flash recovery area is an Oracle-managed directory, file system, or Automatic Storage Management disk group that provides a centralized disk location for backup and recovery files. All the files you need to completely recover a database from a media failure are part of the Flash Recovery Area. Oracle creates archived logs and flashback logs in the flash recovery area. DBA Junior. Oracle MAA – Arquitecturas de referencia. Oracle En Español: Que es un Online Redo Log. Cajón de sastre sobre oracle. Oracle En Español: El caso curioso del datafile que "pertenecía" a dos Bases de Datos.