Interesting AOL sites

I go to these sites quiet often and hence thought of sharing it with you all.

For yoga related info, check this out:
http://artoflivingyoga.org/index.php

For the daily dose of wisdom, check this out:
http://wisdomfromsrisriravishankar.blogspot.com/
http://www.facebook.com/#!/pages/Sri-Sri-Ravi-Shankar/330938752535?ref=ts

To check for an upcoming AOL course in your area , go to
http://us.artofliving.org/
Select the state and area and it will list all the upcoming AOL courses in that area.....


For Ramdev yoga
For controlling obesity : http://www.youtube.com/watch?v=lM6Yu1Q6u8k
English version :  http://www.youtube.com/watch#!v=2xqgW1AzBLc&feature=channel

Pranayam (Breathing excercise) http://www.youtube.com/watch#!v=1e77exc7ukI&feature=related

Upcoming AOL Course in Union City and Art Excel course in Castro Valley

There is an Art of Living course (part 1 course) happening in Union City from March 17th to March 21. You can find more information at :

http://secure.artofliving.org/course_details.aspx?course_id=6720

Also, for the first time in Castro valley (about 5 minutes from my residence) an ART Excel course is happening from March 25th to March 28th. You can find more information at :

http://secure.artofliving.org/course_details.aspx?course_id=6750

ART EXCEL course is for kids between 8 to 13 years of age. You can find more information for ART EXCEL course at http://www.artoflivingyouth.org/kidzone.html

Oracle Configuration File

Oracle configuration file:

Oracle reads configuration parameters from either server parameter file (SPFILE) or text initialization parameter file (PFILE). When you start database instance, it tries to read SPFILE in default location. Else it searches for pfile. The search order is as under:

• spfileORAACLE_SID.ora
• spfile.ora
• initORACLE_SID.ora

The default location for spfile and pfile is OH/dbs. If ASM is present, SPFILE default location is the same disk group as the datafiles.Alter system has optional scope clause that specifies the scope of the change

• scope=spfile : The change is applied only to spfile only which impliesNo change is made to the current instance. For both dynamic and static parameters, the change is effective at the next startup and is persistent.
• SCOPE=memory The change is applied in memory only which impliesThe change is made to the current instance and is effective immediately. For dynamic parameters, the effect is immedidate , but is not persistent as the server parameter file is not updated. This specification is not allowed for static parameters
• SCOPE=both  The change is applied to both server parameter file and memory which implies The change is made to the current instance and is effective immediately. For dynamic parameters, the effect is persistent. For static parameters, this specification is not allowed.

The default is both if SPFILE is used for startup and MEMORY if pfile is used for startup.
You can use deferred keyword for dynamic parameters, indicating to defer the change for the future sessions.

Managing the Oracle Instance

Stages of database startup and shutdown:

• Startup nomount:
  •  Initialization parameter file is read
• startup open
  •  datafiles and redo log files are read
• startup mount
  •  control files are read

Oracle shutdown options:

• Shutdown normal
• no new connections are allowed

before database is shutdown, the database waits for
all connected users to disconnect recovery is not required on startup

• shutdown immediate
• no new connections are allowed, nor are new transactions allowed to be started after the statement is issuedAny uncommited transactions are rolled back Database rollbacks active transactions and disconnects all users Recovery is not required on startup
• shutdown transactional
• Prevents clients from losing work and at the same  time does not require all users to log off ( no new transactions are allowed, existing transactions are completed and users disconnected after their transactions have completed)no recovery is required
• shutdown abort

Issue this command when
You have problems starting a database instance
When you have to shut down the database instantaneously
No new connections are allowed nor are any new transactions allowed

Current SQL statements are immediately terminated
Uncomitted transactions are not rolled back
Oracle disconnects all the connected users
Recover is required on startup
shutdown timeout
If recovery is required, Oracle starts SMON (system
monitor process) to do the recovery after opening the database.

Managing Schema Objects

Create and Modify tables:
TBD



Manage Constraints: An integrity constraint defined on the table can be in one of the following states

• enable, validate (validate is default if constraint is enabled)
• enable, novalidate
• disable, validate
• disable novalidate (novalidate is default if constrant is disabled)

Create Indexes:
TBD


Create and use temporary tables
The definition of a temporary table is visible to all sessions, but the data in a temporary table is visible only to the session that inserts data into the table. There are two types of temporary tables:

• Session specific
• The db truncates the table when you terminate the session
• Specified by ON COMMIT PRESERVE ROWS clause

• Transaction specific
• The db truncates the table after each commit.
• Specified by ON COMMIT DELETE ROWS clause.

By default temporary tables are stored in the default temporary tablespace of the user who created it. You can alternatively create a temporary tablespace and create the temporary table on that tablespace. Eg: create global temporary table test_temp (startdate date, ......) on commit DELETE ROWS [tablespace some_temp_tbsp]

Performing Database Recovery

Overview of Data recovery advisor:

Data recovery manager is a tool to help reduce MTTS (Mean time to recover). The GUI of data recovery manager is available in database control and grid control by selecting Perform Recovery in Availability tab. Data recovery manager has following commands:

• LIST FAILURE
• To list all the failures
• ADVISE FAILURE
• View repair options which typically include both automated and manual options.
• REPAIR FAILURE
• To repair failure automatically. Once the failure is repaired, the repair failure command closes the relevant repaired failure.
• CHANGE FAILURE
• Used to alter the status and priority of failure. You can change the status of the failure to closed when you manually repair it. You can also change the priority to high or to prioritu low. You cannot set the status to open nor can you set the priority to critical by issuing this command.

Some examples:

• To list all failures:
• rman > list failure

• To list details of a particular failure

• rman > list failure detail

• List a subset of failure

• rman > list failure low ( low is the failure priority; high and critical are the other two failure priority values)
• rman > list failure close
• rman > list failure exclude failure

• To determine repair options for a subset of failure

• rman > advice failure <failure id>

• To see what will be repaired if repair failure command is invoked

• rman > repair failure preview 

• After you list failures with list failure command, you should execute advise failure command before invoking repair failure command. Calling repair failure command before advise failure command results in error. 
• Repair failure command repairs High and Critical failures in ADR and then closes them if they are fixed
• DRA can be used to detect and analyze data failures in single instance database but not in RAC.
• All failures can be automatically repaired by DRA except network I/O failures, which usually needs human intervention.

Announcing free workshop and AOL course in San Leandro

Experience the power of breath and lead a life full of energy and happiness. Art of Living is pleased to announce the following two courses in San Leandro,CA. Free Science of Breath workshop

• When : Jan 17th at 12pm
• Where : All Saints Episcopal Church 911 Dowling Blvd, San Leandro, CA
• Contact : Meera at 510-825-7462
• Course fee : FREE
• More Information: http://us.artofliving.org/sanleandro

Art of Living Basic Course:

• When : Jan 28 to Jan 31
• Where : All Saints Episcopal Church. 911 Dowling Blvd, San Leandro, CA
• Contact : Meera at 510-825-7462
• Course fee : $175 (Offered at discounted price only this month)
• More Information: http://us.artofliving.org/sanleandro