Coursera is offering courses free online. The courses are delivered from faculty members of top universities in the world. You may find more information on the courses at:
https://www.coursera.org/
Happy learning !!!
Wednesday, October 10, 2012
Online Free Courses from World's Best Universities
Coursera is offering courses free online. The courses are delivered from faculty members of top universities in the world. You may find more information on the courses at:
https://www.coursera.org/
Happy learning !!!
Thursday, October 04, 2012
OOW-2012: Oracle 12c New Features
Blogging right from Tom's session "database new features". Here are the new features as they are discussed:
1. Identity Columns
Remember I blogged on this topic earlier.
2. Default on null
A default value is inserted into the column When it's null.
3. Improved defaults - metadata only defaults
Now add new default columns to a table on the fly. 12c does that for you.
4. Increased size limit for Varchar2 and NVarchar2
The column types can be upto 32k.
5. Row Pattern Matching
Efficient SQL functionality for reporting row patterns like identifying V and W patterns for your stock
6. Partitioning Improvements
Online partition movement without using DBMS_REDEFINITION. Efficient global index management during DROP and TRUNCATE partition operation.
7. Hybrid Histograms
Jonathan Lewis spoke on this topic. I think more information on this is available on his blog.
8. Session private statistics for GTTs
Table and index statistics are held private for each session.
9. Temporary UNDO
Undo for temporary tables can now be managed in TEMP. Reduces the amount of undo generated in undo tablespace and redo generation.
10. Pluggable databases
Read Roels blog for this one. He has a good blog post on this
http://roelhartman.blogspot.com/
1. Identity Columns
Remember I blogged on this topic earlier.
2. Default on null
A default value is inserted into the column When it's null.
3. Improved defaults - metadata only defaults
Now add new default columns to a table on the fly. 12c does that for you.
4. Increased size limit for Varchar2 and NVarchar2
The column types can be upto 32k.
5. Row Pattern Matching
Efficient SQL functionality for reporting row patterns like identifying V and W patterns for your stock
6. Partitioning Improvements
Online partition movement without using DBMS_REDEFINITION. Efficient global index management during DROP and TRUNCATE partition operation.
7. Hybrid Histograms
Jonathan Lewis spoke on this topic. I think more information on this is available on his blog.
8. Session private statistics for GTTs
Table and index statistics are held private for each session.
9. Temporary UNDO
Undo for temporary tables can now be managed in TEMP. Reduces the amount of undo generated in undo tablespace and redo generation.
10. Pluggable databases
Read Roels blog for this one. He has a good blog post on this
http://roelhartman.blogspot.com/
Wednesday, October 03, 2012
Oracle RAC 12c: New Features
Blogging live from OOW session on "Enhancements in Oracle RAC". Following are few Oracle RAC 12c new features being discussed in this session as I post:
1. Application Continuity
2. Oracle Flex ASM
With this feature, database instances use remote ASM instances.
3. Oracle ASM Disk Scrubbing
Checks for logical data corruptions and repair them automatically.
4. Enhancements to Policy-based Databases
Actively utilizes different sized servers
5. What - if analysis for server pool management
6. Standardized deployment and patching
Introducing GHS, rapid home provisioning and gold images
7. A new "ghctl" command for better patching
8. Oracle Utility Cluster
9. Dynamic IP Management and name resolution made easy
10. IPv6 Based IP Addresses Support for client connectivity
11. Multi-purpose Installation
12. Oracle installer will run Fix-up scripts & "root.sh" scripts across nodes. You don't have to run the scripts manually on RAC nodes.
Exciting new features !!!
1. Application Continuity
2. Oracle Flex ASM
With this feature, database instances use remote ASM instances.
3. Oracle ASM Disk Scrubbing
Checks for logical data corruptions and repair them automatically.
4. Enhancements to Policy-based Databases
Actively utilizes different sized servers
5. What - if analysis for server pool management
6. Standardized deployment and patching
Introducing GHS, rapid home provisioning and gold images
7. A new "ghctl" command for better patching
8. Oracle Utility Cluster
9. Dynamic IP Management and name resolution made easy
10. IPv6 Based IP Addresses Support for client connectivity
11. Multi-purpose Installation
12. Oracle installer will run Fix-up scripts & "root.sh" scripts across nodes. You don't have to run the scripts manually on RAC nodes.
Exciting new features !!!
Tuesday, October 02, 2012
OOW-2012: Very Large Databases (VLDB): Challenges and Opportunities
I would like to thank all the attendees for attending my session "Very Large Databases (VLDB): Challenges and Opportunities". I am glad, the hall was full to it's capacity. :)
You may download the presentation by logging into OOW-2012 schedule builder.
I request all the attendees to kindly rate my session by logging into OOW: Schedule Builder.
See you all !!!
You may download the presentation by logging into OOW-2012 schedule builder.
I request all the attendees to kindly rate my session by logging into OOW: Schedule Builder.
See you all !!!
Subscribe to:
Posts (Atom)