-
Dynamic SGA
What is Dynamic SGA?What is the advantage of Dynamic SGA?
hmounir
- May 3rd, 2010
Dynamic SGA allows to change the size of the buffer cache, the large pool, the shared pool and the process private memory on the fly, that is without shutting down the instance.
doza_kasf
- May 1st, 2010
Dynamic SGA allows to change the size of the buffer cache, that is without shutting down the instance.
-
Tablespace Fragmentation
How can you prevent tablespace fragmentation? (rebuilding, moving)?
vidyajnath
- Apr 23rd, 2010
As rows are added to tables, the table expands into unused space within the space. Conversely, when rows are deleted, a table may coalesce extents, releasing unused space back into the tablespace. As ...
-
Chained / Migrated Rows
Explain about the Chained / Migrated Rows
vidyajnath
- Apr 23rd, 2010
In two circumstances, the data for a row in a table may be too large to fit into a single data block. In the first case, called chaining, the row is too large to fit into an empty data block. In this ...
-
Oracle Background Processes
Outline the names and function of Oracle background processes
vidyajnath
- Apr 23rd, 2010
The Oracle architecture has five mandatory background processes Mandatory background processes: DBWR (Database Writer) PMON (Process Monitor) CKPT (Check Point) LGWR (Log Writer) SMON (System Monitor)...
-
Oracle Segments
What are the different types of segments in Oracle?
hmounir
- Apr 21st, 2010
Four types of segments are found in an Oracle database:1- Data segment every table in the database resides in a single data segment.2- Index segment each index is stored in its own index segment.3- Te...
narendra05
- Apr 16th, 2010
There are following types of segments in Oracle1. Data segments stores the data2. Index segment stores the index data3. Rollback segment : Stores undo data information for data consistency.
-
Acid Properties
What is Acid Properties in Oracle?
ushaudayam
- Mar 22nd, 2010
ACID Properties areAtomicity: A transaction is an atomic unit of execution, which may contain more than one database operation. The transaction should be done entirely or done nothing to keep data in ...
-
-
-
-
Record Focus
What is the built-in that tells you the record that the user is placed the fouces?
-
Count Last Transaction Records
How to count the last transaction number of record in singal table?How to view uncommited transaction / uncommited record?
-
Oracle Dbms Pipe Commands
Give the dbms_pipe commands in oracle of there execution,which are used to send & recieve messages what is the max size can sent at one go
Read Best Answer
Editorial / Best Answer
saginandkishore- Member Since Jun-2008 | Jun 24th, 2008
dbms_pipe is a IPC methodology which allows processes to communicate with each other using pipes.
The important functions/procedures in this package are
(1) CREATE_PIPE to create a new pipe
==> dbms_pipe.create_pipe(pipename) where pipename can be Oracle supplied or user defined as below
dbms_pipe.create_pipe(dbms_pipe.unique_session_name) -- Creates a PIPE based on your unique Session ID
or
pipename constant varchar2(100) := 'TEST_PIPE';
dbms_pipe.create_pipe(pipename);
(2) Having created the pipes try sending some data through the pipe. To send data prepare the data using dbms_pipe.pack_message(mesg_buf) where mesg_buf can be varchar2, char, number. Basically this procedure is overloaded for Numbers, Varchar2 and date. For long and raw data use the corresponding DBMS_PIPE.PACK_MESSAGE_RAW method. This procedure basically places the data into buffer which can be send on any pipe using the dbms_pipe.send_message(pipename) function.
(3) At the other end of the pipe you can receive the data using dbms_pipe.receive_message function. This functions fetches the data into buffer from where you can unpack the data using dbms_pipe.unpack_message function. This function gets the data in the buffer into a message buffer.
These are the basic commands that you can use for working with pipes. For more details visit oracle documentation.
imranbaig.geek
- Dec 1st, 2009
------Funtions------DBMS_PIPE.CREATE_PIPE:- for creating a pipeDBMS_PIPE.SEND_MESSAGE:- For sending messageDBMS_PIPE.REMOVE_PIPE:- for removing messageDBMS_PIPE.RECEIVE_MESSAGE:- For receiving message...
saginandkishore
- Jun 24th, 2008
dbms_pipe is a IPC methodology which allows processes to communicate with each other using pipes. The important functions/procedures in this package are(1) CREATE_PIPE to create a new pipe ==> dbms...
-
Oracle Unused Column
How to set unused column back to normal column?
-
Recover data from database block corruption error
How to solve the database block corruption error? even index also validated and recreated and don't have any backup.
-
How to Read *.csv File?
How to read columns from excel file (converted into *.CSV format) into Forms using upload button.
kishore.harname
- Oct 31st, 2009
You can use UTL_file package which is provide by Oracle to read & write data into csv file or use external table funda.
-
System_context
Why is sys_context used for providing privileges in Oracle?
reyazan
- Oct 16th, 2009
The sys_context function can be used to retrieve information about the Oracle environment.The syntax for the sys_context function is:sys_context( namespace, parameter, [ length ] )namespace is an Orac...
-
Install Oracle 9i in Vista
How to Install Oracle 9i in Vista?
-
Autonomous Transaction
What are the disadvantages of Autonomous Transaction?
-
Debug Oracle PL/SQL Package
How to Debug the Oracle PL/SQL Package?
-
AND - OR Operators
In the combination of Logical Operators - AND, OR (more than 2) operators which one gets 1st preference.
Oracle Basics Interview Questions
Read Best Answer
Ans