titel
14-04-2008
Klik hier om een link te hebben waarmee u dit artikel later terug kunt lezen.nieuw
Database Configuration Report
Database Configuration Report
 

 

Database:QUALNAVI.WORLD

 

Date:April 12, 2005 9:47:19 AM

Table Of Contents

Instance
Database and Instance Information
Database Options
SGA Information
Initialization Parameters
Schema
Schema Objects (non SYS and SYSTEM)
Security
General User Account Information
User Roles
Storage
Control files
Tablespaces
Datafiles
Rollback Segments
Redo Logs
Archive Logs

Instance

Database and Instance Information

DB Name QUALNAVI
Global Name QUALNAVI
DB Version Oracle8i Release 8.1.7.0.0 - Production
Host Name INS0ANTNT043
Instance Name qualnavi
Instance Start Time 10-Apr-2005
Restricted Mode NO
Archive Log Mode ARCHIVELOG
Read Only Mode NO

Database Options

Options
Objects
Connection multiplexing
Connection pooling
Instead-of triggers
Parallel load
N-Tier authentication/authorization

SGA Information

Name Size (K)
Database Buffers 200000
Fixed Size 74.02734375
Redo Buffers 76
Variable Size 309044

Initialization Parameters

Parameter Name Value Default Dynamic
O7_DICTIONARY_ACCESSIBILITY TRUE TRUE FALSE
active_instance_count   TRUE FALSE
always_anti_join NESTED_LOOPS TRUE FALSE
always_semi_join STANDARD TRUE FALSE
aq_tm_processes 0 TRUE IMMEDIATE
audit_trail NONE TRUE FALSE
background_core_dump partial TRUE FALSE
background_dump_dest D:ORA8173adminqualnavibdump FALSE IMMEDIATE
backup_tape_io_slaves FALSE TRUE DEFERRED
bitmap_merge_area_size 1048576 TRUE FALSE
blank_trimming FALSE TRUE FALSE
buffer_pool_keep   TRUE FALSE
buffer_pool_recycle   TRUE FALSE
commit_point_strength 1 TRUE FALSE
compatible 8.1.0 FALSE FALSE
control_file_record_keep_time 7 TRUE IMMEDIATE
control_files F:oradataqualnavicontrol01.ctl FALSE FALSE
control_files G:oradataqualnavicontrol03.ctl FALSE FALSE
control_files F:oradataqualnavicontrol02.ctl FALSE FALSE
core_dump_dest %ORACLE_HOME%RDBMSTRACE TRUE IMMEDIATE
cpu_count 1 TRUE FALSE
create_bitmap_area_size 8388608 TRUE FALSE
cursor_sharing EXACT TRUE IMMEDIATE
cursor_space_for_time FALSE TRUE FALSE
db_block_buffers 25000 FALSE FALSE
db_block_checking FALSE TRUE DEFERRED
db_block_checksum FALSE TRUE IMMEDIATE
db_block_lru_latches 1 TRUE FALSE
db_block_max_dirty_target 25000 TRUE IMMEDIATE
db_block_size 8192 FALSE FALSE
db_domain   TRUE FALSE
db_file_direct_io_count 64 TRUE DEFERRED
db_file_multiblock_read_count 8 FALSE IMMEDIATE
db_file_name_convert   TRUE FALSE
db_files 1024 FALSE FALSE
db_name qualnavi FALSE FALSE
db_writer_processes 1 TRUE FALSE
dblink_encrypt_login FALSE TRUE FALSE
dbwr_io_slaves 0 TRUE FALSE
disk_asynch_io TRUE TRUE FALSE
distributed_transactions 10 FALSE FALSE
dml_locks 748 TRUE FALSE
enqueue_resources 1792 TRUE FALSE
event   TRUE FALSE
fast_start_io_target 0 TRUE IMMEDIATE
fast_start_parallel_rollback LOW TRUE IMMEDIATE
fixed_date   TRUE IMMEDIATE
gc_defer_time 10 TRUE IMMEDIATE
gc_files_to_locks   TRUE FALSE
gc_releasable_locks 0 TRUE FALSE
gc_rollback_locks 0-128=32!8REACH TRUE FALSE
global_names FALSE FALSE IMMEDIATE
hash_area_size 800000 TRUE FALSE
hash_join_enabled TRUE TRUE FALSE
hash_multiblock_io_count 0 TRUE IMMEDIATE
hi_shared_memory_address 0 TRUE FALSE
hs_autoregister TRUE TRUE IMMEDIATE
ifile F:ORADATAqualnaviinitqualnavi.ora FALSE FALSE
instance_groups   TRUE FALSE
instance_name qualnavi FALSE FALSE
instance_number 0 TRUE FALSE
java_max_sessionspace_size 0 TRUE FALSE
java_pool_size 90M FALSE FALSE
java_soft_sessionspace_limit 0 TRUE FALSE
job_queue_interval 60 FALSE FALSE
job_queue_processes 4 FALSE IMMEDIATE
large_pool_size 130M FALSE FALSE
license_max_sessions 0 TRUE IMMEDIATE
license_max_users 0 TRUE IMMEDIATE
license_sessions_warning 0 TRUE IMMEDIATE
lm_locks 12000 TRUE FALSE
lm_ress 6000 TRUE FALSE
local_listener   TRUE FALSE
lock_name_space   TRUE FALSE
lock_sga FALSE TRUE FALSE
log_archive_dest G:oradataqualnaviarchlog FALSE IMMEDIATE
log_archive_dest_1   TRUE IMMEDIATE
log_archive_dest_2   TRUE IMMEDIATE
log_archive_dest_3   TRUE IMMEDIATE
log_archive_dest_4   TRUE IMMEDIATE
log_archive_dest_5   TRUE IMMEDIATE
log_archive_dest_state_1 enable TRUE IMMEDIATE
log_archive_dest_state_2 enable TRUE IMMEDIATE
log_archive_dest_state_3 enable TRUE IMMEDIATE
log_archive_dest_state_4 enable TRUE IMMEDIATE
log_archive_dest_state_5 enable TRUE IMMEDIATE
log_archive_duplex_dest   TRUE IMMEDIATE
log_archive_format %%ORACLE_SID%%T%TS%S.ARC FALSE FALSE
log_archive_max_processes 1 TRUE IMMEDIATE
log_archive_min_succeed_dest 1 TRUE IMMEDIATE
log_archive_start TRUE FALSE FALSE
log_archive_trace 0 TRUE IMMEDIATE
log_buffer 32768 FALSE FALSE
log_checkpoint_interval 10000 FALSE IMMEDIATE
log_checkpoint_timeout 1800 FALSE IMMEDIATE
log_checkpoints_to_alert FALSE TRUE FALSE
log_file_name_convert   TRUE FALSE
max_commit_propagation_delay 700 TRUE FALSE
max_dump_file_size 10240 FALSE IMMEDIATE
max_enabled_roles 30 FALSE FALSE
max_rollback_segments 37 TRUE FALSE
mts_circuits 0 TRUE FALSE
mts_dispatchers   TRUE IMMEDIATE
mts_listener_address   TRUE FALSE
mts_max_dispatchers 5 TRUE FALSE
mts_max_servers 20 TRUE FALSE
mts_multiple_listeners FALSE TRUE FALSE
mts_servers 0 TRUE IMMEDIATE
mts_service qualnavi TRUE FALSE
mts_sessions 0 TRUE FALSE
nls_calendar   TRUE FALSE
nls_comp   TRUE FALSE
nls_currency   TRUE FALSE
nls_date_format   TRUE FALSE
nls_date_language   TRUE FALSE
nls_dual_currency   TRUE FALSE
nls_iso_currency   TRUE FALSE
nls_language AMERICAN TRUE FALSE
nls_numeric_characters   TRUE FALSE
nls_sort   TRUE FALSE
nls_territory AMERICA TRUE FALSE
nls_time_format   TRUE FALSE
nls_time_tz_format   TRUE FALSE
nls_timestamp_format   TRUE FALSE
nls_timestamp_tz_format   TRUE FALSE
object_cache_max_size_percent 10 TRUE DEFERRED
object_cache_optimal_size 102400 TRUE DEFERRED
open_cursors 300 FALSE FALSE
open_links 4 FALSE FALSE
open_links_per_instance 4 TRUE FALSE
ops_interconnects   TRUE FALSE
optimizer_features_enable 8.1.7 TRUE FALSE
optimizer_index_caching 0 TRUE FALSE
optimizer_index_cost_adj 100 TRUE FALSE
optimizer_max_permutations 80000 TRUE FALSE
optimizer_mode CHOOSE TRUE FALSE
optimizer_percent_parallel 0 TRUE FALSE
oracle_trace_collection_name   FALSE FALSE
oracle_trace_collection_path %ORACLE_HOME%OTRACEADMINCDF TRUE FALSE
oracle_trace_collection_size 5242880 TRUE FALSE
oracle_trace_enable FALSE TRUE IMMEDIATE
oracle_trace_facility_name oracled TRUE FALSE
oracle_trace_facility_path %ORACLE_HOME%OTRACEADMINFDF TRUE FALSE
os_authent_prefix   FALSE FALSE
os_roles FALSE TRUE FALSE
parallel_adaptive_multi_user FALSE TRUE IMMEDIATE
parallel_automatic_tuning FALSE TRUE FALSE
parallel_broadcast_enabled FALSE TRUE FALSE
parallel_execution_message_size 2148 TRUE FALSE
parallel_instance_group   TRUE IMMEDIATE
parallel_max_servers 5 FALSE FALSE
parallel_min_percent 0 TRUE FALSE
parallel_min_servers 0 TRUE FALSE
parallel_server FALSE TRUE FALSE
parallel_server_instances 1 TRUE FALSE
parallel_threads_per_cpu 2 TRUE IMMEDIATE
partition_view_enabled FALSE TRUE FALSE
plsql_v2_compatibility FALSE TRUE IMMEDIATE
pre_page_sga FALSE TRUE FALSE
processes 150 FALSE FALSE
query_rewrite_enabled FALSE TRUE IMMEDIATE
query_rewrite_integrity enforced TRUE IMMEDIATE
rdbms_server_dn   TRUE FALSE
read_only_open_delayed FALSE TRUE FALSE
recovery_parallelism 0 TRUE FALSE
remote_dependencies_mode TIMESTAMP TRUE IMMEDIATE
remote_login_passwordfile EXCLUSIVE FALSE FALSE
remote_os_authent FALSE TRUE FALSE
remote_os_roles FALSE TRUE FALSE
replication_dependency_tracking TRUE TRUE FALSE
resource_limit FALSE TRUE IMMEDIATE
resource_manager_plan   TRUE IMMEDIATE
rollback_segments   TRUE FALSE
row_locking always TRUE FALSE
serial_reuse DISABLE TRUE FALSE
serializable FALSE TRUE FALSE
service_names qualnavi FALSE FALSE
session_cached_cursors 0 TRUE FALSE
session_max_open_files 10 TRUE FALSE
sessions 170 TRUE FALSE
shadow_core_dump partial TRUE FALSE
shared_memory_address 0 TRUE FALSE
shared_pool_reserved_size 4500000 TRUE FALSE
shared_pool_size 90M FALSE FALSE
sort_area_retained_size 400000 FALSE DEFERRED
sort_area_size 400000 FALSE DEFERRED
sort_multiblock_read_count 2 TRUE DEFERRED
sql92_security FALSE TRUE FALSE
sql_trace FALSE TRUE FALSE
sql_version NATIVE TRUE FALSE
standby_archive_dest %ORACLE_HOME%RDBMS TRUE IMMEDIATE
star_transformation_enabled FALSE TRUE FALSE
tape_asynch_io TRUE TRUE FALSE
text_enable FALSE TRUE IMMEDIATE
thread 0 TRUE FALSE
timed_os_statistics 0 TRUE IMMEDIATE
timed_statistics FALSE TRUE IMMEDIATE
tracefile_identifier   TRUE FALSE
transaction_auditing TRUE TRUE DEFERRED
transactions 187 TRUE FALSE
transactions_per_rollback_segment 5 TRUE FALSE
use_indirect_data_buffers FALSE

14-04-2008, 13:24 geschreven door coiscaeyers
Klik hier om een link te hebben waarmee u dit artikel later terug kunt lezen.
savec1
savec1
RecipeParameterName RecipeParameterValue BatchId
LAAD_TRAJECT prod2 601
HOEVEELHEID 16500 601
LAAD_TRAJECT prod3 602
HOEVEELHEID 15000 602
LAAD_TRAJECT prod1 603
HOEVEELHEID 17000 603


14-04-2008, 12:35 geschreven door coiscaeyers
Klik hier om een link te hebben waarmee u dit artikel later terug kunt lezen.html

<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html;charset=windows-1252">
<TITLE>Material Usage</TITLE>
</HEAD>
<BODY>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TR HEIGHT=16 >
<TD WIDTH=8 ><BR></TD><TD WIDTH=88 ><B><I><FONT SIZE=2 FACE="Times New Roman" COLOR=#000080>Phase Name:</FONT></B></I></TD>
<TD WIDTH=865 ><FONT SIZE=1 FACE="Arial" COLOR=#000000>All Phases</FONT></TD>
</TR>
</TABLE>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TR HEIGHT=19 >
<TD WIDTH=961 ><I><FONT SIZE=2 FACE="Times New Roman" COLOR=#000080>A3_LAAD_CLS</FONT></I></TD>
</TR>
</TABLE>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TR HEIGHT=19 >
<TD WIDTH=244 ><B><I><FONT SIZE=2 FACE="Times New Roman" COLOR=#000080>Batch ID</FONT></B></I></TD>
<TD WIDTH=145 ><B><I><FONT SIZE=2 FACE="Times New Roman" COLOR=#000080>Download Time</FONT></B></I></TD>
<TD WIDTH=159 ><B><I><FONT SIZE=2 FACE="Times New Roman" COLOR=#000080>Target Value</FONT></B></I></TD>
<TD WIDTH=136 ><B><I><FONT SIZE=2 FACE="Times New Roman" COLOR=#000080>Upload Time</FONT></B></I></TD>
<TD WIDTH=286 ><B><I><FONT SIZE=2 FACE="Times New Roman" COLOR=#000080>Actual Value</FONT></B></I></TD>
</TR>
</TABLE>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TR HEIGHT=16 >
<TD WIDTH=244 ><FONT SIZE=1 FACE="Arial" COLOR=#000000>704_B</FONT></TD>
<TD WIDTH=295 ><FONT SIZE=1 FACE="Arial" COLOR=#000000>3/11/02 5:53:58 PM</FONT></TD>
<TD WIDTH=136 ><FONT SIZE=1 FACE="Arial" COLOR=#000000>3/11/02 7:15:16 PM</FONT></TD>
<TD WIDTH=286 ><FONT SIZE=1 FACE="Arial" COLOR=#000000>12307.02</FONT></TD>
</TR>
</TABLE>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TR HEIGHT=16 >
<TD WIDTH=244 ><FONT SIZE=1 FACE="Arial" COLOR=#000000>704_C</FONT></TD>
<TD WIDTH=295 ><FONT SIZE=1 FACE="Arial" COLOR=#000000>3/12/02 12:39:44 AM</FONT></TD>
<TD WIDTH=136 ><FONT SIZE=1 FACE="Arial" COLOR=#000000>3/12/02 6:08:25 AM</FONT></TD>
<TD WIDTH=286 ><FONT SIZE=1 FACE="Arial" COLOR=#000000>20027.29</FONT></TD>
</TR>
</TABLE>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TR HEIGHT=16 >
<TD WIDTH=244 ><FONT SIZE=1 FACE="Arial" COLOR=#000000>705</FONT></TD>
<TD WIDTH=295 ><FONT SIZE=1 FACE="Arial" COLOR=#000000>3/12/02 12:37:27 PM</FONT></TD>
<TD WIDTH=136 ><FONT SIZE=1 FACE="Arial" COLOR=#000000>3/12/02 1:25:36 PM</FONT></TD>
<TD WIDTH=286 ><FONT SIZE=1 FACE="Arial" COLOR=#000000>14807.80</FONT></TD>
</TR>
</TABLE>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TR HEIGHT=16 >
<TD WIDTH=244 ><FONT SIZE=1 FACE="Arial" COLOR=#000000>706</FONT></TD>
<TD WIDTH=295 ><FONT SIZE=1 FACE="Arial" COLOR=#000000>3/12/02 7:06:53 PM</FONT></TD>
<TD WIDTH=136 ><FONT SIZE=1 FACE="Arial" COLOR=#000000>3/12/02 7:34:07 PM</FONT></TD>
<TD WIDTH=286 ><FONT SIZE=1 FACE="Arial" COLOR=#000000>7411.30</FONT></TD>
</TR>
</TABLE>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TR HEIGHT=16 >
<TD WIDTH=244 ><FONT SIZE=1 FACE="Arial" COLOR=#000000>707</FONT></TD>
<TD WIDTH=295 ><FONT SIZE=1 FACE="Arial" COLOR=#000000>3/13/02 1:02:12 AM</FONT></TD>
<TD WIDTH=136 ><FONT SIZE=1 FACE="Arial" COLOR=#000000>3/13/02 1:28:51 AM</FONT></TD>
<TD WIDTH=286 ><FONT SIZE=1 FACE="Arial" COLOR=#000000>7410.10</FONT></TD>
</TR>
</TABLE>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TR HEIGHT=16 >
<TD WIDTH=244 ><FONT SIZE=1 FACE="Arial" COLOR=#000000>708</FONT></TD>
<TD WIDTH=295 ><FONT SIZE=1 FACE="Arial" COLOR=#000000>3/13/02 5:58:46 AM</FONT></TD>
<TD WIDTH=136 ><FONT SIZE=1 FACE="Arial" COLOR=#000000>3/13/02 6:46:18 AM</FONT></TD>
<TD WIDTH=286 ><FONT SIZE=1 FACE="Arial" COLOR=#000000>7495.80</FONT></TD>
</TR>
</TABLE>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TR HEIGHT=16 >
<TD WIDTH=244 ><FONT SIZE=1 FACE="Arial" COLOR=#000000>709</FONT></TD>
<TD WIDTH=295 ><FONT SIZE=1 FACE="Arial" COLOR=#000000>3/13/02 10:27:53 AM</FONT></TD>
<TD WIDTH=136 ><FONT SIZE=1 FACE="Arial" COLOR=#000000>3/13/02 10:54:33 AM</FONT></TD>
<TD WIDTH=286 ><FONT SIZE=1 FACE="Arial" COLOR=#000000>7411.80</FONT></TD>
</TR>
</TABLE>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >
<TR HEIGHT=17 >
<TD WIDTH=430 ><B><I><FONT SIZE=1 FACE="Times New Roman" COLOR=#000080>Wednesday, March 13, 2002</FONT></B></I></TD>
<TD WIDTH=118  ALIGN=CENTER ><B><I><FONT SIZE=1 FACE="Times New Roman" COLOR=#000080>Material Usage Report</FONT></B></I></TD>
<TD WIDTH=276  ALIGN=RIGHT ><B><I><FONT SIZE=1 FACE="Times New Roman" COLOR=#000080>Page 5 of 5</FONT></B></I></TD>
</TR>
</TABLE>

<A HREF="cc_rapp3_1.html">First</A> <A HREF="cc_rapp3_1Page4.html">Previous</A> <A HREF="#">Next</A> <A HREF="#">Last</A></BODY>
</HTML>

14-04-2008, 12:12 geschreven door coiscaeyers
Klik hier om een link te hebben waarmee u dit artikel later terug kunt lezen.beurs

http://www.tijd.be/beurzen/

14-04-2008, 12:11 geschreven door coiscaeyers
27-09-2005
Klik hier om een link te hebben waarmee u dit artikel later terug kunt lezen.oracle

Neen, uw blog moet niet dagelijks worden bijgewerkt.  Het is gewoon zoals je het zélf wenst.  Indien je geen tijd hebt om dit dagelijks te doen, maar bvb. enkele keren per week, is dit ook goed.  Het is op jouw eigen tempo, met andere woorden: vele keren per dag mag dus ook zeker en vast, 1 keer per week ook.

Er hangt geen echte verplichting aan de regelmaat.  Enkel is het zo hoe regelmatiger je het blog bijwerkt, hoe meer je bezoekers zullen terugkomen en hoe meer bezoekers je krijgt uiteraard. 

27-09-2005, 16:32 geschreven door coiscaeyers
Klik hier om een link te hebben waarmee u dit artikel later terug kunt lezen.

Het maken van een blog en het onderhouden is eenvoudig.  Hier wordt uitgelegd hoe u dit dient te doen.

Als eerste dient u een blog aan te maken- dit kan sinds 2023 niet meer.

Op die pagina dient u enkele gegevens in te geven. Dit duurt nog geen minuut om dit in te geven. Druk vervolgens op "Volgende pagina".

Nu is uw blog bijna aangemaakt. Ga nu naar uw e-mail en wacht totdat u van Bloggen.be een e-mailtje heeft ontvangen.  In dat e-mailtje dient u op het unieke internetadres te klikken.

Nu is uw blog aangemaakt.  Maar wat nu???!

Lees dit in het volgende bericht hieronder!

27-09-2005, 16:32 geschreven door coiscaeyers
>

Blog tegen de wet? Klik hier.
Gratis blog op https://www.bloggen.be - Meer blogs