Temporary Tablespace in Oracle 10g

Temporary tablespaces are used to manage space for database sort operations and for storing global temporary tables. For example, if you join two large tables, and Oracle cannot do the sort in memory, space will be allocated in a temporary tablespace for doing the sort operation.

Each database should have one temporary tablespace that is created when the database is created. A temporary tablespace uses temporary files (also called tempfiles) rather than regular datafiles.
TEMPFILEs are not fully initialised (sparse). When you create a TEMPFILE, Oracle only writes to the header and last block of the file. This is why it is much quicker to create a TEMPFILE than to create a normal database file.

An example to create Temporary Tablespace:
CREATE TEMPORARY TABLESPACE temp
TEMPFILE ‘/ora01/oracle/oradata/booktst_temp_01.dbf’ SIZE 50m;
DROP TEMPORARY TABLESPACE temp INCLUDING CONTENTS AND DATAFILES;

To view Temporary Tablespace details (including TEMFILES):
select * from v$tempfile

Posted in Uncategorized | Tagged , | Leave a comment

How to allow 32-bit Ubuntu Desktop to use more than 3 GB of RAM

This is enabled by a feature called Physical Address Extension (PAE), there is a kernel version in Ubuntu 32-bit that supports PAE, there is a meta package that does this for you, i.e. grabs the latest kernel version and allows future updates, just run:

“sudo apt-get install linux-generic-pae linux-headers-generic-pae”

Then restart your machine, Enjoy 🙂

Update: I’ve just restarted my computer, and it recognized my RAM, everything seems to be running fine till now, will keep you updated.

Posted in Uncategorized | Tagged , , , , , , , | Leave a comment

How to use Portrait and Landscape pages within the same document in OpenOffice

  1. Format->Styles and Formatting
  2. Click the Page styles
  3. Right click and select “New”, this will start creating a new style
  4. Name it “Portrait” or whatever name you need
  5. Click on the page tab and choose the orientation to be “Portrait”
  6. Do the above steps again for a style that you name “Landscape”, although it should be there by default, but if you don’t find it, just create it
  7. Whenever you need to switch the page orientation, click Insert->Manual Break->Page break, and choose the style you want to apply to the new page

Voila! There you go 🙂

Posted in Uncategorized | Tagged | Leave a comment

TechieNotes: Another Innovation Site .:: موهوبون ::.

.:: موهوبون ::..

Another Arabic site that promotes for innovation in the Middle East, that is worth promotion and support

 

Posted in Leadership, Management | Leave a comment

TechieNotes: Analog IC Design Course – Nile University-NISC Events & Media

Nile University-NISC Events & Media.

 

Nile University Logo

 

Advanced Analog IC Design

Nile University, Egypt, 8-10 November 2010

Professor Willy Sansen
Katholieke Universiteit Leuven-Belgium

 

 

AIM

This 3-day course has been designed to develop an in-depth knowledge on the design of analog integrated circuits, which have to achieve low power consumption. Many important aspects of analog design are covered, from the design of fully-differential operational amplifiers, to the design of switched-capacitor filters, low-power Sigma-Delta AD Converters and coupling effects between the digital and analog subblocks.

This course is intended for several categories of designers:

  • Novice designers to learn about design procedures, such that they can master the art of optimum design for low-power consumption
  • Digital designers to be able to design and to include low-power analog blocks on digital system chips
  • Designers with analog experience, to update their design knowledge

COURSE METHOD

This course consists of a series of lectures and several embedded design exercises. All lectures are taken from the book “Analog Design Essentials” (Springer 2006) which is handed out for this course.

COURSE CONTENT:

Day 1: Basic Topics
01. Comparison of MOST and bipolar-transistor models
02. Differential voltage and current amplifiers
03. Stability of operational amplifiers
04. Systematic design of operational amplifiers

Day 2: Advanced Topics
05. Important opamp configurations
06. Fully-differential operational amplifiers
07. Offset and CMRR; random and systematic
08. Bandgap and current reference circuits

Day 3: Selected Topics
09. Switched-capacitor filters
10. Low-power Sigma-Delta AD converters
11. Design of LNA’s
12. Coupling in mixed-signal circuits

TARGET PARTICIPANTS

The course is intended for graduate students and researchers as well as design engineers, and product managers at industry. Certificates of completion will also be given.

COURSE VENUE

The course will be held at Nile University’s
Campus, Juhayna Square, 6th of October City

Course Instructor

Willy Sansen has received the MSc degree in Electrical Engineering from the Katholieke Universiteit Leuven in 1967 and the PhD degree in Electronics from the University of California, Berkeley in 1972.
In 1972 he was appointed by the National Fund of Scientific Research (Belgium) at the ESAT laboratory of the K.U.Leuven, where he has been a full professor since 1980. During the period 1984-1990 he was the head of the Electrical Engineering Department. From 1984 to 2008 he was head of the ESAT-MICAS laboratory on analog design, which counts about sixty members and which is mainly active in research projects with industry and in teaching worldwide.
In 1978 he was a visiting professor at Stanford University, in 1981 at the EPFL Lausanne, in 1985 at the University of Pennsylvania, Philadelphia, in 1994 at the T.H. Ulm and in 2004 at Infineon, Villach. Prof. Sansen is a member of several editorial and program committees of journals and conferences. He is cofounder and organizer of the workshops on Advances in Analog Circuit Design in Europe. He is a member of the executive and program committees of the IEEE ISSCC conference. He was program chair of the ISSCC-2002 conference and was President of the Solid-State Circuits Society in 2008/2009. He is a life-fellow of the IEEE.
He has been involved in design automation and in numerous analogue integrated circuit designs for telecommunications, consumer electronics, medical applications and sensors. He has been supervisor of over fifty-eight PhD theses in these fields. He has authored and coauthored more than 620 papers in international journals and conference proceedings and fifteen books, among which “Analog design essentials” (Springer 2008).

Posted in Leadership, Management | Tagged , , | Leave a comment