|
|
Viewing 0 - 20 out of 10 Articles |
- How to Schedule or Automate Backup through Crontab
How to Schedule or Automate Backup through Crontab Schedule or Automate Backup is a needed thing almost in all
environment. We can do automate or scheduling tasks through two ways, one is DBMS_SCHEDU......
Posted in:
Oracle | By:
Hari | Date: 04 Sep 2008 10:53 pm |
Comments (0)- cebkngsv
aiowfzme http://mepnsgvl.com bhldbtiq jrnjkqns wanprmdt [URL=http://vqatisea.com]krmckdxw[/URL]......
Posted in:
Oracle | By:
| Date: 11 Feb 2010 12:45 am |
Comments (0)- Optimize Data Access Path in Oracle
To achieve optimum performance for data-intensive queries, materialized views and indexes are essential when tuning SQL statements. The SQL Access Advisor enables to optimize data access paths of SQL ......
Posted in:
Oracle | By:
Admin | Date: 06 Feb 2010 2:13 pm |
Comments (0)- Oracle INSERT Performance
Yesterday we had an issue to increase the speed of insert statements. We had to insert about 500K record to database as quickly as possible. We were inserting at a rate of 10 records/sec. Well, I was ......
Posted in:
Oracle | By:
Admin | Date: 06 Feb 2010 2:09 pm |
Comments (0)- When you would make Index and when not.
* Create an index if you frequently want to retrieve less than 15% of the rows in a large table.
* To improve performance on joins of multiple tables, index columns used for joins.
* Small table......
Posted in:
Oracle | By:
Admin | Date: 06 Feb 2010 2:06 pm |
Comments (0)- Convert CLOB to BLOB
Convert CLOB to BLOB
I will write a procedure clob_blob_proc which convert description
column of test table of type clob to blob. Here is the procedure.
1)Create a Table with Clob Column:
----......
Posted in:
Oracle | By:
| Date: 04 Sep 2008 11:20 pm |
Comments (5)- difference b/w fal_client and fal_server
FAL_CLIENT <service_name> of the current host database which will act as client for the archive log shipping
FAL_SERVER <service_ name> of the standby or remote database which will be shi......
Posted in:
Oracle | By:
Hari | Date: 06 Sep 2008 4:22 pm |
Comments (2)- How to monitor alert log file in Oracle
How to monitor alert log file in Oracle
We know in a UNIX system with tail -f we can monitor alert log file to see how alert log file is populated. For example the latest happenings in alert log file......
Posted in:
Oracle | By:
Hari | Date: 04 Sep 2008 10:36 pm |
Comments (2)- How to determine free memory and used memory in Oracle
How to determine free memory and used memory in Oracle
The summary information of the SGA is determined by,
SQL> select * from V$SGA;
NAME VALUE
------------ --------- --------- --------- ------......
Posted in:
Oracle | By:
Hari | Date: 04 Sep 2008 10:35 pm |
Comments (0)- How to know database initialization parameter in oracle
How to know database initialization parameter in oracle 1)SHOW PARAMETER option: If you
use SQL*Plus then you can use SHOW PARAMETER parameter_name to display
the values of parameters currently in u......
Posted in:
Oracle | By:
Hari | Date: 04 Sep 2008 10:33 pm |
Comments (0)
