Critical Patch Update - January 2011. Description A Critical Patch Update is a collection of patches for multiple security vulnerabilities.
It also includes non-security fixes that are required (because of interdependencies) by those security patches. Critical Patch Updates are cumulative, except as noted below, but each advisory describes only the security fixes added since the previous Critical Patch Update. Thus, prior Critical Patch Update Advisories should be reviewed for information regarding earlier accumulated security fixes.
Optimizing Performance. This chapter describes how to optimize connection performance.
This chapter contains these topics: Configuring Session Data Unit Under typical database configuration, Oracle Net encapsulates data into buffers the size of the session data unit (SDU) before sending the data across the network. Oracle Net sends each buffer when it is filled, flushed, or when an application tries to read data. ORACLE - DBA Tips Corner. By Jeff Hunter, Sr.
Database Administrator Copyright (c) 1998-2014 Jeffrey M. Hunter. All rights reserved. All articles, scripts and material located at the Internet address of is the copyright of Jeffrey M. I have made every effort and taken great care in making sure that the material included on my web site is technically accurate, but I disclaim any and all responsibility for any loss, damage or destruction of data or any other property which may arise from relying on it.
Importing into Oracle tutorial. Brian Peasland: This is a pretty common procedure, which isn't too hard to accomplish.
So here is a step-by-step guide. Export the entire schema from production: exp userid=system file=user_a.dmp log=user_a.log owner=a FTP the dump file (in BINARY mode) to the development server. Make sure user B exists in your development instance. Run this command: imp userid=system file=user_a.dmp log=imp.log fromuser=a touser=b The only big sticking point is that user B may have a different default tablespace than user A, if user A exists. Brian Peasland: You can do this a few ways.
If you are not using 9i, or do not wish to use this method, then you can use the UTL_FILE supplied package. Karen Morton: You can run imports of the same dump file multiple times BUT you must make sure that if you do, you do it in such a way as to not create duplicates or attempt to "re-do" work you accomplished in a previous import. I would stay away from LONG RAWS since they are more restrictive and will be desupported soon. Managing Oracle Software and Applying Patches.
Oracle 10g Install Guide for Linux redhat enterprise , linux fedora and linux redhat 9. The following procedure is a step-by-step guide (Cookbook) with tips and information for installing Oracle Database 10g on Red Hat Linux. Oracle10g is the easiest Oracle on Linux installation so far. This guide shows how I installed: - Oracle 10g (10.1.0.3) on Red Hat Enterprise Linux Advanced Server 4 (RHELAS4) - Oracle 10g (10.1.0.2) on Red Hat Enterprise Linux Advanced Server 3 (RHELAS3) - Oracle 10g (10.1.0.2) on Red Hat Enterprise Linux Advanced Server 2.1 (RHELAS2.1) - Oracle 10g (10.1.0.3) on Red Hat Fedora Core 3 (FC3)
Oracle 10g Central : Database Security and Oracle Patches – Part 4. Oracle Functions - Sum, Average, Max, Min... Oracle Tablespaces. Create table t_contig_space ( tablespace_name VARCHAR2(30), file_id NUMBER, block_id NUMBER, starting_file_id NUMBER, starting_block_id NUMBER, blocks NUMBER, bytes NUMBER) tablespace uwdata; CREATE OR REPLACE VIEW v_contig_space AS SELECT SUBSTR(tablespace_name,1,20) TABLESPACE_NAME, starting_file_id, starting_block_id, SUM (blocks) sum_blocks, COUNT(blocks) count_blocks, MAX(blocks) max_blocks, SUM (bytes)/1024/1024 SUM_MB FROM tl_contig_space GROUP BY tablespace_name, starting_file_id, starting_block_id; DECLARE CURSOR query IS SELECT * FROM dba_free_space ORDER BY tablespace_name, file_id, block_id;
