*** ENG *** Welcome to this blog where you will find some technical notes related to Oracle Database issues. Hope you enjoy it! Access All Posts here *** ESP *** Bienvenid@s a este blog donde puedes encontrar notas sobre Oracle. Espero que te sea de utilidad! Acceder a todos los posts en español aquí Sergio…
http://oradbnotes.wordpress.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Friday
LOAD TIME
0.1 seconds
16x16
32x32
PAGES IN
THIS WEBSITE
5
SSL
EXTERNAL LINKS
0
SITE IP
192.0.78.12
LOAD TIME
0.141 sec
SCORE
6.2
oradbnotes | Notes about Oracle and other database issues | oradbnotes.wordpress.com Reviews
https://oradbnotes.wordpress.com
*** ENG *** Welcome to this blog where you will find some technical notes related to Oracle Database issues. Hope you enjoy it! Access All Posts here *** ESP *** Bienvenid@s a este blog donde puedes encontrar notas sobre Oracle. Espero que te sea de utilidad! Acceder a todos los posts en español aquí Sergio…
oradbnotes.wordpress.com
Network mode imports (NETWORK_LINK) | oradbnotes
https://oradbnotes.wordpress.com/2011/07/24/network-mode-imports-network_link
Notes about Oracle and other database issues. Laquo; How to resize the online log groups (redo log). Mover índices y tablas de tablespace. Network mode imports (NETWORK LINK). July 24, 2011. With network mode imports, one doesn’t need any intermediate dump files ( no more FTP’s of dump files). Data is exported across a database link and imported directly into the target database. Tables with long (lob, etc) types will not import their data, but will create their structure. Here is an example:. Saber qué ...
Saber qué procedimientos usan una tabla | oradbnotes
https://oradbnotes.wordpress.com/2011/07/27/saber-que-procedimientos-funciones-etc-hacen-uso-de-una-determinada-tabla
Notes about Oracle and other database issues. Laquo; LogMiner (DBMS LOGMNR). Uso básico. Auditoría sobre una tabla en Oracle. Saber qué procedimientos usan una tabla. July 27, 2011. Aquí está una manera de poder saber qué procedimientos, funciones, etc. están haciendo uso de una determinada tabla. Existe una vista llamada user dependencies. Que nos ayuda a llevar a cabo esa tarea. La forma de utilizarla es muy simple:. Select name, type, referenced name, referenced type. Leave a Reply Cancel reply.
Auditoría sobre una tabla en Oracle | oradbnotes
https://oradbnotes.wordpress.com/2011/07/27/56
Notes about Oracle and other database issues. Laquo; Saber qué procedimientos usan una tabla. Auditoría sobre una tabla en Oracle. July 27, 2011. Se puede realizar una auditoría sobre una tabla en Oracle, para saber qué acciones (inserciones, actualizaciones, etc.) se van realizando sobre ella. Para ello se puede crear un procedimiento al que se le pase como parámetro el nombre de la tabla a auditar. Se crearán dos tablas, maestro-detalle ( audit log y audit log columns). P table IN VARCHAR2,. L pkey := ...
Mover índices y tablas de tablespace | oradbnotes
https://oradbnotes.wordpress.com/2011/07/26/mover-indices-y-tablas-de-tablespace
Notes about Oracle and other database issues. Laquo; Network mode imports (NETWORK LINK). LogMiner (DBMS LOGMNR). Uso básico. Mover índices y tablas de tablespace. July 26, 2011. Podemos ver qué indices queremos mover:. Select index name,tablespace name from dba indexes where tablespace name ’TBINDICES’ and owner=’OWNER’. Y para cambiarlos de tablespace, simplemente ejecutar lo siguiente:. ALTER INDEX OWNER.CONSTRAINT NAME REBUILD TABLESPACE NOMBRETABLESPACEINDICES;. En cuanto a las tablas:.
July | 2011 | oradbnotes
https://oradbnotes.wordpress.com/2011/07
Notes about Oracle and other database issues. Archive for July, 2011. Auditoría sobre una tabla en Oracle. July 27, 2011. Read the rest of this entry? Saber qué procedimientos usan una tabla. July 27, 2011. Read the rest of this entry? LogMiner (DBMS LOGMNR). Uso básico. July 26, 2011. Read the rest of this entry? Mover índices y tablas de tablespace. July 26, 2011. Read the rest of this entry? Network mode imports (NETWORK LINK). July 24, 2011. Read the rest of this entry? July 24, 2011. July 22, 2011.
TOTAL PAGES IN THIS WEBSITE
5
Oracle DB Development – Changing the world, one line of code at a time
Help text as a modal dialog. To continue on the theme of help text in APEX, lets take a look at showing it in a modal. Help text in APEX in-line with page. Setting up help text in APEX is not hard but I often see it not done at all or implemented. Help text in APEX on a dedicated page. Use a dedicated page to show help text in APEX. Database is the marquee feature again. So every year before and during Oracle Open World we all complain about how data and database is brushed to. Get your virtual mojo on.
Information About Oracle DBA
Information About Oracle DBA. This is most useful frequently asked questions of RAC cluster database. Thursday, March 13, 2008. RAC Frequently Asked Questions. Why does netca always creates the listener which listens to public ip and not VIP only? Ct wants to use rconfig to convert a single instance to RAC but ct is using raw devices in RAC. Does rconfig support RAW? Can we designate the place of archive logs on both ASM disk and regular file system, when we use SE RAC? What software is necessary for RAC?
小施的幸福家园
九月 19th, 2014. ORA-00245: control file backup failed; target is likely on a local file system. By oradb, 195 views. ORA-00245: control file backup failed; target is likely on a local file system. Oracle@ebsdb1 ]$ rman target /. Recovery Manager: Release 11.2.0.4.0 – Production on Fri Sep 19 09:44:04 2014. Connected to target database: PROD (DBID=264535759). RMAN show all;. Using target database control file instead of recovery catalog. CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default. 七月 6th, 2014.
oradbn - oracle blog | Benedikt Nahlovsky – Oracle Database Administrator
Benedikt Nahlovsky – Oracle Database Administrator. Oradbn – oracle blog. Oracle Statspack und SQL zur Performanceanalyse Kostenlos aber effektiv. Sie möchten mehr zu Performanceanalyse mit Oracle Statspack und SQL erfahren? Hatte ich die Gelegenheit, zu diesem interessanten Thema einen Aritkel zu verfassen:. Http:/ www.informatik-aktuell.de/betrieb/datenbanken/oracle-statspack-und-sql-zur-performanceanalyse-kostenlos-aber-effektiv.html. Https:/ support.oracle.com/epmos/faces/DocumentDisplay? Today i was...
oradbnotes | Notes about Oracle and other database issues
Notes about Oracle and other database issues. Welcome – Bienvenid@. Welcome to this blog where you will find some technical notes related to Oracle Database issues. Hope you enjoy it! Access All Posts here. Bienvenid@s a este blog donde puedes encontrar notas sobre Oracle. Espero que te sea de utilidad! Acceder a todos los posts en español aquí. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public). Blog at WordPress.com.
Protected Blog › Log in
This site is marked private by its owner. If you would like to view it, you’ll need two things:. A WordPress.com account. Don’t have an account? All you need is an email address and password register here! Permission from the site owner. Once you've created an account, log in and revisit this screen to request an invite. If you already have both of these, great! Larr; Back to WordPress.com.
ORADBPRO Consulting Services & Publishing
ORADBPRO GmbH - Consulting Services and Publishing. ORADBPRO GmbH offers top notch ORACLE DBMS consulting to clients in the telecommunications, financial, automotive and IT industries primarily in Germany. ORADBPRO accept contract work for ORACLE database administration, design and software development. We strive not only to deliver sound administration, defect-free code and elegant software architectures, but also commit to high-quality documentation. More .
www.oradbsupport.com
This Web page parked FREE courtesy of CDV. Search for domains similar to. Is this your domain? Let's turn it into a website! Would you like to buy this. Find Your Own Domain Name. See our full line of products. Easily Build Your Professional Website. As low as $5.74/mo. Call us any time day or night (480) 624-2500.
Oracle Database Tips From My Notes
Oracle Database Tips From My Notes. Tuesday, June 9, 2015. Create Baseline to change execution plan hash value. When a query is having a new plan which is worst and you found by SQL tuning Advisor there is another plan which is having better execution time. There is a better plan in AWR as in above Fig. Steps to change plan hash value. Step1: Create SQL tuning set with SQL ID attached. Drop if same name exists before. Exec dbms sqltune.DROP SQLSET('sqlid 1vktnmmbp6cz3');. Create new one as follows. 08:35...
