Windows 8 Developer Preview

by Roman Akopov 16. September 2011 01:00

The Windows Developer Preview is a pre-beta version of Windows 8 for developers. These downloads include prerelease software that may change without notice. The software is provided as is, and you bear the risk of using it. It may not be stable, operate correctly or work the way the final version of the software will. It should not be used in a production environment. The features and functionality in the prerelease software may not appear in the final version. Some product features and functionality may require advanced or additional hardware, or installation of other software.

Windows Developer Preview downloads

Tags:

Network Access Protection by Sandro Galdava

by Roman Akopov 15. September 2011 23:03

Network Access Protection by Sandro Galdava

Tags:

Happy Programmers Day!

by Roman Akopov 13. September 2011 19:43

Tags:

Cisco Easy VPN Server by Kote Tvaltvadze

by Roman Akopov 9. September 2011 21:46

Cisco Easy VPN Server by Kote Tvaltvadze

Tags:

Lync 2010 Overview by Giorgi Jambazishvili

by Roman Akopov 8. September 2011 00:00

Microsoft Lync Server 2010 Overview by Giorgi Jambazishvili

Tags:

Installation Guide For Oracle TimesTen 11.2.1 In-Memory Database

by Vazha Mantua 25. August 2011 17:38

Good day all,

Today we will announced about a very nice type of database provided by Oracle. it’s Oracle TimesTen in memory database.

While installing a new technology, you can watch small presentation about this product, which I found on YouTube:

 

As you watched :

TimesTen is an in-memory relational database software product from Oracle. TimesTen is a high performance event-processing software component that enables applications to capture, store, use, and distribute information in real-time,
while preserving transactional integrity and continuous availability.

Full Articles about this product you can find on link: http://www.oracle.com/technetwork/database/timesten/overview/index.html

 

On This article we will provide you step by step procedure how install Oracle TimesTen 11.2.1 in Memory Database on Windows Platform 32 bit. Future We are going to publish some articles which deeply describe this product.

 

Let’s Start

 

Step 1: Install Software

First of all you should download installation package from Oracle:

You can download soft form link: http://www.oracle.com/technetwork/database/timesten/downloads/index.html

Run Setup.exe file , You can see in pictures steps , which you should done for installing software.

12

34

56

78

910

1112

13

After Installation software we should connect to DB

Step 2 Configure DSN

A Timesten Database is simply created by connecting to it, A first connection to an already-existing database results in loading the database in memory.Only A instance administrator can create TimesTen Database.

First of all We should configure system DSN for connecting to DB.

1. Go to control panel , then administrative Tools and Data Sources(ODBC)

2. Switch menu on System DSN part

3. Add System Data Source, named is my_ttdb

4. In Data Store Path browse directory in which you will store data

5. In Transaction Log Directory choose directory, where you will store log data.

6. Choose character set of DB, if you planning pin Oracle TimesTen Database on Oracle Database in future , choose character set, which you have an Oracle Database

7. In section First Connection you can set First connection attributes.

 

Step3 Connecting And Creating TimesTen Database

 

1. Enter ttisql at the OS Command prompt to launch ttIsql

2. For connecting to DB run connect “dns=my_ttdb”;

3. When the connect command returns , the database my_ttdb has been created and loaded into memory.

 

Now you can create users and object within database my_ttdb

 

Very useful instrument for TimesTen Database in SQL Developer. it’s very simple to use SQL Developer for TimesTen Database.

 

Status of Service you can get by command ttStatus from OS command prompt .

 

 

 

Tags: , , , , , ,

Oracle Announces Openworld 2011

by Vazha Mantua 24. August 2011 10:39

Oracle OpenWorld is an annual Oracle event for business decision-makers, IT management. It is held in San Francisco, California; São Paulo, Brazil,Shanghai and China. The world's largest conference for Oracle customers and technologists.

 

Openworld in 2010:

About 41,000 people will attend this year’s expo, up from 37,000 in 2009, said Tania Weidick, vice president of event marketing for Redwood City, California-based Oracle. Those guests will spend more than $100 million on hotel rooms, restaurants and shopping, the company said.

 

Oracle welcomes proposals for presentations on a wide variety of topics, with content targeted at all levels of attendees from beginner to expert. Attendees come from around the world representing thousands of Oracle customers and partners. At this time Oracle is also accepting proposals for Oracle Develop content.

Oracle Openworld 2011 starts on 2 of October and ends 6 of October in Moscone Center 747 Howard Street, San Francisco , CA, USA

Detail Information about this event you can find on link : http://www.oracle.com/openworld/index.html

Tags: , ,

DBMS_PROFILER - Identify performance bottleneck

by Vazha Mantua 22. August 2011 15:13

The dbms_profiler  package provides an interface to profile existing PL/SQL applications and identify performance bottlenecks. You can then collect and persistently store the PL/SQL profiler data.

The basic idea behind profiling with dbms_profiler is for the developer to understand where their code is spending the most time, so they can detect and optimize it.

Let see a example:

In Scott schema you have a procedure named create_client_information. Your goal is find which lines of source code of procedure is potential bottleneck .

Once you have run the profiler, Oracle will place the results inside the dbms_profiler tables.

First of all you should build appropriate tables and procedures for using dbms_profiler.

Step By Step:

 

1. Create necessary metadata for using dbms_profiler

   connect  as sysdba
run scripts @$ORACLE_HOME/rdbms/admin/profload.sql

    connect  as Scott 
run scripts @$ORACLE_HOME/rdbms/admin/proftab.sql

 

2. Delete unused data and start profiler for collecting information

delete from plsql_profiler_data;
delete from plsql_profiler_units;
delete from plsql_profiler_runs;
commit;

declare
  success binary_integer;
begin
  success := dbms_profiler.start_profiler(run_comment => 'test_run');

  if success <> 0 then
    dbms_output.put_line('could not start profiler');
  else
    dbms_output.put_line('Profiler started!');
  end if;
end;

3. Run procedure which you are testing now, for our example

begin  create_client_information(); end;

4. Stopping profiler

 select decode(
  dbms_profiler.stop_profiler,
  '0', 'Profiler Stopped',
  'Could not stop profiler')
from
  dual;

5. Get A results

 

First of all you should find which runid  is your case, you can get this information from statement:

select runid from plsql_profiler_runs
 
then you can get information with select

SELECT *
FROM PLSQL_PROFILER_DATA A,
     PLSQL_PROFILER_UNITS B
WHERE A.UNIT_NUMBER = B.UNIT_NUMBER
   AND A.RUNID = &ID

 

 With dbms_profiler you can find in which line of procedure you have a performance problem, but only find, it will not help you optimize code itself.

Tags: ,

ORA-00600: internal error code, arguments: [qctcte1], [0], [], [], [], [], [], []

by Vazha Mantua 18. August 2011 17:26
In a test DB we applied patch from 10.2.0.2 to 10.2.0.4 , after this procedure we could ’t compile a user specified view with error :ORA-00600: internal error code, arguments: [qctcte1], [0], [], [], [], [], [], []
On metalink there are a lot of articles and scenarios with this error, but I will focus on only one,which help us.
Problem
--------
SQL statement with aggregations and unions fail with
ORA-600: internal error code, arguments: [qctcte1], [0], [], [], [], [], [], [] during parse.


--------------------
Solution:
disable query_rewrite make it works fine.
alter session set "_complex_view_merging"=false;
Init parameter “_complex_view_merging”- Controls complex view merging.

Tags: ,

Now ocp.community.ge is on Facebook

by Vazha Mantua 17. August 2011 18:03

My friends, know you can find us on Facebook, on page ocp.community.ge. Please like this page Smile

From this moment you can be noticed about new articles form Facebook page

 

 

Vazha Mantua

Tags: ,