I have **Oracle 12c** running on **Solaris** which is my main database for multiple systems and data processing. There is planned upgrade and migration from Solaris but this wont happen soon, my team is not responsible for this. I need to create **Database link** to **MariaDB**. This MariaDB Server is owned by different team and run some third party system for me. The problem is **MariaDB** is configured with **dialog authentication method** which is **not supported by MySQL**. This means I cannot use MySQL driver, only MariaDB driver. Unfortunately i cannot find any drivers for Solaris. The only solution I can image is to download source of MariaDB driver and build for Solaris but this is tricky for me. **Is there any other solution i can use?**

I am Junior Database Administrator at a Bank and there was an issue that caused the Oracle Database Instance one to crash (We have two instances). So the system rebooted itself and everything is working fine now. But the bank's DBA consultant said the Database requested the system crash. I tried to google on it but couldn't find any thing on it. My question is, can oracle db request a system crash (crash the instance that has the issue) if the db is experiencing issue with the OS? FYI, It is running Oracle RAC Grid Infrastructure

Running an sql script in SQLplus on Solaris Any idea why script hangs in line 9 '/' and not executed? declare dummy number; begin select 1 into dummy from dual ; end; /

Oracle version = Oracle 8i (817_312) //Yes I know this is old. Database id = LED OS = Solaris 8 Oracle USERID = oraled Oracle DBA group = dba rman backups to disk. Sorry this is so long. I am not a DBA, I am UNIX/Linux system administrator. We lost our DBA a while ago, and I was told to keep it running. What am I missing or doing wrong? I am trying to restore an oracle database from a good backup and I am getting errors that there is a problem with the controlfiles. The oracle DB is up, mounted and open when this script runs. This is how we are backing up the oracle DB from Oracle's cron. rman target / nocatalog cmdfile=/oracle/admin/led/rman/LEDlvl0 log=$LOGFILE and in /oracle/admin/led/rman/LEDlvl0.sh we have run { set command id to 'LED_rman_test'; allocate channel disk1 type disk format '/apps1/backup/%d.LVL0.%s.%t.%p.dbf'; allocate channel disk2 type disk format '/apps2/backup/%d.LVL0.%s.%t.%p.dbf'; allocate channel disk3 type disk format '/apps3/backup/%d.LVL0.%s.%t.%p.dbf'; allocate channel disk5 type disk format '/apps5/backup/%d.LVL0.%s.%t.%p.dbf'; allocate channel disk6 type disk format '/apps6/backup/%d.LVL0.%s.%t.%p.dbf'; backup incremental level=0 setsize=7000000 database ; backup (current controlfile format '/apps4/backup/%d.%s.%t.%p.ctl'); release channel disk1; release channel disk2; release channel disk3; release channel disk5; release channel disk6; This ran succesfully. I want to restore this backup. I have removed the data files and copied the control file (/apps4/backup/LED.22010.973362972.1.ctl) file back to the the locations specified by the initLED.ora file. As the Oracle user these are the commands I am running. $ rman nocatalog RMAN> connect target sys/********@LED RMAN> startup mount and I get this error RMAN-06196: Oracle instance started RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-06003: ORACLE error from target database: ORA-00205: error in identifying controlfile, check alert log for more info RMAN-06097: text of failing SQL statement: alter database mount RMAN-06099: error occurred in source file: krmk.pc, line: 4192 and the alertLED.log shows: Tue Apr 24 16:57:04 2018 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 LICENSE_MAX_USERS = 0 Starting up ORACLE RDBMS Version: 8.1.7.0.0. System parameters with non-default values: processes = 150 sessions = 170 timed_statistics = TRUE event = 10183 trace name context forever, level 1, 10191 trace name context forever, level 1 shared_pool_size = 400000000 enqueue_resources = 8000 control_files = /oracle/LED/sapdata1/cntrl/cntrlLED.dbf, /oracle/LED/sapdata2/cntrl/cntrlLED.dbf, /oracle/LED/sapdata3/cntrl/cntrlLED.dbf db_block_buffers = 142000 db_block_size = 8192 db_block_lru_latches = 4 compatible = 8.1.0 log_archive_start = TRUE log_archive_dest = /oracle/LED/saparch/R3Parch log_archive_min_succeed_dest= 1 log_buffer = 1048576 log_checkpoint_interval = 300000 log_checkpoint_timeout = 0 db_files = 254 db_file_multiblock_read_count= 8 log_checkpoints_to_alert = TRUE control_file_record_keep_time= 45 dml_locks = 2500 row_locking = always replication_dependency_tracking= FALSE transactions_per_rollback_segment= 20 max_rollback_segments = 400 rollback_segments = PRS_0, PRS_1, PRS_2, PRS_3, PRS_4, PRS_5, PRS_6, PRS_7, PRS_8, PRS_9 transaction_auditing = FALSE remote_os_authent = TRUE remote_login_passwordfile= EXCLUSIVE db_domain = world audit_trail = TRUE sort_area_size = 2097152 sort_area_retained_size = 0 db_name = LED open_cursors = 800 optimizer_mode = choose optimizer_index_cost_adj = 10 cursor_space_for_time = FALSE parallel_max_servers = 20 hash_join_enabled = FALSE background_dump_dest = /oracle/LED/saptrace/background user_dump_dest = /oracle/LED/saptrace/usertrace core_dump_dest = /oracle/LED/saptrace/background PMON started with pid=2 DBW0 started with pid=3 LGWR started with pid=4 CKPT started with pid=5 SMON started with pid=6 RECO started with pid=7 Tue Apr 24 16:57:07 2018 ARCH: STARTING ARCH PROCESSES ARC0 started with pid=8 Tue Apr 24 16:57:07 2018 ARCH: STARTING ARCH PROCESSES COMPLETE Tue Apr 24 16:57:07 2018 ARC0: Archival started Tue Apr 24 16:57:07 2018 alter database mount Tue Apr 24 16:57:07 2018 ORA-00202: controlfile: '/oracle/LED/sapdata1/cntrl/cntrlLED.dbf' Tue Apr 24 16:57:10 2018 ORA-205 signalled during: alter database mount... and oerr 205 give me this: $ oerr ora 205 00205, 00000, "error in identifying controlfile, check alert log for more info" // *Cause: The system could not find a controlfile of the specified name and // size. // *Action: Check that ALL controlfiles are online and that they are the same // files that the system created at cold start time. So I check the controlfiles: $ ls -l /oracle/LED/sapdata1/cntrl/cntrlLED.dbf /oracle/LED/sapdata2/cntrl/cntrlLED.dbf /oracle/LED/sapdata3/cntrl/cntrlLED.dbf -rw-r----- 1 oraled dba 29876736 Apr 23 23:19 /oracle/LED/sapdata1/cntrl/cntrlLED.dbf -rw-r----- 1 oraled dba 29876736 Apr 23 23:19 /oracle/LED/sapdata2/cntrl/cntrlLED.dbf -rw-r----- 1 oraled dba 29876736 Apr 23 23:19 /oracle/LED/sapdata3/cntrl/cntrlLED.dbf So I try and restore the controlfile. $ rman nocatalog RMAN> connect target sys/********@LED RMAN> startup nomount RMAN-06196: Oracle instance started Total System Global Area 1609240736 bytes Fixed Size 73888 bytes Variable Size 444837888 bytes Database Buffers 1163264000 bytes Redo Buffers 1064960 bytes RMAN> run { 2> allocate channel ch1 type disk; 3> allocate channel ch2 type disk; 4> allocate channel ch3 type disk; 5> allocate channel ch5 type disk; 6> allocate channel ch6 type disk; 7> 8> restore controlfile to '/apps6/backup/jimt.ctl'; 9> } RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: ch1 RMAN-08500: channel ch1: sid=10 devtype=DISK RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: ch2 RMAN-08500: channel ch2: sid=11 devtype=DISK RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: ch3 RMAN-08500: channel ch3: sid=12 devtype=DISK RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: ch5 RMAN-08500: channel ch5: sid=13 devtype=DISK RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: ch6 RMAN-08500: channel ch6: sid=14 devtype=DISK RMAN-03022: compiling command: restore RMAN-03022: compiling command: IRESTORE RMAN-03026: error recovery releasing channel resources RMAN-08031: released channel: ch1 RMAN-08031: released channel: ch2 RMAN-08031: released channel: ch3 RMAN-08031: released channel: ch5 RMAN-08031: released channel: ch6 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure during compilation of command RMAN-03013: command type: restore RMAN-03002: failure during compilation of command RMAN-03013: command type: IRESTORE RMAN-06003: ORACLE error from target database: ORA-01507: database not mounted ORA-06512: at "SYS.X$DBMS_RCVMAN", line 4461 ORA-06512: at line 1 RMAN-06097: text of failing SQL statement: begin dbms_rcvman . setDatabase ( upper ( :dbname:dbname_i ) , :rlscn , :rltime , :fhdbi:fhdbi_i ) ; end ; RMAN-06099: error occurred in source file: krmk.pc, line: 9196 I am stuck. Any ideas of what I should try next? Thanks JiM T

The oracle generated logs (ie. alert and listener logs) are being created with 600 permissions. These files are of course created automatically by the oracle user. How would I change the permissions to automatically be 640, for instance, in a Solaris 10 environment? This would allow DBAs to read them and such without logging into the oracle user account.

I need 10g RAC software (Solaris 11 SPARC) for an audit. It's no longer on OTN. I've opened an SR, but it is taking forever then they gave me the wrong O/S. Do you know of any other place to get it?

Currently, we are using the **dbaccess** utility to export all tables in the Informix database to text files. These are used to "mirror" the database multiple Windows machines running MSSQL Server on a nightly basis. I was looking into the **dbexport** utility to see if it would be a viable solution. The text export takes almost 2 hours and I'm looking to shrink that time down if possible. However, I'm not familiar with these Informix utilities and we do not have a test environment for this... so I'm wondering what exactly is the output from dbexport? Is there an option to export each individual table to a text file with dbexport? Thank you.

I’ve searched and read wide about the good practices of configuring swap space for Oracle Database installation. I am aware that for 1-2GB RAM, swap has to be 1.5x. For between 2GB and 8GB, swap needs to be equal to SGA. Above 8GB, swap will be twice SGA size (I stand to be corrected). However, just yesterday, someone introduced something that got me confused. He said, “For Oracle Database or Oracle RAC on systems, available swap space must be at least equal to the sum of the SGA sizes of all instances running on the servers.” I am a bit confused because I am aware that even though it is a RAC environment, each server has its OS and maintains its internal memory separately hence, the swap for each serverdoesn’t have to be equal to the sum of SGAs as indicated by my colleague. Can anyone please help me understand what the correct value should be?

I'm barely new with Solaris OS and there are still a couple of things I definitely don't get it. I want to replicate a MySQL installation that someone did in the past in a development server we have. Simple: MySQL 5.6.36 running on Solaris 11.3 installed as a IPS package with its SMF services. I'm testing a with a fresh new install Solaris 11.3. I did a "pkg install database/mysql-56" (following this simple guide ), but the MySQL IPS package installed version is 5.6.25. How can I upgrade it to 5.6.36? Why the latest MySQL IPS Package available version is so old (in fact, I was expecting a newer version, and then try to figure out how to downgrade it)? What I'm missing? Regards!

I am attempting to solve a problem explained in another question [here](https://stackoverflow.com/q/20355007/13860) . On Debian 7.4 with Postgres 9.1.12, I am able to use the Perl qr operator just fine. On Solaris 5.11 with Postgres 9.2.4, however, I am not able to. As detailed in the question above, the following stored procedure fails on the Solaris installation: REATE FUNCTION foo(VARCHAR) RETURNS VARCHAR AS $$ my ( $re ) = @_; $re = ''.qr/\b($re)\b/i; return $re; $$ LANGUAGE plperl; With the following error: ERROR: Unable to load utf8.pm into plperl at line 3. BEGIN failed--compilation aborted. CONTEXT: PL/Perl function "foo" It is apparent that in the Debian installation of Postgres, 'utf8' is already loaded by default. I ran the following stored procedure on both systems: CREATE FUNCTION perl_modules() RETURNS VOID AS $$ warn join(', ',sort keys %INC); $$ LANGUAGE plperl; On the Debian system: > WARNING: Carp.pm, Carp/Heavy.pm, Exporter.pm, feature.pm, overload.pm, strict.pm, unicore/Heavy.pl, unicore/To/Fold.pl, utf8.pm, utf8_heavy.pl, vars.pm, warnings.pm, warnings/register.pm at line 2. On the Solaris system: > WARNING: Carp.pm, Carp/Heavy.pm, Exporter.pm, feature.pm, overload.pm, overloading.pm, strict.pm, vars.pm, warnings.pm, warnings/register.pm at line 2. I tried to load the utf8 module on the Solaris system by adding this to the postgres config file: plperl.on_init = 'use utf8; use re;' And that successfully loads the utf8 and re modules, as shown here: > WARNING: Carp.pm, Carp/Heavy.pm, Exporter.pm, XSLoader.pm, feature.pm, overload.pm, overloading.pm, re.pm, strict.pm, utf8.pm, vars.pm, warnings.pm, warnings/register.pm at line 2. However the foo() stored procedure still fails: dc=# select foo('foo'); ERROR: Attempt to reload utf8_heavy.pl aborted. Compilation failed in require at /opt/perl-5.18.0/lib/utf8.pm line 17. CONTEXT: PL/Perl function "foo" What is the secret to successfully loading utf8, and its dependencies, in this Solaris environment?

We are getting ORA-01658 (Error :ORA-01658: unable to create INITIAL extent for segment in tablespace MYDATA_LDATA_INDEX) in our application logs. This happens when application is trying to insert data for the first time into tables that are empty. It is only happening to this particular index. The tablespace free space decreases by multiple of 50M. The parameters used to create the index tablespace: CREATE TABLESPACE MYDATA_LDATA_INDEX DATAFILE '/index/oradata/mydb/mydata_ldata_index_01.dbf' SIZE 1300M AUTOEXTEND ON NEXT 10M MAXSIZE 2048M LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL UNIFORM SIZE 50M BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; We are sure application is not trying to insert massive amount of data into the tables, an operation that only insert one row also causes this. After increasing tablespace for the index manually, regular operation can be continued and tablespace usage for the index is not increasing dramatically. We are using Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production on Solaris 11.1. How do we pin point source of the problem? Is there an issue with the parameter of the index tablespace?

I'm trying to set up a database on a Solaris 10 platform that had its database corrupted before. Due to the lack of backups, I was forced to reinstall Oracle server. Currently I'm facing an issue where answers I have found keep sending me in loops. I opened sqlplus, and saw that it was connected to an idle instance, so I performed the STARTUP command. This led me to the following errors: ORA-48108: invalid value given for the diagnostic_dest init.ora parameter ORA-48140: the specified ADR Base directory does not exist [/export/home/oracle/u01/app/oracle/product/11.2.0/dbhome_1/dbs/] So after some googling, I was told to try changing the diagnostic_dest via the following: ALTER SYSTEM SET diagnostic_dest='u01/app/oracle';, which was equivalent to setting the diagnostic_dest to my ORACLE_BASE. However, the error below occurred: ORA-01034: ORACLE not available After some googling again, I found that the solution was to start the database (which I can't)! I have no idea how I should proceed from here. Any help will be much appreciated. If any other information is required, I will gladly update it in the OP. I have tried restarting lsnrctl, but it doesn't seem to help. I would change all the default parameters within the file locations, but from what I found, the init.ora file which was supposed to be used already has diagnostic_dest='', the spfile.ora file also has diagnostic_dest='/u01/app/oracle'. I'm really lost as to how I should carry on.

Good day, Setup: Oracle 11G on Solaris 10 x86 We'd like to capture the errors/failures of our nightly scheduled procedures/ packages in the OS's syslog. That log will then be sent to a remote NMS managed by the NOC who'll alert the on-call personnel. Can and how can this be done? Thanks.

I had a problem recently with oraenv and oratab and finding out where oraenv is located was a bit challenging. Since it's a question I ask myself often, I wanted to have it here. It may help others.

What is the path of oratab on solaris? This is actually a question I google a lot and switching from environment to another, I tend to mix them up and forget. Today I googled it again and I wanted it in a place where I usually have all the answers.

i have two Oracle 12c instances. currently both are shutdown. when I try to connect with sqlplus / as sysdba it says tns protocol adapter error contents of tnsnames.ora are DB12102 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DB12102) ) ) LISTENER_DB12102 = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ORADB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = oradb.example.com) ) ) LISTENER_ORCL = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1539)) contents of listener.ora are LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost )(PORT = 1521)) ) ) Output of lsnrctl status is TNSLSNR for Solaris: Version 12.1.0.2.0 - Production System parameter file is /u01/app/oracle/product/12.1.0.2/db_1/network /admin/listener.ora Log messages written to /u01/app/oracle/diag/tnslsnr/id1presasd0100/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost) (PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Solaris: Version 12.1.0.2.0 -Production Start Date 21-OCT-2015 02:44:00 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/12.1.0.2/db_1/network/admin/listener.ora Listener Log File /u01/app/oracle/diag/tnslsnr/id1presasd0100/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))) The listener supports no services The command completed successfully still when i try to connect with sqlplus $ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Wed Oct 21 02:45:36 2015 Copyright (c) 1982, 2014, Oracle. All rights reserved. ERROR: ORA-12560: TNS:protocol adapter error Any help on this ?? I repeat none of the instances are running currently. i am trying SQLplus on same machine as database.

Way back when Michael Jackson was still alive, I made this question: https://stackoverflow.com/questions/1018822/inner-join-on-vs-where-clause And now I'm performance-auditing a system in which the developer used the first form, instead of an INNER JOIN. The DBMS is Oracle 10.2.0.4 on Solaris/SPARC. I could, of course, recommend the change in syntax solely because it's better form, but if it won't positively impact performance it's kind of pointless. So, my question is: is it possible there will be a change in query execution if I ask them to change the query syntax to INNER JOIN?

I ran MySQLTuner to verify the configuration of a MySQL database, and it reported this problem: [!!] Maximum possible memory usage: 40.9G (1022% of installed RAM) These figures come from computing max_connections multiplied by read_buffer_size + sort_buffer_size + join_buffer_size in the my.cnf file, which effectively gives 40Gb. However, the server has 128Gb of RAM. It appears that MySQL only sees 4Gb. At first I thought that this was because a MySQL 32-bit binary on a 64-bit OS can effectively access only 4Gb of RAM . However, both MySQL binary and OS are 64-bit: root@box# isainfo -v 64-bit amd64 applications pclmulqdq aes sse4.2 sse4.1 ssse3 popcnt tscp ahf cx16 sse3 sse2 sse fxsr mmx cmov amd_sysc cx8 tsc fpu 32-bit i386 applications pclmulqdq aes sse4.2 sse4.1 ssse3 popcnt tscp ahf cx16 sse3 sse2 sse fxsr mmx cmov sep cx8 tsc fpu root@box# uname -a SunOS box 5.11 11.2 i86pc i386 i86pc root@box# file /usr/local/bin/mysql /usr/local/bin/mysql: ELF 64-bit LSB executable AMD64 Version 1 [SSE2 SSE FXSR CMOV FPU], dynamically linked, not stripped and there is no limit on how much memory a process can access: root@box# ulimit -a address space limit (kbytes) (-M) unlimited core file size (blocks) (-c) unlimited cpu time (seconds) (-t) unlimited data size (kbytes) (-d) unlimited file size (blocks) (-f) unlimited locks (-x) not supported locked address space (kbytes) (-l) not supported message queue size (kbytes) (-q) not supported nice (-e) not supported nofile (-n) 256 nproc (-u) 29995 pipe buffer size (bytes) (-p) 5120 max memory size (kbytes) (-m) not supported rtprio (-r) not supported socket buffer size (bytes) (-b) 5120 sigpend (-i) 128 stack size (kbytes) (-s) 8192 swap size (kbytes) (-w) not supported threads (-T) not supported process size (kbytes) (-v) unlimited Is there another way I can see how much memory MySQL is effectively using? (In case you ask, shell is tcsh; I cannot tag the post "tcsh" due to insufficient privileges.)

i have a setup here where we use a Solaris 10 x86, zpool for oracle12c-redo-log using mirrored disks and mirrored ZIL. logbias="latency", recordsize=128: pool: xxxxxx01_redo00 state: ONLINE scan: resilvered 25.1G in 0h1m with 0 errors on Thu Jan 22 15:24:41 2015 config: NAME STATE READ WRITE CKSUM xxxxxx01_redo00 ONLINE 0 0 0 mirror-0 ONLINE 0 0 0 c5t60000970000295700789533031393742d0 ONLINE 0 0 0 c5t60000970000295700860533033424537d0 ONLINE 0 0 0 logs mirror-1 ONLINE 0 0 0 c5t60000970000295700789533032304344d0 ONLINE 0 0 0 c5t60000970000295700860533033423844d0 ONLINE 0 0 0 When i now check what the lgwr process does in terms of IO it is after all mostly writes to the redo-logs (when not switching logs). Here is what i do not get: The lgwr-process does writes in different sizes (which is okay) and i expect to see them actually happening on the ZIL-Devices until the txg_timeout is getting hit, then i expect to see the flush to the data-disks. Instead the picture is different. Here is the iostat: 0.0 133.3 0.0 4067.1 0.0 0.1 0.0 0.5 0 7 c5t60000970000295700789533032304344d0 0.0 133.8 0.0 4077.1 0.0 0.3 0.0 2.2 0 29 c5t60000970000295700860533033423844d0 44.6 0.0 5708.7 0.0 0.0 0.1 0.0 2.0 0 9 c5t60000970000295700789533031393742d0 33.6 0.0 4297.6 0.0 0.0 0.1 0.0 3.3 0 11 c5t60000970000295700860533033424537d0 as you can see, the first two disks are the ZILs, the other two are the actual disks with the Data. checking the lgwr from syscall-level with: ./rwsnoop -p UID PID CMD D BYTES FILE 708 16559 oracle W 512 /export/zones/xxxxxx01/root/opt/app/oracle/redo00/XXXX0/XXXX0_redo07.rdo 708 16559 oracle W 58368 /export/zones/xxxxxx01/root/opt/app/oracle/redo00/XXXX0/XXXX0_redo07.rdo 708 16559 oracle W 2560 /export/zones/xxxxxx01/root/opt/app/oracle/redo00/XXXX0/XXXX0_redo07.rdo 708 16559 oracle W 26112 /export/zones/xxxxxx01/root/opt/app/oracle/redo00/XXXX0/XXXX0_redo07.rdo 708 16559 oracle W 69632 /export/zones/xxxxxx01/root/opt/app/oracle/redo00/XXXX0/XXXX0_redo07.rdo here we can see that the lgwr-process does its io with different blocksizes. now from a devices-pov (of the Data-Devices not the ZIL) ./iosnoop -d UID PID D BLOCK SIZE COMM PATHNAME 708 16559 R 29073760 131072 oracle 708 16559 R 29074016 131072 oracle 708 16559 R 29073504 131072 oracle 708 16559 R 29073760 131072 oracle 708 16559 R 29073504 131072 oracle 708 16559 R 29073760 131072 oracle 708 16559 R 29074784 131072 oracle 708 16559 R 29074784 131072 oracle 708 16559 R 29074784 131072 oracle 708 16559 R 29074272 131072 oracle 708 16559 R 29074272 131072 oracle this seem to be clearly zfs 128k reads but why so they happen? is it just because the recordsize=128 and zfs collecting the writes and because of the c-o-w it needs to read? I would appreciate to dig deeper with you all or just be enlightened ;-) Cheers B.

I've got one Onesight alert mail stating below: Short Description: Onesight Alert: ZEUS DB Monitor (zeus04) Description: Solaris 5.8: vmstat memory(free) - Free Memory for zeus04 2065112 8:06:02 AM IST 2 min Free Memory below 4GB: Value was 3,965,488 , threshold is 4194304.0 - 12:36:02 AM IST Upon issuing OS level commands below I got the following understanding: prstat This command returned me the top process ID(3578) which is using more CPU. then, prstat -Lm -p 3578 this command returned me the following output: PID USERNAME USR SYS TRP TFL DFL LCK SLP LAT VCX ICX SCL SIG PROCESS/LWPID 3578 oracle 0.7 2.3 1.6 0.0 0.0 90 4.4 1.5 483 235 1K 0 java/838694 3578 oracle 0.3 0.0 0.2 0.0 0.0 95 1.5 0.1 52 8 41 0 java/839336 I thought some Java process would be running so asked the Apps Support team and the said: we believe this process is related to the Oracle OEM agent Java process Now how do i drill down the issue and resolve because free memory is going below 2GB almost everyday. DB environment details: OS:Solaris 5.8(Unix) DB version: 10.2.0.5 Memory size:64 GB Regards, Ritu